Questions tagged [stock]

Denotes questions related to stock management and configuration on Magento

Filter by
Sorted by
Tagged with
1
vote
3answers
30 views

How to get salable qty in magento 2.3.3?

How to get salable qty of each Product and display in Product view page. Can someone help me? Thanks in advance.
0
votes
0answers
20 views

Magento 2: Move Stock info above Add to cart

I know this questions has been posted other times, but in my case didn't solve the issue. I need to move the Stock info before the add to cart button (in the product page of course). I put this code ...
0
votes
0answers
33 views

The requested SKU is not assigned to the given stock

When I access my admin panel and try to send the order I received this message below, how could I fix it? I suspect that it'd be caused by the MSI.
0
votes
1answer
32 views

Magento 2: how to get only configurable products that have some in stock child without looping?

I want to get only those configurable products whose any child are in stock. I.e filter out the ones that have no child that are in stock. Also, i want to achieve this without looping since it's quite ...
0
votes
2answers
31 views

Display “only X left threshold” and stock status on category view

I'm new to Magento(2) and I'm trying to display Stock Status, stock count, and quantity field in category view like in product view. I don't know where to get theses values and where to put it... I'm ...
1
vote
0answers
21 views

Magento 2 - Layered navigation show products with salable quantity to 0

In my store I have all products with only 1 quantity. When I buy a product, its "Salable Quantity" is 0 instead its "Quantity" stays 1 and thats ok, because the product is only "reserved" and the ...
1
vote
0answers
16 views

async rest api product can't set `enable_qty_increments`

I would set up enable_qty_increments in my store. I've edit store settings cart options to manage this but when I try to use rest api to update my product always this request can't set options relate ...
0
votes
1answer
58 views

Update item custom quantity and salable quantity value after place order in Magento 2

I need to decrease purchased item saleable quantity with custom value (x* ordered_qty) after place order in Magento 2.Right now I'm using the following observer and class to update the quantity of ...
1
vote
1answer
14 views

Magento 1 php script product in stock sent email

I would like a php script that when specific products, which I define, have a qty of higher than 0. I automatically receive an e-mail from this. Anyone have an idea how I can easily make a script out ...
1
vote
0answers
39 views

Magento 2.3.3 Upgrade Error - You cannot define a correlation name 'stock_item' more than once

Getting Error on Bundle Product page on Magento 2.3.3 after Upgrade. Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'stock_item' more than once Thanks
0
votes
1answer
38 views

How to show out of stock in configurable product's option selection Magento 2.3.2

How to show out of stock in configurable product Magento 2.3.2 like the below image https://i.ibb.co/JpKdwNx/5210046c-6f62-11e6-8db7-abda30a5c09d.png
3
votes
1answer
139 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
1answer
26 views

Magento 1 check if any of cross sell items are in stock

How can I check if any of the cross sell items are in stock in our Magento 1 store? I want to load some php if rule, that only display a text line, if any of the cross sell items are in stock. My ...
1
vote
1answer
70 views

Update Product QTY right before place order from external remote API

We want to update and check product quantity when user clicks on "Place Order" button. If product is outofstock in remote API and get 0 qty then user should not able to "Place Order" and display ...
0
votes
0answers
35 views

Magento 2 Do we need to reindex & cache clean for Product Qty update

I need to update product Qty programmatically, I have my main store where I have my stocks details so I need to update to Magento whenever it's triggered from my Main store or by cron with interval. ...
0
votes
0answers
23 views

Why is programmatically updating stock and price so slow?

I'm trying to update the stock and price of the products in a magento 2.3 store from a csv file. The file I have has about 5,000 rows, and about 3,500 of those correspond to products in magento. ...
1
vote
0answers
91 views

Magento 2: Missing Default Inventory Stock and Source

While running the Magento indexer commands I received this error: No linked stock found. After checking the backend I realised that there is no default inventory stock entry or source. I am running ...
0
votes
0answers
10 views

Magento 2.3.2: Need decrease salable quantiy on while set from admin ,Decrease Stock When Order is Placed set “NO”

Is it possible to still decrease salable quantity on place order while select from admin, Decrease Stock When Order is Placed set "NO". if yes please help how can.
0
votes
0answers
62 views

Magento 2: selling 0.5 item as MINIMUM quantity WITHOUT using decimals

I have a very weird question to ask you. I would like to use 0.5 quantity ONLY as minimum quantity without using decimals. As of now, if I try to put 0.5 having decimals disabled, it doesn't work (of ...
0
votes
1answer
128 views

How to add custom column in the product grid while creating the order in the admin in Magento 2?

I am using Magento 2.3.0 You can see above grid when you try to add products while order creation in the admin. I want to add a new column called "Stock" in the above grid and I want to display the ...
0
votes
0answers
20 views

Magento 2.2 - Products showing out of stock

I'm having an issue where only a handful of products are showing out of stock even though they have inventory and are set to in stock. One thing I've noticed is that the products will go to in-stock ...
0
votes
0answers
60 views

How to show saleable quantity in Magento Low Stock Report

Today I have encountered a problem with one of our magento store. Below are the store configuration. Magento 2.3.2 (Migrated from Magento 1.9.4.2) Backorders are allowed in our store. Product X has ...
1
vote
0answers
16 views

How to get catalog in stock on frontend?

I have done everything everyone subscribes everywhere From reindex, in stock, manage all, quantity, databases check, double check But products just don't appear on front end because it says out of ...
1
vote
2answers
201 views

Downloadable product on Magento 2.3.1 out of stock issue

I'm issuing a problem with newly created downloadable products on Magento 2.3.1 This store contains about 10k products (phisical and digital) imported from M1 Phisical in stock/out of stock is ...
0
votes
2answers
93 views

Display stock status on product detail page

I have searched a lot and since I am new to magento I would like your help. I want to display my stock quantity on my product details page. Can someone please give me a step by step configuration ...
2
votes
1answer
185 views

Magento 2: Rest API add “stock_item” in to the list of the products

Magento 2 product rest API provided stock_item details in /V1/products/:sku API. But V1/products rest API not included stock_item details in products. I want to need stock_item details in to the list ...
1
vote
2answers
57 views

Save stock data programmatically

You know how you've got; $tempProduct->setData('price', 9.99); $tempProduct->getResource()->saveAttribute($tempProduct,'price'); I want to do the same, except for stock; $stockData = $...
0
votes
0answers
29 views

Magento 2: Adding fields/attributes to product “Assigned Sources”

A relatively new feature in Magento 2 is stock sources, where inventory can be held at multiple locations, like this: Our client wants to store the location of the product within each store (aisle ...
0
votes
0answers
27 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
192 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
34 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
2answers
51 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 the error Unable to save Stock ...
0
votes
1answer
284 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
260 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
1answer
43 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
77 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
63 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
21 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
150 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
187 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
40 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
38 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
28 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
81 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
30 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
60 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
37 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 ...
1
vote
1answer
275 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
19 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