Importing to multiple PARENT categories

  • Posts: 82
  • Thank you received: 1
13 years 4 months ago #20987

I have products that need to be imported into various PARENT categories. Example:

Parent categories are:

Riding Apparel
Children's Riding Apparel
Boots and Half Chaps

Children's Riding Boots would need to be shown in all 3 Parent categories. So far the import only allows a single parent category listed in the product_parent_id heading.

How can I make this happen> It's extremely cumbersome to change the parent category 3 times, or go into EACH product and assign a new category.


Note: the arrangement of categories is consistent with other sites in the customer's industry.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
13 years 4 months ago #20989

There is no product_parent_id heading for CSVs...

You can do that like this:
product_code,categories
my product,"Riding Apparel,Boots and Half Chaps,Children's Riding Apparel"

It's explained there: www.hikashop.com/en/support/documentatio...hikashop-import.html
Also, if you export a product with several categories, you will get a CSV which will give you an example of how to do your import.

Please Log in or Create an account to join the conversation.

  • Posts: 82
  • Thank you received: 1
13 years 4 months ago #20995

Sorry, meant parent_category

If it were as simple as you'd described :)

My csv is set up as follows:

product_code
images
product_tax_id
product_parent_id
parent_category
categories
product_name
product_description
price_value

Note that there is a PARENT category and CATEGORIES. I need to be able to do ONE import of a list of products and assign them to multiple PARENT CATEGORIES. To better illustrate, Category tree looks something like the following:

Riding Apparel
-Tall Riding Boots
-Paddock Boots
-Half Chaps
-Coats
-Shirts
-Breeches
-Belts

Boots and Half Chaps
-Paddock Boots
-Half Chaps
-Riding Boots
-Tall Riding Boots

Children's Riding Apparel
-Tall Riding Boots
-Paddock Boots
-Half Chaps
-Coats
-Shirts
-Breeches
-Belts

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
13 years 4 months ago #21004

Now I see what you mean. It's indeed not possible.
The only option I see with the current import is to use the categories ids then.
For example, if Riding Apparel->Tall Riding Boots has the id 5 and Children's Riding Apparel->Tall Riding Boots has the id 6
You could do like this:
product_code,categories
my_product,"5,6"

Please Log in or Create an account to join the conversation.

  • Posts: 82
  • Thank you received: 1
13 years 4 months ago #21120

worked PERFECTLY. Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.065 seconds
Powered by Kunena Forum