Questions tagged [msi]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
24 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 ...
1
vote
0answers
13 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
1answer
32 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 ...
0
votes
2answers
21 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 ...
0
votes
0answers
15 views

Magento2 and Backorders: what happens when a quote is cancelled or a credit memo is issued?

So when using Magento 2 and Backorders are enabled. Stock = 2 and Backorder Min Qty = -5, resulting in a Salable qty = 2 -- 5 = 7. Now when adding items to the cart we see 1 item in cart (stock = 2, ...
0
votes
0answers
36 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 ...
0
votes
2answers
45 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 ...
0
votes
0answers
8 views

How to add plugin for MSI in module with version condition for M2.2 without error?

Does any one knows how to add plugin for Multi Source Inventory in module so it should work for M2.2 and M2.3.x?
0
votes
1answer
24 views

Showing stock status on Frontend

I am trying to find a solution for showing the stock status for 2 warehouses on the frontend Category and Product page. To explain a Little better. I have 2 sources connected to our saleable stock - ...
3
votes
2answers
56 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
0answers
25 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
0answers
22 views

How to filter product by MSI Salable Quantity > 0 in Admin Panel

How can I add a filter in the Admin Panel products grid to filter (display only) product with Salable Quantity > 0 in Multi Source Inventory?
0
votes
0answers
17 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?
0
votes
0answers
46 views

Getting: Not all of your products are available in the requested quantity when try to create a shipment

I've created a backorder with one item. For that item i have the manage stock set to Yes and the qty set to 0. When I try to create a shipment in Magento(2.3.4) and I am receiving this error ...
0
votes
1answer
19 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 ...
0
votes
0answers
25 views

Product Listing giving and Error on Multi Inventory Enabled In magento 2

I have created a product Grid in in my admin using Datasource of Magento_Catalog <dataSource name="vendor_module_product_listing_data_source"> <argument name="dataProvider" xsi:type="...
0
votes
0answers
37 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 ...
0
votes
0answers
12 views

Define a New Sales Channel

We want to use MSI (multi source inventory) but assign stocks per store view instead of per website. In order to do that, we need to create Sales Channels for each of the store views, so they can be ...
1
vote
2answers
282 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
23 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
0answers
22 views

Magento 2.3.3 MSI: Is there a way to remove products from search results or catalog pages when their salable_qty goes to <= 0?

This is the scenario: qty = 2 reservation exists for the product with quantity -2 salable_qty = 0 The product still shows in search results and in category pages, but you can't add it to the cart. ...
0
votes
0answers
19 views

Magento 2 : msi relation with default stock and supplier stock

Good Day and hope everyone is safe, I am confused as I have the msi in my 2.3.3 magento. I was under the impression that the object was to be able to use multiple warehouses for when stock ran out, ...
1
vote
2answers
61 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 ...
0
votes
0answers
14 views

How to import stock sources by manufacturer code instead of SKU?

Say I have files from few suppliers. Each supplier has supplier_sku and qty. On my store I have SKU, suppliler1_sku, supplier2_sku. Magento MSI lets me import only by referring to SKU. How would I ...
0
votes
1answer
287 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 ...
0
votes
0answers
27 views

Unassigning a source on a product programmatically in Magento 2's MSI

In the admin for a product, you can assign and unassign sources for a product (as seen below). How to programmatically unassign a source from a product?
1
vote
1answer
69 views

Why I can't delete my default stock and source in the MSI?

I've tried to remove the default stock and source, why I'm not allowed to do it?
0
votes
1answer
450 views

The requested sku is not assigned to given stock. Product is not displayed

When I go to product page I get this: The requested sku is not assigned to given stock. Also product is not displayed on category page.
0
votes
1answer
46 views

Inventory Stock Sales Channel Mageto 2.3.3

So we have this query that keeps running and BlackFire is complaining about it and I'm wondering if I turn it off there will be any negative effects. We're not managing our own stock so I assume it ...
0
votes
2answers
255 views

M2 REST API: Creating shipment with products from MSI source

I am using MSI. When trying to create a shipment with a source code, the shipment uses the "default source" instead of the one I'm providing. My Request: [POST] /rest/default/V1/order/5/ship { "...
1
vote
0answers
80 views

Remove Source not disable, want to delete it

Magento 2.3.1 with MSI would like to remove source. I repeat want to delete/remove source :) reason is I created accidentally and it needs to be remove before we move to production. For more ...
0
votes
0answers
17 views

MSI stock source as attribute when export CSV

