Jump to content

Example of correct CSV import file


Recommended Posts

After fighting to discover the right format of a CSV file, reading on the forum and uploading like hell, i discovered the right format for a CSV fil(it works for me). It is a basic example but it can be updated and developed acording to the needs of each user. While dealing with wrong formats, it took like 10 minutes to upload a file...now it is quick and relieble and it is 6 in the morning :))

Hint, create the categories....make a scheme, with them and their ID's (these will be used to send a product to it's category). First number at the category is level 1 category, second number is level 2 category and so on (ex: 14,25 -it is a good category example)

I wrote these because I noticed that a lot of people encounter difficulties.

If anybody can make the file better, please submit, it helps a lot!

Best wishes and let this Shop long live!!!

Link to comment
Share on other sites

  • 3 weeks later...

I did as was said and deleted the first line, still it didn't work.
So I trimmed the almost 3600 products down to the first 5 or 6 products and it did import them.
Only thing is, now when you go to the front office and click on any of the products, it doesn't bring up the proruct but it does bring up 'hack attempt' at the top of the page instead. Also the products are not anywhere in the category listing or 'home' in the back office. The only way I can see the product listing (and get the hack attempt message) is to go to 'new products'.
Something tells me this csv import is flaky at best.??

Link to comment
Share on other sites

First of all, it is the first time that i see this kind of file...coma delimited :)) . OK, i have also CSV files but i save them from excel and do not look like yours, i have the columns, but still, i think, yours should work....
Second, I think, blank spaces (lines, columns) are not accepted....

I will try later more but this is for now, gotta leave in a bit...

Link to comment
Share on other sites

Hi,

I did not find a sollution but i can suggest that you ask from your supplier the Excel Spreadsheet and after you have it, try to convert it to CSV file so that you get a similar file to mine. I also have the products in Excel and than, conversion. Your supplier has 100% an excel sheet for the products.

Try like this.

Link to comment
Share on other sites

I have now opened the excell version and tried to convert it to various formats and I still get the 'Invalid CSV file or delimiter' error when I try to work.

If it is ok, I can PM the Excel file to you so perhaps you can convert it to CSV and then check it?
Please note I am using Office 2007 Pro


Regards

Link to comment
Share on other sites

I have recreated both my store and database, and now would like to import the csv file I have.
As before though I get the error:-

Invalid CSV file or delimiter.

I really could do with some help on this if anyone has ideas.


what delimiter is in there?
you can change this in Column separator:
default is ;
Link to comment
Share on other sites

  • 2 months later...

Hello PCHammer,

I have got an up to date version of the .CSV file from the supplier, and opened it with notepad.
I see a delimiter of , (comma) but when I attempt to import it into Prestashop I get the error message 'Invalid CSV file or delimiter'.
If yourself or anyone can help with this it would be appreciated.


Regards

Link to comment
Share on other sites

  • 5 months later...

I'd like to make products and categories IDs to be comparable with my inventory and accounting programs.

for instance, there are all notebooks products IDs start from 1000 till 4999. desktops IDs start from 5000 till 9999and etc.
But there are not all products IDs in use, actually only first ~50-250 numbers of each range, all other numbers are reserved for future.

same question concern categories.

can i use that numbering scheme in PS? Does it reflect bad to data integrity?

I understand, when I will enter products and categories manually in BO, they will get first auto incremental IDs. I am planning to make updates only with import function.

Link to comment
Share on other sites

×
×
  • Create New...