Import products - CSV file example - Ecommerce x PrestaShop - PrestaShop

Jump to content

Photo

Import products - CSV file example

Import products - CSV file ex

#1

Posted 31 January 2013 - 08:31 PM

ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 298 Active Posts
Hello,

can anybody send me an example of csv (xls) file for products import please? (prestashop 1.5.3)

Thank you.

Edited by ldon, 31 January 2013 - 08:31 PM.


#2

Posted 31 January 2013 - 08:42 PM

MEG Venture

    PrestaShop Fanatic

  • Members
  • PipPipPipPip
  • 1635 Active Posts
You can find example files under the csv import tab.

#3

Posted 31 January 2013 - 08:45 PM

ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 298 Active Posts

You can find example files under the csv import tab.


Do you mean that "Available fields" on the left side of CSV IMPORT? I've tried to make one in excel but it doesn't work at all. so thats why I'm asking for simple example.

#4

Posted 31 January 2013 - 08:46 PM

parsifal

    PrestaShop Addict

  • Members
  • PipPipPip
  • 579 Active Posts
http://YOURSHOPURLHERE.COM/docs/csv_import/products_import.csv

id;Active (0/1);Name*;Categories (x,y,z,...);Price tax excl. Or Price tax excl;Tax rules id;Wholesale price;On sale (0/1);Discount amount;Discount percent;Discount from (yyy-mm-dd);Discount to (yyy-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 if back-order allowed;Image URLs (x,y,z,...);Feature;Only available online
1;1;iPod Nano;Home, iPods;49;1;;1;;;;;92458844;54778855;AppleStore;Apple Computer, Inc;;;;0.5;800;New design. New features. Now i….;Curved ahead of the curve. For those about to rock, we give you nine amazing colors. But that's only part of the story. Feel the curved, all-aluminum and glass de...;apple, ipod, nano;;;;ipod-nano;In stock;;http://youdomain.com/img.jpg, http://yourdomain.com/img1.jpg;;
2;1;iPod shuffle;Home, iPods;66.05;1;79;1;;;;;92458845;54778855;AppleStore;Apple Computer, Inc;;;;0;500;iPod shuffle, the world’s most wearabl….;;ipod, shuffle;;;;ipod-shuffle;In stock;;http://youdomain.com/img25.jpg, http://yourdomain.com/img30.jpg;;


#5

Posted 31 January 2013 - 08:49 PM

MEG Venture

    PrestaShop Fanatic

  • Members
  • PipPipPipPip
  • 1635 Active Posts
Please follow the link that parsifal provided.

It is not on the right side. The link for the example files is right under the UPLOAD button.

Please look for "Click to see our samples import csv files."

#6

Posted 31 January 2013 - 09:03 PM

ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 298 Active Posts

Please follow the link that parsifal provided.

It is not on the right side. The link for the example files is right under the UPLOAD button.

Please look for "Click to see our samples import csv files."


I've got it. Thank you. I thought it will be easier to fill all field up .

By the way, can you help me with:

http://www.prestasho...in-cart-module/

and

http://www.prestasho...-modul-problem/


Thank you.

Edited by ldon, 31 January 2013 - 09:05 PM.


#7
RBK

Posted 05 August 2014 - 07:36 AM

RBK

    PrestaShop Newbie

  • Members
  • Pip
  • 1 Active Posts

Have You Think .CSV Creation is a tough Job...

Its quite easy..

 

1.Collect your List in Excel with Product ID,Description,Name...whatever you want

2.When saving Select CSV (MS DOS) Ignore the Service Messages

3.Open it in Notepad++.You can See the Character Separated Files.

4.Again Select Encoding & Choose Encode in UTF-8.Save it

5.Upload it & Select the Columns...

 

Simple;But to be keen in Documentation...

Keep Trying

Follow Me : https://twitter.com/RBK777breakz


Have You Think .CSV Creation is a tough Job...

Its quite easy..

 

1.Collect your List in Excel with Product ID,Description,Name...whatever you want

2.When saving Select CSV (MS DOS) Ignore the Service Messages

3.Open it in Notepad++.You can See the Character Separated Files.

4.Again Select Encoding & Choose Encode in UTF-8.Save it

5.Upload it & Select the Columns...

 

Simple;But to be keen in Documentation...

Keep Trying

Follow Me : https://twitter.com/RBK777breakz

If any Doubt Just Ask



#8

Posted 14 March 2015 - 08:37 AM

kishan soni

    PrestaShop Newbie

  • Members
  • Pip
  • 21 Active Posts

Hello ,

 

Can we import Bulk data into our store through the excel file .xls file in any easy way because while uploading and editing with the .csv file its format gets change and its very much hard to get use to with a person when there is more then 500 products to upload per day for a person.

 

 

i want to do the excel sheet product uploading process like this is it possible

http://sellerhelp.snapdeal.com/?p=826



#9

Posted 14 March 2015 - 08:43 AM

kishan soni

    PrestaShop Newbie

  • Members
  • Pip
  • 21 Active Posts

Hello ,

 

Can we import Bulk data into our store through the excel file .xls file in any easy way because while uploading and editing with the .csv file its format gets change and its very much hard to get use to with a person when there is more then 500 products to upload per day for a person.

 

 

i want to do the excel sheet product uploading process like this is it possible

http://sellerhelp.snapdeal.com/?p=826



#10

Posted 13 May 2015 - 08:21 AM

samindu

    PrestaShop Newbie

  • Members
  • Pip
  • 2 Active Posts

Hi,

 

Have a look at this.

 

http://dh42.com/blog...ting-csv-files/

 

Use comma (,) as a field separator and semi colon ( ; ) as multiple values separator.

 

Thanks

Samindu 


Edited by samindu, 13 May 2015 - 08:22 AM.



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cookies help us deliver our services. By using our services, you agree to use our cookies.     Learn more