Questions tagged [inventory]

Denotes a question related to Magento inventory.

Filter by
Sorted by
Tagged with
18
votes
2answers
13k views

Detect inventory change

I need to detect whenever the inventory level of a product changes. I've had some success using the cataloginventory_stock_item_save_after event which is triggered when inventory is changed in the ...
16
votes
3answers
11k views

Handling multiple stock locations or warehouses

The Magento database contains the table cataloginventory_stock with a single entry in there called 'Default'. I know this is the place to start for handling multiple stock locations. I'm wondering ...
12
votes
10answers
25k views

Magento 2: Programmatically Updating Inventory

In the following code, I am able to store all the information with the exclusion of the stock data. Has something changed in Magento 2? public function __construct( ScopeConfigInterface $...
12
votes
3answers
2k views

Performance: Add Inventory Stock Levels on product listings list.phtml of all product types

TL;DR, The requirement is having a stock level of inventory be displayed on the category product listing page with as little additional queries/memory with performance in mind that adheres to Magento'...
10
votes
1answer
5k views

The purpose of the table cataloginventory_stock

I see that in the default Magento versions 1.0 to 1.8 (ce) There is a table called cataloginventory_stock that contains only one record. stock_id stock_name 1 Default Related to this, ...
9
votes
4answers
3k views

Magento Observer Events - order of operations

I am attempting to inject functionality into the catalog_model_product_duplicate event. Part of this module will be to ensure that the stock status of the duplicated product is also duplicated; ...
9
votes
1answer
10k views

Magento 1: Relationship Between `qty` in Stock Item, and Stock Status Tables

In Magento 1, Inventory information is stored in a Stock Item object. Each Stock Item object is associated with a product object. Magento persists Stock Item objects to the ...
8
votes
9answers
41k views

How to set a product to be in/out of stock programatically

I tried a few snippets found online but with no success. Just trying to set a product to be in stock / out of stock with code, this is as far as I've gotten: $product = Mage::getModel('catalog/...
7
votes
2answers
11k views

Out of stock products still appear in the frontend

I don't want out of stock products to be appeared in my magento website. I have done the following to ensure I don't see my configurable product in the frontend. Configurable product inventory - out ...
7
votes
4answers
10k views

Daily admin email for products that went out of stock that day

I am trying to set up a script to send out daily emails to my admin to let them know what went out of stock that day only. It doesn't need to be anything fancy, perhaps even writing items to a text ...
7
votes
3answers
4k views

Magento 2.1.5: Products Missing in Categories after Reindex

I am running Magento 2.1.5 and facing a really strange issue. I have over 6,500 products uploaded to the store but some items are not showing up after performing a complete reindex. Of course, some ...
6
votes
4answers
22k views

Magento easy way to show out of stock in configurable product (greyed out)

this may be a simple question for some - but we havent used stock extensions before. My question: how can we easily, simply, add the ability to - instead of hiding out of stock simple products (as ...
6
votes
5answers
7k views

How to improve product inventory daily updates from CSV file?

I'm working on a 10000 products Magento store. I scheduled a cronjob to run everyday at 7am to read a CSV file and update each product inventory and set it out of stock if new QTY is less than 1. ...
6
votes
2answers
3k views

Inventory Management solution integrated with Magento

What solution do you guys use/recommend for Inventory Management: Purchase Orders Receive Goods (GRN) Track Stock movements (multiple locations, transfers, consumption) Ship Goods (Delivery Note) ...
6
votes
1answer
178 views

Stock / Inventory management

I am new to Magento extension development and looking for a way to implement a connection to our WMS. I have done some tutorials on extension development, but am a little stuck on where or how to make ...
5
votes
1answer
13k views

How Set Manage Stock as no in the magento - Programmatically

How Set Manage Stock as no in the magento, i have used this code but manage stock showing as yes $_product->setStockData(array( 'manage_stock' => 0, ...
5
votes
2answers
509 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 ...
5
votes
2answers
1k views

Limit product backorder qty

Is there a way to limit the backorder qty? ie: I want to allow a product to get back-ordered, but only by a few
5
votes
2answers
2k views

“Qty uses decimals” field hidden when “Manage stock” is disabled

Managing a product's inventory settings, if a product is set to Manage Stock = No then the option for Qty uses decimals is no longer visible. This does not make sense as you may want customers to ...
4
votes
4answers
5k views

Magento 2 stock inventory is not being updated

when I placed order in front-end or back-end, quantities of product is not getting reduced or decremented When i have checked in admin panel... Please help me out.. Thanks in advance...
4
votes
4answers
6k views

Updating stock causing foreign key constraint fail

So, I'm trying to update product quantities programmatically. On a standard magento install, it works flawlessly, but on the actual magento shop I'm developing it for, it fails with a SQLSTATE[23000]: ...
4
votes
1answer
403 views

How to Track Inventory for Bulk Product

I am interested in knowing if and how Magento could be used to sell bulk product that is pulled from a common inventory and sold in several discrete package sizes? An example would be Potatoes. They ...
4
votes
1answer
181 views

Stock = 0, out of stock - then I process a credit note. Stock = 1, but still out of stock

Situation: Stock = 0, in_stock = no Then I process a credit note. Stock = 1, in_stock = no I would expect the in_stock to be set back to yes. The effect of this is that we have many T-shirts in 1 ...
4
votes
1answer
2k views

Magento-2 get all products having product qty less than 5 only

I'm trying to get product collection, only the products which have the qty less than 5 in Magento 2, but I'm failing to load. use Magento\Framework\App\Bootstrap; require DIR . '/../app/bootstrap....
4
votes
1answer
2k views

Magento 2: How to get Total Qty?

In Product we have Qty. Once we Order product & order is completed. In sales_order_item table we have qty_backordered, qty_canceled, qty_invoiced, qty_ordered, qty_refunded, qty_shipped Once ...
4
votes
3answers
6k views

Out of Stock item in cart causes checkout button to disappear

We are having an issue that is a big problem but I cannot find a mention of it anywhere else. If a customer puts an item in their cart that is purchased by someone else before they check out, the ...
3
votes
2answers
1k views

How do I link my custom app to Magento

I am trying to build an integration between my online inventory system and Magento. However I am a bit lost in the terminology. Do I need to build the plugin from my app, that will connect to the ...
3
votes
5answers
7k 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 ...
3
votes
2answers
3k views

Unable to get inventory status of configurable products

I am having some trouble and perhaps a few people here can expand my knowledge. Here is the code I am using to retrieve some information about a product on my cart page. if($product->...
3
votes
2answers
635 views

Stock reduction on Invoice instead of Order

Currently, stock gets reduced when the Order has been placed, is there any way to change on invoice? As there, lot of junk orders, is there any way to make stock reducing when invoice for the ...
3
votes
2answers
257 views

Out of Stock Inventory showing as In Stock

I have a Configurable Product which has many Simple Products as variations of it. Some of the Simple Products are Out of Stock however when selected in the product listing, the product still displays ...
3
votes
2answers
1k views

Magento 2 - How to get stock of a product?

I want to instantiate CatalogInventory model in Magento 2 by calling loadByProduct() just like I used to do in Magento 1: $stock = Mage::getModel('cataloginventory/stock_item')->loadByProduct($...
3
votes
2answers
72 views

Communication with ERM

I have Magento, our warehouses use AMT as their primary ERM system. They use .txt files via FTP to keep track of orders and update inventory. I need to know what extension I can use that can output ....
3
votes
2answers
1k views

Stock item not put back in stock automatically upon reaching positive inventory

When a stock item reaches QTY 0 or negative (granted backorders are disabled & QTY for item to become out of stock is 0 as well), is_in_stock is set to 0 automatically. However, when it then ...
3
votes
1answer
553 views

Incorrect inventory when saving a product as an order gets placed

I experienced the following behavior in Magento 1.7.0.2: Edit product Go to inventory tab View inventory In my test inventory on the product was sitting at 9 units. I place an order for the product ...
3
votes
1answer
106 views

Product stock inventory

I have a problem I need help with, it's probably very simple but I just can't understand. So, I am trying to make a product called "Silver Fork" that I sell for 10$. But I also want to offer the ...
3
votes
1answer
889 views

checkQuoteItemQty using wrong qty for configurable product

I have a configurable product with associated simple products which I want to keep Inventory of. I set all the inventories to 10. I've noticed that if I try to add 4 products to my cart, it won't let ...
3
votes
2answers
2k views

Show available inventory on configurable product magento 2

I need on configurable product page to show available inventory of simple products,while selecting options, like price will change on option change in same way.
3
votes
1answer
510 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 ...
3
votes
3answers
6k views

different inventory levels for same SKU multi store

We have a Canadian website and a US website. All products are shared. But we have two warehouses, one in each country. Therefore we need different stock levels for our websites. Any ideas?
3
votes
1answer
257 views

override Magento getQty with custom module

I would like to override the inventory set in Magento with my own custom inventory coming from our ERP. I had to do something similar with getPrice, but I can't seem to find the getQty function in ...
3
votes
1answer
2k views

Show out of stock simple products swatches in configurable (M2.2.4)

I want to show out of stock simple products swatches in configurable product (M2.2.4) to show size etc is available but Out of Stock. I thought M2 did this with "Display Out of Stock Products" but ...
3
votes
1answer
5k views

Display Out of Stock product and disable Add to Cart button

I have a store where product quantity are set to 0. I have enabled back orders if qty is 0 for a product, however I would like to disable Add to cart in case product is out of stock. This means Add to ...
3
votes
3answers
2k views

Out of stock products not showing (Community 1.8)

I want 'out of stock' products to show in the store, but despite the option System/Configuration/Inventory/Stock Options/Display Out Of Stock Products being set to yes they still don't show. Is there ...
3
votes
2answers
1k views

Trying to create an observer that notifies when an item goes out of stock returning null

***SOLVED ON MY OWN**** Hi guys, I just solved it using a debugger. It seems that getStockItem() was trying to get an object that doesn't exist that's why it was returning "null". The correct call ...
3
votes
0answers
82 views

Product ordered but was out of stock

I'm using Magento 1.7.0.2 and have configured my store not to allow backorders, but for some reason some products are ordered having the stock at 0. I'm using Paypal for the payment process. Catalog ...
2
votes
2answers
3k views

How to set inventory of all product fom 9999 to 1

I have a client who has set the inventory of all products in 9999 pieces. Now he wants to use the warehouse management. It should all products are reset to 1. Is it possible to automatically make? ...
2
votes
3answers
2k 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 ...
2
votes
3answers
4k views

How to automatically cancel pending orders after a specified amount of time?

We found that we sometimes run out of stock/inventory due to orders pending payment. In our case, when the customer cancels PayPal payment, or doesn't pay through Bank Deposit. Is there a way to "...
2
votes
3answers
6k views

Is it possible to have two stores sharing one backend and the same inventory?

I have two stores targeting different markets selling the same products. I want to charge different prices on each site (high end and then budget) but I want them to share the same inventory so I can ...

1
2 3 4 5
7