Bulk Importing New Product Category Relationships, Brands, Filters & Product Groups

Importing the primary category and brand of products

You can upload a CSV file that will assign products to their primary categories and brands by adding the following 2 fields - the External Code is set for each category by the website admin when setting up each category:

Download Sample File

The following is a sample file for importing product category links:

Click here to Download Sample Product Category Links CSV File

Can also be used for changing primary categories and/or brand categories

You can use this import file to change a primary category or BRAND category for a set of products. 

Automating additional categories, filter groups and/or product groups

Before adding filter groups to your website make sure to set up  a call with Magico so that these can be set up in a way that will enhance your website.  

You can also include up to 10 additional external category code columns - the External Code is set for each category by the website admin when setting up each category.  Since filter groups and product groups are also set up like categories, their External Code can be included in these columns.

NOTE: Unlike the primary/brand categories above, this file can't be used to change a category/filter/product group.  It is only used for adding products to categories.

 Adding External codes to your categories/brands

• Choose CATEGORIES & NAVIGATION from the CATALOGUE in the top navigation
• Navigate to the category/brand that you wish to add an external code for. Click update on the category/brand
  • 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.  Make sure to add the external code to the lowest level of category.   Click Update on the subcategory you wish to add the external code to.  
• Enter a code in the ExternalCode field and save.  This external code field is used to match the category (eg in systems integration & spreadsheet) to a website category/brand code.

How to Import the File:

• Save your spreadsheet in csv (utf-8) format.  To do this use save as in excel, chose the file type csv utf-8:
• Log in as web admin and click Catalogue - Bulk Imports
• Click Import Product Category Links
• 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.
• You may need to CLEAR CACHE in SETTINGS to see the the updates on the front end of the website straight away.

NOTE: The number count of inserts + updates may differ from the number of rows imported.  This is because 1 row can have multiple inserts/updates as each category is a separate insert/update.