To set up your catalogue quickly, you can import a CSV file with all your categories in a table.
You can create CSV files in EXCEL. Always save your file as an excel file (.XLSX) while you are working on it (This avoids issues in opening a .csv file in excel such as losing leading zeros). Then when you are ready to import save the file as CSV instead of XLSX.
Download Sample Categories File
The following is a sample file for importing new categories:
Click here to Download Sample Categories CSV File
This import works well to add new categories or brands, it cannot be easily used for to update categories/brands as there are a number of standard category fields which must be in the upload.
The standard Category Fields
When importing new categories, the following are the standard fields.
|
CategoryCode |
MAX 50 chars |
The unique category code - the external code |
|
Title |
MAX 100 chars |
The title of the category |
|
ParentCategoryCode |
MAX 50 chars |
Depending on the category type, use the following values for this column:
|
| SortOrder |
Number |
Optional: This is set automatically to 0 (zero) but you can override it here |
Additional Fields
The following are additional optional fields that can also be included:
|
MegaMenuTitle |
Max 100 chars |
Optional alternative title for the menu bar |
|
DisableMegaMenuLink |
True or False |
To disable clicking on this menu option |
|
Active |
True or False |
This is set automatically to TRUE but you can override it here |
| ActiveFrom
ActiveUntil |
Date |
Use date format "1 Jan 2020" OR "1 Jan 2020 14:30" if you want to use time as well |
| SEODescription |
Max 4000 chars |
|
| SEOTitle |
Max 150 chars |
|
| OverrideLink |
Max 200 chars |
For Menubar Only: Allows set the URL for this menu bar link |
| ShowProductList |
True or False |
This is set automatically to TRUE for menubar and brands but you can override it here |
Viewing a Category's CATEGORYCODE
The CategoryCode maps to the External Code for a category. To view the External Code for an existing category, follow these steps:
- Choose CATEGORIES & NAVIGATION from the CATALOGUE in the top navigation
- To view an external code for a category click update on that category
- See brand categories by choosing brands on the left navigation
- See primary categories by clicking PRODUCT CATOLOGUE & NAVIGATION on the left navigation and clicking VIEW PAGES/SUBCATEGORIES on the top level category. Click Update on the subcategory you wish to view the external code for.
You can see the external code for some categories in the "All Bottom Level Categories" report in ANALYTICS - REPORTS.
This external code field can also used in systems integrations.
How to Import the File:
- Save the file as a .csv (uft8) format.
- Log in as web admin and click Catalogue - Bulk Imports
- Click Import Categories
- 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
Comments
0 comments
Please sign in to leave a comment.