Product List Export/Import Issues need to be fixed!Author: Tom G.
In last couple of days, I looked into export/import from/to Product List of the Shopping Cart.
I found number of things that need to be fixed or implemented. (I have to thank here Andy A., who helped me in my testing.)
You can manually add product’s description which contains many new lines (hitting “Enter” while editing). The new lines make description displayed on the page more readable, look nicer.
This is the “Description” added manually:
This is how it looks in the “Shopping Cart”:
And this is in an export csv file:
The export csv file for one product is supposed to have two lines: the header and product line. With the new lines in “Description” this is not the case…
The solution I suggest, is replacing every CRLF (new line) character by “\n”. And when importing record with number of “\n”s, change each of them back to CRLF.
Issue with the semicolons in the “Description”.
When imported after export – getting:
but product doesn’t show in "Shopping Cart"!
Similar situation with commas.
When exporting – getting following csv record:
The row #2 is divided into separate cells. Importing doesn’t work:
These are three things regarding certain characters in mandatory fields.
I also found issues in exporting products with different kinds of “Discounts”. But for now – I skip them…