Total Products Sold Counter: setup and help

Follow the steps in Quick start.

Open Modules > Module Manager > Total Products Sold Counter > Configure. You reach Settings, with the Total Products Sold Settings form.

Click Save. For example, choose a minimum of 25 and {count} customers bought this to show the badge once at least 25 distinct customers have ordered this product in valid orders from the current shop.

The module counts sales of the current product across all combinations, including only orders marked as valid by PrestaShop in the current shop.

Display format selects the calculation: {count} sold sums ordered units, {count} orders counts distinct orders containing the product, and {count} customers bought this counts distinct customers who ordered it. The minimum applies to the selected count.

The count covers all dates and is limited to the current shop, including in a shared multistore database. The module does not subtract refunded quantities separately or offer a legacy-sales offset. Only orders marked as valid by PrestaShop are included, with no selectable order statuses.

For {count} sold, you can inspect the query below using your actual database prefix, product ID and current shop ID. For the order or customer formats, replace SUM(od.product_quantity) with COUNT(DISTINCT o.id_order) or COUNT(DISTINCT o.id_customer), respectively:

SELECT SUM(od.product_quantity)
FROM ps_order_detail od
INNER JOIN ps_orders o ON o.id_order = od.id_order
WHERE od.product_id = 123
  AND o.id_shop = 1
  AND o.valid = 1;

The module calculates the value when the hook is rendered. It has no module-level cache for this count.

Your theme must call displayProductAdditionalInfo on PrestaShop 1.7 or later, or displayProductButtons on PrestaShop 1.6, with the product data. The module returns no output if it is disabled, the product ID is missing, or the selected count is below your threshold. It does not add badges to category thumbnails.

The output is a green .mprsold-badge with a check icon and the escaped text. Its exact position depends on your theme's hook placement.

You can customize it in your theme stylesheet:

.mprsold-badge {
    background: #f0f7f0;
    color: #2e7d32;
    border-radius: 20px;
    font-size: 13px;
    font-weight: 600;
}
.mprsold-badge svg {
    width: 16px;
    height: 16px;
}

For a template change, use the theme override location:

themes/your-theme/modules/mprtotalproductssold/views/templates/hook/sold.tpl

The module assigns mprsold_text. Render it with:

{$mprsold_text|escape:'htmlall':'UTF-8'}

1. Choose a product with a known count for the selected format in valid orders from the current shop.
2. Confirm the expected total with your order data or the query above.
3. Set Minimum sales to display at or below the total and save.
4. Open that product page and confirm the text.
5. Raise the threshold above the total and confirm the badge disappears.

If the badge is missing, check Enable, the threshold, the order valid flags, and your theme's displayProductAdditionalInfo hook (PrestaShop 1.7 or later) or displayProductButtons hook (PrestaShop 1.6). Check the configuration page's installation integrity banner for missing infrastructure. Do not expect an individual combination count or a category-listing badge.

Set Enable to No and save to hide the counter while keeping settings. Uninstall through Module Manager to remove the module menu and its configuration entries. Your order history is read by this feature; the uninstall method does not delete your orders.

Requires PrestaShop 1.6 or later and PHP 7.1 or later.