Import CSV all in a specific category

  • Posts: 156
  • Thank you received: 0
6 years 9 months ago #288272

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.5
-- PHP version -- : 5.6

How can I import a CSV in order to have all items added in a specific category?

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
6 years 9 months ago #288293

Hi,

In your CSV, you can add a "categories" column and enter either the name or the id of the category in that column for all the rows (it's really easy to do in Excel). Then, import that modified CSV and you'll have what you want.

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

  • Posts: 156
  • Thank you received: 0
6 years 9 months ago #288331

Where can I find the name or the id of category in hikashop that it must matches the name or the category added in CSV?

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

  • Posts: 1119
  • Thank you received: 114
6 years 9 months ago #288338

Hi,

You can use name or ID but I would prefer ID. To find it go to hikashop->categories. Please check my screenshot.

Thanks

Attachments:

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

  • Posts: 156
  • Thank you received: 0
6 years 8 months ago #289922

But before I need to create a "category" in Hikashop or after the CSV import Hikashop, automatically create the category?
For example:
category BRAND (brand1, brand2 brand3, etc...)

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

  • Posts: 2143
  • Thank you received: 747
6 years 8 months ago #289923

www.hikashop.com/support/documentation/7...shop-import.html#csv
-> "Importing product categories":

You can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes".


Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

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

  • Posts: 156
  • Thank you received: 0
6 years 8 months ago #290121

lousyfool wrote: www.hikashop.com/support/documentation/7...shop-import.html#csv
-> "Importing product categories":

You can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes".


It also applied for the characteristic and variant?

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

  • Posts: 2143
  • Thank you received: 747
6 years 8 months ago #290125

SuX wrote: It also applied for the characteristic and variant?


Sorry, but did you actually look at the documentation page I already linked to (and here again)? If you do, you can't miss the paragraph titled "Importing products with variants".


Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
6 years 8 months ago #290122

Characteristics and values of characteristics won't be generated for you. You need to pre create them.

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

Time to create page: 0.101 seconds
Powered by Kunena Forum