Questions tagged [cataloginventory]
Denotes questions regarding Magento Catalog Inventory
89
questions
0
votes
1
answer
26
views
Can I set Manage stock at website level?
I have question regarding inventory management.
I do not want to use multi source inventory for our magento 2.4.0 store.
Now we are going to convert multi website with different quantities for same ...
- 877
1
vote
0
answers
108
views
Magento 2 The stock item was unable to be saved. Please try again
This is the log i found. i don't know why its happening when creating a new product.
[2022-09-27 07:10:49] main.CRITICAL: The stock item was unable to be saved. Please try again. {"exception"...
- 85
0
votes
1
answer
49
views
Issue with Advanced MSI and products listing Magento 2.4.3
I'm facing an issue with Magento 2.4.x, the website is hosted on managed magento server.
We have 2 inventory sources (default & abc) and we have assigned products to the source abc. If we enable ...
- 21
0
votes
1
answer
60
views
After POSTing a product those go out of stock, but never back in stock
Can anyone explain why exactly a configurable product for which every virtual product's quantity goes down to zero, and said product subsequently disappears from the store, won't come back even if the ...
- 151
0
votes
1
answer
81
views
How to automatic stock details (quantity increment)?
In the warehouse, if we scan the product it has to update in Magento inventory (i mean quantity has to increase).
How can I achieve this one?
- 453
2
votes
1
answer
264
views
Magento 2 - list products out of stock at the end with ELASTIC SEARCH
I need to show out of stock products on at the end of listings using ElasticSearch on Magento 2.4.*.
I was able to order without ElasticSearch, but once I enable ElasticSearch it won't work.
It feels ...
- 165
0
votes
2
answers
357
views
Backorder products displaying Out of Stock label
My employer has a range of products that we make to order. As such, we don't keep any on hand so our inventory on the Magento 2 backend is always set to 0.
I have lowered the out of stock threshold so ...
- 1
0
votes
1
answer
98
views
Magento 2 : How to set product stock status customer group specific?
My requirement is wholesaler can order out of stock prdocuts.
I tried to create a plugin for the below file but didn't work.
\Magento\CatalogInventory\Helper\Stock::addIsInStockFilterToCollection
...
- 427
1
vote
0
answers
146
views
How to detect product quantity change using observer in Magento 2.4.1?
We are using Magento 2.4.1 and we want to update the values of some custom attributes in the product whenever the product quantity is changed in the admin. Which events can be used to detect the ...
- 627
2
votes
1
answer
1k
views
inventory_source_item and cataloginventory_stock_item data is not same
inventory_source_item and cataloginventory_stock_item data is not same? which table to used for stock now. Please explain. Thanks so much
- 455
0
votes
0
answers
74
views
Magento 2 do not update Inventory correctly
Example: Inventory level is at QTY 100. All of these things happen simultaneously:
1- An admin processes a refund/return and restocks 2 items.
2- Two customers make a purchase buying quantities of 1 ...
0
votes
2
answers
1k
views
Magento 2 how to get products per website programmatically?
I want to know how to get the amount of products per website? I don't know if this exists, it should.
I was searching for a plugin or observer, but I cannot find it, under magento-catalog and magento-...
- 533
0
votes
1
answer
717
views
How to automatically change the status to In Stock if products are added to the product
if the number of products falls below 1, then it will become out of stock, but if you increase the products manually, then the status will remain out of stock. How can I automatically change the ...
- 148
0
votes
0
answers
42
views
Product Qty update after order place Magento 1.9
I am doing it via observer but nothing is working. here is my code snippet:
config.xml
<checkout_onepage_controller_success_action>
<observers>
<qtyupdate>
...
- 784
0
votes
1
answer
143
views
After shifting the website to another server. Products are showing out of stock
After shifting the website to another server. Products are showing out of stock
I found the error while uploading the database file.
CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`localhost` SQL ...
- 706
0
votes
1
answer
188
views
How to change stock status Instock permanently in magento2.3?
Please shown below image.
If quantity is 0 aur greater than 0 select Instock only. No need to select out of stock if quantity below 0.
Can i change this functionality through admin panel or need to ...
0
votes
1
answer
888
views
Magento2 - Inventory source By Product Sku
I am getting the product inventory source successfully below is my code.
$sources = $this->getSourceItemsBySku->execute($sku);
$array = [];
foreach ($sources as $index => $source) {
$...
- 51
0
votes
1
answer
1k
views
After Migration inventory_source_item table is empty magneto 2
This Table ( inventory_source_item ) is Empty and which all my product show out of stock, Can anyone, please help me solve this issue
- 352
1
vote
1
answer
310
views
Magento2: How to get the old qty of product?
How to get the available qty of the product before saving the product with new qty in magento2.
How to do that.
Thanks.
- 2,520
3
votes
4
answers
6k
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
...
- 201
1
vote
0
answers
54
views
Availability-only not shown on inventory level in Magento 1.9
For my Magento store, the threshold qty is not considered on inventory level, although this is set up in the backend.
This is the view with the output of the QTY message
app/design/frontend/base/...
- 11
1
vote
1
answer
865
views
Magento 2 MSI - How to listen the event of all source item stock update API
Am using the below rest API to update bulk product's Stock information
/rest/all/V1/inventory/source-items
My requirement is that I need to listen the observer or some file whenever this API is ...
- 379
0
votes
1
answer
523
views
404 error while updating Product inventory by rest API Magento 2.3.1
I am trying to integrate Magento 2.3.1 with Linnworks,
All the api calls are working fine expect the CatalogInventory.
When we try to update the product inventory using rest
PUT https://sitename.com/...
- 350
1
vote
0
answers
274
views
SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support Magento 2
I am facing below error while run setup upgrade commands.
SQLSTATE[42000]: Syntax error or access violation: 1235 This version
of MySQL doesn't yet support 'multiple triggers with the same action
...
- 461
3
votes
0
answers
443
views
What is the difference Between cataloginventory_stock_status & cataloginventory_stock_status_idx
If I use cataloginventory_stock_status and cataloginventory_stock_status_idx return different values, what is the main difference between these two tables?
- 145
0
votes
1
answer
317
views
Inventory management after order created via rest API in Magento 2.x version ( without cart)
I have created Magento rest API for the third party integrations and I have used a couple of API's for listing products, fetching product detail and created order.
I used [PUT] - /V1/orders/create - ...
- 505
1
vote
1
answer
1k
views
Missing add to cart button on some items
We're experiencing a strange issue with our catalog, I'm scratching my head of where to start looking for...
Here are the symptoms:
Item X - doesn't have the "Add to Cart" Button.
When I go to the ...
- 535
0
votes
5
answers
6k
views
Magento 2.3 - How to fetch stock statuses of all the stores
I need to fetch the stock status (In Stock/Out of Stock) of all the stores for the single product.
I have configured MSI. Lets say am in store1. In product view page I should be able to get the stock ...
- 379
3
votes
2
answers
818
views
How to disable/enable backorder for particular website/store?
I want to enable/disable backorder from one of the available websites. How can I implement it?
- 1,175
6
votes
1
answer
427
views
How to programatically transfer qty from one to other source
Does anyone has idea how to update product qty from one source to other programmatically ?
Basically I've 2 sources in my magento setup. Let say currently Salable Qty = 50 and first source has 20 qty ...
- 3,714
2
votes
0
answers
64
views
Products do not appear on list page in magento 2?
I am working on a project where I need to display the list products on list page. I have added the products on local server where I am getting them on front-end. But when I create products on live ...
1
vote
0
answers
25
views
Change the quantity of a child, the change should be applied for the other child of its parent in configuration product
In other words, when I change the quantity of a child, the change should be applied for the other child of its parent in configuration product .Thank you in advance.
- 143
0
votes
1
answer
917
views
How to show "out of stock" child products for configurable product in list and product view page magento 2?
I am trying to show out of stock child products for configurable product in details and product view.I changed the settings from catalog inventory to display out of stock products even it is not ...
- 1,836
0
votes
1
answer
606
views
Why order item quantity is not decreased after order placed
I am facing a strange issue in our live site order item quantity is not decreased after order placed from the frontend.
(i.e) if a successful order has 5 products, 4 products quantity has been ...
2
votes
4
answers
4k
views
Store level Inventory for individual product Magento 2.2.0
Is there any way that have enable Store level Inventory.
Its not about user config Inventory at
Catalog > Inventory
Its about
Admin >> Catalog >> Product >> Open product which you want to ...
- 454
1
vote
1
answer
4k
views
Magento 2 How to set product minimum quantity selected to minimum qty configured in the Advanced Inventory product level
If 5 is the minimum Qty on Advanced Inventory product level for a product then in Product detail page it should as 5 default selected.
How can I achieve this.
- 454
1
vote
1
answer
3k
views
cataloginventory_stock_status entry issue Magento 2
I did not get an entry in cataloginventory_stock_status table after indexing.
Product stock entry is exist in cataloginventory_stock_item table.
I have checked this thing in Magento 2.2.5 in default ...
- 421
0
votes
1
answer
282
views
Magento 1.9.3.8 Execute only when there is a change for the Stock Level
I have got a custom extension, to track stock movements. So, keep a record of when x amount stock is added for a given product and/or when x amount of stock is removed.
However, Even if I don't edit ...
- 765
2
votes
1
answer
1k
views
What is the usage of itemId inside Update inventory REST API?
According to the swagger, the REST API PUT /V1/products/{productSku}/stockItems/{itemId} is used to update the product inventory.
However, for the attribute value itemId, I found no differences no ...
- 2,695
1
vote
0
answers
38
views
Magento 2.2 Inventory not getting decreased when orders are created using REST API
I am new to Magento 2.2 and I want to create orders using REST API. Orders are getting created. But the stock value of the Product is not getting decreased. I have made the necessary settings in ...
0
votes
4
answers
3k
views
How to show only in stock products? [duplicate]
I am using product collection in my custom phtml file I try to add filter only show in stock product but it will not work
My code :
$currentCategory = Mage::registry('current_category');
$catId =...
- 11
1
vote
1
answer
649
views
Is there any observer like 'cataloginventory_stock_item_save_commit_after' in magento 2?
I need to trigger the inventory changes in Magento 2.0
I have an observer cataloginventory_stock_item_save_commit_after in Magento 1.9 and its working fine.
But I can't find the same observer in ...
- 192
1
vote
0
answers
84
views
show total stock available
Is there a simple way to show total quantity in stock for products. We are trying to make it a simple inventory catalog showing products and total quantity available per product?
If some development ...
2
votes
1
answer
712
views
Magento 2: Remove 'low stock' label from product image
I created a product and set 'Manage Stock' to no. But when i see a product on frontend, it shows a label 'Low Stock' on product thumbnail image. I do not want to show that label. I think there is an ...
- 1,053
1
vote
1
answer
1k
views
How to update Qty on product save action?
I'm trying to update the StockData in catalog_product_save_before observer and not having any luck.
I can get the stock data like this
$_newProduct = $observer->getProduct();
$_newStock = $...
- 141
2
votes
2
answers
3k
views
Magento 2 Rest Api V1/products missing extension attributes
I am calling the Rest API V1/products to get the product list from Magento 2 store
Request:
http://{myMagentohost}/Magento/index.php/rest/V1/products?searchCriteria[currentPage]=1&...
- 21
1
vote
1
answer
1k
views
SQL to list all skus, inventory on hand and qty sold between x and x date
I have a Magento 1.9 site and I am trying to write a sql query that would return a listing of all skus (disabled and enabled) in the site as well as how many of each sku was sold between a specific ...
- 693
3
votes
0
answers
242
views
Unable to edit product attribute value
Running 1.9.x Magento, I found a handful of products (out of 80k) that have a product attribute value that cannot be edited from the product edit panel.
The attribute value is a custom value called '...
- 31
1
vote
1
answer
907
views
Update stock level in a particular warehouse
We have multiple warehouses for our web-store and we want to update stock via script whenever we get new stock in. However, when I try to update the stock level via program, the stock level goes up ...
- 23
0
votes
1
answer
190
views
The catalog inventory stock item unique hase changed
I am working on a new Magento 2.1.4 projet. We have a single store. And we need to manage the inventory for a large amount of shops belonging to this store.
I was thinking about using the ...
