Vote to Improve PrestaShop

PrestaShop Forum: Build a free online shop. Count on the Community!

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum: Build a free online shop. Count on the Community!

Jump to content

 
Photo

Import products - CSV file example

Import products - CSV file ex

  • Please log in to reply
6 replies to this topic
ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 243 posts

Posted 31 January 2013 - 08:31 PM

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.


MEG Venture

    PrestaShop Fanatic

  • Members
  • PipPipPipPip
  • 1590 posts

Posted 31 January 2013 - 08:42 PM

You can find example files under the csv import tab.

ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 243 posts

Posted 31 January 2013 - 08:45 PM

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.

parsifal

    PrestaShop Apprentice

  • Members
  • PipPip
  • 436 posts

Posted 31 January 2013 - 08:46 PM

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;;

crudeWWWutils: Bash scripts for quick website backup, restore and cleanup

Webmaster & System Administrator @ moutsioulis.gr

MEG Venture

    PrestaShop Fanatic

  • Members
  • PipPipPipPip
  • 1590 posts

Posted 31 January 2013 - 08:49 PM

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."

ldon

    PrestaShop Apprentice

  • Members
  • PipPip
  • 243 posts

Posted 31 January 2013 - 09:03 PM

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.


RBK

    PrestaShop Newbie

  • Members
  • Pip
  • 1 posts

Posted 05 August 2014 - 07:36 AM

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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users