Blog: PrestaShop in practice
Guides on product data, Google Shopping feeds and keeping a PrestaShop catalog in shape – with ready-to-run SQL queries.
-
How to increase average order value in PrestaShop: discounted bundles and a free-shipping threshold
How to measure average order value in PrestaShop, where to set the free-shipping threshold, how to build a discounted bundle with a cart rule and how to measure the result. With ready-to-run SQL.
-
Q4 in PrestaShop: a checklist before Black Friday and Christmas
The 2026 season calendar, Omnibus-compliant prices, best-seller stock, order value and a shop freeze – with ready-to-run SQL queries.
-
A gift finder quiz for PrestaShop before the holidays: how to help shoppers who don’t know what to buy
Which questions to ask, how many products to show and where to place the quiz so it turns undecided holiday shoppers into buyers.
-
Google Shopping feed from PrestaShop: which products to exclude before a campaign
A pre-campaign checklist: what to keep out of the feed, what to fix first, and how to keep the feed clean.
-
How to find PrestaShop products with missing images, descriptions or EAN (SQL queries)
Ready-to-run SQL queries that list every kind of catalog gap – and an order for fixing them.
-
Google Merchant Center “Missing or incorrect GTIN”: how to find every PrestaShop product without a GTIN
Where PrestaShop keeps the barcode, one SQL query per type of gap, and when you can legitimately skip the GTIN.