CSV File issues when importing to site

I have produced a csv file with cateogies like this

PC0001 Games///Fun & Games 12.99 etc

I have imported into CS Cart and it won't add all the categories and states that I have missing delimeters?

I have asked the CS Cart support and they have said this

[color=#555555][font=Arial, Helvetica, sans-serif][size=3]Thank you for your request.[/size][/font][/color]

[color=#555555][font=Arial, Helvetica, sans-serif][size=3]The problem occurs because there is no following code:[/size][/font][/color]


[color=#555555][font=Arial, Helvetica, sans-serif][size=3]starting from the following line:[/size][/font][/color]


[color=#555555][font=Arial, Helvetica, sans-serif][size=3]The correct line must be the following one:[/size][/font][/color]


Can someone explain what the heck this means or how I even begin, has the way of filling in the CSV file changed as I've never done it like this before and I can't fill my site with products.

Why all the commas? It doesn't make sense to me?

Any direction would be great.


i think that we need a bit of the csv fifle to help out.

so pleas attache a bit of the file containing the error

If that's literally what your csv file contains, looks like you don't have delimited between the fields i.e.

[color=#282828][font=arial, verdana, tahoma, sans-serif]PC0001 Games///Fun & Games 12.99 etc[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]should be[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]PC0001, Games///Fun & Games, 12.99, etc[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]or even better[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]“PC0001”, “Games///Fun & Games”, “12.99”, etc.[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]It should match the delimited [/font][/color][font=“arial, verdana, tahoma, sans-serif”][color=“#282828”]specified in the backend import options.[/color][/font]

I always export and import with “,” selected , is far easier for me in excel.


Thanks will give it a go, its just strange, never had to do this before with CS Cart?