Supplier Association CSV

Last Updated: Apr 02, 2018 06:12PM PDT
Use the Supplier Association CSV to add supplier-specific information (unit cost, lead time, default reorder quantities, etc.) to your variants, informing replenishment and streamlining purchase order data entry.

Download CSV

From the Variants or Products page, click Actions > Supplier Association CSV:

Associate Supplier Info

To associate a supplier with a variant, you'll need that supplier's Contact ID in Stitch:
Column Header Description Value Type
Variant Description (Reference Only) The name of the variant. Changes won't be imported N/A
SKU
(Reference Only)
Your SKU. Changes won't be imported N/A
Variant ID (Required) The Stitch-generated variant ID N/A
Contact ID (Required) The Stitch-generated contact ID Number
Contact Name
(Reference Only)
The top-level contact name in Stitch. Changes made here won't import. N/A
Supplier SKU The ID your supplier uses to identify this item

Automatically added to purchase order line items
Alphanumeric
Default Supplier Cost The price you generally pay for this item from this supplier

Automatically added to purchase order line items
Price
Default Reorder Quantity The quantity you generally order from this supplier Number 
Primary Supplier Yes or no, 1 = yes, 0 = no

Used for dropshipping.
0/1
Dropshippable Yes or no, 1 = yes, 0 = no

Used for dropshipping.
0/1
Lead Time in Days Number of days between opening a PO, sending it to your supplier, and receiving stock Number (of days)
Default Reorder Quantity (Warehouse Specific) The quantity you generally order from this supplier for this warehouse.

Auto-fill on purchase orders to speed up data entry.
Number
Lead Time in Days (Warehouse Specific) Number of days between opening a PO, sending it to your supplier, and receiving stock for this warehouse.

Used to calculate dynamic reorder points.
Number (of days)
Safety Stock (Warehouse Specific) The minimum number of days of inventory you wish to maintain for this warehouse.

Used to calculate dynamic reorder points.
Number (of days)
Once you've made your edits, save the spreadsheet as a CSV file. If there are format options available, be sure to select UTF-8.

Import CSV

To upload the file, return to Products or Variants and click Actions > Supplier Association CSV.