Questions tagged [cataloginventory]

Denotes questions regarding Magento Catalog Inventory

Filter by
Sorted by
Tagged with
9
votes
4answers
5k views

How to get product collection of out of stock items - opposite of addInStockFilterToCollection()?

I have a requirement to display a category's products in two lists - one for in stock items, the other for out of stock items. I'm using Mage::getSingleton('cataloginventory/stock')->...
2
votes
1answer
412 views

Why are there 3 identical tables in Magento2?

We came across three absolutely identical in structure tables in M2 DB: cataloginventory_stock_status cataloginventory_stock_status_idx cataloginventory_stock_status_tmp Anybody has any idea ...
1
vote
1answer
1k views

Slow Save Order Due To Re-Index

We're running CE 1.9.1.0 with all the latest patches and use New Relic, among others, to track site performance. I've noticed a number of slow queries when customers are checking out, and in every ...
2
votes
1answer
343 views

cataloginventory_stock_item.low_stock_date?

Table cataloginventory_stock_item column low_stock_date In our db most of the products have the same exact timestamp. how the event trigger for low stock and how to get the exact date. Actually lot of ...
1
vote
0answers
27 views

Magento 2.3.1 CE qty issue after disabled salable qty feature

I would like to disable the Salable Quantity feature on Magento 2.3.1 CE. For this, I have followed this reference link and disabled MSI (Multi Stock Inventory) modules using command line & ...
1
vote
1answer
2k views

Notify for Quantity Below in Magento 2

I have a requirements to notify the admin through email when a product quantity goes below 5 in Magento 2.0.7. I have found that there is option on the admin: System > Configuration > Catalog > ...
1
vote
4answers
9k views

Magento 2 - How to set a maximum order qty of individual products?

I am trying to figure out how to set the maximum qty allowed in a shopping cart for an individual product. In my case: Most products can be added to the cart as many times as they want, but I have a ...
0
votes
0answers
47 views

After Migration inventory_source_item table is empty magneto 2

This Table ( inventory_source_item ) is Empty and which all my product show out of stock, Can anyone, please help me solve this issue