SQL · API · IMPORTS · AUTOMATION

PrestaShop. Simplified.

Explore Hacks

PHP

// products won't sync themselves
$webService = new PrestaShopWebservice(
    $shopUrl,
    $apiKey,
    false
);

$xml = $webService->get([
    'resource' => 'products',
    'display' => 'full'
]);

SQL

// active products with current stock

JOIN ps_stock_available sa

ON sa.id_product = p.id_product

WHERE p.active = 1;

Intermediate 08 Aug 2026 PrestaHacks 7 min read

PrestaShop SQL Manager: 15 useful queries worth saving

Not every catalogue check in PrestaShop needs an export, a module or a custom script. For many day-to-day jobs, a well-targeted SELECT is enough to…

SQL Manager PrestaShop SQL

Read Article

HTTP

GET /api/products/42
    ↓
CHANGE ONLY KNOWN DATA
    ↓
PUT /api/products/42
    ↓
GET + VERIFY

Intermediate 10 Aug 2026

PrestaShop Webservice: a safer workflow for product updates

Reading product data is the easy part. Writing it back safely is where an integration…

Read Article

JOIN ps_stock_available sa

ON sa.id_product = p.id_product

WHERE p.active = 1;

Intermediate 09 Aug 2026

PrestaShop SQL: the joins you need for useful catalogue reports

Most useful PrestaShop reports are not stored in one table. The challenge is not writing…

Read Article

WORKFLOW

SUPPLIER FEED
    ↓
RAW
    ↓
NORMALIZE
    ↓
MAP
    ↓
VALIDATE
    ↓
PRESTASHOP READY

Intermediate 08 Aug 2026

Supplier Feed → Google Sheets → PrestaShop: build a reusable transformation pipeline

A supplier feed is not a PrestaShop import file. It is source data. Your job…

Read Article

HTTP

GET /api/products
?display=[id,reference,price]
&output_format=JSON

200 OK
{
  "id": 42,
  "reference": "ABC-001"
}

Beginner 07 Aug 2026

PrestaShop Webservice API: your first real request

Want an external application to read products from PrestaShop without giving it database credentials? The…

Read Article

JOIN ps_stock_available sa

ON sa.id_product = p.id_product

WHERE p.active = 1;

Intermediate 06 Aug 2026

Products, Combinations and Stock in PrestaShop: how they really connect

The request sounds simple: “Give me every product with SKU and stock.” Then you open…

Read Article

CSV

reference,name,price,quantity
SKU-001,Basic Tee,19.90,12
SKU-002,Cargo Short,29.90,7

CSV → NORMALIZE
    → VALIDATE
    → MAP
    → IMPORT

Beginner → Intermediate 05 Aug 2026

PrestaShop CSV Product Import: build the right file before you click Import

The difficult part of a product import is usually not the Import button. It is…

Read Article

HTTP

GET /api/products
?display=[id,reference,name]
&filter[active]=[1]
&sort=[id_DESC]
&limit=0,50

# next page
&limit=50,50

Intermediate 04 Aug 2026

PrestaShop Webservice: filters, sorting and pagination without downloading the whole catalogue

/api/products works. The next mistake is asking for the whole catalogue with every field on…

Read Article

JAVASCRIPT

const url = shopUrl +
  '/api/products';

const res = UrlFetchApp.fetch(url, {
  headers: {
    Authorization: 'Basic ' + token
  }
});

Intermediate 03 Aug 2026

PrestaShop → Google Sheets: product export with Webservice and Apps Script

A Google Sheet can be much more than a manual export. With PrestaShop Webservice and…

Read Article

DATA MAP

SOURCE
Men > Tops > Casual Shirts
        ↓
NORMALIZE
        ↓
MAP
        ↓
id_category = 42

Beginner → Intermediate 01 Aug 2026

Category Mapping for PrestaShop imports: stop trusting supplier category names

Your supplier writes Men > Tops > Casual Shirts. Your shop has MEN > SHIRTS.…

Read Article

HTTP

POST /api/images/products/42

Content-Type:
multipart/form-data

image=@product-main.jpg

VERIFY → REORDER → CLEANUP

Intermediate 31 Jul 2026

PrestaShop Product Images: audit, URLs and an import workflow without broken images

You have 4,000 products and a column called image_url. That does not mean you have…

Read Article

PrestaShop. Simplified.

PrestaShop SQL Manager: 15 useful queries worth saving

PrestaShop Webservice: a safer workflow for product updates

PrestaShop SQL: the joins you need for useful catalogue reports

Supplier Feed → Google Sheets → PrestaShop: build a reusable transformation pipeline

PrestaShop Webservice API: your first real request

Products, Combinations and Stock in PrestaShop: how they really connect

PrestaShop CSV Product Import: build the right file before you click Import

PrestaShop Webservice: filters, sorting and pagination without downloading the whole catalogue

PrestaShop → Google Sheets: product export with Webservice and Apps Script

Specific Prices in PrestaShop: why the price field is not always the final price

Category Mapping for PrestaShop imports: stop trusting supplier category names

PrestaShop Product Images: audit, URLs and an import workflow without broken images

Get practical PrestaShop hacks in your inbox.