Questions tagged [msi]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views
+50

Magento2 Source selection based on Sellable Quantity

I'm trying to modify the Source Selection algorithm based on the following condition: Sort by Sellable(available) Quantity (Descending) and then location sort priority I have tried many tutorials but ...
  • 7,336
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
14 views

Not all of your products are available

We are trying to bypass the Salable Quantity in magento 2. We have a problem with the bundle, when one of the elements present inside the bundle goes negative, this message appears when we try to ship....
0 votes
0 answers
8 views

Bundle products are showing without stock even if I disable the option to show out of stock products

I have a store with MSI and I have bundled products, also I have disabled the option to show out-of-stock products. But when one of the simple products that compound the bundle doesn't have stock the ...
0 votes
1 answer
62 views

Magento 2 MSI error "There are no source items with the in stock status"

I am trying to enable the MSI module after being disabled for a lot of months. Now MSI related tables are empty and it is throwing the error "There are no source items with the in stock status&...
  • 1
0 votes
1 answer
89 views

disable Magento MSI Magento 2.4.4

I'm trying to disable Msi module on Magento 2.4.4 using the following command: php bin/magento module:disable -f Magento_Inventory Magento_InventoryAdminUi Magento_InventoryApi ...
0 votes
0 answers
9 views

Magento 2.4.2 - issue with hide out of stock product

I noticed issue with hide out of stock products. All visible on frontend. Reindex completed (all indexes sucess) indexes reset option hide out of stock enabled correct c:f, s:up etc done. Qty:0 MSI: ...
  • 2,106
0 votes
0 answers
36 views

[Magento][2.4.3] Deduct source item on refund

I have config MSI for my store and I have some problem. When I call api /V1/invoice/:invoiceId/refund to refund my order with payment type is online payment (ex: paypal, ATM..) after refund success, ...
0 votes
0 answers
41 views

Multi source inventory: Move inventory/stock from non-MSI to newly added MSI source/stock?

We have an existing store, where we have just one warehouse. Let's call it Warehouse 1. Because we have only this one warehouse, the MSI related extensions have been disabled before. This is how we ...
  • 1,063
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
0 answers
13 views

How to return inventory quantity with an order status of PAYMENT REVIEW

I have a question about an item whose current order status is "PAYMENT REVIEW". Is there a way to restore the SKU inventory? How can I change the quantity available for sale back from 1 to 2 ...
0 votes
0 answers
65 views

Magento MSI Source - add custom field to Sources in M2

I want to add custom field in MSI source form. not able to find any documentation or idea on it anyone can help me to add field in MSI? I saw same question but not got any proper answer Magento MSI; ...
  • 2,593
0 votes
1 answer
25 views

Magento2 MSI Install on 2.3.4

Trying to install https://github.com/magento/inventory on our Magento Enterprise Cloud v2.3.4 however, am getting this error and am not sure if anyone else has experienced this and figured out how to ...
  • 793
2 votes
2 answers
81 views

Create custom date MSI Attribute

Is it possible to create a custom attribute for MSI Stock data at the store level and add it in the following table at Admin Product edit or do we just have to use the extension/custom attribute to ...
0 votes
0 answers
255 views

Magento 2: Get source inventory qty based on store view

I want to show stock qty based on store view here: I tried getting msi source item qty by sku using: $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $productMsis = $...
  • 161
0 votes
1 answer
198 views

How do I query products by saleable quantity in MSI

How can I get a list of products that have 0 saleable quantity using either the product repository or collection (if not possible in repository). Something like $searchCriteria = $this->...
0 votes
0 answers
92 views

Magento2 Special Price is not correctly reflecting on Product List Page and Search Page

