I hope this make sense…
When I export my collection to take a physical inventory, I get some crazy stuff in the the columns. It looks like something brought over from the Amazon description is screwing the whole thing up.
For instance I have this entry in my collection
000000000000000F Antwone Fisher (Full Screen Edition) Luke, Derek and Washington, Denzel and Gooding, Rainoldo and Hod Drama
Everything after the description in that row is blank in the exported CSV. HOWEVER it looks like the information that was meant for subsequent columns in the row are now on separate rows. It looks like it is because of the description, as a result of what I think are the special characters in the last line in the description
The description reads: AspectRatio
Going to myPHPAdmin and exporting from there as xls works fine. However these descriptions were a direct result of the Amazon look up.
Here is a picture to illustrate my point: http://www.seanandtiff.com/ExportCapture.PNG
Since I had the problem on 95% of my entries. I fixed this problem by running an SQL update
However it might be something that needs to be changed in the Amazon Lookup.
- The topic ‘Export Collection issue with Amazon Descriptions’ is closed to new replies.