How do I prepare an inventory export for reimport?

Export inventory split by location, retain the SKU, Warehouse ID, Location ID, and Stock Level columns, and replace Stock Level with the final quantity you want at each location.

SKU,Warehouse ID,Location ID,Stock Level
PROD-001,11111111-1111-4111-8111-111111111111,22222222-2222-4222-8222-222222222222,25
PROD-002,11111111-1111-4111-8111-111111111111,22222222-2222-4222-8222-222222222222,0

Replace the example IDs with IDs from your export. A value of 25 sets the location to 25 units; it does not add 25. Zero sets it to zero.

Remove reporting columns such as Name, UPC, Available, Physical, Warehouse Name, and Location Name before importing.

Location ID is optional. Leave it blank to use Location Handle (available or unavailable), or leave both blank for the building’s Default Available location. Location ID takes precedence when both are filled. Use one row per SKU and location.

Products, buildings, and locations must already exist. Positive stock can initialize inventory for an existing product that has never been stocked. The import does not create products or buildings.

See all inventory import fields and results and import errors.