We're using MSI in Magento 2 and want to show the quantity per stock source in CSV. At this moment when exporting the products we can see only the stock of the default source. Is there a way to show ...
3
votes
1answer
282 views

Magento 2.3 MSI Custom Product Type, Stock Tracking, and Product Category Collection Filtering?

I need to create a custom product type that has custom stock functionality and does not behave like a simple product, bundle, or configurable. To build out this product type I need to understand how ...
0
votes
0answers
43 views

Magento2 how can I add out-of-stock threshold to admin products grid?

How can I add 'out-of-stock-threshold' (min_qty) to the admin products grid? Or for that matter any of the MSI stock fields beyond qty?
0
votes
0answers
28 views

Adding a column in MSI Source Selection page (in ordered items dynamic rows)

I'm trying to customize MSI Order shipping source selection page (the step before shipment creation form). I need to add a column in "ordered items" dynamic rows. I was able to add my new column, but ...
0
votes
2answers
407 views

Magento 2.3 Upgrade magento inventory MSI

I've got a store that is suffering performance issues. And I've been able to pinpoint this to MSI. I started to seriously look at this today. How do you upgrade MSI on Magento 2.3? I've read help ...
0
votes
0answers
23 views

Magento 2.3.x: MSI sync to Ebay

We are using Magento 2.3.2 with MSI where we have several sources assigned to one stock. After configuring Omnivore to export products and inventory to Ebay, we noticed that the extension is not able ...
0
votes
1answer
702 views

Magento 2.3 inventory index gives The product that was requested doesn't exist. Verify the product and try again

The inventory index doesn't get re-indexed, it gives this message: The product that was requested doesn't exist. Verify the product and try again. In other questions I found that there could be ...
2
votes
2answers
453 views

Magento 2.3 cleanest way to remove MSI to speed up store

My question is simple. What is the cleanest way to speed up Magento 2.3.x by removing MSI. In my opinion this is a B2B feature and most small merchants won't be interested in this feature. IMHO it ...
0
votes
2answers
494 views

Magento2 - MSI In-Store Pickup how to enable?

I have a fresh Magento 2.3.2 installation and want to allow my customers to pick up their orders in-store. But I can't find any configuration related to this functionality, can someone explain to me, ...
1
vote
0answers
223 views

Magento 2.3: Getting the salable quantity via SQL

I'm trying to get all stock data of a product via SQL for debugging. The part that I'm not 100% on is the salable quantity. Here is what I have: SELECT t1.`quantity` + SUM(t2.`quantity`) ...
1
vote
1answer
687 views

Magento 2.3.2 Inventory Reservation, adding entries for open order before inventory upgrade

My salable quantity is off. I figured out why it's off and how salable quantity is calculated. Example proper order: User: New order with product sku SKU-AAA x 1 System: Create a Reservation for ...
0
votes
1answer
42 views

How do I create a shipment via REST API magento2?

Can someone help me about the shipment. How can I pass the MSI source code to the Shipment Create API? Thanks
1
vote
1answer
326 views

Add column to sales order view page

I'm currently working in the Magento 2.3.1 MSI. When I viewed in the product view page in the admin panel there is a quantity per source column with displaying quantities per source. Can I add this ...
1
vote
0answers
118 views

Stock not reduce after placed the order in magento 2 after enabling MSI

As i mentioned in the question, after i enabled the MSI module in my magento 2 store product qty is not reducing from the stock until i complete the shipment. Is there any way to reduce the product ...
1
vote
0answers
256 views

Error during rate request at Dhl/Express/Webservice/Soap/RateServiceAdapter.php:77

I have upgraded magento 2.2.4 to 2.3.2. After upgrade version we have enabled MSI modules. After Enabling MSI modules we are getting below error when we try to create shipment. We are not able to ...
1
vote
3answers
705 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 ...
3
votes
1answer
833 views

Trunacate Table `inventory_reservation`

How much risk is to truncate table inventory_reservation ? After truncate does MSI will work fine or Do i need to bang my head on keyboard !!?
3
votes
3answers
914 views

Magento 2.3.0 MSI isTableExists calls take too long

I'm experiencing slow performance coming from MSI. New Relic reports something like: 48 runs of SHOW TABLE STATUS LIKE ? that takes in total 5 seconds. There are many calls to this because it's about ...
0
votes
1answer
20 views

How to add MSI Integration in Magento 2.1

I am using Magento 2.1. I know Multi-store inventory is available in Magento 2.3. But now I need to add multiple sources for Magento 2.1. I couldn't find any blogs or information regarding this.