Questions tagged [cataloginventory]

Denotes questions regarding Magento Catalog Inventory

Filter by
Sorted by
Tagged with
1
vote
1answer
3k views

Notify for Quantity Below in Magento 2

I have a requirements to notify the admin through email when a product quantity goes below 5 in Magento 2.0.7. I have found that there is option on the admin: System > Configuration > Catalog > ...
2
votes
2answers
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&...
0
votes
0answers
29 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 ...
0
votes
0answers
10 views

Prevent Catalog Inventory Source Items Save on Store Level

I would like to prevent saving source items fields (Source Item Status, Quantity etc...) on store level on product edit in admin. I've created a preference for \Magento\InventoryCatalogAdminUi\...
0
votes
1answer
931 views

Show Empty Categories on Catalog Page - Magento 2

I want to show all categories, even if they have no products in them. How can I achieve something like this?
1
vote
1answer
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 ...
0
votes
0answers
15 views

update magento quantities from mysql

I'm drawing a draft for a script to update several products at once using mysql. I've got my own table myinventory which has two columns: sku and qty UPDATE cataloginventory_stock_item INNER JOIN ...
2
votes
3answers
3k 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 ...
1
vote
1answer
1k views

Slow Save Order Due To Re-Index

We're running CE 1.9.1.0 with all the latest patches and use New Relic, among others, to track site performance. I've noticed a number of slow queries when customers are checking out, and in every ...
9
votes
5answers
5k views

How to get product collection of out of stock items - opposite of addInStockFilterToCollection()?

I have a requirement to display a category's products in two lists - one for in stock items, the other for out of stock items. I'm using Mage::getSingleton('cataloginventory/stock')->...
0
votes
2answers
43 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 ...
0
votes
1answer
23 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 ...
0
votes
0answers
21 views

Custom Model to load from Redis Cache

I want to create a custom module, it will have one model called Product and I want to load product details from Redis cache. So how to configure a model which will get loaded up from redis.
0
votes
0answers
61 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 ...
0
votes
1answer
184 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
0
votes
0answers
24 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
0answers
22 views

Modify In Stock functionality of Layered Navigation

In a specific requirement, we need to have out of stock product listed on website for back orders, magento does offer it very well, but I am looking to have a filter for layered navigation, if chosen ...
0
votes
0answers
16 views

How to reduce stock in inventory when order is placed and not when shipped

How to reduce stock in inventory when order is placed and not when shipped . "Decrease Stock When Order is Placed"is already set to yes , still count does not decrease on order placement.
2
votes
4answers
3k 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 ...
0
votes
2answers
159 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-...
0
votes
1answer
379 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/...
0
votes
1answer
672 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
0
votes
1answer
40 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 ...
0
votes
0answers
27 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> ...
5
votes
3answers
7k views

Can I completely disable an indexer?

I have a situation where I'd like to completely disable one of Magento's core indexers (cataloginventory_stock). I don't want this index to ever be rebuilt, maintained or altered in any way. Is it ...
0
votes
1answer
76 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 ...
0
votes
1answer
45 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
1answer
199 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) { $...
3
votes
2answers
365 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?
0
votes
5answers
4k 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 ...
1
vote
1answer
174 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.
1
vote
0answers
51 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/...
1
vote
1answer
566 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 ...
0
votes
1answer
769 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
vote
0answers
213 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 ...
3
votes
0answers
236 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 '...
0
votes
1answer
246 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 - ...
2
votes
0answers
189 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?
3
votes
5answers
9k views

Disable "Only X left Threshold" Qty from Showing on Store

Anyone know how to remove the "Only # left" from showing on the product page of the store? System > Configuration > Inventory for Stock Options has the field "Only X left Threshold" set to "0" which ...
1
vote
1answer
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 ...
1
vote
2answers
339 views

How to get minimum, maximum, and available products for a product

I need to find the stock details of a product how to find that.
6
votes
1answer
354 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 ...
2
votes
0answers
50 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 ...
2
votes
3answers
16k views

Magento 2 - How to set a maximum order qty of individual products?

I am trying to figure out how to set the maximum qty allowed in a shopping cart for an individual product. In my case: Most products can be added to the cart as many times as they want, but I have a ...
3
votes
2answers
1k views

Email for Low Stock Products

How can I setup the Email Notification for the Low Stock Products and Expired Products?
1
vote
0answers
23 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.
1
vote
1answer
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.
0
votes
1answer
516 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
789 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 ...