cum export produsele pentru okazii.ro sau compari.ro?

[manuel21]

SaLUTARE stie cineva cum export produsele din magazin prestashop in feed pentru okazii sau compari??? Va multumesc!

[gentiana]

nici eu nu am aflat inca...

[floreauwe]

Salut baieti ma ajutati si pe mine cu SQL interogation pentru prestashop 1.4?

 

Asta am nevoie:

 

Product name

Category

Reference

Price tax excl

Short description

Description

URL rewritten

Weight

 

Multumesc mult!

[zorro22]

Salutare, incercati cu SQL manager (interfata SQL) - urmatoarea comanda - si eu am luat-o ca atare si am folosit-o si in ea selectati campurile pe care le doriti - sper sa va fie de folos: - PS am folosit in varianta de PS1613

 

SELECT p.id_product,
 p.active,
 pl.name,
 GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories,
 p.price,
 p.id_tax_rules_group,
 p.wholesale_price,
 p.on_sale,
 IF(pr.reduction_type='amount',pr.reduction,' ') as discount_amount ,
 IF(pr.reduction_type='percentage',pr.reduction,' ') as discount_percent,
 pr.from ,
 pr.to,
 p.reference,
 p.supplier_reference,
 p.id_supplier,
 p.id_manufacturer,
 p.ean13,
 p.upc,
 p.ecotax,
 p.width,
 p.height,
 p.depth,
 p.weight,
 p.quantity,
 p.minimal_quantity,
 p.visibility,
 p.additional_shipping_cost,
 p.unity,
 p.unit_price_ratio,
 pl.description_short,
 pl.description,
 IF(t.name IS NOT NULL,
 GROUP_CONCAT(DISTINCT(t.name) SEPARATOR ","), '') as tags ,
 pl.meta_title,
 pl.meta_keywords,
 pl.meta_description,
 pl.link_rewrite,
 pl.available_now,
 pl.available_later,
 p.available_for_order,
 p.available_date,
 p.date_add,
 p.show_price,

 0 as 'Delete Images',
 ' ' as 'Feature',
 p.online_only,
 p.condition,
 p.customizable,
 p.uploadable_files,
 p.text_fields,
 p.out_of_stock,
 p.id_shop_default,
 p.advanced_stock_management
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category)
LEFT JOIN ps_category c ON (cp.id_category = c.id_category)
LEFT JOIN ps_specific_price pr ON (p.id_product = pr.id_product)
LEFT JOIN ps_image pi ON ( p.id_product = pi.id_product)
LEFT JOIN  ps_configuration conf ON conf.name = 'PS_SHOP_DOMAIN'
LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product)
LEFT JOIN ps_tag t ON ( pt.id_tag = t.id_tag )
WHERE pl.id_lang = 1
AND cl.id_lang = 1
AND t.id_lang = 1
AND p.id_shop_default = 1
GROUP BY p.id_product

Edited January 5, 2016 by zorro22 (see edit history)

[Rasq]

nici eu nu am aflat inca...

Din cate stiu pentru PS exista feed doar pentru produsele din prima pagina. Produse recomandate. Altfel poti face un fisier php care face un SELECT in baza de date cu print in browser. Si il poti aranja cum doresti.

[dan.dimofte]

Poate ii este folositor cuiva: http://addons.prestashop.com/en/22437-compariro-feed-produse.html