When you use the 'Vendors - Import Vendor - Category Connections' import process, you need to upload a file containing the category ID's and vendor/supplier ID's to determine which links to create. For this you use the template that you can download in step 2 of the import process.
Below is an example of a correctly filled import template:
All columns from the import template are explained below. If the import file does not meet these requirements, the import will fail.
Categories and suppliers in the same line in the uploaded template will be linked together. You will see this in Vendors and in Admin > Vendors settings > Connect commodities.
Column | Explanation | Requirements | Required |
categoryid | The reference of the category. You can find it in Admin > Tables > Commodities. |
The reference of an existing category in Admin > Tables > Commodities. |
Yes |
supplierid | The ID of the vendor. You can find this in the vendors overview in Vendors > Vendors. Make sure 'supplierid' is checked via the Columns function. |
Numeric vendor ID of an existing vendor in the Vendors module. |
Yes |
Comments
0 comments
Please sign in to leave a comment.