Contenu
...
Comprendre les paramètres avancés
...
Voici un exemple de fichier prêt à l'import, ici pour une liste de produits :
Code Block |
---|
|
"Enabled";"Name";"Categories";"Price";"Tax rule ID";"Buying price";"On sale";"Reference";"Weight";"Quantity";"Short desc.";"Long desc";"Images URL"
1;"Test";"1,2,3";130;1;75;0;"PROD-TEST";"0.500";10;"'Tis a short desc.";"This is a long description.";"http://www.myprestashop/images/product1.gif"
0;"Test 02";"1,5";110;1;65;0;"PROD-TEST2";"0.500";10;"'Tis also a short desc.";"This is a long description too.";"http://www.myprestashop/images/product2.gif"
1;"Test 03";"4,5";150;1;85;0;"PROD-TEST3";"0.500";10;"'Tis a short desc. again";"This is also a long description.";"http://www.myprestashop/images/product3.gif"
|
...
Lister les adresses e-mail de tous les clients.
Code Block |
---|
SELECT email FROM ps_customer
|
...
Lister tous les produits activés et ayant une description en français
Code Block |
---|
SELECT p.id_product, pl.name, pl.link_rewrite, pl.description
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
WHERE p.active = 1
AND pl.id_lang = 4
|
Lister toutes les commandes, en donnant le transporteur, la devise, le paiement, le prix total et la date
Code Block |
---|
SELECT o.`id_order` AS `id`,
CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Customer`,
ca.`name` AS `Carrier`,
cu.`name` AS `Currency`,
o.`payment`, CONCAT(o.`total_paid_real`, ' ', cu.`sign`) AS `Total`,
o.`date_add` AS `Date`
FROM `ps_orders` o
LEFT JOIN `ps_customer` c ON (o.`id_customer` = c.`id_customer`)
LEFT JOIN `ps_carrier` ca ON (o.id_carrier = ca.id_carrier)
LEFT JOIN `ps_currency` cu ON (o.`id_currency` = cu.`id_currency`)
|
...