Everything you'd want to know before you install.
A detailed look at how Specific Price Cleaner for PrestaShop 1.7.8, 8 & 9 works, why we built it the way we did, and the thinking behind the features above.
Why the specific price table keeps growing
Every promotion, customer price, quote or import adds rows to the specific price table, and PrestaShop does not remove them when they expire or when the targeted product, customer or group disappears. Over time, the price list of a product becomes hard to read and nobody knows which rows still matter. The dashboard of the module shows the exact state of the table, sorted by type of problem, with the number of cleanable rows and the number of protected rows.
What the module never deletes by default
A price bound to a cart can belong to a quote or a negotiation in progress: it stays protected, and only the Finished carts category, with a delay in days, can remove it. A price generated by a catalog price rule is regenerated by PrestaShop: the module points to the rule instead of touching its prices. Upcoming prices, prices without an end date and prices another module still references are protected too. Priority conflicts, several active prices on the same target, are listed for manual review.
A six-step wizard
Choose the categories and filters, run the simulation, review the planned rows and exclude the ones to keep, create the backup, confirm, then read the report. The plan is frozen at the simulation: no row added in the meantime can be deleted, and a row changed since then is skipped. After the cleanup, the price caches are cleared and the faceted search price index is updated for the products concerned.
Schedule without losing control
The schedule calls a cron URL protected by a token. It starts in simulation mode: you receive the report by e-mail and decide. In cleanup mode, the same protections apply, a backup is made automatically and a cap limits the number of rows per run; the rest goes to the next run. A lock prevents two runs at the same time.
There are no reviews yet.