sales .cvs file import

  • Posts: 92
  • Thank you received: 0
13 years 3 weeks ago #28866

Hi,
I found the sales record can be exported as a .csv file on the sales page.
Please advise how to import the .csv file back to the sales page?
Thanks!

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 3 weeks ago #28895

That's not possible.
Sales can only be exported.

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

  • Posts: 92
  • Thank you received: 0
13 years 3 weeks ago #28956

Hi,
So, what is the main function of the sales .cvs export for?
Any software can apply for this file like a normal readable table?
Because when I open it by excel is display like:
product_id;"product_parent_id";................
(even I open it in WINCVS, is the same)
Regs.,
Jade

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 3 weeks ago #28980

Well, that's because you need to configure them to handle the semi colon as a separator. Alternatively, you can change that in the HikaShop configuration so that HikaShop exports the CSV files with comma as the separator.
Then, when you import the CSV in Excel, you will have the data in columns as expected.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum