Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

CSV File issues when importing to site Rate Topic   - - - - -

 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 17 October 2012 - 07:08 PM #1

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
Thank you for your request.

The problem occurs because there is no following code:


,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


starting from the following line:


N0612,Bondage///Restraints


The correct line must be the following one:


N0612,Bondage///Restraints,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
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.
Thanks

 
  • BaDTaG
  • Senior Member
  • Members
  • Join Date: 01-Jul 11
  • 188 posts

Posted 20 October 2012 - 09:06 PM #2

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
VPS Hosting whit easy VPS control panel no technical skills required.
EDB Eksperten din online it forhandler

 

Posted 21 October 2012 - 05:40 PM #3

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

PC0001 Games///Fun & Games 12.99 etc

should be

PC0001, Games///Fun & Games, 12.99, etc

or even better

"PC0001", "Games///Fun & Games", "12.99", etc.

It should match the delimited specified in the backend import options.

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 5126 posts

Posted 22 October 2012 - 11:05 AM #4

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

John

4 14.1


 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 07 November 2012 - 10:52 AM #5

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