cancel
Showing results for 
Search instead for 
Did you mean: 

Problem indexing inventory

Problem indexing inventory

When i try to reindex with the parameter inventory i recieve the following error:

 

php bin/magento index:reindex inventory

The product that was requested doesn't exist. Verify the product and try again.
Product Price index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:00

All products have an SKU number in the database.


What can i do to find the product that is causing this issue?

* edited typo

6 REPLIES 6

Re: Problem indexing inventory

Hi @scns,

For Catalog inventory reindex you need to run following command:

php bin/magento indexer:reindex cataloginventory_stock

You can get all indexer info from following command:
php bin/magento indexer:status

For reindex all:
php bin/magento indexer:reindex

I hope it will help you!

Re: Problem indexing inventory

Hello @scns 

 

The message 'Requested product doesn't exist' is triggered whenever Magento 2 tries to load a product which does not have a SKU.

To check which products do not have a SKU, sort the table catalog_product_entity by SKU. All the products with no SKU will then be grouped together. You can then fix this issue by manually adding the SKUs to the products in this table.

 

After that you can run indexing commands as follows:


php bin/magento indexer:reindex

Let me know if you need any other help.

Manish Mittal
https://www.manishmittal.com/

Re: Problem indexing inventory


@Manish Mittal wrote:

Hello @scns 

 

The message 'Requested product doesn't exist' is triggered whenever Magento 2 tries to load a product which does not have a SKU.

To check which products do not have a SKU, sort the table catalog_product_entity by SKU. All the products with no SKU will then be grouped together. You can then fix this issue by manually adding the SKUs to the products in this table.

 

After that you can run indexing commands as follows:


php bin/magento indexer:reindex

Let me know if you need any other help.


Hi @Manish Mittal Tnx for the possible solution, but there are no products with an empty SKU. 

 

When i sort the SKU column there are no empty cells. 

Re: Problem indexing inventory

Hi @scns ,

Please try to reset indexing first and then try again. 
May be it will work for you.

php bin/magento indexer:reset

Re: Problem indexing inventory

Hi @Vimal Kumar 

 

Tried your solution, but the still the same after the reset.

 

 php bin/magento index:reindex inventory
The product that was requested doesn't exist. Verify the product and try again.
Product Price index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:00

 Allready tried to flush the cache but no solution.

Re: Problem indexing inventory

I have the same problem... please help