How can we help?
Use the Inventory CSV to edit existing variants in bulk. Delete or reorder rows, but don't delete or reorder any columns.
Note: Note: This article applies to both our Stitch X and Stitch Classic Versions.
|Remove unneeded rows||Remove or reorder unneeded columns|
|Clear Stock values if you're not making changes to stock. Blank Stock cells import as "no change."||Clear any other values unless you want to erase them.|
- Be Careful
- Export CSV
- Edit CSV
- Import CSV
- Export the Inventory CSV via Products > Actions > Inventory CSV:
Field Notes SKU If using Excel, avoid all-numeric SKUs. Excel reformats numerical strings in scientific notation (e.g., 8.765+E), which will overwrite values if imported back into Stitch. Stock This updates on-hand counts. If you've enabled multi-warehousing, update the Stock column for each warehouse, instead. The Available column is for reference only. Low Stock Set a positive or negative threshold (based on the Available quantity) at which you'd like an alert. Use this alert to trigger reordering, physical count, backorder production runs, etc. Weight (lbs) Value recorded in pounds. Stitch supports imperial measurements only. Average Unit Cost This updates average unit cost for all on-hand units. Default PO ID This is the unique product identifier that your supplier/manufacturer uses. Avoid using this field. Instead, associate supplier part numbers with specific suppliers via the Supplier Variant CSV. Default PO Cost This value appears as the default Unit Cost on Stitch purchase orders. Avoid using this field. Instead, associate default PO cost with specific suppliers via the Supplier Variant CSV. Location ("Bin Location") This field appears on picklists (Orders > Actions > Picklist Export) and gets pushed to ShipStation, helping your fulfillment team quickly locate items. Pricing Tiers Edit pricing tiers to manage pricing in Stitch and on your channels via Master of Price (where supported). Bundle Components Convert variants into bundles in bulk. For more detail, see our Bundles article.
Note: If using Excel for Mac, save your file in the Windows Comma Separated (.csv) file format. If prompted for format options, choose UTF-8.
When the file uploads successfully, you'll see a green Success notification confirming that the file has uploaded for processing.
Once the upload has fully processed, you’ll receive a message in your notification center stating success, partial success, or failure:
For smaller inventories, the process takes just a few minutes. For larger inventories, the process can take 20-40 minutes.