csv export of products not opening correctly
13 years 3 months ago #110354
by markV
csv export of products not opening correctly was created by markV
If you are having this problem, download the file to a local machine and at the top put sep=; on a single line then excel will use the ; as a separater rather than the , it is expecting when you open it up. for example:
Code:
sep=;
"product_id";"product_parent_id";"product_name";"product_description";"product_quantity";"product_code";"product_published";"product_hit";"product_created";"product_sale_start";"product_sale_end";"product_delay_id";"product_tax_id";"product_type";"product_vendor_id";"product_manufacturer_id";"product_url";"product_weight";"product_keywords";"product_weight_unit";"product_modified";"product_meta_description";"product_dimension_unit";"product_width";"product_length";"product_height";"product_max_per_order";"product_access";"product_group_after_purchase";"product_min_per_order";"product_contact";"product_last_seen_date";"product_sales";"product_waitlist";"product_layout";"product_average_score";"product_total_vote";"product_page_title";"product_alias";"product_price_percentage";"product_msrp";"product_canonical";"additional_information";"categories_ordering";"parent_category";"categories_image";"categories";"price_value";"price_currency_id";"price_min_quantity";"price_access";"files";"images";"related";"options";
Please Log in or Create an account to join the conversation.
13 years 3 months ago #110359
by nicolas
Replied by nicolas on topic csv export of products not opening correctly
Or you can set the separator in the Excel import interface:
www.youtube.com/watch?v=m4n7FwDH2Js
Or you can also change the CSV separator option of the configuration of HikaShop
www.youtube.com/watch?v=m4n7FwDH2Js
Or you can also change the CSV separator option of the configuration of HikaShop
The following user(s) said Thank You: markV
Please Log in or Create an account to join the conversation.
13 years 3 months ago #110364
by markV
Replied by markV on topic csv export of products not opening correctly
didn't know about the separator in the shop config! Thanks
Please Log in or Create an account to join the conversation.
Time to create page: 0.169 seconds