csv export of products not opening correctly

Start
Prev
1
Next
End

markV
Topic Author
Offline

Posts: 12
Thank you received: 0

11 years 5 months ago #110354

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:

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.

nicolas
Online

Posts: 82863
Thank you received: 13372
MODERATOR

11 years 5 months ago #110359

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