Bonsoir,
il te faut quelque chose comme çà
<?php
require('../includes/application_top.php');
// Liste des fichiers à créer
$array_query = array();
// Requête Le Guide FR (articles autres que les bas : taille=1 / couleur=2)
$array_query['leguide_FR'] = array();
$array_query['leguide_FR'][] = '
SELECT
(SELECT mc.merchant_category FROM merchant_category mc, zen_products_description zpd
WHERE zpd.products_id=pd.products_id AND zpd.language_id=1 AND zpd.products_description LIKE CONCAT(mc.product_description, "%") GROUP BY zpd.products_id) AS merchant_category,
p.products_model AS offer_id,
pd.products_name AS name,
pd.products_description AS description,
p.products_price * 1.196 AS regular_price,
CONCAT("http://www.tonsite.com/index.php?main_page=product_info&products_id=", CAST(p.products_id AS CHAR) AS product_url,
CONCAT("http://www.tonsite/images/medium/", LEFT(p.products_image, LENGTH(p.products_image)-4), "_g.jpg") AS image_url,
"EUR" AS currency,
CASE
WHEN cadp.categories_name LIKE "DISCOUNT%" THEN p.products_price * 0.5 * 1.196
WHEN cadp.categories_name = "Soldes -70%" THEN p.products_price * 0.3 * 1.196
WHEN cadp.categories_name = "VENTE FLASH" THEN p.products_price * 0.5 * 1.196
ELSE ""
END AS discount_price,
CASE
WHEN cadp.categories_name LIKE "DISCOUNT%" THEN 1
WHEN cadp.categories_name = "Soldes -70%" THEN 1
WHEN cadp.categories_name = "VENTE FLASH" THEN 1
ELSE 0
END AS sales,
m.manufacturers_name AS manufacturer,
p.products_last_modified AS update_date,
GROUP_CONCAT(DISTINCT povt.products_options_values_name) AS `size`,
GROUP_CONCAT(DISTINCT povc.products_options_values_name) AS color,
0 AS sf,
m.manufacturers_name AS brand
FROM zen_products p
LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_categories ca ON (p.master_categories_id = ca.categories_id)
LEFT JOIN zen_categories_description cadp ON (ca.parent_id = cadp.categories_id)
LEFT JOIN zen_products_attributes pat ON (p.products_id = pat.products_id)
LEFT JOIN zen_products_options_values povt ON (pat.options_values_id = povt.products_options_values_id)
LEFT JOIN zen_products_attributes pac ON (p.products_id = pac.products_id)
LEFT JOIN zen_products_options_values povc ON (pac.options_values_id = povc.products_options_values_id)
WHERE p.products_status = 1
AND ca.categories_status = 1
AND pd.language_id = 1
AND pat.options_id = 1
AND povt.language_id = 1
AND pac.options_id = 2
AND povc.language_id = 1
AND cadp.language_id = 1
GROUP BY p.products_id
';
il faudra certainement que tu l'adaptes un peu car cette requête tiens compte des tailles des couleurs mais aussi des catégories pour afficher le prix avec remise s'il y a lieu, en l'occurrence ici pour le guide.com
exporter son catalogue