Import Categories Exel > CSV(?) > HikaShop

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:

"parent_category","categories";
BRAND,MODEL,SPECINFO,09/94-01/97,SPECINFO1,SPECINFO,,

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.

This:

categories
Brand,Model,Info1,09/94-01/97,

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

product_code,parent_category,categories
,"On use","Type,Brand,Model,Subcat2,Year",

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.

Yes, I did so.

"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";"";"";"";"";"";"";"";"";

product_code,parent_category,categories
,"On use","Type,Brand,Model,Subcat2,Year",

You just have to use the "parent_category" column for your subcategories, it will place the category inside the parent one

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

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

parent_category,categories
,ERA
ERA,CARBON
CARBON,ANATAL

you worte exact in this moment. thank you