Questions tagged [stock]

Denotes questions related to stock management and configuration on Magento

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

Stock level in configurable product dropdown

Can someone helpful think of a way to display the stock level of a configurable product variant in the dropdown list? i.e S... 9 in stock M...3 in stock L...2 in stock Thanks,
1
vote
1answer
38 views

Magento 2 - Bulk update stock programmatically - Using database query [duplicate]

I have 10 products; 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. I want to be able to bulk change 1, 3, 4, 5 and 9 to 0 quantity and out of stock and 2, 6, 7, 8 and 10 to 100 quantity and in stock. How can I do ...
0
votes
0answers
15 views

Are these the correct fields to update for a stock update API method?

I have several thousand products in Magento, and the /V1/products/{productSku}/stockItems/{itemId}/ takes too long to update inventory for all the products, so I'm making my own API method to update ...
0
votes
1answer
22 views

how i can solve unable to save stock item in magento 2 while saving product

I deleted all the products and categories via SQL queries (i used this answer https://magento.stackexchange.com/a/283404/73525 ) while saving new product i got error Unable to save Stock Item ...
1
vote
1answer
54 views

Can't getStockItem magento 2.3.1

Block namespace Vendor\Extension\Block\Product; use Magento\Framework\View\Element\Template; class Stickycart extends Template { protected $_registry; protected $_stockItemRepository; ...
0
votes
2answers
16 views

Magento 2 : We cant place the order : SQLSTATE[HY000]: General error: 1449 The user specified as a definer your_db_user@% does not exist

I have migrated a Magento 2 site to a new server and getting the below error when placing order We cant place the order : SQLSTATE[HY000]: General error: 1449 The user specified as a definer ...
0
votes
0answers
11 views

Magento 2 - Render cost price in low stock report - Many can use this

We have a shop, where we want a low stock report with cost prices, so we can see how much we need to pay for these products before buying them. What I want is to add an extra column with the cost ...
0
votes
0answers
21 views

Magento 2 how Inventory and Out-of-Stock Threshold calculation works?

With regards to Magento 2.3.1 what is the use of Out-of-Stock Threshold assigned to product inventory? For eg: product stock status "in stock" qty "10" When I assign Out-of-Stock Threshold "5" ...
1
vote
1answer
21 views

M2 - Reset Salable Quantity

Is it possible to reset the Salable Quantity? It looks like our Stock and Salable Quantity is going the wrong way, they show to much difference. It can because of we removed all the test orders... So ...
0
votes
0answers
13 views

Stock Issue: cataloginventory_stock_status table doesn't hold correct final status

AFAIK, cataloginventory_stock_status table holds the final status of the product stock (Which is the result of stock indexing). But it seems it not working as expected. Expected Results When any ...
0
votes
2answers
71 views

How to move the “IN STOCK” above Add to cart button

How to move the Stock availability (In Stock) next to the Quantity button.
0
votes
0answers
22 views

M2 - Configurable product stock is 10, max to order is 6

I have multiple configurable products on my webshop and the quantity is set to 10, but if I want to order 7 items, I get a message "The specified number is not available". And if I order 6 items, it's ...
0
votes
1answer
27 views

Magento2 : Product Updates Not Showing on Front End - store scope issue

Problem: Certain product attribute updates are not being seen on the front end. Irrespective of re-indexing, cleaning and flushing the cache, etc. If I change them via Update Mass Attributes, then ...
1
vote
0answers
36 views

Magento 2 - bundle product

I want to sell in Magento 2 products that depend from production. I will explain this base on coffee. Let say I have 1 Kg of seeds arabika as a simple product. This translate to 900 g of ground ...
0
votes
1answer
28 views

Magento2 : Products showing “Out-of-Stock” in Frond-End and “In-Stock” in Backend

I am using Magento version 2.3.x and when I add a downloadable product, it is showing out-of-stock in the front end. but it is showing in-stock in the back end. how to fix this, I have tried my ...
0
votes
0answers
19 views

How to set bundle product out of stock if any associate product out of stock?

I want bundle product out of stock if that product's any child have 0 qty
1
vote
0answers
27 views

Product stock not returning to available stock in canceled order

Is there any explanation of why product stock from canceled order is not returning to available stock? Step to reproduce: I tried to order an item X (until place order) Open admin site, edit ...
0
votes
0answers
22 views

Concurrent checkout made negative/minus stock

Sorry, I'm asking this question again. I already put the question in Magento community to explore if there is any possibility to handle this issue. Also, I already explore that this issue was fixed in ...
0
votes
2answers
48 views

How to update product stock using custom script in Magento 2

How to create a script for update product stock. After the product stock update saves the product. Anyone helps me to create this script.
0
votes
0answers
21 views

How to reslove source and stock issue in magento2 bundle product

For Inventory Management, Single Source merchants may experience performance degradation with all products assigned to the Default Source and Default Stock. created and assigned all products to one ...
0
votes
0answers
36 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 ...
0
votes
1answer
15 views

Update Product Attribute based on Stock Levels [Magento 1.9]

I am trying to have two out of my Product Attributes updated once the Stock Level reaches 0, or goes above 0. Would this be possible ? Thanks
0
votes
1answer
52 views

Magento 2.3.1 How to display source or stock name on product page ? MSI Multii Source Inventory

How to display source or stock name and code on the product page? Where is information about a current stock or source name? Can I use the code from Sourceitem.php on the Product page? public ...
1
vote
0answers
19 views

Stock API - QTY and out of stock

I have an integration with an ERP system which is pushing stock qty to Magento2. The problem is that if the item qty becomes 0 Magento puts it out of stock, when the ERP updates the qty to say 10 the ...
0
votes
1answer
35 views

Stock for quantities over quantities 100 go up randomly - Magento 2

I have a problem whereby stock quantities with 3 or more digits (100 or more) go up randomly on my site. I am not sure what the problem could be. Stock quantity increments are disabled on every level....
1
vote
1answer
41 views

Magento 2.2 - event to detect qty change

I need to detect a change of qty in product (backoffice change after edit is enough for me). I was trying to do it with simple observer <event name="cataloginventory_stock_item_save_after"> ...
0
votes
1answer
13 views

Getting product stock levels / quantities in Magento 2.3

I have the following code to get a product collection but how do I also return back the stock levels too $products = $this->productCollectionFactory->create() ->...
0
votes
1answer
47 views

Magento 2: Event-Observer for whenever the stock status of product changes

Is there an event for whenever a product goes from In-Stock to Out of Stock and vice-versa. I basically need to programatically set the value of a custom product attribute depending on the stock ...
2
votes
0answers
25 views

Magento 2 REST API: Show In-stock products first in product listing API

I am looking into a headless magento approach. I am using the following API to list the products in a given category: V1/products?searchCriteria[filter_groups][0][filters][0][field]=category_id&...
1
vote
0answers
30 views

stock filter is not adding to layered navigation in magento 2.2.7

Do all the setting but not get the filter in front end for stock
0
votes
2answers
32 views

Magento 2 stock update returns 0

Im trying to update the stock of my products programmatically, using this code: $stockItem = $this->stockRegistry->getStockItemBySku($sku); $stockItem->setQty($qty); $this->stockRegistry-&...
0
votes
1answer
33 views

Multiple Products, One Stock Quantity

Good Afternoon, I apologise if I ask or say anything seemingly ignorant or stupid however I am very new to Magento. I work for a company that sells laptop LCD panels all over the world. We have ...
0
votes
0answers
16 views

Magento 2 : Stock status not accurate

I have some products which they are out of stock in backend and also in catalog pages, but on the product page, they appear as in stock. This behavior is the same whether the flat product enabled or ...
0
votes
1answer
38 views

In magento 2 how to override stock availability in product detail page in custom module

In magento 2 how to override stock availability in product detail page in custom module app/code/Vendor/Module/view/frontend/layout/catalog_product_view.xml <?xml version="1.0"?> <page ...
0
votes
0answers
12 views

Rogue rows being removed from cataloginventory_stock_status

We have around 180,000 products and are having issues with salable quantity not matching quantity. We've narrowed it down to an issue with the table "cataloginventory_stock_status" When we reindex ...
1
vote
1answer
28 views

How to add available qty to cart when customer request more than available qty?

As asked in the question, Is there any possibility to add available qty(in stock) to the cart when customer requesting more than available qty. How magento behave with this situation? ex : I have 5 ...
1
vote
0answers
28 views

Trying to update stock on Magento OMS using API

I am trying to test out updating stock on the Magento OMS API by using the magento.inventory.source_stock_management.update method. The first step of getting the authentication token from the https://...
4
votes
1answer
55 views

Why have my configurables stock status Out of Stock

All I found so far is from the User Guide in Step 4 under 2.: The Quantity is determined by the product variations, so you can leave it blank for now. The Stock Status of a configurable ...
1
vote
2answers
62 views

Reindex Not Happening Automatically Magento 2.3

Every time I update a product stock in magento it updates perfectly in the backend but only when I manually run a reindex via SSH does it update on the front end. Very annoying when I am sometimes ...
0
votes
0answers
6 views

Magento 2 Decrease Stock Quantity When Order Placed with Manage Stock OFF

Does anyone know how to decrease stock quantity of a product if the manage stock function is switched off. From the standard backend it doesnt seem possible so I am hoping it can be coded in Thanks
2
votes
0answers
30 views

Magento 2 with Stock and Order Management Software

Hopefully someone can help with this I am running stock management software. Currently I am experiencing this isse Item Stock 3 Sellable Stock 3 Item sells Item Stock 3 Sellable Stock 2 So far so ...
1
vote
0answers
20 views

Sellable Quantity Not Matching Product Quantity

I have alot of SKU which the sellable quantity is less that the actual quantity. So quantity could be 5, but sellable quantity is 3. I thought it could be open orders, or processing orders, so I ...
1
vote
2answers
325 views

How to set qty to product on MSI Magento 2.3

In my custom module, I'm using StockRegistryInterface to set qty and save my product. But on Magento 2.3 I started facing the issue of having 0 salable qty right after saving the product. After ...
1
vote
0answers
15 views

Setting out of stock using MAGMI?

I want to set a products stock status to "out of stock". This is the csv file content: sku;is_in_stock 2714575;0 After that, the stock status did not change in the backend. Any idea what I am ...
0
votes
0answers
194 views

While saving product throws “Unable to save Stock Item” exception in magento 2.2.6

While saving product in backend,throws "Unable to save Stock Item". I have tried after flushed the cache and reindexing but still exception throws. I have reffered below link, but no luck https://...
0
votes
1answer
32 views

Magento MSI; add custom attribute to Sources in M2

we want to use multiple sources using Magento Multistock MSI. 2 of our 5 stock locations are called 'virtual'. They have stock that is not readily avilable but can be sold. OUr idea is to mark ...
0
votes
1answer
43 views

Magento 2 Error filtering template?

After installed module we are getting one error message called "Error filtering template: You cannot define a correlation name 'stock' more than once" Mentioned with below code. Can anyone ...
3
votes
2answers
127 views

Salable Quantity is greater than quantity

My salable quantity is greater than my quantity. How has this happened? I recently updated to Magento 2 and have been trying to get my head around the MSI but still can't figure out how salable ...
0
votes
0answers
28 views

Stock Alert / Out of Stock Threshold

I've set up my products so that I'm notified by email when stock drops below a certain threshold, the issue is that the email I recieve only tells me that a product has dropped below the threshold not ...
0
votes
3answers
680 views

Showing Salable QTY in frontend Magento 2.3

We are currently showing our available qty in stock on the frontend of each product using the following code: <?php $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $...