My Duel with CSV upload

[Rayan]

I am trying to upload some 6000 products on my local server. I am not able to import products properly. Can some1 give me a sample sheet of there CSV so that I can see the example. I made one myself but when I go for uploading it gives me error " CANNOT BE SAVED "

Please some1 explain to me each and every step of this.

[Rayan]

WHy is it that no one has replied to my thread yet? Is it that you are not able to understand it?

[Kelvin Koh]

I am trying to upload some 6000 products on my local server. I am not able to import products properly. Can some1 give me a sample sheet of there CSV so that I can see the example. I made one myself but when I go for uploading it gives me error " CANNOT BE SAVED "

Please some1 explain to me each and every step of this.

Hi Rayan,

I guess nobody knows how to help without details from you other than your mention of "CANNOT BE SAVED" error.
Is it the CSV format or uploading and importing process that you're having problems with?

Have you searched and read the threads related to CSV formats, upload & import? If you haven't, please do or see:
1. http://www.prestashop.com/forums/viewthread/86913/
2. http://www.prestashop.com/forums/viewthread/92016/

Take note that when you are importing products via CSV (obviously file format must be in .csv extension) from BO, you have to select the correct "Products" choice from the drop-down menu.

Attached are 2 CSV files - 1 for product, another for product's combinations

Sample Product.csv

Sample Combinations.csv

[Rayan]

I am trying to upload some 6000 products on my local server. I am not able to import products properly. Can some1 give me a sample sheet of there CSV so that I can see the example. I made one myself but when I go for uploading it gives me error " CANNOT BE SAVED "

Please some1 explain to me each and every step of this.

Hi Rayan,

I guess nobody knows how to help without details from you other than your mention of "CANNOT BE SAVED" error.
Is it the CSV format or uploading and importing process that you're having problems with?

Have you searched and read the threads related to CSV formats, upload & import? If you haven't, please do or see:
1. http://www.prestashop.com/forums/viewthread/86913/
2. http://www.prestashop.com/forums/viewthread/92016/

Take note that when you are importing products via CSV (obviously file format must be in .csv extension) from BO, you have to select the correct "Products" choice from the drop-down menu.

Attached are 2 CSV files - 1 for product, another for product's combinations

I just checked the Sample file which you attached. First of all. I am using a separate cell for each coloumn. I am not using ; as a separator. I will post the images and then you can see the error properly.

For eg:-

You Wrote
Products ID; Product Name; Price in one cell

What I wrote is
Products ( Different Cell ) Name( Different Cell ) Price ( Different Cell )

I hope u understand what I am trying to say.

[Kelvin Koh]

I am trying to upload some 6000 products on my local server. I am not able to import products properly. Can some1 give me a sample sheet of there CSV so that I can see the example. I made one myself but when I go for uploading it gives me error " CANNOT BE SAVED "

Please some1 explain to me each and every step of this.

Hi Rayan,

I guess nobody knows how to help without details from you other than your mention of "CANNOT BE SAVED" error.
Is it the CSV format or uploading and importing process that you're having problems with?

Have you searched and read the threads related to CSV formats, upload & import? If you haven't, please do or see:
1. http://www.prestashop.com/forums/viewthread/86913/
2. http://www.prestashop.com/forums/viewthread/92016/

Take note that when you are importing products via CSV (obviously file format must be in .csv extension) from BO, you have to select the correct "Products" choice from the drop-down menu.

Attached are 2 CSV files - 1 for product, another for product's combinations

I just checked the Sample file which you attached. First of all. I am using a separate cell for each coloumn. I am not using ; as a separator. I will post the images and then you can see the error properly.

For eg:-

You Wrote
Products ID; Product Name; Price in one cell

What I wrote is
Products ( Different Cell ) Name( Different Cell ) Price ( Different Cell )

I hope u understand what I am trying to say.

Rayan,

May I know which Spreadsheet program are you using? I'm using OpenOffice's Calc to create the data before converting (and saving) it in CSV format. If you're using Excel to open the file, it'll show the data in one cell.

When you open the csv file in semi-colon format using OpenOffice Calc, it'll show in different columns not one. When you open it using Notepad (plain text program), you will see the data in strings and rows, seperated by ";".

When we create data in spreadsheets (in both Excel and OO Calc), we input them in different columns, but both programs convert data into CSV format differently. OpenOffice Calc is more user-friendly when it comes to Spreadsheet-to-CSV file format conversion as it creates CSV files with ";" field seperator by default.

[Rayan]

I am trying to upload some 6000 products on my local server. I am not able to import products properly. Can some1 give me a sample sheet of there CSV so that I can see the example. I made one myself but when I go for uploading it gives me error " CANNOT BE SAVED "

Please some1 explain to me each and every step of this.

Hi Rayan,

I guess nobody knows how to help without details from you other than your mention of "CANNOT BE SAVED" error.
Is it the CSV format or uploading and importing process that you're having problems with?

Have you searched and read the threads related to CSV formats, upload & import? If you haven't, please do or see:
1. http://www.prestashop.com/forums/viewthread/86913/
2. http://www.prestashop.com/forums/viewthread/92016/

Take note that when you are importing products via CSV (obviously file format must be in .csv extension) from BO, you have to select the correct "Products" choice from the drop-down menu.

Attached are 2 CSV files - 1 for product, another for product's combinations

I just checked the Sample file which you attached. First of all. I am using a separate cell for each coloumn. I am not using ; as a separator. I will post the images and then you can see the error properly.

For eg:-

You Wrote
Products ID; Product Name; Price in one cell

What I wrote is
Products ( Different Cell ) Name( Different Cell ) Price ( Different Cell )

I hope u understand what I am trying to say.

Rayan,

May I know which Spreadsheet program are you using? I'm using OpenOffice's Calc to create the data before converting (and saving) it in CSV format. If you're using Excel to open the file, it'll show the data in one cell.

When you open the csv file in semi-colon format using OpenOffice Calc, it'll show in different columns not one. When you open it using Notepad (plain text program), you will see the data in strings and rows, seperated by ";".

When we create data in spreadsheets (in both Excel and OO Calc), we input them in different columns, but both programs convert data into CSV format differently. OpenOffice Calc is more user-friendly when it comes to Spreadsheet-to-CSV file format conversion as it creates CSV files with ";" field seperator by default.

I am using MS OFFICE 2007. I am making this file in EXCEL 2007. I am thinking of installing OPENOFFICE in my pc. Let me know which version to install and is it similar to EXCEL?

[Kelvin Koh]

OpenOffice is similar to MS Office and it comes with a database program (equivalent of MS Access).
You can download the latest OpenOffice here.

[Osvald]

More convenient to use a portable assembly
OpenOfficePortable
you can edit uniCSVed

Yarn Shop