Questions tagged [inventory]

Denotes a question related to Magento inventory.

Filter by
Sorted by
Tagged with
0
votes
2answers
24 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 ...
0
votes
0answers
14 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
1answer
35 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....
0
votes
1answer
16 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. ...
0
votes
0answers
8 views

Magento2 showing wrong data for low stock report for multiple warehouse

I have set new source and new stock and assigned new stock in product, when i check low stock report its not showing updated data for new source and stocks, its always showing default stock data, can ...
0
votes
0answers
16 views

Inventory- do not want to take sample into account for inventory

Due to the nature of our business sometimes we have product that is shop worn and we do not want to take into account as a unit in inventory. In this case, we would like the backorder message to be ...
1
vote
0answers
21 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
1answer
21 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 ...
0
votes
1answer
65 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
0answers
21 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 ...
2
votes
2answers
305 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->...
0
votes
0answers
13 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
1answer
80 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
0answers
12 views

How does low-quantity notification work?

In my test site (Magento CE 2.3) I've set the "manage stock" option to yes and set the "Notify for Quantity Below" option to 5. As you can see my current Quantity is 1 but I haven'...
0
votes
1answer
113 views

Magento 2.3 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
1answer
11 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 ...
0
votes
1answer
22 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 ...
0
votes
1answer
170 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
1answer
61 views

Inventory View inventory_stock_1 causing database locks

