magento reindexing just the prices tried every solution

magento reindexing just the prices tried every solution

October 10, 2026 · Illustrated author avatarBy Stefan Bogdanescu
magento reindexing just the prices tried every solution

Magento Reindexing: Solving the Product Prices Issue

If you’re facing reindexing errors for product prices in your Magento store, you’ve probably tried various solutions to no avail. The error message typically mentions an “unknown error” or a mismatch between column counts and value lists.

Understanding the Error Message

The provided error log indicates a PDOException with message: “SQLSTATE[21S01]: Insert value list does not match column list”. This usually occurs when there’s a discrepancy between the number of columns in your query and the values you’re trying to insert.

Here are some common causes for this issue:

  1. Missing or extra fields: Check if all required fields are present in your data and ensure they match the table structure exactly.
  2. Extra commas: Sometimes, extra commas can cause a mismatch between column counts.
  3. Extension conflicts: Third-party extensions may modify the table structure or query logic, leading to this error.

Step-by-Step Solution

1. Identify the Root Cause

The error log points to an issue in app/code/local/Innoexts/StorePricing/Model/Mysql4/Downloadable/Indexer/Price.php. This suggests that a custom extension (Innoexts Store Pricing) is causing the problem.

2. Disable the Problematic Extension

To isolate the issue, disable the Innoexts Store Pricing extension temporarily:

  • Log in to your Magento admin panel.
  • Navigate to “System” > “Configuration”.
  • Under “Advanced”, click on “Advanced”.
  • Scroll down and find “Disable Modules Output”.
  • Add Innoexts_StorePricing to this list.
  • Save the configuration.

3. Manually Reindex the Price Index

After disabling the extension, try reindexing just the product prices manually:

  1. Log in to your Magento admin panel.
  2. Navigate to “System” > “Index Management”.
  3. Find “Product Prices” in the list and click “Reindex”.

4. Check for Table Structure Issues

If the manual reindex fails, check if there are any issues with the table structure:

  1. Log in to your MySQL database using a client like phpMyAdmin or MySQL Workbench.
  2. Locate the catalog_product_index_price table (or similar).
  3. Ensure that all columns match the expected names and data types.

5. Cleanup and Reindex

If everything looks fine with the table structure, proceed with the following cleanup steps:

  1. Delete the contents of var/cache/.
  2. Delete the contents of var/log/.
  3. Delete or rename the var/report/ folder.
  4. Run the Magento database repair tool: php bin/magento setup:db-data:upgrade.

After completing these steps, try reindexing all indexes using the following command in your terminal:

php bin/magento indexer:reindex

When to Seek Professional Help

If you’ve followed these steps carefully and are still facing issues, it’s a good idea to consult with a Magento developer or support team. They can provide more advanced troubleshooting techniques and review your extensions for any conflicts.

Remember, Magento is complex software, and sometimes the solution requires a deep understanding of its architecture and indexing processes.

Conclusion

Reindexing errors are common in Magento, especially when dealing with third-party extensions that modify core functionality. By disabling problematic extensions, manually reindexing, and checking table structures, you can often resolve these issues.

However, if you find yourself constantly struggling with reindexing problems, consider reaching out to a professional Magento support service like Laravel Company. Their team of experienced developers can help diagnose and fix complex technical issues, ensuring your store runs smoothly.

Catalog Indexing Database Extensions

Our network