Inventory CSV

Last Updated: Apr 09, 2019 03:36PM PDT
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.

Be Careful

Do Don't
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.

Export CSV

  • Be Careful
  • Export CSV
  • Edit CSV
  • Import CSV
  • Export the Inventory CSV via Products > Actions > Inventory CSV:
    ‚Äč

    Edit CSV

    Open the CSV in any spreadsheet software. Don't modify any column headers. If a column header says Reference Only, don't modify that column's contents at all.
    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.
    Once you've made your changes, save the CSV as a new file. Should you mistakenly upload incorrect values, you can use the original export to restore your data.

    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.

    Import CSV

    Import your changes via Products > Actions > Inventory CSV.

    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.