Questions tagged [inventory]

Denotes a question related to Magento inventory.

Filter by
Sorted by
Tagged with
0 votes
1 answer
869 views

Magento 2.4.2 product isSalable not being set properly

Using Magento 2.4.2-p2, I have a product that has stock and qty in the backend, but per the product->getData(), is_salable is set to 0 on the front end. Per this article, I fully removed the ...
0 votes
3 answers
2k views

Prevent the quantity of inventory in the backend products is negative

I'm using Magento 1.7.0.2 and Magento 1.9.1.0. As we know, by default, Qty Inventory at the backend (Admin - Catalog - Manage Products - Edit - General - Inventory - Qty) may contain a negative value, ...
2 votes
1 answer
2k views

Magento 2 product "packs"

I want to implement a store with many small products that are usually bought in bulk (maybe 20-100 pieces at once). So I want to implement product "packs", i.e. a "pack of 10" alongside a "pack of 50"....
0 votes
1 answer
20 views

How to Programmatically Adjust Out-of-Stock Threshold for Products in Magento 2

I'm currently working on a Magento 2 project that utilizes MSI and I'm trying to programmatically update the Out-of-Stock Threshold for each of my products. While I am able to adjust the quantity ...
2 votes
2 answers
2k views

Magento2 REST API products list and out of stock

In the api call V1/products i get also out of stock products, even though I've set in Stores->configuration->catalog->inventory "Display out of stock products" to No. there's a way to get rid of this ...
0 votes
1 answer
26 views

Prevent Quantity Decrease on shipment generate

I want to prevent the decrease product QTY after the shipment generation. Actually my client is using NetSuite and he want to update the QTY from there. They are managing all orders from the NetSuite. ...
0 votes
1 answer
1k views

Message queue topic "inventory.reservations.updateSalabilityStatus" is not configured after place order. Magento 2.3

recently reinstalled magento v2.3.0 and after place order get Message queue topic "inventory.reservations.updateSalabilityStatus" is not configured. No success page/no refresh card/ But get ...
0 votes
2 answers
3k views

Magento 2 : Cannot set product stock status to "Out of stock" using csv

I tried to import a product using CSV with is_in_stock value to '0' and after the import, the stock status still shows "In stock" CSV looks like this : sku,is_in_stock DC3508BR,0 What am I ...
1 vote
2 answers
3k views

Stock status and back orders in Magento 2

I want to enable customers to be able to place backorders In the docs its states for stock status of "Out of Stock" the following Unless Backorders are activated, prevents the product from being ...
0 votes
0 answers
11 views

Order qty sometimes going through as 2 instead of 1

I have a script which submits 5 orders to a staging instance of Magento using MSI for the stock. All 5 orders in the script are for the same product and with a Qty of 1 item. I noticed that the ...
1 vote
3 answers
3k views

How do I disable products when they become "out of stock"

I'd like to have items automatically change to disabled once they become "out of stock". The default options simply remove the add to cart button but the product is still viewable if you have the ...
0 votes
1 answer
2k views

Magento 2.3.1 Inventory reservations cleanup not working

Even though cron job seems to be working fine, it does not cleanup the inventory_reservation table. This is the result I get back from the cron.log: [2019-06-03 00:00:11] main.INFO: Cron Job ...
0 votes
1 answer
26 views

Inventory integration

Anyone knows how to get the custom type from the product editing page? (Need to get via code into phtml file)
2 votes
2 answers
994 views

Can a product have 2 different stock status?

I would got a use case whereby stock is differentiated into own stock and consignment stock. Consignment stock will only be sellable once the owned stocked is all sold. Is there a way to implement ...
0 votes
0 answers
27 views

Deadlock on table inventory_pickup_location_quote_address

