AliExpress のレビューをPrestaShopストアにインポート

<?php
// Insert the 5-star reviews of an AliExpress product as PrestaShop product comments.
// Run it from the command line on your server, after backing up the database.
require_once __DIR__ . '/config/config.inc.php';

$idProduct = 42; // your PrestaShop product
$ch = curl_init('https://api.aliexpress-reviews.com/v1/reviews/1005006123456789?filter=5&pageSize=20');
curl_setopt_array($ch, [
    CURLOPT_HTTPHEADER => ['x-api-key: ' . getenv('REVIEWS_API_KEY')],
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_TIMEOUT => 30,
]);
$body = curl_exec($ch);
if (curl_getinfo($ch, CURLINFO_HTTP_CODE) !== 200) {
    exit("Request failed\n");
}
$reviews = json_decode($body, true)['data'];

foreach ($reviews as $r) {
    Db::getInstance()->insert('product_comment', [
        'id_product' => (int) $idProduct,
        'id_customer' => 0,
        'id_guest' => 0,
        'customer_name' => pSQL($r['author']),
        'title' => pSQL(mb_substr($r['content'], 0, 60)),
        'content' => pSQL($r['content']),
        'grade' => (int) $r['rating'],
        'validate' => 1,
        'deleted' => 0,
        'date_add' => pSQL($r['date'] . ' 12:00:00'),
    ]);
}