Die hier aufgeführten Infos werden automatisch in die Emailvorlagen geschaltet, die ab Lagerstand X versandt werden.

Folgende Codes sind per SQL-Eingabe ausführbar:

-- Ersetzungsmuster
SET pd.products_name =  REPLACE (spalte, was, wodurch)

-- Zuordnung der manufacturer_ID nach  Kategorie
UPDATE products p
LEFT JOIN products_to_categories ptc ON ptc.products_id = p.products_id
Left JOIN categories c on ptc.categories_id = c.categories_id
LEFT JOIN categories_description cd ON cd.categories_id =  c.categories_id
LEFT JOIN products_slider_set pss ON pss.products_slider_set_id =  p.products_id
LEFT JOIN slider_set ss ON ss.slider_set_id =  pss.slider_set_id
LEFT JOIN shipping_status sh on sh.shipping_status_id =  p.products_shippingtime
LEFT JOIN products_description pd on pd.products_id =  p.products_id
SET p.manufacturers_id = '3'
where cd.categories_name IN  ('NADH')
AND sh.language_id = $lid

-- nach Produktname
where pd.products_name like ('%Produktname%')
AND sh.language_id = $lid


-- von altem Hersteller zu neuem Hersteller
#hier neuen /neuen Namen eintragen
SET @manu_old = "GN Products";
SET @manu_new = "GNP Products";

SET @manu_old_id = (Select manufacturers_id from manufacturers where manufacturers_name = @manu_old);
SET @manu_new_id = (Select manufacturers_id from manufacturers where manufacturers_name = @manu_new);
UPDATE products p
LEFT JOIN manufacturers ma ON ma.manufacturers_id = p.manufacturers_id
SET p.manufacturers_id = @manu_new_id
WHERE p.manufacturers_id = @manu_old_id;