In order to create a valid CSV for uploading supplier assignments, we’re going to need to start by downloading a product CSV export from your store’s admin. We’ll then add in columns for supplier assignments, which should result in a CSV we can upload to create those supplier assignments. Only some of the rows and columns from the export will be needed, but it will be an excellent starting point for creating a CSV for the app.
Set Up Product Export
To begin, we’ll need to create a product export from your ecommerce store. The export will provide an easy way to identify products that the app will be able to match with your store after additional columns have been added.
Export Settings
From your store admin’s catalog area, you can do a complete export of all the store’s products by clicking the “Export All” button from the “Import or Export Products” dropdown.
If you’re not ready to import values for all products yet, you can always do a search before exporting the products, and the resulting CSV will only have those searched products included.
After exporting, you should get a CSV with a lot of data about your products. We’ll use this as a starting point to create our threshold values upload.
New Columns
The CSV that gets generated by your store’s admin has a lot of extra rows and columns. The only rows needed are the ones with the type “product” and “product_variation“. Of the columns, we only need to keep type, product_internal_id, and url. Extra columns or rows aren’t a problem and will be ignored by the app, but in the above example they’ve been removed for clarity.
The upload CSV can also take additional columns, which correspond with their settings supplier assignments in the app: Supplier Price, Minimum Quantity, Supplier SKU, Order Multiple and Pack Quantity. The order of these columns doesn’t matter, but the columns need to have those names. Please keep these restrictions in mind when willing out values for these fields:
- Minimum Quantity, Order Multiple and Pack Quantity should be positive integers
- Supplier Price needs to be a positive number with a period as the decimal separator, without currency markers (currency signs, thousands separators, etc.)
Uploading 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.
Supplier Purchase Orders for Ecwid by Lightspeed
Supplier Purchase Orders can help you manage your store’s purchase orders and warehouse receiving. Try now, and get a 7 day free trial!