One returned item should not obscure the rest of the order
Build a line-level disposition record from the original order, return and any exchange records. Identify quantities retained by the buyer, physically returned, still awaiting return or otherwise unresolved, and original quantities still awaiting fulfillment. Link replacement items separately to the exchange that created the obligation. A return or refund label for part of the order cannot establish that the remaining original items or replacement work are complete.
For: A research-only merchant's support or fulfillment lead reconciling an order where only some items are returned or exchanged.
Account for the original quantities without counting them twice
Start with the original product or variation and quantity for each order line. Preserve the original reference even if the order was subsequently edited. Then assign each quantity a current physical disposition supported by a record: retained by the buyer, received back, awaiting return, awaiting original fulfillment, or unresolved. Preserve any other documented disposition rather than forcing it into the wrong category.
Treat those physical categories as mutually exclusive at the time of the comparison. Do not count a unit both as retained and awaiting return merely because the return has not yet arrived. Instead, record that it is still with the buyer in the evidence note for the awaiting-return quantity. A unit with uncertain status belongs in the unresolved quantity until a record explains it.
The total quantities allocated across those categories should account for the original line. A gap signals missing disposition evidence; an excess signals overlapping or duplicate quantities. This is a record comparison, not a reason to alter an order quantity to make a total fit. Returned quantities also need their processing state recorded separately: physical receipt does not establish refund completion.
Attach the return and exchange without erasing the retained items
For Shopify, creating a return is separate from processing received items, refunds or payment collection and fulfilling exchanges. Partial processing can change the immediate financial outcome while other items remain unresolved. Map each processed event to the original lines and quantities it actually covers. Leave retained items and outstanding original fulfillment visible beside that event.
An exchange adds a replacement obligation that needs its own product or variation, quantity and linked exchange reference. Do not add replacement quantity into the original line's physical-disposition total. Keep a separate replacement record, connected to the original line, so both what came back and what is now owed can be followed.
Shopify documents that exchange inventory is not reserved until processing. A requested replacement therefore does not prove an earlier stock reservation or a later shipment. Record the actual processing and fulfillment state. Feature availability and return/refund permissions vary, so confirm that the relevant action is available to the assigned staff member rather than treating this worksheet as a platform procedure.
Use fulfillment records only for the work they actually cover
Where the documented WooCommerce Fulfillments feature is present, individual fulfillments hold products, quantities, draft or fulfilled status and shipping or tracking information. Compare those constituent records with the items still needing outbound work. The order-level fulfillment state is calculated from the item and fulfillment records; a partial state can reflect unassigned items or work that is still in draft.
Do not assume every WooCommerce installation exposes this model, or copy Shopify's return controls onto it. Identify the active feature and extensions. If the store uses a different extension or a private operational record, name that record and verify its meaning before interpreting the order label.
A draft WooCommerce fulfillment does not send a customer notification when created, edited or removed. Actions on fulfilled records can notify according to the notification toggle. Those settings describe intended notification behavior, not email delivery. Likewise, an application record marked fulfilled is not independent proof of a carrier event. Keep payment/refund evidence, carrier evidence and customer-message evidence separate from the item assignment.
Choose the next action for each open quantity
Read across each line instead of assigning one conclusion to the whole order. A retained quantity may have no further physical action; a return quantity may still require receipt or processing; a replacement quantity may still require an outbound handoff. A financial issue may remain even when the physical movements are accounted for. Record the next action only where the underlying record supports it.
Give every unresolved quantity an owner and the reference that owner must inspect. Before arranging another refund or shipment, check the linked records for earlier actions covering the same items. The aim is to make outstanding work visible while preserving completed work and the items the buyer kept.
Use the resulting map to prepare a customer update limited to that order's actual item states. If the recurring difficulty is conflicting store, support or fulfillment records, describe the platform and gap in a Prism checkout consultation. Scope, responsibilities, fees and terms are confirmed before work; the inquiry does not authorize item handling or establish a refund entitlement.
Order disposition map
Complete a copy for each real original order line. Allocate original quantities once across current physical dispositions, recording unknown quantities explicitly. Keep financial states alongside those dispositions and replacement quantities in their own linked record. The original quantities should reconcile without adding replacements into that total.
Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.
Order disposition map. The last column is for temporary notes.
Line fact
Evidence to use
Reconciliation check
Your line record
Order line
Evidence to useOriginal product or variation reference and quantity, with any subsequent edit history.
Reconciliation checkUse one stable line reference so returns and exchanges remain connected to the original purchase.
Retained quantity
Evidence to useConfirmed quantity remaining with the buyer and not currently assigned to a return.
Reconciliation checkExclude quantities already counted as awaiting return; preserve retained items when another item is returned.
Returned quantity
Evidence to usePhysical receipt record and quantity received back for this line.
Reconciliation checkRecord processing state separately; a return request alone does not establish receipt.
Awaiting-return quantity
Evidence to useThe active return record and quantity still expected back.
Reconciliation checkKeep this separate from received-back and retained quantities to avoid counting the same unit twice.
Other original quantity
Evidence to useOriginal quantities still awaiting fulfillment, unresolved quantities or another documented physical disposition, each labeled separately.
Reconciliation checkAll mutually exclusive physical dispositions together must account for the original quantity; flag gaps or overlaps.
Exchange reference
Evidence to useThe actual linked exchange, replacement item or variation and replacement quantity.
Reconciliation checkMaintain a separate replacement record; these new outbound quantities do not balance the original line.
Financial action
Evidence to useReturn-processing result and the corresponding actual refund or payment record.
Reconciliation checkKeep requested, submitted and completed actions distinct from physical receipt and shipment.
Outbound evidence
Evidence to useRelevant original or replacement fulfillment items and quantities, state and associated tracking record.
Reconciliation checkIdentify which obligation each fulfillment covers; a draft or original shipment cannot prove a replacement shipped.
Outstanding action
Evidence to useThe unresolved quantity or financial question, responsible owner and record needed next.
Reconciliation checkClose only the documented action; leave other original and replacement work visible.
These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.
Limits
This map organizes records; it does not decide legal return rights, product condition, safe stock disposition or whether a returned research product may be resold.
Shopify return actions and WooCommerce Fulfillments describe different platform features. Availability, permissions and extensions must be established for the actual store.
Application fulfillment, money movement, carrier events and delivered messages need separate evidence. No single order label proves all four.
Keep customer identities, addresses, payment details and private tracking links in authorized systems rather than public consultation forms.
Shopify creating returns and exchanges — checked 2026-09-29. Return creation, processing received items, refunds or payment collection and exchange fulfillment are separate. Partial processing can change the immediate financial outcome while remaining items still matter. Exchange inventory is not reserved until processing; permissions and feature restrictions apply.
WooCommerce order fulfillment — checked 2026-09-29. Where the documented Fulfillments feature is present, each fulfillment records items, quantities, status and tracking. Order-level state derives from those records. Draft creation, edits and removal do not notify customers; fulfilled-record notification behavior depends on the toggle. Payment records and independent carrier events require separate checks; availability and extension behavior cannot be assumed.
Prism solutions — checked 2026-09-21. Published support includes storefront review, processing preparation and provider website questions. Scope, fees and terms are discussed before work.
Get help with store operations
Need help with the order, email or fulfillment step itself?