Change layout of the contents in exported CSV file

  • Posts: 14
  • Thank you received: 0
12 years 2 days ago #75820

Hi

Can someone please tell me how to change the contents in the exported CSV file to a table layout? I want to create all my products in the excel file and import to Hikashop afterwards but the right now the contents are all in the same cell separated by commas.

Thanks


File Attachment:

File Name: hikashopexport.csv
File Size:4 KB



Attachments:

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

  • Posts: 82796
  • Thank you received: 13357
  • MODERATOR
12 years 2 days ago #75984

Hi,

When you import your CSV in excel, you need to change the separator from , to ; so that it can display them nicely.

Otherwise, you can change the separator used by HikaShop in the Files tab of the configuration.

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

  • Posts: 78
  • Thank you received: 5
  • Hikashop Business
11 years 9 months ago #88268

Just as a little tip, if you still have this problem, before you open up the CSV file in excel, open it up in Notepad.

Add a line at the top that says:

sep=;

Save that file and then open in Excel. That will then work, depending on your setup.

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

Time to create page: 0.054 seconds
Powered by Kunena Forum