A Safer Shopify Inventory Transfer Worksheet Before Receiving

Large Shopify inventory transfers are easiest to troubleshoot before anyone clicks “Receive.”

When a transfer arrives in several deliveries, the receiving screen is only one part of the problem. The harder question is whether the spreadsheet still identifies the right variant, location, and quantity after the shipment was split. A clean receiving checklist prevents a quick workaround from creating a barcode or inventory problem later.

Start with stable identity

Keep at least one stable product identity on every row:

• Variant ID when it is available
• Shopify SKU
• Barcode only when it is a real, existing barcode

Do not replace a real UPC, EAN, or GTIN with a temporary value just to make a screen searchable. If the receiving workflow does not find a variant by SKU, first confirm whether it expects the barcode field, whether the SKU is duplicated, and whether the row belongs to the correct location. A temporary backfill can be useful only when the barcode field is genuinely unused and the change has been tested on a small group.

Make the shipment boundary explicit

A transfer that arrives in three deliveries should not be treated as one unexplained quantity. Add a shipment or receipt reference to your working sheet, then keep these fields together:

• Transfer or shipment reference
• Source and destination location
• Variant ID, SKU, and barcode
• Expected quantity
• Quantity in this delivery
• Remaining quantity
• Review note

The sum of the delivery quantities should equal the expected transfer quantity. If it does not, leave the row open for review instead of forcing the remaining amount into the latest shipment.

Separate planning from receiving

A transfer plan answers “how much should move?” Receiving answers “what actually arrived?” They should share the same identifiers, but they should not overwrite one another.

For planning, compare destination stock against a minimum and target level. Cap the suggested transfer by source availability and flag any source shortfall. For receiving, record the delivered quantity and inspect variance against the plan. A planning worksheet can suggest a quantity; it cannot confirm that a carrier delivered it.

Review before applying changes

Before importing or entering anything into Shopify:

1. Check that every row has a destination location.
2. Check that SKU and barcode values are not duplicated across unrelated variants.
3. Confirm that quantities are numeric, non-negative, and expressed in the same unit.
4. Keep variant rows together when you split a large file.
5. Test one small product group or shipment before processing the full transfer.
6. Save the reviewed before-and-after worksheet for reconciliation.

For a browser-side worksheet that calculates suggested quantities from source stock, destination stock, and min/max rules, see the Shopify inventory transfer CSV planner. It creates a local review file; it does not create Shopify transfers, change barcodes, or write inventory through an API.

The safest transfer workflow is deliberately boring: preserve identity, separate shipments, validate quantities, and keep the reviewed file beside the final Shopify receipt record.