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')->...
6
votes
3answers
4k views

Product stock is not saved when creating a product programmatically

I'm creating products programatically on Magento CE 1.8.1. The form works fine except every once in a while we get a nasty error that comes and goes away, and does not affect all users. :"SQLSTATE[...
6
votes
1answer
236 views

How to programatically transfer qty from one to other source

Does anyone has idea how to update product qty from one source to other programmatically ? Basically I've 2 sources in my magento setup. Let say currently Salable Qty = 50 and first source has 20 qty ...
5
votes
3answers
5k views

Can I completely disable an indexer?

I have a situation where I'd like to completely disable one of Magento's core indexers (cataloginventory_stock). I don't want this index to ever be rebuilt, maintained or altered in any way. Is it ...
5
votes
2answers
482 views

Disable all Mage_CatalogInventory features

We don't use any feature of Mage_CatalogInventory and I disabled some of it in the system configuration, but there are still a lot MySQL Queries especially in the checkout, which took very long. My ...
3
votes
5answers
7k views

Disable “Only X left Threshold” Qty from Showing on Store

Anyone know how to remove the "Only # left" from showing on the product page of the store? System > Configuration > Inventory for Stock Options has the field "Only X left Threshold" set to "0" which ...
3
votes
2answers
1k views

Email for Low Stock Products

How can I setup the Email Notification for the Low Stock Products and Expired Products?
3
votes
1answer
491 views

SOAP V2 query returns empty array

This simple query works as expected with SOAP V2: $result = $proxy->catalogProductList($sessionId); var_dump($result); but swap the Role resource access to Catalog Inventory > Retrieve stock data ...
3
votes
2answers
1k views

Magento - change of product quantity and status is not working in an event

I have created an event which checks that if the backorder quantity of an item is greater than zero than set the ordered product quantity to zero instead of keeping it in negative and also change its ...
3
votes
0answers
210 views

Unable to edit product attribute value

Running 1.9.x Magento, I found a handful of products (out of 80k) that have a product attribute value that cannot be edited from the product edit panel. The attribute value is a custom value called '...
3
votes
0answers
2k views

Manage Qty Stock update using Magento SOAP API [closed]

