Jump to content

CSV Product import categories


Recommended Posts

I am trying to import a csv of products, for migrating our store from XCart. However, the example CSV uses category names in the category field, and as we have subcategories that have the same name, I tried using the ID instead of the name, but that doesn't work: it created a new category each time with the category ID as a name.

 

Our category structure is similar to this:

 

- "Main category 1"

-------"Subcategory"

- "Main category 2"

-------"Subcategory"

 

As there are two categories named "Subcategory", we can't use it as an identifier for the category. How could we solve this?

Link to comment
Share on other sites

Have you considered concatenating the MainCategory name into the Subcategory name?  You can do this easily in Excel by creating another column and entering the formula to concatenate the two.

       A       B        C

1 Main1  Sub   =A1 & "_" & B1

2 Main2  Sub   =A2 & "_" & B2

 

The third column will have

Main1_Sub

Main2_Sub

 

You can't have two different categories with the same name regardless of whether or not they are under another category.

CJ

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...