Pr-conditions: Magento version: Magento Commerce 2.3.6 Varnish version : 5.2.1 PHP version: PHP 7.2.33 MySQL version: 5.7 Multi Website architecture Catalog Price Scope = "Website" (Admin &...
  • 1
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
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 ...
1 vote
1 answer
158 views

Is it ok to Truncate the "inventory_reservation" table

I have Magento 2.3.6 with MSI enabled. What are the consequences that can occur after truncating the "inventory_reservation" table? Is it ok to truncate the "inventory_reservation" ...
2 votes
1 answer
371 views

Impossible drop table during s:up after disable MSI

I have disable MSI M 2.4.0 and now I try run upgrade but I get: SQLSTATE[HY000]: General error: 1829 Cannot drop column 'source_code': needed in a foreign key constraint '...
  • 2,106
0 votes
1 answer
247 views

How to determine if MSI is enabled or not

I am building a Magento 2 module that makes changes to stock information. Bearing in mind stock management APIs are different in Magento depending on if MSI is being used or not, what is the best ...
  • 101
0 votes
1 answer
404 views

Magento 2.4 MSI : How to programmatically set Notify Stock Level on Source and SKU

I would like to set Notify Qty from a script that reads a CSV file with Source, SKU and NotifyQty. It would probably need to enable notify qty for the products as well. I can do it with SQL query to ...
  • 7
0 votes
1 answer
142 views

How to set source quantity (MSI) from my own custom backend module in Magento 2.4?

I'm new to M2, and I am in a hurry to migrate my site from M1. In M1 I made my own MSI functionality, but now I would like to use the built in MSI functionality in M2. For some of the backend logic (...
  • 7
1 vote
1 answer
632 views

Magento 2 MSI Get Product's Inventory Location/wareshouse on frontend

How would I go about displaying a product's warehouse location on the product page? We are using MSI and would like to display which stock source the product is in stock at on the product page.
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
160 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 ...
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
20 views

How to display out of stock on product?

How can I display "Out of stock" in the product based on the Warehouse selected. I will have a selected_opco cookies that can determine the selected source. How can I display "Out of ...
1 vote
0 answers
80 views

MSI M2 - Multisource shipping?

We are using MSI Multistock (multisource) and want to be able to ship from multiple sources in M2 in one shipment. In short it does the following sell items from multiple sources as shown in image ...
  • 5,332
1 vote
0 answers
300 views

Default source and stock missing in MSI after re-enabled - Magento 2

We disabled all the below MSI extensions. Magento_Inventory Magento_InventoryCatalog Magento_InventoryAdminUi Magento_InventoryApi Magento_InventoryBundleProduct Magento_InventoryBundleProductAdminUi ...
  • 9,599
0 votes
1 answer
328 views

Magento 2.3.4 - How to install Inventory Management Manually?

I am trying to install https://www.appjetty.com/magento2-magemob-inventory.htm, After installed the module during di:compile command i am getting the following error, Class Magento\Inventory\Model\...
  • 105
0 votes
1 answer
272 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 ...
  • 1
2 votes
0 answers
76 views

How to make my own selection algorithm working with multi source inventory? Magento 2.3

Is there a way to make my own selection algorithm in MSI? Working only with one website and one store.
0 votes
1 answer
465 views

Magento2 Salable Qty value is not correct how can we re-calculate this value? List inconsistencies? Fix it?

Salable Qty <> sum(sources) No idea why. We are testing MSI and Backorders and have use the Ampersand extension to disable reservations. But nonetheless: how can salable qty be incorrect? and ...
  • 5,332
0 votes
2 answers
358 views

Magento2 MSI How can we set 1 source to ship from, but not to sale from?

Magento2 MSI How can we set 1 source to ship from, but not to sale from? We currently use backorders. Sales are made from stock sources and backorders (min_qty). Suppose Local stock 2 Incoming stock ...
  • 5,332
3 votes
1 answer
2k views

Magento2 MSI v2.3.5 and up: What does "Synchronize with Catalog" do exactly?

We are seeing a new option in v2.3.5 "Synchronize with Catalog" and can read about it here. https://docs.magento.com/user-guide/configuration/catalog/inventory.html But what does it do ...
  • 5,332
1 vote
2 answers
3k views

How do we change the Default Stock or Default Source for Magento 2 MSI?

How do we change the Default Stock or Default Source for Magento 2 MSI? There is no option to do so And when importing stock or Backorder " out of stock threshold " then it activates Default ...
  • 5,332
3 votes
2 answers
479 views

I have to disable the MSI and enable the usual qty field only in the magento 2.3.5 version

I have to disable the MSI and enable the usual qty field only in the Magento 2.3.5 version https://www.rakeshjesadiya.com/disable-sources-in-multi-source-inventory-magento-2/ I tried to use the ...
1 vote
0 answers
99 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 ...
1 vote
0 answers
82 views

Filter in Admin Panel by MSI Salable Quantity > 0

How can I add a filter in the Admin Panel products grid to filter (display only) product with Salable Quantity > 0?
  • 151
0 votes
1 answer
68 views

Assign inventory source if distance greater than 20km

I am using the distance priority algorithm for source selection of the inventory. I want to assign a particular source to a product if the nearest available source is greater than 20km distance. Is it ...
  • 114
0 votes
0 answers
257 views

Wrong store_id in product collection

I need to cycle products collection for each store. But the method $collection->addStoreFilter($store) seems to not work properly. I also tried to $collection->setStore and setStoreId. The problem ...
1 vote
2 answers
1k 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.
  • 71
0 votes
1 answer
220 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 ...
1 vote
2 answers
863 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 vote
1 answer
1k views

Why I received the error "Could not receive Stock Item data" in admin product grid?

"Could not receive Stock Item data" line appear instead of the product grid in the admin side. I have recently imported other DB to my Cloud local setup. When I'm doing indexing, I'm getting an error ...