i want to add 3 level of category to my csv

  • Posts: 56
  • Thank you received: 0
7 years 2 months ago #259136

-- HikaShop version -- : 3.6.5

hello , i want to add 3 level deep categories to my csv file. and i know that i it has level of categories but i need one more. i read your answers about exact question in another topic but it didn't work well.

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
7 years 2 months ago #259139

Hi,

So what CSV are you using ?
If you followed our instructions in the other threads or on our CSV documentation it should normally work so I can only guess that you missed something.

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

  • Posts: 56
  • Thank you received: 0
7 years 2 months ago #259188

i am using the exact format but i don't know what should i do whold you help me? tell me what should i do.plz

Last edit: 7 years 2 months ago by ebrahimahamdi.

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

  • Posts: 56
  • Thank you received: 0
7 years 2 months ago #259193

would you mind tell what is your format ? how should i create it?would you giving me sample.plz

Last edit: 7 years 2 months ago by ebrahimahamdi.

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
7 years 2 months ago #259191

Hi,

What exact format ?
What CSV are you using ?

Please understand that we are not able to provide you any useful help if we do not have the basic details about what you're doing, with which content and what instructions you followed.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 56
  • Thank you received: 0
7 years 2 months ago #259303

it is my first time that i am using csv for importing product in hikashop. because i didn't know the right format of excel file , i use 'export'' of hikashop then i use that excel file for adding my product in it , after that i upload that excel format in google sheet for convert it to csv by utf-8 for supporting persian. after i download that csv from google sheet i import it to hikashop.

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
7 years 2 months ago #259304

Hi,

So in the CSV that you got when you used the export button, you must have seen "empty" rows at the beginning which only contains the category structure.
You can even do a test on our demo website if you want: demo.hikashop.com/administrator/index.ph...ikashop&ctrl=product
You'll see that thanks to such lines, you can add as many levels of categories as you want with a CSV.
Our CSV documentation also explains what to write in the parent_category and categories columns in order to do that:
www.hikashop.com/support/documentation/73-hikashop-import.html

Importing product categories

Then, you can also have a categories column where you can put a list of categories id or a list of categories namekey.

For example:

product_code,product_name,categories

my_product_1,My first product,"2,13"



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.

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



You could also mix both products and categories in the CSV:

product_code,parent_category,categories

,main category 1,sub category 2

my_product_1,main category 1,sub category 2

The following user(s) said Thank You: ebrahimahamdi

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

  • Posts: 56
  • Thank you received: 0
7 years 2 months ago #259388

thank you :whistle:

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

Time to create page: 0.069 seconds
Powered by Kunena Forum