Questions tagged [cataloginventory]

Denotes questions regarding Magento Catalog Inventory

Filter by
Sorted by
Tagged with
0
votes
1answer
310 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 ...
1
vote
1answer
61 views

Magento inventory

In my magento project I have created a superuser who can directly add product to customers cart from his cart. Here I am loading customer quote by their emailId and adding each product from super user ...
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.
0
votes
1answer
313 views

Magento 2.1 Override Catalog Inventory

I'm currently writing multi-vendor extension, I'm looking for sample code on how to override the inventory, so it shows inventory from a custom field, Already tried overriding getQty of the Product ...
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
0answers
200 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
372 views

On Product Save from Magento admin getting the Integrity constraint violation error

On Product Save from Magento admin getting the Integrity constraint violation error, Can any one please let me know why this errors coming up. SQLSTATE[23000]: Integrity constraint violation: 1062 ...
5
votes
2answers
587 views

Disable all Mage_CatalogInventory features

We don't use any feature of Mage_CatalogInventory and I disabled some of it in the system configuration, but there are still a lot MySQL Queries especially in the checkout, which took very long. My ...
1
vote
1answer
966 views

How to Prevent Negative Stock Qty Value In Magento?

How do I prevent product stock qty value showing negative values in admin? I have set Backorders to "No Backorders" but still it's showing negative values. can anybody please help me on this. Thanks
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 > ...
0
votes
0answers
644 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 ...
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

Magento - change of product quantity and status is not working in an event

I have created an event which checks that if the backorder quantity of an item is greater than zero than set the ordered product quantity to zero instead of keeping it in negative and also change its ...
0
votes
1answer
54 views

Magento 1.9 - Use backorder stock instead of actual stock for certain products

For some "Special" products in a webshop I want to use Backorder stock instead of actual stock which is available for those products but not sure how to proceed with it. I have looked into ...
2
votes
1answer
686 views

Why are there 3 identical tables in Magento2?

We came across three absolutely identical in structure tables in M2 DB: cataloginventory_stock_status cataloginventory_stock_status_idx cataloginventory_stock_status_tmp Anybody has any idea ...
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 ...
0
votes
0answers
53 views

Display stock remaining quantity for all type of products [duplicate]

My requirement is to display stock remaining quantity in PDP for all types of products : simple,bundle,grouped,configurable. For bundle products, when I choose the radio button/switch option, the ...
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?
0
votes
1answer
303 views

How to uncheck checkbox of Use Config Settings in Catalog Product Inventory

I want to uncheck checkbox Use Config Settings by default in Inventory section in Catalog=>Product section as below image--- I know that we can update it from DB query but I want to make them ...
1
vote
1answer
123 views

Single inventory for all products

I'm wondering what is the best way to accomplish inventory management for a magento store that sells custom made t shirts. The store has several designs the user can choose to be printed on the t ...
3
votes
1answer
543 views

SOAP V2 query returns empty array

This simple query works as expected with SOAP V2: $result = $proxy->catalogProductList($sessionId); var_dump($result); but swap the Role resource access to Catalog Inventory > Retrieve stock data ...
2
votes
1answer
526 views

cataloginventory_stock_item.low_stock_date?

Table cataloginventory_stock_item column low_stock_date In our db most of the products have the same exact timestamp. how the event trigger for low stock and how to get the exact date. Actually lot of ...
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
1answer
48 views

is it possible to get products filtered by out of stock by date?

Is it possible to get all products filtered by out of stock by date? This will give the function to see when the products was last in stock, and give us the information to delete product if necessary.
1
vote
0answers
254 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
1answer
2k views

How to decerement the product quantity after place an order?

I am tring to add multiples of x products in to cart, that is working fine as expected after check out i want to decrement the product quantity, how can i do that? I am using an event observer for ...
6
votes
3answers
5k views

Product stock is not saved when creating a product programmatically

I'm creating products programatically on Magento CE 1.8.1. The form works fine except every once in a while we get a nasty error that comes and goes away, and does not affect all users. :"SQLSTATE[...
0
votes
1answer
16 views

Products assigned to category root issue

So I'm trying to solve a small issue that I noticed in my category setup. To preface, I'm running a multi-domain install with 2 separate stores. For example purposes, i'll refer to their root ...
1
vote
1answer
668 views

Magento sold more products than in inventory

My client had a big traffic on server for 1 day. They added one product (ID X) with quantity = 10000. After few hours they sold about 15000 items of this product - I can say because of simple query: ...
0
votes
1answer
2k views

How to reserve qty for magento in cart for a specific time? [closed]

Let say Product A has 1 qty left in inventory, If a customer add to cart that product, it should be reserved for 10min or specfied, If he clear checkout while that time otherwise it should back into ...
3
votes
0answers
2k views

Manage Qty Stock update using Magento SOAP API [closed]

We are using below like code for Qty stock update using Magento SOAP API. try { $client = new SoapClient('http://www.magentosite/index.php/api/?wsdl', array("connection_timeout" => 5,'cache_wsdl' =...
1
vote
2answers
1k views

Issue How to track each size of product inventory

I have a question. Please let me know how I can do this? We cannot count inventory for variations, like XL, XM, M, L etc.. etc.. For example, take a look at this product, it has different size "...
1
vote
1answer
965 views

$stockItem->getIsInStock() stopped working after update to 1.9

example code: $stockItem = $product->getStockItem(); $stockItem->getIsInStock() The product is one item of a collection. Before the update I could Request the isInStock status in this way. ...
1
vote
1answer
205 views

Possible bug in 1.7 import for saving product qty in function _saveStockItem()

I had a problem where product import files with only sku and qty fields were importing the wrong qty's for most items. I realized that whatever qty the first item had would be applied to all the rest ...
0
votes
2answers
1k views

Product stock qty management

I've developed a module to allow some minor changes to products from the frontend. It works but the quantity management because the qty value is added and not replaced in ...
1
vote
1answer
52 views

Integration with our Inventory System [closed]

I want to integrate our Magento website with Inventory management system. for this task we are development 2 ways syncing service which will update Magento db & Inventory system also; How to ...
1
vote
1answer
480 views

Possible orphans in cataloginventory_stock_item?

Should every record in cataloginventory_stock_item link to a record in catalog_product_entity? When I run the following SQL I get 15,874 products in cataloginventory_stock_item that do not match a ...
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 ...
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
2