A Thousand Apps .

---

What Is the Supplier Assignments CSV?

The Supplier Assignments CSV feature allows you to bulk-assign your BigCommerce products (and variants) to a single supplier by editing a single CSV file. You begin by exporting your product list from BigCommerce, adding the required supplier assignment columns, and then uploading the file. This speeds up the process of mapping products to suppliers—especially beneficial if you have a large catalogue.

---

Step-by-Step: How to Prepare & Upload Your CSV

1. Export Your Product List

• In BigCommerce, start by creating an export template. In your store’s settings, click the “Export templates” to create new export settings.

• On the next page, click the Create an Export Template… button.

• For this export, we’re only going to need to export products.

• We’ll need to enable the Include Product Options? setting as well. This will let us export information about product variants as well as products. We’ll need to see variants in the export in order to set assignments for them, instead of just setting assignments for their parent products.

• The CSV only technically needs the Item Type, and the Product ID fields for the upload to work, but you’ll probably need a few more fields to identify what products and variants those ID values relate to. If we select Product SKU and Product Name values, we should be able to identify what each row relates to.

2. Add Supplier Assignment Columns

• Open the exported file in a spreadsheet editor (Excel, Google Sheets, etc.).
• You only technically need the Item Type and Product ID fields for the upload to work—but adding the supplier information is what will make the assignment truly helpful.
• Insert the following supplier information columns (exact names must match):
  • Supplier SKU
  • Supplier Cost
  • Minimum Quantity
• Make sure your entries follow validation rules:
  • Minimum Quantity should be a whole number (no decimals).
  • Supplier Cost should be a number without currency symbols or special characters.
• Important: The CSV is intended for one supplier only. Remove rows for products not relevant to that supplier, otherwise those products will be assigned incorrectly.
• Every row in the CSV will be used to create a supplier assignment, even if no values are present for the three added columns.

3. Upload the CSV

Once you have a CSV created for a supplier, go to the Supplier Product Assignments section of the app, and select the supplier that the CSV is related to. Click the Choose File button to select the CSV, and then click the Upload Assignments CSV to start the upload.

A box will appear below letting you know how the upload is going. After processing for the CSV has started, you can click the View Assignments tab to see assignments getting created. If any errors occur, we’ll reach out and let you know.

---