Questions tagged [inventory]

Denotes a question related to Magento inventory.

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

How to get Product Salable quantity by productId in magento2

How to get product salable qty by productId?
  • 15
1 vote
0 answers
24 views

Magento 2 The stock item was unable to be saved. Please try again

This is the log i found. i don't know why its happening when creating a new product. [2022-09-27 07:10:49] main.CRITICAL: The stock item was unable to be saved. Please try again. {"exception"...
0 votes
0 answers
10 views

MSI saleable qty showing a positive number for stock Qty is 0

I can't figure this one out. I'm using the BSS Advanced Inventory module to manage multiple stock sources. The problem is, we have a product with a Quantity below 0. However, the Default stock (...
  • 147
0 votes
0 answers
7 views

Cardinality violation When Deactivating MSI on Magento 2.4.5

When I disable MSI on Magento 2.4.5 I receive the following error when trying to open any product Cardinality violation: 1242 Subquery returns more than 1 row, query was: SELECT 1 AS `status`, `e`.`...
  • 126
0 votes
0 answers
13 views

I want to handle Magento book & Magazine Inventories using the barcode system

I'm looking for a complete solution (App, Api's, recommended barcode scanner) integrated with Magento 2 that helps to handle Magento inventory using a barcode scanner. I need to be able to scan the ...
  • 11
0 votes
0 answers
14 views

Can I prevent Google indexing in stock/out of stock status?

We've recently updated to Magento 2.4.3, I'm not sure if this issue is due to this version or if it existed previously. It's not been a problem until now. We use an extension to set a custom stock ...
  • 101
0 votes
1 answer
22 views

Product stock quantity is reducing automatically before shipment

How the product stock quantity is decreasing automatically in magento2 before shipment(not saleable quantity)
  • 15
0 votes
1 answer
13 views

Getting the minimum qty allowed in a shopping cart without deprecated methods

Previously to get the minimum qty allowed in a shopping cart I would use the following code: public function __construct( \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry ){ ...
  • 2,469
0 votes
0 answers
12 views

Incorrect salable quantity with empty inventory_reservation table in magento 2

In my store, I have multiple items that have an incorrect salability quantity, but the inventory_reservation table does not contain that product. What's the table used in the salable quantity ...
  • 129
0 votes
1 answer
16 views

After POSTing a product those go out of stock, but never back in stock

Can anyone explain why exactly a configurable product for which every virtual product's quantity goes down to zero, and said product subsequently disappears from the store, won't come back even if the ...
0 votes
0 answers
139 views

Wrong stock status Magento 2

I use firebear and magmi to import and update products and m2epro to list on amazon. In many cases I see the wrong stock status, for example, qty=0 but stock status is "in stock". Also many ...
  • 11
0 votes
0 answers
37 views

Change Scope from Global to website for "Maximum qty allowed in Shopping Cart"

The global setting in Magento2 System -> Configuration -> Catalog -> Inventory -> Product Stock Options has settings for "Maximum qty allowed in Shopping Cart". Unfortunately, ...
0 votes
1 answer
90 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 ...
0 votes
1 answer
30 views

How do i create a stock level report in magento?

I need to get a stock report from Magento. what do we have in stock? what SKUs - what Qty. how do I do this?
0 votes
0 answers
82 views

Notify for qty below 0 not showing in low stock report

When notify for qty below 0 is set nothing shows in low stock report (items on backorder not shown eg salable qty -1). But if I set to qty below 1 it will show any item that has a qty of 0
  • 35
1 vote
0 answers
40 views

Quantity Increments in advanced inventory is not working for configurable products Magento 2

I tried to increment the product quantity by 10 steps on each click on the + sign by configuring it in the quantity increment from the advanced inventory of the product dashboard. Unfortunately, it is ...
0 votes
0 answers
17 views

Subtract/reduce more than one unit from a product's stock/inventory

I want to configure that my shop subtracts/reduces a defined stock value from the product stock specified in product or elsewhere. Is this possible and if, how can I do it?
  • 17
0 votes
1 answer
41 views

Magento 2: Display product inventory on frontend based on store select

I want to display product inventory based on store select on frontend.(product should be updated on store select) Any help would be appreciated.
  • 161
0 votes
0 answers
87 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
54 views

How to prevent inventory decrement on place of order

My requirement is on a specific order that inventory should not decrease from Default Stock or Quantity after placing the order. How can I Achieve it? Is it possible? Can I get some help.? Thank you ...
0 votes
0 answers
20 views

magento 2 : How do I set display stock status to don't show?

I need the "in inventory" message not to be displayed, with products set to don't manage stock.
0 votes
1 answer
20 views

Magento 2 Which file stores the "in inventory" product view?

I am trying to figure a way to hide show stock status/availability on product page.
0 votes
0 answers
13 views

magento 2 display stock status does not display

"manage inventory" is set to "no" and "Display products availability in Stock on Storefront" is set to yes. Yet, "in inventory" doesn't show on product page.
0 votes
1 answer
259 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 ...
  • 704
0 votes
1 answer
46 views

How to automatic stock details (quantity increment)?

In the warehouse, if we scan the product it has to update in Magento inventory (i mean quantity has to increase). How can I achieve this one?
1 vote
1 answer
237 views

Where Inventory_stock_% table get updated in Magento 2?

The problem I'm facing is that The table Inventory_stock_13 used for the 2nd website is updated incorrectly. When set source status to Out of stock, column is_salable is still 1 and quantity is ...
0 votes
1 answer
19 views

Stock set to zero after sale

Magento 2.4.2 For some reason product stock is being set to 0 after an order is placed, regardless of quantity previously in stock or quantity ordered. What could be causing this? How can I debug ...
0 votes
0 answers
41 views

After disabling MSI modules in magento2.4.1

My Magento store is throwing this error: Error: Cannot instantiate interface Magento\InventorySalesApi\Api\IsProductSalableInterface I am using Magento 2.4.1
  • 445
0 votes
1 answer
284 views

Can we disable all salable quantity modules in mganeto2.4.1

We manage our stock in another system and update the quantity field as orders come in. This is causing issues as suddenly the salable quantities are lowering, and never reset. Is there a way to reset ...
  • 445
1 vote
0 answers
86 views

Magento 2 order item find assigned MSI source

I am looking for a extended functionality of Magento 2 adminhtml. After order has been placed (created), how do I find out origin MSI source for each order item (and specified quantity) => from ...
0 votes
0 answers
136 views

Magento 2: Disable redirection to product page if requested quantity is not available on add to cart function

On catalog category page, when I add any product to cart and the requested quantity is not available, it redirects to product page and shows error message there. What I want is to display error ...
  • 1
0 votes
1 answer
407 views

Magento2.4 rest api for get all products inventory

I need to get all products detail such as inventory, max, min, qty and more. how can I get them with rest api for magento 2.4? I can get it for 1 sku but I need all skus
  • 721
0 votes
1 answer
436 views

Magento2 How to filter Product collection by Stock (Get only In stock products)

I want to filter product collection by stock and get only In stock products. I have tried multiple ways and followed multiple stack solutions but nothing works as expected. I am using the Smartwave ...
0 votes
2 answers
565 views

How does Magento 2 Inventory work when an order is placed?

I am confused about how Magento 2 inventory works when an order is placed. What if I have only one qty stock for a product and there are two people who make an order for this product at the same time. ...
  • 79
0 votes
1 answer
414 views

Salable Quantity is greater than quantity with some products

on some cases my salable quantity is greater than my quantity, not for all product but for example to 10 products on 1000. I could not figure out why, I also tried to delete the product and insert it ...
  • 1
1 vote
2 answers
226 views

Inventory cleanup cron job is not running

The cron job at magento/module-inventory-reservations/etc/crontab.xml does not show up in the general pool in the admin backend. It does not show up in cron_schedule table. It does not run. All other ...
0 votes
2 answers
244 views

Backorder products displaying Out of Stock label

My employer has a range of products that we make to order. As such, we don't keep any on hand so our inventory on the Magento 2 backend is always set to 0. I have lowered the out of stock threshold so ...
1 vote
0 answers
93 views

Inventory Source Selection For Quotes

We need inventory source selection at the time of ordering, not at the time of shipment and already solved reservations with a custom reservation mechanism that reserves stock on source level. Now I'm ...
0 votes
1 answer
275 views

Magento 2.3.1 How to hide out of stock products from frontend?

I have Magento setup version 2.3.1 in normal Magento flow if salable qty is > 0 then the product will show in frontend else hide it. This functionality is working correctly after Magento version 2....
  • 1,197
0 votes
1 answer
159 views

Can I set MSI stock values using products REST endpoint?

We currently run Magento without MSI. The ERP sends stock updates via extension attributes on the (bulk) product endpoint. This enables us to do most product updates in on API call. Very convenient. ...
1 vote
0 answers
153 views

PHP Fatal error on inventory:reservation:list-inconsistencies command

Magento 2.4.0 PHP 7.3 MariaDB 10.4 When I try to run this command: bin/magento inventory:reservation:list-inconsistencies -r I get the following error: PHP Fatal error: Uncaught TypeError: Argument 1 ...
0 votes
1 answer
159 views

Only `inventory_cleanup_reservations` CRON is not scheduled

The Magento2.3 instance is installed in AWS server. The CRON has setup correctly and there are many CRON's running successfully. Below is the content of cron_schedule. But the issue is CRON with ...
1 vote
1 answer
2k views

Magento2: Product Stock Bulk Update API

I'm looking for the bulk variant of the product stock update API /rest/default/V1/products/{productSku}/stockItems/{itemId} Objective: I want to update quantities of multiple products in one API call ...
0 votes
0 answers
35 views

Magento 2 do not update Inventory correctly

Example: Inventory level is at QTY 100. All of these things happen simultaneously: 1- An admin processes a refund/return and restocks 2 items. 2- Two customers make a purchase buying quantities of 1 ...
3 votes
3 answers
2k views

"Only 0 Left" message has suddenly appeared after 2.4.2 upgrade

As wrote in the title, after I've upgraded from Magento 2.4.1 to 2.4.2 the message "Only 0 Left" has suddenly appeared in the product page (configurable product). I checked in Stores->...
  • 115
0 votes
0 answers
113 views

Remove Stock Status if Price = 0 in Magento 2.3

Is there a way to hide the Out Of Stock message for products with $0 as a price only? I realize that the saleable quantity can be hidden in Go to Stores > Configuration > Catalog > Inventory &...
1 vote
1 answer
1k 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
1 answer
962 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?
0 votes
1 answer
18 views

Multistore Advanced Inventory

I have two stores one which is going to be wholesale store and the other a retail store I want to create a product which allows me to set the cart minimum order quantity to 100 for the wholesale ...
  • 1
0 votes
1 answer
33 views

Change stock availability of products based on qty

I'm looking for a query to get all my products that have "qty > 2 and 'stock availability = 0'" and change the stock availability to 1. A crash on my inventory update routine did a mess ...
  • 47

1
2 3 4 5
8