Questions tagged [cataloginventory]

Denotes questions regarding Magento Catalog Inventory

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
198 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 '...
2
votes
0answers
39 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?
2
votes
1answer
55 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?
2
votes
0answers
37 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
2answers
2k 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&...
1
vote
0answers
21 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
0answers
20 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
0answers
25 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 ...
1
vote
0answers
76 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 ...
1
vote
1answer
744 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 ...
1
vote
1answer
484 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 ...
1
vote
0answers
173 views

Magento2: Updating products with CSV duplicates product_id in cataloginventory_stock_item

Any ideas why Magento 2 creates duplicate product_id into cataloginventory_stock_item table for each product that I try to update via import functionality? Thanks.
1
vote
1answer
2k 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 > ...
1
vote
0answers
231 views

What events trigger low_stock_date to be updated?

What events trigger cataloginventory_stock_item.low_stock_date? In our db most of the products have the same exact timestamp, and it's only 4 days ago, despite a lot of these products being out of ...
0
votes
0answers
16 views

Show out of stock products for specific web site (store view)

I have 4 retail web sites setup with one Magento installation (multistore – different websites and store views). First, 3 web sites show only “in stock” products (which is what I want), but the 4th ...
0
votes
2answers
28 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
77 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 ...
0
votes
1answer
91 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 - ...
0
votes
0answers
49 views

How to setup different Advanced Inventory Options for each store?

I couldn't find an answer for this problem and I hope someone can help me out. I have a magento 2 multi store version 2.3, a retail store www.example.com and a wholesale store wholesale.example.com, ...
0
votes
0answers
32 views

Magento 2.2 Detect Product Inventory Change

Is it possible to detect Inventory change of a Simple Product from a custom module? Basically if the Value displayed in a Simple Product's 'Quantity' field ( as seen in the Admin product detail page....
0
votes
0answers
20 views

How to Add quantity box in Magento 2.1 product page

I want Add To Cart with one sku with multiple size and Quantity. if I select Size M then I can add qty 1 or more
0
votes
1answer
368 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 ...
0
votes
1answer
259 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 ...
0
votes
1answer
103 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 ...
0
votes
1answer
232 views

configurable Parent Product set “Stock Availability” set auto magento-1.9

I would like to do if any Child product has status "in-stock" parent status auto update "in-stock". else parent configurable product status update "out-stock". anyone can help me how can I do it with ...
0
votes
1answer
618 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?
0
votes
0answers
539 views

Get CatalogInventory stock collection in Observer

I need, on website save, get the inventory with the current website ID. Ad I'm trying to get the CatalogInventory Stock Collection in an Observer, but it finish with the error: Configuration array ...
0
votes
4answers
264 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 ...