Looking for a sample CSV Import File for products for 1.4.7.0

[lettersets]

Hi,

 

Does anybody have a working CSV Import file for importing products? The sample one I downloaded in version 1.4.7.0 isn't working. Specifically, the "available for order" and "show price" options aren't working. In other words, my imported products are showing up in my shop, but without a price and you are unable to order them.

 

I tried adding the "available for order" and "show price" columns manually to my import file but there was no result. I am unsure what I need to enter in those columns for the products to show the price and be available for order.

 

I was wondering if somebody is using the CSV import products successfully and can share their import file with a sample product.

 

Thanks for your help!

 

Michelle

[lettersets]

I ended up making one myself. If you'd like to have it, please send me a message.

[Carl Favre]

Hi lettersets,

 

It could be even better to attach it to your post .

[Matt80]

Hi lettersets,

 

It could be even better to attach it to your post .

I agree with you:)

[Dh42]

This could be helpful also

http://www.prestashop.com/forums/topic/162556-csv-import/page__p__801320__hl__csv__fromsearch__1?do=findComment&comment=801320

[lettersets]

I can't attach a .csv file, but if you save the following text as a .csv file it should work:

 

"ID";"Active (0/1)";"Name *";"Categories (x,y,z...)";"Price tax excl.";"Tax rules ID";"Wholesale price";"On sale (0/1)";"Discount amount";"Discount percent";"Discount from (yyyy-mm-dd)";"Discount to (yyyy-mm-dd)";"Reference #";"Supplier reference #";"Supplier";"Manufacturer";"EAN13";"UPC";"Ecotax";"Weight";"Quantity";"Short description";"Description";"Tags (x,y,z...)";"Meta-title";"Meta-keywords";"Meta-description";"URL rewritten";"Text when in stock";"Text when backorder allowed";"Available for order";"Product creation date";"Show price";"Image URLs (x,y,z...)";"Delete existing images (0 = No, 1 = Yes)";"Feature";"Available online only";"Condition"
;0;"Simon Art Letter Set Bicycle";"Letter Sets, Simon Art";01-02-49;;;;;;;;;;;;;;;53;2;"Pretty stationery by Simon Art Korea for writing letters. This set includes 6 sheets and 3 envelopes. Sheet size 17x25cm.";;"letter set, simon art";;"pretty stationery, writing letters, simon art letter set";"Pretty stationery by Simon Art Korea for writing letters. A letter set with 6 sheets and 3 envelopes.";"pretty-stationery-simon-art-bicycle";;;1;;1;"http://www.lettersets.com/images/lettersets/simonart/2012/large/bicycle.jpg";1;;;

[glennlawre]

I can't attach a .csv file, but if you save the following text as a .csv file it should work:

 

"ID";"Active (0/1)";"Name *";"Categories (x,y,z...)";"Price tax excl.";"Tax rules ID";"Wholesale price";"On sale (0/1)";"Discount amount";"Discount percent";"Discount from (yyyy-mm-dd)";"Discount to (yyyy-mm-dd)";"Reference #";"Supplier reference #";"Supplier";"Manufacturer";"EAN13";"UPC";"Ecotax";"Weight";"Quantity";"Short description";"Description";"Tags (x,y,z...)";"Meta-title";"Meta-keywords";"Meta-description";"URL rewritten";"Text when in stock";"Text when backorder allowed";"Available for order";"Product creation date";"Show price";"Image URLs (x,y,z...)";"Delete existing images (0 = No, 1 = Yes)";"Feature";"Available online only";"Condition"
;0;"Simon Art Letter Set Bicycle";"Letter Sets, Simon Art";01-02-49;;;;;;;;;;;;;;;53;2;"Pretty stationery by Simon Art Korea for writing letters. This set includes 6 sheets and 3 envelopes. Sheet size 17x25cm.";;"letter set, simon art";;"pretty stationery, writing letters, simon art letter set";"Pretty stationery by Simon Art Korea for writing letters. A letter set with 6 sheets and 3 envelopes.";"pretty-stationery-simon-art-bicycle";;;1;;1;"http://www.lettersets.com/images/lettersets/simonart/2012/large/bicycle.jpg";1;;;

 

When I save this text as a .csv file and open with Excel to edit with my products the cells are all messed up, i.e. there's not a separate heading column for each heading.

 

This is how the cells look -

 

Cell A1 = ID;"Active (0/1)";"Name *";"Categories (x

Cell B1 = y

Cell C1 = z...)";"Price tax excl.";"Tax rules ID";"Wholesale price";"On sale (0/1)";"Discount amount";"Discount percent";"Discount from (yyyy-mm-dd)";"Discount to (yyyy-mm-dd)";"Reference #";"Supplier reference #";"Supplier";"Manufacturer";"EAN13";"UPC";"Ecotax";"Weight";"Quantity";"Short description";"Description";"Tags (x

 

I imagine it should be something like the following -

 

Cell A1 = ID

Cell B1 = Active (0/1)

Cell C1 = Name *

Etc. etc.

 

This is probably something got to do with the encoding, but I am not sure.

 

Can anyone advise?

[glennlawre]

Not to worry, I actually just used OpenOffice and it works fine now.

 

If anyone else has this issue, use OpenOffice.

[Matt80]

Not with encoding but with the settings in excel, normally for excel delimiter for columns is [TAB] not semicolon.

You can change it somewhere in excel settings (it's depends on the version) or you can change all the semicolons on tab sign.

You can use any program like notepad, pspad, editplus etc. to do it.