Magento Tutorial now will show you a solution for a Magento problem. When you imported products for your Magento site. Somehow, all products do not use default settings for inventory anymore. Each product has its own configuration for inventory, like below picture:
In this case, it causes some problems for his site when creating orders in back-end. It will displays this error message: “The stock item for Product is not valid.”
It is easy to solve the problem. We just need to update these products to “use configure settings”. But how long will it take if you have to update each product when you have some thousands. Luckily, we can use database to update all products.
Go to your phpmyadmin, look at table ‘cataloginventory_stock_item’. You will need to set manage_stock = 0, and use_config_manage_stock = 1 for these items. The simple sql command for this is:
- UPDATE `cataloginventory_stock_item` SET `manage_stock`=0, `use_config_manage_stock`=1 WHERE…
--- Updated News ---Here we go with the new generation of Magento 2 extensions, after its official release on 17 November 2015. Within the next technology of Magento 2, we expect better extensions for our E-commerce website, including of Magento 2 One Step Checkout, Magento 2 Gift Card and Magento 2 Affiliate. Having all these 3 products will help your store rocket the sales.