We are using below like code for Qty stock update using Magento SOAP API. try { $client = new SoapClient('http://www.magentosite/index.php/api/?wsdl', array("connection_timeout" => 5,'cache_wsdl' =...
2
votes
3answers
1k views

Store level Inventory for individual product Magento 2.2.0

Is there any way that have enable Store level Inventory. Its not about user config Inventory at Catalog > Inventory Its about Admin >> Catalog >> Product >> Open product which you want to ...
2
votes
1answer
415 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 ...
2
votes
1answer
527 views

Magento 2: Remove 'low stock' label from product image

I created a product and set 'Manage Stock' to no. But when i see a product on frontend, it shows a label 'Low Stock' on product thumbnail image. I do not want to show that label. I think there is an ...
2
votes
1answer
344 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 ...
2
votes
0answers
57 views

What is the difference Between cataloginventory_stock_status & cataloginventory_stock_status_idx

If I use cataloginventory_stock_status and cataloginventory_stock_status_idx return different values, what is the main difference between these two tables?
2
votes
1answer
76 views

How to disable/enable backorder for particular website/store?

I want to enable/disable backorder from one of the available websites. How can I implement it?
2
votes
0answers
41 views

Products do not appear on list page in magento 2?

I am working on a project where I need to display the list products on list page. I have added the products on local server where I am getting them on front-end. But when I create products on live ...
2
votes
2answers
2k views

Magento 2 Rest Api V1/products missing extension attributes

I am calling the Rest API V1/products to get the product list from Magento 2 store Request: http://{myMagentohost}/Magento/index.php/rest/V1/products?searchCriteria[currentPage]=1&...
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 ...
1
vote
1answer
112 views

Magento 2 MSI - How to listen the event of all source item stock update API

Am using the below rest API to update bulk product's Stock information /rest/all/V1/inventory/source-items My requirement is that I need to listen the observer or some file whenever this API is ...
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 ...
1
vote
1answer
243 views

Is there any observer like 'cataloginventory_stock_item_save_commit_after' in magento 2?

I need to trigger the inventory changes in Magento 2.0 I have an observer cataloginventory_stock_item_save_commit_after in Magento 1.9 and its working fine. But I can't find the same observer in ...
1
vote
2answers
172 views

How to get minimum, maximum, and available products for a product

I need to find the stock details of a product how to find that.
1
vote
1answer
203 views

Possible bug in 1.7 import for saving product qty in function _saveStockItem()

I had a problem where product import files with only sku and qty fields were importing the wrong qty's for most items. I realized that whatever qty the first item had would be applied to all the rest ...
1
vote
1answer
465 views

Possible orphans in cataloginventory_stock_item?

Should every record in cataloginventory_stock_item link to a record in catalog_product_entity? When I run the following SQL I get 15,874 products in cataloginventory_stock_item that do not match a ...
1
vote
1answer
36 views

Magento2: How to get the old qty of product?

How to get the available qty of the product before saving the product with new qty in magento2. How to do that. Thanks.
1
vote
1answer
206 views

Missing add to cart button on some items

We're experiencing a strange issue with our catalog, I'm scratching my head of where to start looking for... Here are the symptoms: Item X - doesn't have the "Add to Cart" Button. When I go to the ...
1
vote
1answer
1k views

Magento 2 How to set product minimum quantity selected to minimum qty configured in the Advanced Inventory product level

If 5 is the minimum Qty on Advanced Inventory product level for a product then in Product detail page it should as 5 default selected. How can I achieve this.
1
vote
1answer
867 views

How to update Qty on product save action?

I'm trying to update the StockData in catalog_product_save_before observer and not having any luck. I can get the stock data like this $_newProduct = $observer->getProduct(); $_newStock = $...
1
vote
1answer
58 views

Magento inventory

In my magento project I have created a superuser who can directly add product to customers cart from his cart. Here I am loading customer quote by their emailId and adding each product from super user ...
1
vote
1answer
344 views

On Product Save from Magento admin getting the Integrity constraint violation error

On Product Save from Magento admin getting the Integrity constraint violation error, Can any one please let me know why this errors coming up. SQLSTATE[23000]: Integrity constraint violation: 1062 ...
1
vote
1answer
807 views

How to Prevent Negative Stock Qty Value In Magento?

How do I prevent product stock qty value showing negative values in admin? I have set Backorders to "No Backorders" but still it's showing negative values. can anybody please help me on this. Thanks
1
vote
2answers
1k views

Issue How to track each size of product inventory

I have a question. Please let me know how I can do this? We cannot count inventory for variations, like XL, XM, M, L etc.. etc.. For example, take a look at this product, it has different size "...
1
vote
1answer
887 views

$stockItem->getIsInStock() stopped working after update to 1.9

example code: $stockItem = $product->getStockItem(); $stockItem->getIsInStock() The product is one item of a collection. Before the update I could Request the isInStock status in this way. ...
1
vote
1answer
48 views

Integration with our Inventory System [closed]

I want to integrate our Magento website with Inventory management system. for this task we are development 2 ways syncing service which will update Magento db & Inventory system also; How to ...
1
vote
0answers
25 views

Availability-only not shown on inventory level in Magento 1.9

For my Magento store, the threshold qty is not considered on inventory level, although this is set up in the backend. This is the view with the output of the QTY message app/design/frontend/base/...
1
vote
0answers
99 views

SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support Magento 2

I am facing below error while run setup upgrade commands. SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support 'multiple triggers with the same action ...
1
vote
0answers
21 views

Change the quantity of a child, the change should be applied for the other child of its parent in configuration product

In other words, when I change the quantity of a child, the change should be applied for the other child of its parent in configuration product .Thank you in advance.
1
vote
0answers
27 views

Magento 2.2 Inventory not getting decreased when orders are created using REST API

I am new to Magento 2.2 and I want to create orders using REST API. Orders are getting created. But the stock value of the Product is not getting decreased. I have made the necessary settings in ...
1
vote
0answers
77 views

show total stock available

Is there a simple way to show total quantity in stock for products. We are trying to make it a simple inventory catalog showing products and total quantity available per product? If some development ...
1
vote
1answer
804 views

SQL to list all skus, inventory on hand and qty sold between x and x date

I have a Magento 1.9 site and I am trying to write a sql query that would return a listing of all skus (disabled and enabled) in the site as well as how many of each sku was sold between a specific ...
1
vote
1answer
534 views

Update stock level in a particular warehouse

We have multiple warehouses for our web-store and we want to update stock via script whenever we get new stock in. However, when I try to update the stock level via program, the stock level goes up ...
1
vote
0answers
183 views

Magento2: Updating products with CSV duplicates product_id in cataloginventory_stock_item

Any ideas why Magento 2 creates duplicate product_id into cataloginventory_stock_item table for each product that I try to update via import functionality? Thanks.
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
1answer
114 views

Single inventory for all products

I'm wondering what is the best way to accomplish inventory management for a magento store that sells custom made t shirts. The store has several designs the user can choose to be printed on the t ...
1
vote
0answers
235 views

What events trigger low_stock_date to be updated?

What events trigger cataloginventory_stock_item.low_stock_date? In our db most of the products have the same exact timestamp, and it's only 4 days ago, despite a lot of these products being out of ...
1
vote
1answer
615 views

Magento sold more products than in inventory

My client had a big traffic on server for 1 day. They added one product (ID X) with quantity = 10000. After few hours they sold about 15000 items of this product - I can say because of simple query: ...
0
votes
1answer
744 views

cataloginventory_stock_status entry issue Magento 2

I did not get an entry in cataloginventory_stock_status table after indexing. Product stock entry is exist in cataloginventory_stock_item table. I have checked this thing in Magento 2.2.5 in default ...
0
votes
1answer
219 views

Magento 2.1 Override Catalog Inventory

I'm currently writing multi-vendor extension, I'm looking for sample code on how to override the inventory, so it shows inventory from a custom field, Already tried overriding getQty of the Product ...