Next is the product category relationships file – which is a file of your products and the categories they are assigned to. Each product is normally assigned to a primary category and a brand category. And some would also be assigned to other categories too.
Sample Product Category Relationship CSV File
The following is a sample csv file:
"ProductCode","PrimCat_ExternalCode","BrandCat_ExternalCode"
"A1234","MENSJUMPERS",”NIKE”
"B2345"," MENSJUMPERS ",”NIKE”
"C3456","MENSTROUSERS",”ADIDAS”
Mapping each category code to the corresponding website category using External Category Codes
For this export, we will simply be assigning each product to categories on the website.
Before you set this export up, you will need to have set up some or all of the categories on the website. You then need to map the categories on your ePos/ERP to the categories on your website using a unique code for each category (which we call the “External Code”).
To update each category on the website with the same unique code that you are using in your CSV file, log in to your website as an admin and go into the category update screen for each category. You will see an EXTERNAL CODE field which is blank. Enter the ERP/ePos code into this field and click SAVE.
Note the following:
- You only have to set up EXTERNAL CODES for the bottom level categories. For example, if a main category is called MENSWEAR and it has 5 sub-categories called MENSSHIRTS, MENSJUMPERS, MENSTROUSERS, MENSSHOES and MENSSHORTS, you will assign the product to the 5 sub-categories and not the main category.
- Similarly, you need to assign it to the EXTERNAL CODE for each brand category that you will have set up on the website.
File Naming Standard
The following is the CSV file that you can export:
CSV File |
|
|
Product Category Relationships |
prodcats_YYYYMMDDHHMMSS.csv |
Only send products ENABLED FOR WEB
Every 15 minutes |
Fields in the CSV File
Similar to the Products File, the following are the fields for the product category relationships file:
ProductCode |
MAX 50 chars |
Only use PARENT products or products with no versions |
PrimCat_ExternalCode |
MAX 50 chars |
The primary category (the bottom-most node in the category tree)
We need to give all categories on the website a category code which is what is sent to the website in the CSV file when assigning products to website categories in the ePos/ERP.
|
BrandCat_ExternalCode |
|
The brand category code |
SecCat1_ExternalCode |
|
Optional other category 1 code |
… |
|
|
SecCat10_ExternalCode |
|
Optional other category 10 code |
Comments
0 comments
Please sign in to leave a comment.