Issue for indexer for custom type product on updating and adding to cart

[magentodem347f]

Basically, I have created a custom product type named "rental" in the system. I created it successfully and visible in admin perfectly.

The screenshot link is attached. (https://webkul.chatwhizz.com/share/screenshot/64c8b7b87b4603072b5dd7f6)

And products are also successfully created under this product type. But whenever we update rental product types or add rental products to the cart. Then automatically run indexer on product change this is the default functionality of the Magento.

But the below issue is coming in the indexer for rental products. 

main.CRITICAL: PDOException: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 in /home/users/md.mubarik/www/html/m246/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:90

Stack trace:

#0 /home/users/md.mubarik/www/html/m246/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(90): PDOStatement->execute()

.......

Next Zend_Db_Statement_Exception: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price` SELECT `ip_tmp`.* FROM `catalog_product_index_price_temp` AS `ip_tmp` ON DUPLICATE KEY UPDATE `tax_class_id` = VALUES(`tax_class_id`), `price` = VALUES(`price`), `final_price` = VALUES(`final_price`), `min_price` = VALUES(`min_price`), `max_price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`) in /home/users/md.mubarik/www/html/m246/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109

Stack trace:

#0

.......

Kindly check and suggest a solution to this.

[magentodem347f]

Can anyone help me with this?

[zoyascootg16c3]

Indexing is a crucial process in Magento that helps improve the performance of data retrieval operations. It's used to create optimized tables (indexes) that store the relationships between products, categories, and other entities.

When you update certain aspects of your store, such as product attributes, categories, or prices, the associated indexes need to be updated to reflect those changes accurately.

Magento provides different indexing modes:

1. Update on Save
2. Update on Schedule

You can adjust these settings in the Magento admin panel:

Stores> Configuration> Advanced> System> Index Management

[magentodem347f]

Thank you for your reply.

But I am getting an error when saving the custom-type product (Rental Product) from the admin end.
I have attached a video link for your reference.

https://webkul.chatwhizz.com/share/view-recording/64d35a62f0172f7f8a0615d9

Kindly check it and help me to resolve this issue.

[samdobreva3178]

It seems like you're facing an issue related to indexing custom product types when they are updated or added to a cart. Indexing is an essential process in e-commerce platforms that helps optimize search functionality and improve the performance of product searches and filters. Let's break down some possible issues and solutions related to this problem:

1. **Indexing Process:** E-commerce platforms often use indexing to store and retrieve product information efficiently. When a product is updated or added to a cart, it needs to be reindexed to reflect the changes accurately in search results and filters.

2. **Real-Time vs. Batch Indexing:** Depending on the platform's architecture, indexing can be done in real-time or in batches. Real-time indexing updates the index immediately upon changes, while batch indexing updates the index periodically. Real-time indexing is more resource-intensive but offers more up-to-date results.

3. **Custom Product Types:** If you're dealing with custom product types that have unique attributes, the indexing process needs to handle these attributes properly. Make sure that the indexing mechanism is aware of the custom product types and their specific attributes.

4. **Cache and Invalid Indexes:** Sometimes, cached search results or outdated indexes can lead to discrepancies between what's shown to users and the actual product data. Clearing the cache and reindexing might resolve such issues.

5. **Data Integrity and Synchronization:** Ensure that the data being indexed is accurate and synchronized across the system. If there are inconsistencies between the actual product data and the indexed data, it can lead to search result discrepancies.

6. **Errors or Exceptions:** Monitor for any errors or exceptions that occur during the indexing process. These can provide insights into why indexing might be failing or not updating correctly.

7. **Scalability and Performance:** As your e-commerce platform grows, indexing processes can become more complex and resource-intensive. Make sure your indexing solution can scale to handle the increased data and usage.

8. **Platform-Specific Solutions:** Different e-commerce platforms have varying indexing mechanisms. Whether you're using a custom-built solution or a third-party platform like Magento, WooCommerce, Shopify, etc., consult the platform's documentation or support resources for specific troubleshooting steps.

9. **Testing:** Test the indexing process thoroughly with various scenarios, including adding, updating, and removing products. Use a staging environment to avoid affecting the live site during testing.

10. **Third-Party Plugins:** If you're using third-party plugins or extensions, ensure they are compatible with your custom product types and the indexing process.

If you're struggling to resolve the issue on your own, consider seeking help from developers experienced in e-commerce platforms. They can analyze your specific setup, codebase, and database structure to identify and fix the indexing issue.