- Posts: 107
- Thank you received: 2
Example of CSV file
11 years 5 months ago #197774
by bw92116
Example of CSV file was created by bw92116
-- 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
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.
11 years 5 months ago #197790
by charlesdh
Replied by charlesdh on topic Example of CSV file
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
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.
11 years 5 months ago #197791
by Jerome
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.
Replied by Jerome on topic Example of CSV file
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,
@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.
11 years 5 months ago #197792
by bw92116
Replied by bw92116 on topic Example of CSV file
OK thank you!
Please Log in or Create an account to join the conversation.
11 years 5 months ago - 11 years 5 months ago #198122
by bw92116
Replied by bw92116 on topic Example of CSV file
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
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: 11 years 5 months ago by bw92116.
Please Log in or Create an account to join the conversation.
11 years 5 months ago #198124
by Jerome
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.
Replied by Jerome on topic Example of CSV file
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,
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.222 seconds