- Posts: 3
- Thank you received: 0
Import Categories Exel > CSV(?) > HikaShop
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:
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.
- Posts: 12953
- Thank you received: 1778
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.
Doesn't work to create categorie, subcat1, subcat2 respectively.
What am I doing wrong?
This:
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
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.
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.
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
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.
Please Log in or Create an account to join the conversation.
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.
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
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.