Articles

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

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

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

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

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

CSV → NORMALIZE
    → VALIDATE
    → MAP
    → IMPORT

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

# next page
&limit=50,50

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

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

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

POST /api/images/products/42

Content-Type:
multipart/form-data

image=@product-main.jpg

VERIFY → REORDER → CLEANUP