umberto86 Posted December 7, 2015 Share Posted December 7, 2015 Hi Everyone, i seem to be having issues importing products into prestashop using a csv file. Attached is what my csv file looks like. I used the import button under catalog -> products -> import When i select upload the csv file and click next step it doesn't allow me to select the columns See attached screenshots. Any help is appreciated! Link to comment Share on other sites More sharing options...
umberto86 Posted December 7, 2015 Author Share Posted December 7, 2015 But my csv file has no "commas or "semi-colons" everything is separated by columns... is this incorrect? Should it all be in one column with each tab separated by "semi-colons"? Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 7, 2015 Share Posted December 7, 2015 When you export your spreadsheet, you can choose the "delimiter". The delimiter is the character (usually tab, comma or semicolon) that separates the columns in the CSV file. I assume based on your last reply that your CSV is exported with tab characters. You need to export your spreadsheet with semicolon characters. This is done after you choose 'export' in the one of the dialogs that follow. If you have a lot of rows in your file you may also run into a problem (once the import starts working) that the import will "time out" and never complete. When this happens the usual fix is to divide the file up into several smaller files and keep dividing until the import succeeds. Link to comment Share on other sites More sharing options...
umberto86 Posted December 8, 2015 Author Share Posted December 8, 2015 hello, I still seem to be getting the same error... not sure what im doing wrong. Would you mind creating one line with the following? ID, Active (0/1), Name, Categories, Price, Reference #, Quantity, Image URLs, Long Description That way i can format my csv accordingly and test it out. Appreciate the help! Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 8, 2015 Share Posted December 8, 2015 Can you attach a copy of your CSV so I can look at it. Link to comment Share on other sites More sharing options...
umberto86 Posted December 8, 2015 Author Share Posted December 8, 2015 I attached it in zip format since it won't let me attach a .csv Thank you for your help import.csv.zip Link to comment Share on other sites More sharing options...
umberto86 Posted December 9, 2015 Author Share Posted December 9, 2015 hello, just wondering if anyone could please help? We have over 5000 products to import... and doing it 1 by 1 would take forever! Please help. Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 9, 2015 Share Posted December 9, 2015 You should use semicolons for column delimiters when you save your spreadsheet as a CSV. Right now the CSV has commas as delimiters. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now