Product code Category Product name Short description Description Price Inventory tracking Taxes
“MSR0030” [tab] “Computer Systems@@@Netbooks@@@MSI@@@Wind Netbook Series” [tab] “U100-028AU-IC N280/1.66/1/160/10.2"” [tab] “U100-028AU-IC N280/1.66/1/160/10.2"” [tab] “ATOM N280 1.66GHz,1GB RAM,160GB HDD,10.2" WSVGA NO ODD,WLAN 11N+BT,6 CELL BTRY,BAG,1.3MB WEB CAM 1 YR WRTY, WIN 7 STARTER - ROSE” [tab] “699” “D” “GST”
Take the above sample csv. When the Product name or Short description and other fields have " at the end. The CS Cart import script refuses to import even though it’s escaped with a
But if I add a letter/word at the end it will import… ie: (adding boo)
“U100-028AU-IC N280/1.66/1/160/10.2"boo”
The above sample is TAB delimited.
Is this a bug?
Try importing with the csv delimiter as comma - you don’t have to worry about the quotes.
Make sure your final column has data in every cell.
Same thing happens with comma delimited.
The final column contains information like
Laptop blah blah 17"
Or category names for monitors like 24"
I rather maintain the original description/names by escaping then renaming the whole data…
[quote name=‘Lyn’]Try importing with the csv delimiter as comma - you don’t have to worry about the quotes.
Make sure your final column has data in every cell.[/QUOTE]
Put a different column as your last column. I always use the Taxes column as my last column as it always has information in it and no quotes.
Basically just change the order of your columns and put the Taxes column last.