Generating a feed returns an error "Something went wrong: SQLSTATE[42S02]: Base table or view not found: 1146 Table '****inventory_stock_1' does not exist". How to fix this issue?

Generating a feed returns an error "Something went wrong: SQLSTATE[42S02]: Base table or view not found: 1146 Table '****inventory_stock_1' does not exist". How to fix this issue?

      This error occurs when the inventory module is enabled, yet the inventory is not used. The issue can be resolved by adjusting the InventoryResolver.php file that is located either in the app/code/Amasty/Feed/Model/ or vendor/amasty/feed/Model/ directory.

      Please open the file and find the following line: return $this->moduleManager->isEnabled(self::MAGENTO_INVENTORY_MODULE_NAMESPACE);

      In that line, add "false; //" after return

      Should you require any assistance with adjusting the file, please do contact our Support Team.

• Related Articles

• Generating a feed returns an error: "Something went wrong: Couldn't lock indexer. Reindex in progress". How to fix?

        This message indicates that during the generation of the feed, its indexers are currently in progress, in the processing status:       Please check the feed grid and the status of the feeds in the Generated column:       If the status is ...

• Generating a feed returns an error "There are no products to generate the feed". How to fix this issue?

        This is one of the common errors, yet the troubleshooting process is quite simple. ​       First of all, double-check the settings in the General and Conditions tabs in order to make sure that those configurations are valid and do not ...

• Can I output products based on the source or stock in the feed?

        Product Feed extension, by default, supports product output based on the store view only, meaning that it is not possible to select a particular stock or source.       Nevertheless, it is possible to exclude products with "Out of Stock" status ...

• Test connection fails with an error. What might be the issue?

        This error message appears as a result of an unsuccessful test connection.       First thing is to double-check the credentials from the FTP settings tab - there's a chance that one of these values was entered with a typo, either the password ...

• Feed is empty after download - how to fix that?

        If the feed was created via the custom feed template in .xml, .txt, or .csv formats, it is required to manually add some product attributes to it because initially, the custom template does not contain any attributes.       1. Navigate to the ...

• Announcements

• Already done in Q3'22

  Extensions updates Advanced Reports now, when a website works with multi currencies while filtering reports by the store views, the data in the report is converted to the site base currency; now, the Product Performance report displays up-to-date customer

• What to expect in Q3'22

  New features and improvements Improved Layered Navigation integration with Live Search. Elastic Search improved Relevance Rules functionality. Product Feed an option to add configurable options to product URL; possibility to use Quantity attribute as

• Already Done in Q2'22

  Brand-new extensions Google Page Speed Optimizer Powered by SpeedSize™ is a synergy of Amasty Google Page Speed Optimizer and SpeedSize, which will help you greatly increase the site performance due to code structure compression and neuroscience media

• What to expect in Q2'22

  Amasty always strives to deliver new functionality in accordance with the most popular customers’ requests and e-commerce trends. In this article, we'll share our plans on new extensions, improvements, fixes, and other releases the team intends to be

• March'22 results

  New Solutions In March, the team presented two new suites that combine features of top Amasty extensions and are attractive price-wise: Must-Haves Suite. Don't know how to grow your business or what to start with? Get our must-have set of features for