Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [cataloginventory]

Denotes questions regarding Magento Catalog Inventory

6
votes
1answer
54 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 ...
2
votes
0answers
30 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 ...
0
votes
0answers
27 views

How to setup different Advanced Inventory Options for each store?

I couldn't find an answer for this problem and I hope someone can help me out. I have a magento 2 multi store version 2.3, a retail store www.example.com and a wholesale store wholesale.example.com, ...
1
vote
0answers
18 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.
0
votes
0answers
21 views

Magento 2.2 Detect Product Inventory Change

Is it possible to detect Inventory change of a Simple Product from a custom module? Basically if the Value displayed in a Simple Product's 'Quantity' field ( as seen in the Admin product detail page....
0
votes
0answers
20 views

How to Add quantity box in Magento 2.1 product page

I want Add To Cart with one sku with multiple size and Quantity. if I select Size M then I can add qty 1 or more
0
votes
1answer
143 views

How to show “out of stock” child products for configurable product in list and product view page magento 2?

I am trying to show out of stock child products for configurable product in details and product view.I changed the settings from catalog inventory to display out of stock products even it is not ...
0
votes
1answer
68 views

Why order item quantity is not decreased after order placed

I am facing a strange issue in our live site order item quantity is not decreased after order placed from the frontend. (i.e) if a successful order has 5 products, 4 products quantity has been ...
2
votes
2answers
383 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 ...
1
vote
1answer
306 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.
0
votes
1answer
137 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
25 views

Magento 1.9.3.8 Execute only when there is a change for the Stock Level

I have got a custom extension, to track stock movements. So, keep a record of when x amount stock is added for a given product and/or when x amount of stock is removed. However, Even if I don't edit ...
0
votes
0answers
30 views

Magento Qty is being squared in checkQuoteItemQty

We noticed on the cart page we'd see the "The requested quantity for product_name is not available." error after it's been successfully added to the cart. I added var_dump($qty); just before that ...
0
votes
1answer
282 views

What is the usage of itemId inside Update inventory REST API?

According to the swagger, the REST API PUT /V1/products/{productSku}/stockItems/{itemId} is used to update the product inventory. However, for the attribute value itemId, I found no differences no ...
1
vote
0answers
22 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 ...
0
votes
0answers
284 views

How to properly add CatalogInventory stock quantity to a product Collection

When using the ProductRepository to retrieve a single product (get or getById) Magento2 returns pretty much all the information about that product, including media gallery, prices, inventory stock, ...
0
votes
4answers
1k views

How to show only in stock products? [duplicate]

I am using product collection in my custom phtml file I try to add filter only show in stock product but it will not work My code : $currentCategory = Mage::registry('current_category'); $catId =...
0
votes
1answer
173 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
0answers
69 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 ...
2
votes
1answer
453 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 ...
0
votes
0answers
313 views

Configurable Product - Product Quantity Tracking for Each Color and Size

We have a product (called Polycotton Shop Coat) that comes in 3 different colors. The product is available in all sizes. We produce a certain quantity of this product for each of the 3 colors and ...
1
vote
1answer
645 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 = $...
2
votes
2answers
1k 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&...
0
votes
0answers
127 views

cataloginventory_stock_status

on Magento admin it says A product has 2000 stocks, but on "cataloginventory_stock_item", and "cataloginventory_stock_status_idx" it says 500 stocks are left. so i reindexed, but nothing has been ...
1
vote
1answer
659 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 ...
3
votes
0answers
162 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 '...
1
vote
1answer
246 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 ...
0
votes
1answer
82 views

The catalog inventory stock item unique hase changed

I am working on a new Magento 2.1.4 projet. We have a single store. And we need to manage the inventory for a large amount of shops belonging to this store. I was thinking about using the ...
0
votes
1answer
204 views

configurable Parent Product set “Stock Availability” set auto magento-1.9

I would like to do if any Child product has status "in-stock" parent status auto update "in-stock". else parent configurable product status update "out-stock". anyone can help me how can I do it with ...
1
vote
1answer
56 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
2answers
81 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.
0
votes
1answer
166 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 ...
0
votes
1answer
511 views

Show Empty Categories on Catalog Page - Magento 2

I want to show all categories, even if they have no products in them. How can I achieve something like this?
1
vote
0answers
153 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
289 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 ...
5
votes
2answers
414 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 ...
1
vote
1answer
669 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
1answer
1k 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 > ...
0
votes
0answers
480 views

Get CatalogInventory stock collection in Observer

I need, on website save, get the inventory with the current website ID. Ad I'm trying to get the CatalogInventory Stock Collection in an Observer, but it finish with the error: Configuration array ...
1
vote
4answers
6k 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 ...
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 ...
0
votes
1answer
42 views

Magento 1.9 - Use backorder stock instead of actual stock for certain products

For some "Special" products in a webshop I want to use Backorder stock instead of actual stock which is available for those products but not sure how to proceed with it. I have looked into ...
2
votes
1answer
297 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 ...
0
votes
0answers
42 views

Display stock remaining quantity for all type of products [duplicate]

My requirement is to display stock remaining quantity in PDP for all types of products : simple,bundle,grouped,configurable. For bundle products, when I choose the radio button/switch option, the ...
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?
0
votes
1answer
236 views

How to uncheck checkbox of Use Config Settings in Catalog Product Inventory

I want to uncheck checkbox Use Config Settings by default in Inventory section in Catalog=>Product section as below image--- I know that we can update it from DB query but I want to make them ...
1
vote
1answer
109 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 ...
3
votes
1answer
464 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 ...
2
votes
1answer
319 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 ...