Reconcile repeated quantities across a split order's parent and children

Identify which record is the commercial original

When an order is split for operational reasons, the records that result are not equal. The parent order represents the sale: what the buyer ordered, paid for and is owed. The child records represent physical work carved out of that sale, such as separate shipments or picks. Seeing the original quantity repeated on the parent and again on the children is a property of the record structure, not evidence that the obligation multiplied.

Before any arithmetic, write down which record your team treats as the commercial original and which records exist only to drive physical work. If a child record carries the full original quantity rather than a partial allocation, that is a data finding to flag, not a new obligation to fulfill.

Allocate original line quantities to the children

Work line by line for each product or variation on the parent. Record the original ordered quantity, then the quantity each child record actually carries for that line. Sum the child allocations and compare with the original. A sum equal to the original means the line is fully allocated; a sum below it leaves an unallocated remainder that is still owed; a sum above it means at least one record is overstating its share.

Count each physical unit once. A unit shown on a child shipment and also visible in the parent's original line is the same unit in two views, not two units. Keep any authorized order amendments as their own history so the allocation baseline reflects the currently agreed quantities rather than a silently edited original.

Read the split model your tool actually uses

ShipStation's documentation describes splitting as allocating item quantities among shipments, with shipment-specific details and notifications attached to each. That model supports the allocation approach above: each shipment carries its share, and the shares reconcile against the order. The same documentation notes limitations around marketplace updates and partial-fulfillment behavior, so verify how your sales channel receives the results before assuming a split propagates cleanly.

Do not conflate ShipStation's legacy separate-order behavior with its newer multiple-shipment model; the layouts differ, and other platforms may use entirely different split semantics. Confirm the actual integration and layout in use before changing records, and never assume that a repeated quantity field means the same thing in two tools.

Resolve over- and under-allocation before fulfilling

An over-allocated line, where child quantities exceed the original, is a double-count risk: fulfilling every child as written would dispatch more than the buyer ordered. Trace which child record is wrong against the physical pick evidence and the tool's allocation record, and have the authorized owner correct it through the installed system's documented process.

An under-allocated line leaves a remainder with no operational record driving it. That remainder is real work: assign it to a named owner with a next step, whether that is creating the missing allocation through the proper process or recording an authorized decision that the quantity is no longer required. ShipStation's shipment-specific notifications make it worth checking what each child shipment told the buyer, so the messages do not contradict the reconciled figures.

Close with one remaining-obligation figure

The reconciliation ends with a single number per line: the quantity still physically owed, supported by the allocation records and any dispatch evidence for units already sent. The authorized owner signs off on that figure, and support uses it rather than summing visible quantities across records.

Retain the worksheet and underlying records in authorized internal storage. If repeated quantity fields keep producing conflicting fulfillment totals, describe the pattern and your platform through a Prism consultation and confirm scope, responsibilities, fees and terms before any work begins.

Parent-child line allocation worksheet

Complete one pass per affected order, repeating the allocation rows for each product or variation in your own records. Use genuine order and shipment references. The sheet computes what remains owed; it does not authorize picking, shipment or status edits.

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.

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.