[Prestashop error] The price is not displayed in the list of products with combinations

In this article we will talk about a very important problem that we have had to solve in many Prestashop online stores of our customers. The error is that the price is not displayed or its value is zero (0o) in the product listing, and only on products that have combinations.

However, if the item card is accessed, the price is displayed correctly. Therefore it only happens in the product listing.

What are the causes of the problem?

Although because of the nature of the problem, we find no logic, because if the price on the product page is displayed correctly, how is it possible that in the product listing, that product does not show the price or is displayed with quantity 0?.

Its origin is in an error in the Prestashop MySQL Database. The tables affected and that cause this problem are the ps_product table and ps_product_shop and the column that is causing the problem is cache_default_attribute which is where the default attribute ID that each product that carries combinations is configured is stored. This column sometimes stores erroneous or non-existent data from the default attribute IDs in products with combinations, which is why the problem mentioned in this article is caused.

During store operation, the Database is constantly working by performing insert, delete, update, and display data operations. During these processes and over time, the Database may deteriorate causing this and other errors. For that reason, we always recommend periodic maintenance of the Database. Maintenance can be performed by hiring a professional company such as us, or by purchasing a module specialized in the repair, optimization and maintenance of the Database, in this case we recommend our Ultimate Database Optimizer module.

How to fix the error of showing zero price in the list of products with combinations


Hiring 1 hour of Technical Support with us. We will perform the work manually ensuring the results and resolution of the error.

Program that fixes the error

Installation and automatic execution of a small program (Script) developed by our technical team and that solves the error completely.

Do you want to periodically maintain the Database, repair it, optimize it and always keep it fully operational?

Prestashop Ultimate Database Optimizer Module

With this module you will be able to have a repaired database, optimized and completely clean of waste to increase performance the maximum and avoid errors.

Artículos relacionados