Stitch Labs/Home
Using Stitch
Integrations
The App
Supplier Association CSV
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.
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.
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) |