Something went wrong: There are no products to generate feed. Please check Amasty Feed indexers status or feed conditions

Question

How can I do this problem as the title?

When I finish all of the settings of google feed setup by Amasty Feed and try to generate it but it turns as above picture. I went to Index Management and check all of the statuses are ready. Someone also told me to let the Amasty Feed update on save but it still didn't work. Is there anyone who has the same problem and solved it?

Hope to get the answer. Regards, Tess

Answer 1

Found out a few things: It seems during product indexing the amasty_feed_valid_products gets cleaned up. This causes the error we see in the backend because each iteration queries the table like this:

select * from amasty_feed_valid_products where feed_id=75 limit 2000,500

If the result is empty, because the indexer is just in progress of updating the table, the error will be thrown.

However, the Amasty Feed module supports a lock for the indexer. But that doesn't seem to be effective as the AJAX request will release the lock and the small time between the response and then new request from the browser seem to be enough to cause an error.

The cronjob shouldn't be effected by that. But the locking provider in env.php is maybe not effective. Maybe try to use database as locking provider:

  array (
    'provider' => 'db',
    'config' =>
    array (
      'prefix' => null
    ),
  ),```