Gil Mobile Online Posted September 27, 2008 Share Posted September 27, 2008 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 More sharing options...
jeremy Posted October 13, 2008 Share Posted October 13, 2008 Can I get a copy of the working csv from you? Link to comment Share on other sites More sharing options...
hong Posted October 14, 2008 Share Posted October 14, 2008 i want a copy of one~~tks Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 15, 2008 Author Share Posted October 15, 2008 hong, i sent one for you today Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 15, 2008 Author Share Posted October 15, 2008 i attach one also here hopelast.csv Link to comment Share on other sites More sharing options...
jeremy Posted October 16, 2008 Share Posted October 16, 2008 is it possible to specify the image file to be used in the csv? Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 16, 2008 Author Share Posted October 16, 2008 jeremy, i do not understand your request...please help me by saying againregards Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 23, 2008 Share Posted October 23, 2008 I'm still having problems with CSV files, I got a hold of the csv file for one of my suppliers and whatever I seem to do I end up with:-Invalid CSV file or delimiter.If I use the helplast.csv file posted on here though it works.Please, any help you can offer! Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 23, 2008 Share Posted October 23, 2008 I've got further now, but when I try to import it (final stage) I now get:-Hack attempt (Product -> quantity = Product Status) Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 23, 2008 Author Share Posted October 23, 2008 eraase the first lineafter it should work Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 25, 2008 Share Posted October 25, 2008 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 More sharing options...
Gil Mobile Online Posted October 25, 2008 Author Share Posted October 25, 2008 try with my file....and erase the inputs after, put the products at one category onlycheck it out at www.gilmobile.ro/shop , it works... Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 25, 2008 Share Posted October 25, 2008 I don't see any csv file?Did you say to import all the items into one category?And I guess this category must already exist in your shop? Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 25, 2008 Author Share Posted October 25, 2008 I don’t see any csv file?Did you say to import all the items into one category?And I guess this category must already exist in your shop?Where don't u see the csv file?yes, try with one catogory at ones, then with morethe category is already made in the backoffice Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 25, 2008 Share Posted October 25, 2008 Thanks for answering so quickly.I have deleted my store, including database due to these problems. I shall now be recreating the store and will try to import the file again. Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 29, 2008 Share Posted October 29, 2008 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. Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 29, 2008 Author Share Posted October 29, 2008 try to import my file or to modify it....i go now to footballgood luck Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 29, 2008 Share Posted October 29, 2008 As I originally said, I can import the test csv that you posted on this topic but not anything else.Can anyone please help?? I can supply the file I am using if that helps?? Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 30, 2008 Author Share Posted October 30, 2008 Put it here, i will try....But if you modify as you want my file, doesn't it work? Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 30, 2008 Share Posted October 30, 2008 I have used your file and yes it works. When I go to replace the content with my own it does not work. Also as I say, the original CSV file I have does not work.I have attached the CSV file my supplier has given me, please be warned this is for an adult themed shop. Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 30, 2008 Author Share Posted October 30, 2008 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 More sharing options...
Darkmarauder Posted October 30, 2008 Share Posted October 30, 2008 Thanks for that, I'll wait and see how you go with the file, I have had no luck at all. Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 31, 2008 Author Share Posted October 31, 2008 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 More sharing options...
Darkmarauder Posted October 31, 2008 Share Posted October 31, 2008 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 ProRegards Link to comment Share on other sites More sharing options...
Gil Mobile Online Posted October 31, 2008 Author Share Posted October 31, 2008 give it to me: PM or mail: [email protected] Link to comment Share on other sites More sharing options...
pchammer Posted November 1, 2008 Share Posted November 1, 2008 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 More sharing options...
Darkmarauder Posted January 9, 2009 Share Posted January 9, 2009 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 More sharing options...
kamaltin Posted July 8, 2009 Share Posted July 8, 2009 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 More sharing options...
Recommended Posts