Auto Added by WPeMatico
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 delete the relation of product… Read More »Can I truncate inventory_source_item table?
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, run cron, and memory/storage looks… Read More »Inventory management not automatically changing to ‘out of stock’ (is there Patches List for Magento 2)
We’re running Magento 2.4.5 with the MSI module and using the In-Store Delivery shipping method. I would like to change the In-Store Delivery store locator on the checkout page, so that a location will only be available if each product… Read More »Restrict the checkout In-Store Delivery pickup-up locations to products that have available inventory
How to get product salable qty by productId?
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 (salable quantity) is still showing a… Read More »MSI saleable qty showing a positive number for stock Qty is 0
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`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`,… Read More »Cardinality violation When Deactivating MSI on Magento 2.4.5
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 inventory_cleanup_reservations is successfully finished. Statistics: {“sum”:0.0029830932617188,”count”:1,”realmem”:0,”emalloc”:70656,”realmem_start”:161742848,”emalloc_start”:160341872} [] [] It… Read More »Magento 2.3.1 Inventory reservations cleanup not working
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 Magazine barcode that has 12 digits of… Read More »I want to handle Magento book & Magazine Inventories using the barcode system
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 status for… Read More »Can I prevent Google indexing in stock/out of stock status?
Previously to get the minimum qty allowed in a shopping cart I would use the following code: public function __construct( MagentoCatalogInventoryApiStockRegistryInterface $stockRegistry ){ $this->stockRegistry = $stockRegistry; } public function getMinSaleQtyAllowed($productId): float { $stockItem = $this->stockRegistry->getStockItem($productId); return $stockItem->getMinSaleQty(); } However, MagentoCatalogInventoryApiStockRegistryInterface… Read More »Getting the minimum qty allowed in a shopping cart without deprecated methods