Skip to main content

Magmi Single and Multiple Category Importer

Magmi On the fly Category Creator

Magmi can create or update categories while it is importing products
This document refers to On the fly category creator Version 0.2.3

Categories column

To assign your products to categories, include a column called "categories" in your CSV file. If a category branch does not exist, it will be created on the fly during the import process and your products will be assigned to it
Each branch level of the category tree is separated with a forward slash (/).
In the example shown above, the two products will be put into their own categories and the following tree will be created
A product can appear in more than one category by including the extra categories in your data. Each category path is separated by two semicolons (;;)
In the example shown above, product 1000 will appear in the category called "level3" AND the category called "level3bis". The category tree generated will be

Default Category Values

The categories will be created with the following default values:
is_active = 1
is_anchor = 1
include_in_menu = 1
The default values can be changed while you are importing your data. This is done by including extra attributes with the category path. Eg
The format of the attributes are:
category name::[is_active]::[is_anchor]::[include_in_menu]

Escaping forward slash

If your raw data contains forward slashes, you can change the character used to separate branches by modifying the "Tree level separator" value in the Magmi configuration screen.
Alternatively, you can escape the forward slashes that you require in your category name by prefixing them with a backwards slash. Eg
In the example shown above, we have escaped the forward slash between Mens and Boys. This will create the following category branches

Base Category Tree

This Magmi plugin allows you to define a prefix that will be added to every category included in your CSV file. This can be especially useful when you need to append your categories to a selected root node.
category2

Example File

In the example shown above, product 1000 will appear in the category called "level3" AND the category called "level3bis". This is the same as one of the examples shown earlier in this post. However, by including the base category tree setting, the category tree will be prefixed with "shoes" and "mens".

Assigning products to the last node of each branch

By default products are assigned into all levels of the category they are assigned to
In the example shown above:
- Product 100 will be active in "My Products", "Sample Products" and "Sample Category"
- Product 101 will be active in "My Products" and "Other Products"
You can change the import to only activate the product in the last category level. For example:
- Product 100 will only be active in "Sample Category"
- Product 101 will only be active in "Other Products"
To do this, change the "Assing product to" setting to "last category of each branch". Note : The label used in the plugin has a spelling mistake. The work "Assing" should be "Assign".
category3

Setting Explicit Root Categories

I do not understand how this part of Magmi works. If you can explain it better, please send me an email or leave a comment and I will update the post (and give you full credit for the information)
In the meantime, I have copied the raw Wiki section below
STORE CATEGORY ROOT NAMES HAVE TO BE PUT BETWEEN SQUARE BRACKETS [] TO BE IDENTIFIED AS CATEGORY ROOT NAMES
The plugin will try to detect on which root(s) to create the categories listed in the item line.
if store column is set with non admin:
will create categories under each root of listed stores
if store column is set to admin:
will create rooted trees under corresponding root
will create unrooted trees under main store root
Say we have :
store1 with StoreRootName1 root category name
store2 with StoreRootName2 root category name
store1 is main store
will create
Now, unrooted line
now cat tree will be

Comments

Popular Posts