adrianutrilla Posted July 21, 2014 Share Posted July 21, 2014 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 More sharing options...
cjrhoads Posted July 22, 2014 Share Posted July 22, 2014 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now