Bulk Importing Menubar Categories & Brands – AB Commerce Online Help

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:

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: Menubars - Use the parent category's EXTERNAL CODE Brands - Set this to BRANDS
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

Related articles