Supplier Association CSV

Last Updated: Dec 19, 2017 09:43AM PST
Use the Supplier Association CSV to associate variant with one or more suppliers. From the Variants or Products page, click Actions > Supplier Association CSV:

Stitch will look for unique pairs of ID's in the Variant ID and Contact ID columns to create associations or update information related to those associations. 

To create relationships between your Suppliers and Variants, look up the Contact ID number in Stitch for the Supplier you would like to associate with a Variant. Then, add the Stitch Contact ID number to the Contact ID filed for the variant.

You can set default re-order quantity by warehouse for your Variants on the CSV.

You can set Supplier relationships between multiple Suppliers and one Variant by copying and pasting the Variant ID in another row under the Variant ID column on the CSV. Add the Stitch Supplier Contact ID under the Contact ID Column. 

You can also mark variants as dropshippable, so that they can be drop shipped on orders to your suppliers. To do this, write 1 for 'Yes' in the column for Is Dropshippable and Is Primary Supplier. (a value of 0 signifies 'No')
 
Column Header Description Value Type
Variant Name (for reference only) The name of the variant. Changes will not be imported NA
SKU (for reference only) Your SKU. Changes will not be imported NA
Variant ID The Stitch generated variant ID  NA
Contact ID The Stitch generated contact ID Number
Contact Name (for reference only) Your contact name. Changes will not be imported NA
Supplier Product ID The ID your supplier uses to identify this item Alphanumeric
Supplier Default Unit Cost The price you generally pay for this item from this supplier Price
Default Reorder Quantity The quantity you generally order from this supplier Number 
Is Primary Supplier Yes or no, 1 = yes, 0 = no 0/1
Is Drop Shippable Yes or no, 1 = yes, 0 = no 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 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 Number (of days)
Safety Stock (Warehouse Specific) The minimum number of days of inventory you wish to maintain for this warehouse Number (of days)

Note: Information in the Variant name, SKU, and Contact Name columns is for reference only and will not be imported. Deleting, editing, reordering, or adding column headers will result in upload errors.

When edits are complete, save the spreadsheet as a CSV file. If there are format options available, be sure to select UTF-8. To upload the file, head to the Inventory page and click Actions > Supplier Association CSV.