Example of CSV file

  • Posts: 97
  • Thank you received: 1
  • Hikashop Essential
9 years 7 months ago #197774

-- HikaShop version -- : HikaShop Essential 2.4.0

Do you have an example of a CSV file, that is properly formatted, and contains all the fields necessary for import? This would help me to properly prepare my CSV file.

Thank you

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

  • Posts: 36
  • Thank you received: 5
9 years 7 months ago #197790

Hi,

You can check this link.
It has a file that I created which works. It has a before an Excel code and after.
www.hikashop.com/forum/9-commercial-jobs...eadsheet-to-csv.html

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 7 months ago #197791

Hi,

@bw92116 : Sure !
Just perform a CSV export and you will have you perfect sample according to your configuration and custom fields.
It is the best way to have the right CSV for your current website.

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: 97
  • Thank you received: 1
  • Hikashop Essential
9 years 7 months ago #197792

OK thank you!

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

  • Posts: 97
  • Thank you received: 1
  • Hikashop Essential
9 years 7 months ago #198122

So to clarify, for Import, does Hikashop prefer the CSV file with:

Field delimiter ;
Text delimiter "

And if there is no data for a field, is it better to have
;;
or to have
;"";

? Thank you

Last edit: 9 years 7 months ago by bw92116.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 7 months ago #198124

Hi,

When there is no data, you can use ;; or ;"";
HikaShop will handle them both but for human eye, I will recommend you ;""; (it is easier to count the number of columns).

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.

Time to create page: 0.070 seconds
Powered by Kunena Forum