7

I am migrating a custom e-commerce site over to Magento. We have well over a hundred thousand products. Many are drop shipped from a number of suppliers. Several suppliers can provide the same product. Naturally they will all have different stock and provide different pricing. We have a custom script that parses all the feeds from all the suppliers and create a single feed that contains the new stock and pricing for all the products. With this volume we couldn't use Magento to import the changes. Thus we are using Magmi. Unfortunately Magmi, from what I can tell, will not zero out the stock if an item isn't in the feed. I could just import the products into another table and do a SQL call to set stock = 0 where the products are not in the new table then run magmi against with the feed file.

  • I believe that running a second import with stock only is most likely solution. Another option is to merge missing products with main feed and with stock set to 0 – Petar Dzhambazov Feb 14 '13 at 20:37
3

First idea: If your only problem is to set all the products to 0 before the import, why don't you do it?

I'm not sure, wether this is a good idea, and wether there are side effects, but importing is often a dirty job, so a SQL before the import might solve the problem.

UPDATE `cataloginventory_stock_item` SET qty = 0;

This means, for the time of the import you don't have any products.

Second idea: If this is a problem, you can think about, building a proxy for the feed, fetching all the products from the shop and add the missing products

  • 4
    With the SQL query, don't forgot to also set is_in_stock to 0 else it will still show as if it is in stock. – Rick Kuipers Feb 16 '13 at 12:03
3

I use MAGMI Import. It's a simple, straight-forward solution and most of all, it's fast! It has a simple GUI but it also offers a command-line interface, which makes it easily scriptable.

The learning curve is not so steep, but it requires a lot of attention as it fiddles directly into Magento DB (that's why it's so fast).

I currently import/update about 12.000 SKUs daily in less than 6 minutes.

http://sourceforge.net/projects/magmi/

Hope it helps.

  • +1 for MAGMI, couldn't live without it. The image importer plugin makes importing multiple images per SKU very easy. We also have 35 (and counting) customer groups, so tiered pricing is big for us. MAGMI handles it all with ease – CCBlackburn Feb 17 '13 at 21:52
  • I am using MAGMI as well due to its sheer speed with product updates/inserts. But that only solves half my problem. The need to zero out products I didn't update in the import. I see the product update field gets set after an update. So I think what I can do is get the time before I do the magmi update then once it completes, I set stock to 0 for any product that wasn't updated since the last import. That is the idea I am going with right now. – mvivanco Feb 18 '13 at 4:35
2

If you want an SQL way of updating instead of EAV way then you can refer to the following blog articles: Updating product qty in Magento in an easier & faster way http://www.blog.magepsycho.com/updating-product-qty-in-magento-in-an-easier-faster-way/

Updating product prices in Magento in an easier & faster way http://www.blog.magepsycho.com/updating-product-prices-in-magento-in-easier-faster-way/

Hope that helps.

1

There is a free magento extension for bulk updating all product prices from savethemage.com or you can download from Magento Connect here http://www.magentocommerce.com/magento-connect/catalog/product/view/id/17639/s/bulk-update-all-product-prices-4483/ It lets you bulk change all prices in your store by a percentage or flat amount, adding or subtracting.

protected by Community Apr 22 '15 at 14:48

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.