After moving databases we are getting spikes in our database from PDP pages with the following query, and it ends up taking a full minute to query. SELECT `inventory_stock_1`.`quantity`, `...
0
votes
0answers
15 views

Magento 2: Hide “Sources” section on Add/Edit product page (for some users)

I have a user role that's allowed to edit products, but shouldn't be able to manipulate inventory for the product (e.g. the "Sources" section of the add/edit product page, the catalog is ...
1
vote
0answers
13 views

Stocks sources of other website's showing on applying store switcher in admin

Ours is the multi website store(UAE and Oman), and each website is assigned its own stock source under Stores > Stocks But when I Go to product edit, and switch store to Oman website, user is able ...
0
votes
1answer
58 views

Backorder quantity wrong when unshipped reservations

Magento version: 2.3.5-p1 (magento/module-inventory-sales) version: 1.0.8 -- The backorder quantity shown in checkout and stored in sales_order_item.qty_backordered can be wrong when there are ...
0
votes
0answers
18 views

Magento 2.3.5-p1 inventory changes only after shipping not with sale transaction

we upgraded our test system from 2.3.4 to 2.3.5-p1 on PHP 7.3. we use the out of the box inventory function with simple products. After the successful sale transaction the inventory count remains ...
0
votes
0answers
23 views

Set specific source inventory to customer with MSI

We currently have a B2B project with about 50 physical stores, and each store has its own independent inventory. Each customer is assigned to one or more physical stores. When the customer logged in, ...
0
votes
0answers
124 views

How to upgrade inventory-composer-metapackage to 1.1.5 in Magento 2.3.3?

How can I update magento-inventory-metapackage to version 1.1.5 in Magento 2.3.3? I have tried this: composer require magento/inventory-composer-metapackage:1.1.5 But it resulted this: Your ...
1
vote
0answers
78 views

Magento 2 product is “in stock” and saleable qty is zero 'add to cart' still showing in category page

Using Magento 2.3.5-p1 version Product stock status is "in stock" and saleable qty is zero 'add to cart' still showing in category page but the "add to cart" button not showing in ...
1
vote
0answers
97 views

Magento 2 “Add to Cart” button appear on category pages for “Out of Stock” products

Magento 2.3.5 Add to cart button will not show on the category page. It shows instead of "out of stock" Also, there is an issue on Magento GitHub - https://github.com/magento/magento2/issues/...
0
votes
0answers
14 views

Stock Qty:40 Salable Quantity: 260. What has gone wrong?

Using Magento 2.3.2 I have a few products where the salable quantity is slightly more than the stock quantity, and one in particular which is WAY out. 40 in stock 260 salable. How do I reset the ...
0
votes
0answers
27 views

Updating multiple products stock script slows over execution time

I'm tring to update all products of an eshop with a php script ( magento command ). I'm preparing an array with all stock data and while looping over all shop products i'm updating the stock using the ...
0
votes
0answers
20 views

Customers ordering out of stock products

I have my store set up so that out of stock items do not show up. For some odd reason every so often a customer is able to purchase a product that is out of stock. When I look that item up on my ...
0
votes
1answer
268 views

Magento 2 All Bundle Product Show Out Of Stock On PDP

In my magento 2 store show all bundle product OUT OF STOCK.
0
votes
0answers
161 views

SQLSTATE[42S02]: inventory_stock_sales_channel doesn't exist - Magento 2.3.1

I have disabled the MSI (inventory) and some products work for me but other products do not and I get this error: 2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base ...
0
votes
0answers
41 views

Magento 2.3 Change product status to out-of-stock when qty is less than 'Minimum Qty Allowed in Shopping Cart'

I'm running Magento 2.3.5. Some of my products have Minimum Qty Allowed in Shopping Cart set to greater than one. For example, product A has Minimum Qty Allowed: 7. Currently, the QTY of A is: 10. Now ...
0
votes
0answers
246 views

Magento 2.3 Update Stock via Database - Multi Source Inventory

I was hoping to get a grasp on the how Stock levels(Qty of a sku in stock) are stored in the database with the changes to MSI. Now that we have stocks and sources I'm unsure what all tables we need to ...
1
vote
0answers
72 views

Magento 2 How to Update Product Saleable qty using programmatically with Magento standard code

How to Update Product Saleable qty using programmatically with Magento standard code ? i am able to update product quantity using below code - protected $_stockRegistry; public function __construct( ...
1
vote
0answers
18 views

Out of Stock Products Displaying on front-end when told not to!

just a quick one. Using Magento 2.3.2 I have "Display out of stock products" switched to "No" in Stores > Configuration > Catalog > Inventory, but my storefront still ...
1
vote
1answer
187 views

Why changing the scope of quantity_and_stock_status from Global to Website level does not affect the Quantity and Stock Status field?

I have changed the scope of quantity_and_stock_status in Stores > Attributes > Product > from Global to Web Site: But while creating new products or editing existing products the Quantity ...
1
vote
2answers
97 views

How to change the scope of product Quantity from Global to Website level?

I am using Magento 2.2.6 Open Source Edition, a single product has been selected for 3 websites in Product in Websites section, I would like to have different quantities of the product for each ...
2
votes
0answers
34 views

Share inventory between my 3 stores (MSI disabled - Same Environment)

I have 3 stores that share the same stock for products. The stock is being handled by an external system, and in order for everything to work properly, they have been recommended to disable MSI (...
2
votes
2answers
667 views

isAvailable() and isSalable() return false for all products on frontend even though they are definitely saleable

I just completed a migration from M1 to M2 version 2.3.5-p1. All of the product and stock data was correctly migrated (I can see it in the database) but no matter what I do, products are all showing ...
0
votes
0answers
12 views

Salable Inventory

I have read through all the Magento documentation on Salable Inventory and still can not figure out how to update the salable inventory quantities. All stores and products show "No manage stock&...
0
votes
1answer
54 views

After shifting the website to another server. Products are showing out of stock

After shifting the website to another server. Products are showing out of stock I found the error while uploading the database file. CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`localhost` SQL ...
0
votes
0answers
15 views

After shifting the website to another server. Products are showing out of stock

All product showing out of stock. I found the error while uploading the database file. CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS ...
1
vote
0answers
50 views

Magento2: Not able to assign Source after enable the MSI module

I have disabled the MSI inventory module (as explained in this article) in my store. After facing some issues I have reverted back MSI related all modules, but after enabled all modules I am not able ...
0
votes
1answer
110 views

Error on Update inventory REST API? when SKU has a “#” in it

I'm trying to update the inventory of our products from our ERP using the rest api. I have run into an issue when the SKU has a pound "#" in it. A URL like: https://magento.xyx.com/rest/V1/...
1
vote
3answers
1k views

Salable quantity of 0 but still showing in stock?

I have a big issue with Magento 2.3.2. When products reach a salable quantity of 0 they still appear in stock. These products still have a physical quantity of more than zero as they haven't shipped ...
1
vote
2answers
787 views

MAGENTO 2: HOW TO DISABLE MSI in MAGENTO 2.3.0

How one can disable the MSI module in Magento 2.3.0 if not in use.
0
votes
1answer
87 views

Assign inventory by customer group with MSI?

We have a site with B2C Customers and B2B customers. The Inventory of each came for different warehouses. So, the requirement is that B2C customer only watches and buy the products in stock on B2C ...
0
votes
1answer
85 views

Magento 2.3 Inventory Management with Linnworks Integration Stock Levels Not Updating from Linnworks

I'm running Magento 2.3.4 and have successfully integrated it with Linnworks. However, I believe I need to disable the inventory management in Magento 2.3 in order for the Linnworks to update the ...
1
vote
2answers
200 views

Can I disable the Magento Inventory modules?

I have my stock synchronized and managed by SAP, because of it I'm having issues with the inventory quantity vs salable quantity, I won't use multi-source inventory in this project, can I disable ...

1
2 3 4 5
7