Add quantities to all products programatically in magento

Question

I want to add quantities to all of my 780 products using custom script. Is there anyway to do it from admin. I had tried a way to export products first then add quantities in csv file, remove all products from store, then again import products, its working fine but issue with product images.

Can anyone tell me the way to inject database table directly from script to update quantities.

Thanks in advance
Sanjay

score 0 · Answer 1 · answered Jan 12 '12 at 08:17

0

Take a look at cataloginventory_stock_status. I think you can update your stock there. :)

answered Jan 12 '12 at 08:17

boti

677
5
12

don't forget to reindex your catalog stock status after manipulating the table directly – Jonathan Day Jan 12 '12 at 10:51

score 0 · Answer 2 · answered Jan 12 '12 at 12:15

0

No need to hanle db.

$product = //initialize product
$product->setStockData(
     array(
        'is_in_stock' => 1,
        'qty' => $qty
     )
);
$product->save();

answered Jan 12 '12 at 12:15

Jevgeni Smirnov

3,787
5
33
50

score 0 · Answer 3 · answered Jan 12 '12 at 14:14

0

If you want to have mass update for Qtys using raw sql (very fast enough for millions of products), then you can try the following article:
http://www.blog.magepsycho.com/updating-product-qty-in-magento-in-an-easier-faster-way/

Hope this helps. Thanks

answered Jan 12 '12 at 14:14

MagePsycho

1,944
2
29
60

Add quantities to all products programatically in magento

3 Answers3