[Skip to main content](#vessel-content)

#   Product Export Problems

##

- **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")**
- [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Topic Author
- [ Offline](/forum/user/6276-tony-10uk-net)

Less More

- Posts: 127
- Thank you received: 12
-
-

12 years 10 months ago [\#139176](#139176) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")  *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139176 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")* was created by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")*

-- HikaShop version -- : 1.5.7
-- Joomla version -- : 1.7

Hi,

I just tried to do a full export of my products.

It exported a CSV file which is semi-colon delimited.

I imported that into Excel on my Mac.

However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.

Here is the first line in the file:

"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";"stock_shelf";"parent_category";"categories_image";"categories";"price_value";"price_currency_id";"price_min_quantity";"price_access";"files";"images";"related";"options";"Colour";"Weight";"Size";"Range";"Strength";"Length";"Waggler Floats - Unloaded";"Waggler Floats - Loaded";"Sizes";"Stonfo bait holders";"Wychavon carp rod";"Okuma Razor";"Specialist Freespin";"Big Pit Freespin";"Okuma Carbonite";"Okuma Electron";"Rapide RD";"Okuma Compressa RD";"Okuma Octana";"WB Clarke XTS Pellet";"Carbon Pellet Waggler";"Fox FX Spin";"XTS poles";"Carborex carbon pushover pole";"Mini Fat Plugbait";"Shallow running lure";"Deep Diving Lure";"Fat Plugbait";"Hand Sanitizer";"B/S";"Colours";"Gardner Fleece";"Gardner Sweat Jacket";"Gardner Beenie";"Covert Tackle";"Covert Arrow Beads";"Covert swivel kwik lok";"Covert maggot clips";"Cover Rig rings";"Covert Rolling &amp; Mini Swivels";"colour";"weight";"Hook Type";"Hook Size";"Hook Sizes";"Shirt sizes";"Mirage size / B/S";"Line B/S";"Diameter";"B/S &amp; length";"B/S &amp; Colour";"Bait Drills";"Hair Needles";"Gate Latch Needle";"Braided Hair Needle";"Stringer needles";"Size ";"Slinga Catapults &amp; accessories";"Bait";"Colour/Flavour";"flavour / Size";"Type";"Size/Colour";"Type / Flavour";"Flavours";"Colou / Flavour";"Colour / Size";"Size/colour";"Colour / type";"Flavour";"Size / Qty";"size/flavour";"Flavour/colour";"Flavour / colour";"Flavour / weight";"Pack size";"Length/kit/ extension";"Pole/kit/extension";"Section No";"Chair &amp; Accessories";"Test Curve";"Model";"Set or individuals";"Gardner Casting Glove";"Banshee 12'";"Reel &amp; Guard";"Middy PTFE Bushes";"Middy Pole Connectors";"Middy Shock Core Internal Bushes";"Middy Shock Core winder bung";"Middy Low-Viz Flourocrystal";"LB's B/S";"model";"Size &amp; Weight";"Jungle";"Crave";"Winter Almond"

From that point on none of the data loads into the correct columns.

What am I doing wrong? Why does the first line not just show the proper hikashop product list?

Thanks,

Tony

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 10 months ago [\#139197](#139197) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139197 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Hi,

Where do you have tried to export the products ? from the products listing ?
If it is, how many products do you try to export at the same time ? Thanks to try to export thanks to the mass actions.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")**
- [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Topic Author
- [ Offline](/forum/user/6276-tony-10uk-net)

Less More

- Posts: 127
- Thank you received: 12
-
-

12 years 10 months ago -  12 years 10 months ago [\#139215](#139215) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")  Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139215 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Yes I am doing from the Products page.

All sub elements selected.

Trying to export all products but just tried it with a single product with the same result.

There are about 600 products.

Even stranger is that when I change the filter options an export download is triggered without me pressing the export button. (EDIT: If I go out and then back into the page the filter options work again)

This used to work.

Tony

Last edit: 12 years 10 months ago by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile"). Reason: edit

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86571
- Thank you received: 14316
-
-

12 years 10 months ago [\#139339](#139339) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139339 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

It looks like the software that you're using to open your CSV didn't detect the ; as delimiters for the columns.
You can change the "CSV separator" option to comma in the configuration of HikaSop so that your software will be able to properly detect the different columns of your CSV.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")**
- [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Topic Author
- [ Offline](/forum/user/6276-tony-10uk-net)

Less More

- Posts: 127
- Thank you received: 12
-
-

12 years 10 months ago [\#139347](#139347) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")  Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139347 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

It's not that. The semi colon delimiters are recognised.

It seems to be including lots of strange fields in the header line.

I think the problem is in the export.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86571
- Thank you received: 14316
-
-

12 years 10 months ago [\#139349](#139349) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139349 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Aren't these fields custom fields or characteristics of your products ? If so, then it's normal that you see them as columns.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")**
- [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Topic Author
- [ Offline](/forum/user/6276-tony-10uk-net)

Less More

- Posts: 127
- Thank you received: 12
-
-

12 years 10 months ago [\#139374](#139374) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")  Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139374 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Ah that's normal? Characteristics maybe. No custom fields.

The first four products look OK but then it goes wrong.

"704","0","Pkangling Rig Kit","&lt;h3&gt;These kits are fantastic value. Enough to make 6 UK rigs or 3 continental rigs with spare clips, cones and swivels. available in 6 colours.&lt;/h3&gt;
&lt;h4&gt;&lt;strong&gt;Kit contains&lt;/strong&gt;&lt;/h4&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;1 x 2 mtr length of rig tube.&lt;/strong&gt;&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;10 lead clips.&lt;/strong&gt;&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;10 tail cones.&lt;/strong&gt;&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;10 swivels.&lt;/strong&gt;&lt;/li&gt;

Product 704 is where it goes wrong but later corrects itself but goes wrong again a bit later. So the columns have data in them that should relate to a different column.

All very strange as the text delimiter (") is set correctly on import.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86571
- Thank you received: 14316
-
-

12 years 10 months ago [\#139409](#139409) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#139409 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

I don't see the problem.
Please provide your CSV.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")**
- [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile")
- [ Offline](/forum/user/11107-byoguru)

Less More

- Posts: 99
- Thank you received: 5
-
-

10 years 9 months ago [\#228195](#228195) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile")  Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#228195 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Hello, I am experiencing the same issue.
It seems to do with HTML code that contains "" - is there a solution?

Any help appreciated!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")**
- [![byoguru's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11107-byoguru "View byoguru's Profile")
- [ Offline](/forum/user/11107-byoguru)

Less More

- Posts: 99
- Thank you received: 5
-
-

10 years 9 months ago [\#228209](#228209) by [byoguru](/forum/user/11107-byoguru "View byoguru's Profile")  Replied by *[byoguru](/forum/user/11107-byoguru "View byoguru's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#228209 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

*** UPDATE ****

I see a difference in the data between the Export Button on the Products page vs Exporting from Mass Actions.

When exporting data from Product screen the HTML code can break the CSV import to XL
When exporting data from MASS ACTIONS - the data can be opened in XL without issue.

- Tony

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

10 years 9 months ago [\#228216](#228216) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product Export Problems](/forum/37-import-export-csv-xls/864886-product-export-problems#228216 "-- HikaShop version -- : 1.5.7 -- Joomla version -- : 1.7  Hi,  I just tried to do a full export of my products.  It exported a CSV file which is semi-colon delimited.  I imported that into Excel on my Mac.  However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.  Here is the first line in the file:  &quot;product&#95;id&quot;;&quot;product&#95;parent&#95;id&quot;;&quot;product&#95;name&quot;;&quot;product&#95;description&quot;;&quot;product&#95;quantity&quot;;&quot;product&#95;code&quot;;&quot;product&#95;published&quot;;&quot;product&#95;hit&quot;;&quot;product&#95;created&quot;;&quot;product&#95;sale&#95;start&quot;;&quot;product&#95;sale&#95;end&quot;;&quot;product&#95;delay&#95;id&quot;;&quot;product&#95;tax&#95;id&quot;;&quot;product&#95;type&quot;;&quot;product&#95;vendor&#95;id&quot;;&quot;product&#95;manufacturer&#95;id&quot;;&quot;product&#95;url&quot;;&quot;product&#95;weight&quot;;&quot;product&#95;keywords&quot;;&quot;product&#95;weight&#95;unit&quot;;&quot;product&#95;modified&quot;;&quot;product&#95;meta&#95;description&quot;;&quot;product&#95;dimension&#95;unit&quot;;&quot;product&#95;width&quot;;&quot;product&#95;length&quot;;&quot;product&#95;height&quot;;&quot;product&#95;max&#95;per&#95;order&quot;;&quot;product&#95;access&quot;;&quot;product&#95;group&#95;after&#95;purchase&quot;;&quot;product&#95;min&#95;per&#95;order&quot;;&quot;product&#95;contact&quot;;&quot;product&#95;last&#95;seen&#95;date&quot;;&quot;product&#95;sales&quot;;&quot;product&#95;waitlist&quot;;&quot;product&#95;layout&quot;;&quot;product&#95;average&#95;score&quot;;&quot;product&#95;total&#95;vote&quot;;&quot;stock&#95;shelf&quot;;&quot;parent&#95;category&quot;;&quot;categories&#95;image&quot;;&quot;categories&quot;;&quot;price&#95;value&quot;;&quot;price&#95;currency&#95;id&quot;;&quot;price&#95;min&#95;quantity&quot;;&quot;price&#95;access&quot;;&quot;files&quot;;&quot;images&quot;;&quot;related&quot;;&quot;options&quot;;&quot;Colour&quot;;&quot;Weight&quot;;&quot;Size&quot;;&quot;Range&quot;;&quot;Strength&quot;;&quot;Length&quot;;&quot;Waggler Floats - Unloaded&quot;;&quot;Waggler Floats - Loaded&quot;;&quot;Sizes&quot;;&quot;Stonfo bait holders&quot;;&quot;Wychavon carp rod&quot;;&quot;Okuma Razor&quot;;&quot;Specialist Freespin&quot;;&quot;Big Pit Freespin&quot;;&quot;Okuma Carbonite&quot;;&quot;Okuma Electron&quot;;&quot;Rapide RD&quot;;&quot;Okuma Compressa RD&quot;;&quot;Okuma Octana&quot;;&quot;WB Clarke XTS Pellet&quot;;&quot;Carbon Pellet Waggler&quot;;&quot;Fox FX Spin&quot;;&quot;XTS poles&quot;;&quot;Carborex carbon pushover pole&quot;;&quot;Mini Fat Plugbait&quot;;&quot;Shallow running lure&quot;;&quot;Deep Diving Lure&quot;;&quot;Fat Plugbait&quot;;&quot;Hand Sanitizer&quot;;&quot;B/S&quot;;&quot;Colours&quot;;&quot;Gardner Fleece&quot;;&quot;Gardner Sweat Jacket&quot;;&quot;Gardner Beenie&quot;;&quot;Covert Tackle&quot;;&quot;Covert Arrow Beads&quot;;&quot;Covert swivel kwik lok&quot;;&quot;Covert maggot clips&quot;;&quot;Cover Rig rings&quot;;&quot;Covert Rolling &amp; Mini Swivels&quot;;&quot;colour&quot;;&quot;weight&quot;;&quot;Hook Type&quot;;&quot;Hook Size&quot;;&quot;Hook Sizes&quot;;&quot;Shirt sizes&quot;;&quot;Mirage size / B/S&quot;;&quot;Line B/S&quot;;&quot;Diameter&quot;;&quot;B/S &amp; length&quot;;&quot;B/S &amp; Colour&quot;;&quot;Bait Drills&quot;;&quot;Hair Needles&quot;;&quot;Gate Latch Needle&quot;;&quot;Braided Hair Needle&quot;;&quot;Stringer needles&quot;;&quot;Size &quot;;&quot;Slinga Catapults &amp; accessories&quot;;&quot;Bait&quot;;&quot;Colour/Flavour&quot;;&quot;flavour / Size&quot;;&quot;Type&quot;;&quot;Size/Colour&quot;;&quot;Type / Flavour&quot;;&quot;Flavours&quot;;&quot;Colou / Flavour&quot;;&quot;Colour / Size&quot;;&quot;Size/colour&quot;;&quot;Colour / type&quot;;&quot;Flavour&quot;;&quot;Size / Qty&quot;;&quot;size/flavour&quot;;&quot;Flavour/colour&quot;;&quot;Flavour / colour&quot;;&quot;Flavour / weight&quot;;&quot;Pack size&quot;;&quot;Length/kit/ extension&quot;;&quot;Pole/kit/extension&quot;;&quot;Section No&quot;;&quot;Chair &amp; Accessories&quot;;&quot;Test Curve&quot;;&quot;Model&quot;;&quot;Set or individuals&quot;;&quot;Gardner Casting Glove&quot;;&quot;Banshee 12'&quot;;&quot;Reel &amp; Guard&quot;;&quot;Middy PTFE Bushes&quot;;&quot;Middy Pole Connectors&quot;;&quot;Middy Shock Core Internal Bushes&quot;;&quot;Middy Shock Core winder bung&quot;;&quot;Middy Low-Viz Flourocrystal&quot;;&quot;LB's B/S&quot;;&quot;model&quot;;&quot;Size &amp; Weight&quot;;&quot;Jungle&quot;;&quot;Crave&quot;;&quot;Winter Almond&quot;  From that point on none of the data loads into the correct columns.  What am I doing wrong? Why does the first line not just show the proper hikashop product list?  Thanks,  Tony")*

Hi,

Please describe more your problem and provide the CSV with the issue.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjQ4ODYtcHJvZHVjdC1leHBvcnQtcHJvYmxlbXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.106 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
