Creating multilevel CSV file

  • Posts: 2
  • Thank you received: 0
10 years 2 months ago #169850

I am going to create a multi-level CSV file with only one work-book in MS-Excel, but I am not able to that. Please help me how to do it?
For example,
suppose there is an OFFER
this OFFER has several information such as general Info, Offer_type, Billing Rules, Items etc
again, suppose Offer_type has several parts like Purchase, Trial, trial_&_purchase etc.
Trial offer has again some parts like trial_period, upgrade_from_trial etc.

So, now I want to create a csv file by taking all these information. May be i'm a stupid so I am not able to that but still I want to know how to do it.?

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

  • Posts: 13201
  • Thank you received: 2322
10 years 2 months ago #169864

Hi,

To format a csv file with specific data, you will have to create a plugin, and then get and format the data to have desired csv file.
So it require good php skills.

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

  • Posts: 2
  • Thank you received: 0
10 years 2 months ago #169952

Thanks for your reply.

But at first I want to create a CSV file manually after that I will import this file and again export same file as it is needed in my project. So I think first I need knowledge to create a Tree Look csv file which will be parsed in the coding section.

So, please let me know how to create that Tree Look *.CSV file in excel?

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

  • Posts: 82726
  • Thank you received: 13342
  • MODERATOR
10 years 2 months ago #169989

First I would recommend to create a product the way you want via the interface of HikaShop. You'll most likely want to use characteristics/options/custom item fields.
Once you have the product behaving like you want on your frontend, click on the "export" button of the products listing in the backend and that will generate you a CSV and you can base yourself on it in order to add the other products in the CSV.

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

Time to create page: 0.076 seconds
Powered by Kunena Forum