To set up your catalogue quickly, you can import a CSV file with all your categories in a table.
You can create CSV fields in EXCEL and just 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
The standard Category Fields
When importing new categories, the following are the standard fields.
CategoryCode |
MAX 50 chars |
The unique category 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 |
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.
- The ExternalCode field will appear as in the following screen. This external code field is also used to match the category (eg in systems integration & spreadsheet) to a Magico category code - so if possible, use the code from your internal system as the CategoryCode.
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 |
How to Import the File:
- 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.