Magento 2.4.5-p5 with MariaDB. I regularily get this error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `...
2 votes
1 answer
3k views

Magento 2.3 - isSaleable returns true when ProductSalableQty is 0

We have many template files (based on the core) that use: if ($_product->isSaleable()): For determining whether or not to show the add to cart buttons. However, we've found if we have 10 of an ...
0 votes
2 answers
1k views

Stock Availbility not changing after cancel order Magento 1.9

Stock Availability not changing after cancel order, qty is updating but availability status not changing.
0 votes
2 answers
1k views

low stock notification to admin without any extension in magento 1.9

I want to create the custom module for email sent to admin for notifying when the product is low qty in magento 1.9.x.
0 votes
1 answer
3k views

How to solve Magento 2 inventory inconsistencies?

After 3 months of upgrading a Magento 2.0 to 2.3, I noticed many stock inconsistencies like items reserved and never removed, and the orders are closed. Why does it happen and how could I check it?
1 vote
0 answers
25 views

Order for "Bundle products" is not able to send for shipment (Stock Source does not have options)

First of all i searched a lot in other related issues, but does not found identical to my problem (apologies if i missed it). #The problem I have an order for Bundle products (3 separate ones combine ...
0 votes
0 answers
114 views

Magento2 inventory_cleanup_reservations CRON job not working as expected for the large number of reservation records

The basic reason behind this is the MySQL group_concat_max_len value. If we have a large number of records in the reservation table then it fails to group concat the value. Preconditions and ...
0 votes
0 answers
22 views

What would be a comprehensive method to register when a product stock level changes - Magento 2.4

We are having some issues with products going out of stock inexplicably, We need to create a Magento module that registers whenever the product stock changes, such as API updates, product sales etc. ...
0 votes
1 answer
35 views

Inventory switchining to "Out of Stock" after order placed, even though 1000+ still in stock

Why are my items switching to "Out of Stock" after order placed, even though 1000+ still in stock.
1 vote
1 answer
99 views

Inventory oversold problem during high traffic on Magento website

When we have an inventoried item that sells through very quickly, we can run into problems having Magento manage inventory. Ex: If an product assigned with 200 units, it sold through so quickly that ...
1 vote
0 answers
88 views

Undefined array key "inventory_source"

I'm getting the following error while running the setup upgrade command php bin/magento setup:upgrade Warning: Undefined array key "inventory_source" in /vendor/magento/framework/Setup/...
1 vote
2 answers
3k views

Magento Inventory Reservation Compensation command not working

I have tried to run the following command to compensate for the inventory reservation. bin/magento inventory:reservation:create-compensations -r But it got stuck, as in the below image. It would be ...
4 votes
3 answers
5k views

Disable stock check / decrease when shipping an order in Magento 2.3.1

I have a Magento 2.3.1 shop with external software managing my stock levels. I have disabled the Decrease Stock When Order is Placed setting but with the new Magento MSI in Magento 2.3, the stock is ...
0 votes
1 answer
2k views

Magento 2 How to decrease product qty from source same as "Product Salable qty" after orderd placed to make product out of stock?

As Magento 2.3 have default behavior that it decreases the qty from "Product Salable Quantity" after order placed not the "Source inventory". The main qty(source inventory) of a product is decreased ...
0 votes
1 answer
200 views

Magento2 : Get Product Collection With Stock Data

Currently, we require to load product's stock data from stockregistry which increases database connection if working with foreach loop for product collection. I want to reduce it anyhow.
1 vote
1 answer
2k views

How to fix Magento 2 MSI inventory reservation inconsistencies directly via DB?

I see orders that are closed, canceled or completed that were created in the reservation table but never removed and they won't be removed since it's triggered when the order changes the status. I ...
0 votes
3 answers
4k views

How to get configurable child product quantity from cart item

I'm working with magento2, I have created custom add to cart product functionality. Now I want update product quantity. I have fetched all cart items and I want update but I am getting incorrect ...
0 votes
0 answers
254 views

Magento 2 update inventory programmatically using cron

I want to update the product inventory. Get inventory from another platform using cron once got inventory need to update in Magento but what is the best way to update some time I will get more than ...
0 votes
1 answer
108 views

What are the inventory(MSI) options available in Magento 2?

I'm looking to understand the inventory management features in Magento 2. Can someone explain the different inventory options available in Magento 2 and how they can be utilized? Specifically, I'd ...
0 votes
2 answers
88 views

How to fix a database timeout when deleting a source item through the REST API?

I have Magento 2.4.1 with MariaDB and a catalogue of 370,000 products. I’m trying to delete source items through the REST API. It used to work well in the past, but today I can’t get it to work. Even ...
1 vote
1 answer
31 views

Inventory stock update while using payment gateway

Need possible use cases for a scenario in magento 2 when a customer places an order during checkout after entering place order stock from inventory gets reduced then customer moved to payment gateway ...
0 votes
1 answer
26 views

Display Out of Stock Products crash

I have Issue Display Out of Stock Products when enabled. Some link category menu are crashed. Deprecated Functionality: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is ...
1 vote
0 answers
1k views

2.3.3, 2.4.x Admin Product Grid Filter/Sort by Quantity?

With the move to 2.3.3 and MSI it seems that in the main admin product grid - still a problem up to 2.4.5 etc we have acquired a "quantity per source" column, non filterable we have ...
0 votes
0 answers
30 views

Magento 2.4.3: Cloned Product Overwrites Existing Entry in CatalogInvetory_Stock

I am working on a Magento 2.4.3 store and am cloning a product via the below methodology: $product_clone = $this->object_manager->create(Product::class); $product_clone->load($...
0 votes
0 answers
55 views

Value not getting saved or fetched using extension attribute, For a newly added field in 'inventory_source' admin ui page

Have gone through several posts but was somehow not able to find a fix for this issue When I save, its says "Source saved" but my custom field is not beign saved/fetched What I have done so ...
0 votes
1 answer
166 views

Saleable quantity is empty even though quantity is showing admin

Right, here is a strange one we are using magento 2.4.2 and stock in the channel to import product data (if any one is aware of them) for some strange range we ever we ever we run the import the "...
1 vote
0 answers
32 views

Magento2.4.5 throws error while di:compile from Inventory module, SourceValidatorInterface not found

I upgraded the magento version from 2.3.6-p1 to 2.4.5-p1 for enterprise edition. While running di:compile, got the following error. Please guide Error: Interface "Magento\InventoryApi\Model\...
0 votes
1 answer
114 views

Can I truncate inventory_source_item table?

I deleted all the products in the admin, but I noticed that the table inventory_source_item is still full of all the products that do not exist anymore. So, I suppose deleting the products does not ...
0 votes
1 answer
747 views

Inventory management not automatically changing to 'out of stock' (is there Patches List for Magento 2)

I have faced issue after issue with the Magento 2 software that entails me having to do patch after patch. My most recent issue is with the inventory feature. I have turned on inventory management, ...
3 votes
3 answers
4k views

Show available inventory on configurable product magento 2

I need on configurable product page to show available inventory of simple products,while selecting options, like price will change on option change in same way.
7 votes
10 answers
19k views

inventory_stock_1 doest exist on Magento 2.3

When I go to product pages and checkout the exception shows: Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'inventory_stock_1' doesn't exist, ...
1 vote
2 answers
473 views

Magento 2: how to put extra text / drop down for decimal qty

I need to customize the addtocart.phtml in order to add an extra field for decimal qty. I want to use the actual input text for quantities in order to use ONLY unit and I need to create another drop ...
4 votes
1 answer
11k views

Magento 2.3 Saleable stock qty does not equal Global Attribute Qty

I have a simple product,(one of many), that is linked to a configurable product. I'm trying to get the salable quantity and attribute quantity to match. The site is in a dev env, so I don't think ...
0 votes
2 answers
233 views

Install Inventory Manager in 2.4.3 version

I'm trying to install Inventory Manager in my Magento 2.4.3 version after Magento installation. For doing this I download the entire project from here https://github.com/magento/inventory and upload ...
1 vote
2 answers
676 views

How to get Product Salable quantity by productId in magento2

How to get product salable qty by productId?
3 votes
4 answers
21k views

How to get product stock status on the listing page in Magento 2?

I am using Magento 2.3.1 I want to display stock status on the listing page. So, how can I get "Stock Status" attribute value on the listing page? I have tried below code: <?php $...

1
2 3 4 5
8