Multiple categories for PRODUCT IMPORT issues

  • Posts: 69
  • Thank you received: 1
11 years 2 months ago #121854

-- url of the page with the problem -- : steiner.taylorbruce.com
-- HikaShop version -- : HikaShop Business 2.2.1, Joomla!™ Online Store Component (just updated today-Sept 3, 2013)
-- Joomla version -- :Joomla! 3.1.5 Stable [ Ember ] 01-August-2013 14:00 GMT
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hi,

I would like to import a product into a specific category, and have issues... the wrong category/categories are being assigned to the product. I have tried MANY different alternatives... using the parent_category alone and in combination with the categories field.

Can you point me in the right direction? Here is the parent_category field I am using...
myProducts/Collection1/Series1/Gloves

With the above, I get the product imported just fine, but the category is "product category", As I said, I have tried many many different things...

Thanks,

Dennis

______________
Dennis Kmetz

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 2 months ago #121859

In the "categories" column of your CSV, you need to enter the category name where the product is. So if the product is in the Gloves category, simply enter the name of that category in there.

If your categories are already created via the menu Products>Categories of HikaShop, there is nothing else to do.

If not, and you don't ant to create them via the interface because you have a lot of categories, then, you will have to enter the category tree in your CSV with one category relation per line.
So the tree myProducts/Collection1/Series1/Gloves will actually require three lines in the CSV like that:
product_code,parent_category,categories
,myProducts,Collection1
,Collection1,Series1
,Series,Gloves
my_product,,Gloves

The import documentation actually also explains that and much more about the import:
www.hikashop.com/support/documentation/73-hikashop-import.html

I also invite you to create one or two products via the interface like you want and then do an export of the products and you will get a CSV with all the possible columns and what should go where which will be a good help for you to create your own CSV.

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

  • Posts: 69
  • Thank you received: 1
11 years 2 months ago #121978

Hi,

Making the product into three lines in the CSV helped, and did import a product with the desired category tree structure, but it did have some unwanted side effects... specifically that the product is also in all the parent categories of the tree structure.

Here is what I did:
product_name, product_code, parent_category, categories
test22 test22 myProducts Gloves
test22 test22 Gloves MIG-Welding
test22 test22 MIG-Welding Super-Premium

This is what I want... test22 shows up having a category of:
myProducts / Gloves / MIG-Welding / Super-Premium

This is what I go:
test22 shows up having three categories as follows:
myProducts / Gloves
myProducts / Gloves / MIG-Welding
myProducts / Gloves / MIG Welding / Super-Premium

Are there any alternatives to this?

Dennis

______________
Dennis Kmetz

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 2 months ago #121980

That's how you should do it, as per my instructions:
product_name,product_code,parent_category,categories
,,myProducts,Gloves
,,Gloves,MIG-Welding
,,MIG-Welding,Super-Premium
test22,test22,,Super-Premium

The following user(s) said Thank You: dkmetz@taylorbruce.com

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

  • Posts: 69
  • Thank you received: 1
11 years 2 months ago #122014

Nicolas,

That worked for me... thanks!
I missed the fact that a blank product_name and product_code are required for inserting a product into the tree structure.

Dennis

______________
Dennis Kmetz

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

Time to create page: 0.065 seconds
Powered by Kunena Forum