Skip to main content

Import Categories Exel > CSV(?) > HikaShop

13 years 4 months ago #112606 by Feauteau
For a client I need to import an Exel file containing brands, models, and some more info into categories.

He wants a kind of a tree-structure. Brand > Model > Specific Model Info > Year into categories. On the last one, the products ('articles') will be coupled.

The format of the exel is:

BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2

Every thing is listed in a separate column. The last 2 things doesn't have to be imported.

How do I convert this to the correct CSV format (if even needed?) and import it?

This is what I've tried:
Code:
"parent_category","categories"; BRAND,MODEL,SPECINFO,09/94-01/97,SPECINFO1,SPECINFO,,

But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?

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

13 years 4 months ago #112609 by Mohamed Thelji
Hi,

I think that the best method will be to :
- do it manually just for 1 example
- then exporting it through a CSV file
- filling your CSV file with your other values
- and finally importing it.

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

13 years 4 months ago - 13 years 4 months ago #112615 by Feauteau
This:
Code:
categories Brand,Model,Info1,09/94-01/97,

Doesn't work to create categorie, subcat1, subcat2 respectively.

What am I doing wrong?

This:
Code:
categories,categories_image "Brand,Model,Info1,09/94-01/97",

Throws me: Invalid Products: 1.

Is there even a way to do a categorie only import?

Edit: Got it to import.

The current categorie tree-structure is:

On Use > Type > Brand > Subcats I need to import
Code:
product_code,parent_category,categories ,"On use","Type,Brand,Model,Subcat2,Year",

However, this imports the categorie within On Use. So On Use contains Brand, Model, Subcat 2, and Year.

I need to import it like On Use > Brand > Model > Subcat 2 > Year, each within the previous categorie.

Any hints will be very welcome!
Last edit: 13 years 4 months ago by Feauteau.

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

13 years 4 months ago #112624 by Eliot
Hi there,

As Mohamed said, the best to do is to create few categories with one or two product and some categories then export it.
It will give you a great overview of how csv import is working.

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

13 years 4 months ago #112631 by Feauteau
Yes, I did so.
Code:
"product_id";"product_parent_id";"product_name";"product_description";"product_quantity";"product_code";"product_published";"product_hit";"product_created";"product_sale_start";"product_sale_end";"product_delay_id";"product_tax_id";"product_type";"product_vendor_id";"product_manufacturer_id";"product_url";"product_weight";"product_keywords";"product_weight_unit";"product_modified";"product_meta_description";"product_dimension_unit";"product_width";"product_length";"product_height";"product_max_per_order";"product_access";"product_group_after_purchase";"product_min_per_order";"product_contact";"product_last_seen_date";"product_sales";"product_waitlist";"product_layout";"product_average_score";"product_total_vote";"product_page_title";"product_alias";"product_price_percentage";"product_canonical";"product_msrp";"categories_ordering";"parent_category";"categories_image";"categories";"price_value";"price_currency_id";"price_min_quantity";"price_access";"files";"images";"related";"options"; 273;0;"Product";"";-1;"Product";1;0;1373272929;0;0;0;0;"main";0;0;"";0.000;"";"kg";1373272929;"";"m";0.000;0.000;0.000;0;"all";"";0;0;0;0;0;"";0;0;"";"";0.0000000;"";0.0000000;0;"";"";"Brand";"";"";"";"";"";"";"";"";

It throws this out. As you might see, it doesn't help me how the categories are created by CSV.

Like posted before, the current categorie tree-structure is in this way:

On Use > Type > Brand > Subcats I need to import
Code:
product_code,parent_category,categories ,"On use","Type,Brand,Model,Subcat2,Year",

However, this imports the categorie within On Use. So On Use contains Brand, Model, Subcat 2, and Year.

I need to import it like On Use > Brand > Model > Subcat 2 > Year, each within the previous categorie.

Any hints will be very welcome!

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

13 years 4 months ago #112690 by Eliot
You just have to use the "parent_category" column for your subcategories, it will place the category inside the parent one :)

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

13 years 2 weeks ago #130021 by silaroo
hi, i do have the same question, how can i import more than one subcategory?

ERA ist tha parentcategory, CARBON the next level and inside of Carbon there ist ANATAL contained.

how must the csv look like?

There is only parent_category categories to use. i do not need many categories on the same level. but more subcategories.

thank you!
sila

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

13 years 2 weeks ago - 13 years 2 weeks ago #130069 by Xavier
Hi,

This is explained in our Documentation:
www.hikashop.com/support/2013-08-08-00-1...shop-import.html#csv

This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing.

Since version 1.4.1, 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". For example, you could have something like:

parent_category,categories

product category,main category 1;main category 2;main category 3

main category 1,sub category 1;sub category 2


In you case, you need:

parent_category,categories
,ERA
ERA,CARBON
CARBON,ANATAL

Last edit: 13 years 2 weeks ago by Xavier.
The following user(s) said Thank You: silaroo

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

13 years 2 weeks ago - 13 years 2 weeks ago #130070 by silaroo
you worte exact in this moment. thank you
Last edit: 13 years 2 weeks ago by silaroo.

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

Time to create page: 0.080 seconds
Powered by Kunena Forum