You can import your vendor attribute data to create and update your vendor attributes in Inventory Planner.
Vendor attributes are a kind of variant data which correspond to a specific vendor, such as a vendor reference or product name. They are distinct to variant data and vendor data. Learn more about vendor attributes here.
To import vendor attributes, on the Imports screen, select "Variants/vendor attributes", then click "Upload file" at the bottom of the page:
Building an import file
Create a spreadsheet including the information you want to import, making sure each column has a header:
Column name | Required | Column type | Comments |
Vendor | ✓ | Text |
|
SKU Title ID | ✓ | Text | One of these four columns is required to act as an identifier. |
Vendor reference |
| Text |
|
Vendor product name |
| Text |
|
Minimum order quantity |
| Number |
|
Units of measurement |
| Number |
|
Cost price |
| Number |
|
Landing cost price |
| Number |
|
Tier prices |
| Other | Must be formatted as
e.g. in a situation where the price is $2/unit for any quantity below 100, then $1.50/unit for a quantity over 100, the file would read |
Currency |
| Text | Must be in ISO 4217 format. |
Notes |
| Text |
|
You can download a CSV template to help you build your file. Once you've built it, either drag and drop your file into the upload area, or click the upload area to select your file from your computer. Then, click "Map columns".
Mapping fields
Map your columns in the file to Inventory Planner fields. In addition to the columns in the file, you have some options to configure:
Vendor
If not set in the file, choose which vendor you're importing associations for.Remove all other vendors
Enable to remove the other vendors and vendor attributes specified for variants in the import only. This action cannot be undone.If vendor not found
Tell Inventory Planner what to do if the vendor in the file cannot be matched to an existing vendor:Create vendor
Report error
Match by
Choose which identifier you're using to map your variants.Currency
If not set in the file, select the currency of prices in the file.
Once you've mapped all your columns, click "Import".
Inventory Planner will process the file. Once the file is processed, you will be presented with a summary of the changes made and a list of any errors that were triggered.