Importing only ,,Quantities" of products via CSV

[Adey]

Good Evening all

 

Is there anywhere tutorial for importing that specify data?

If there is no tutorial, could i ask you for advice.

 

How it should be done in 1.5 , by showing example?

 

Thank you very much in advance.

And keep the good work

 

Greetings

Adey

[Promokit]

You should to have following format of your csv file:

ID;Qty

1;999

2;999

.......

and when you will select this csv, just specify id and Quantity

[Adey]

Hi, i ve did file same as you told and when i finally clicking import data by selecting. id and qty , it gives me an errors:

 

2 errors

• (ID: id) cannot be saved
  
• Property Product->name is empty
  

 

How can i solve it?

[a1b2]

ID;Name;Qty

If you have the version 1.5 probably you will have problems with the ID.

See: http://www.prestashop.com/forums/topic/188674-csv-importing-categoriescsv-creating-its-own-auto-increment-ids-not-my-own-id-numbers/

[Bejo]

i have same problem .. help pls

[PEPPE83]

Same problem here....anyone know how import stock quantity from a CSV file?

[frikatadmstv]

I am using PrestaShop™ 1.5.2.0 and having these errors when trying to import from csv file:

 

Property Product->name is empty

Rewrite link for friendly-url-autogeneration-failed

 

Can someone please give me a solution to this ploblem...

[donnytkc]

i haven't tried importing quantity from csv file yet, since an afraid to mess up the database....still looking for a more perfect solution, anyone have any ideas ??

[bujufer]

i have a same problem;

Property Product->name is empty

someone have a solution?

[Presta Ecommerce]

I'm also looking for a solution to this problem. Anyone solved it yet??

[lixotuka]

I have the same problem

 

Property Product->name is empty

Rewrite link for friendly-url-autogeneration-failed

 

Any solution?

[m33ts4k0z]

Yes an easy solution is to go to <admin_folder>/tabs/AdminImport.php and at the very top change:

 

public static $required_fields = array('name');

 

to:

 

public static $required_fields = array();

 

This will no longer require the name field. However I'm having trouble updating the quantities that way.

 

EDIT: Having looked in prestashops code, I found the issue of quantities not updating.

 

/* If match ref is specified AND ref product AND ref product already in base, trying to update */
/* Else If id product AND id product already in base, trying to update */
if ((Tools::getValue('match_ref') == 1 && $product->reference) || ($product->id &&
$datas = Db::getInstance()->getRow('SELECT `date_add`, `quantity` FROM `'._DB_PREFIX_.'product` WHERE `id_product` = '.(int)$product->id)))
{
if (isset($datas['date_add']))
{
$product->date_add = pSQL($datas['date_add']);
if($product->quantity <= 0)
$product->quantity = pSQL($datas['quantity']);
}
$res = $product->update();
}

 

In the above example, I simply added this code:

 

if($product->quantity <= 0)

 

Prestashop would update the quantity if reference ID matching was set during the import. If the quantity was 0 in the database, it would replace the actual quantity with 0. Now it will now longer do that.

 

PS: I'm using Prestashop 1.4.9 but it cant be that different in newer versions.

Edited July 9, 2013 by m33ts4k0z (see edit history)

[Ravi Parmar]

Hello

 

i have a same problem;
Property Product->name is empty

 

Solution.

 

[1] You want to Put Blank value in Field "ID"

[2] And after completion of CSV Import 1st step then You must check Proper Field (Dropdown) with you CSV Field

 

 

Thank You.

Edited June 25, 2014 by Ravi Parmar (see edit history)