You have the option to upload a related products csv file – which simply lists all products (not versions) and the products that they are related to.
Download Sample File
The following is a sample file for importing related products:
Click here to Download Sample Related Products CSV File
The Fields to include in the File
The following explains each field:
ProductCodeA |
Max 50 chars |
The unique ProductCode of the product you wish to add related products to. NOTE: Only PARENT products or products without a version |
ProductCodeB |
|
The unique ProductCode of the product that is related to ProductCodeA above. NOTE: If ProductA is related to ProductB, it does NOT automatically relate B to A – this would need to be added as a 2nd row in this file |
SortOrder |
Integer |
The order in which they are displayed (sorted in ASCENDING order) |
Additional Fields
The following are additional optional fields that can also be included:
TypeCode |
Max 50 chars |
Optional type code - the default is "ProductDetail":
|
How to Import the File:
- Log in as web admin and click Catalogue - Bulk Imports
- Click Import Related Products
- Browse to the file and click Upload
- It will then tell you if the file was uploaded successfully and how many records were imported and then inserted/updated - as well as how many errors/warnings were found. If there are errors/warnings, they will be listed down the page.
- If you wish to see the related products on the front end of the website you will need to Clear Cache in Settings.
Comments
0 comments
Please sign in to leave a comment.