Jump to content

Edit History

Casper_O

Casper_O


Variantenpreis und Varianteneinheitspreis in derselben Abfrage

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.19 / 1.16
WHERE
	ps_product.`id_tax_rules_group` = 1;

7% -> 5% 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.07 / 1.05
WHERE
	ps_product.`id_tax_rules_group` = 2;

SONDERPREISE (Grundpreis verändert) 

UPDATE `ps_specific_price`
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET `ps_specific_price`.`price`=`ps_specific_price`.`price`*1.19/1.16
WHERE `ps_specific_price`.`price` != -1
AND ps_product.`id_tax_rules_group` = 1;
UPDATE `ps_specific_price`
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET `ps_specific_price`.`price`=`ps_specific_price`.`price`*1.07/1.0.5
WHERE `ps_specific_price`.`price` != -1
AND ps_product.`id_tax_rules_group` = 2;

SONDERPREISE (Rabatt anwenden zzgl MwSt.) 

UPDATE
ps_specific_price
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET ps_specific_price.reduction = ps_specific_price.reduction*1.19 / 1.16
WHERE
ps_specific_price.reduction_type = "amount" AND
ps_specific_price.reduction_tax = 0 AND
ps_product.id_tax_rules_group = 1

UPDATE
ps_specific_price
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET ps_specific_price.reduction = ps_specific_price.reduction*1.07 / 1.05
WHERE
ps_specific_price.reduction_type = "amount" AND
ps_specific_price.reduction_tax = 0 AND
ps_product.id_tax_rules_group = 2
Casper_O

Casper_O


Variantenpreis und Varianteneinheitspreis in derselben Abfrage

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.19 / 1.16
WHERE
	ps_product.`id_tax_rules_group` = 1;

  

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.07 / 1.05
WHERE
	ps_product.`id_tax_rules_group` = 2;

SONDERPREISE (Grundpreis verändert) 

UPDATE `ps_specific_price`
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET `ps_specific_price`.`price`=`ps_specific_price`.`price`*1.19/1.16
WHERE `ps_specific_price`.`price` != -1
AND ps_product.`id_tax_rules_group` = 1;

SONDERPREISE (Rabatt anwenden zzgl MwSt.) 

UPDATE
ps_specific_price
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET ps_specific_price.reduction = ps_specific_price.reduction*1.19 / 1.16
WHERE
ps_specific_price.reduction_type = "amount" AND
ps_specific_price.reduction_tax = 0 AND
ps_product.id_tax_rules_group = 1

 

Casper_O

Casper_O


Variantenpreis und Varianteneinheitspreis in derselben Abfrage

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.19 / 1.16
WHERE
	ps_product.`id_tax_rules_group` = 1;

  

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.07 / 1.05
WHERE
	ps_product.`id_tax_rules_group` = 2;

SONDERPREISE (Grundpreis verändert) 

UPDATE `ps_specific_price`
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET `ps_specific_price`.`price`=`ps_specific_price`.`price`*1.19/1.16
WHERE `ps_specific_price`.`price` != -1
AND ps_product.`id_tax_rules_group` = 1;

 

Specific_prices

Casper_O

Casper_O


Variantenpreis und Varianteneinheitspreis in derselben Abfrage

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.19 / 1.16
WHERE
	ps_product.`id_tax_rules_group` = 1;

  

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.07 / 1.05
WHERE
	ps_product.`id_tax_rules_group` = 2;

SONDERPREISE (Grundpreis verändert) 

UPDATE `ps_specific_price`
LEFT JOIN ps_product ON ps_product.id_product = ps_specific_price.id_product
SET `ps_specific_price`.`price`=`ps_specific_price`.`price`*1.19/1.16
WHERE `ps_specific_price`.`price` != -1

 

Specific_prices

Casper_O

Casper_O


Variantenpreis und Varianteneinheitspreis in derselben Abfrage

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.19 / 1.16
WHERE
	ps_product.`id_tax_rules_group` = 1;

  

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05,
ps_product_attribute_shop.unit_price_impact = ps_product_attribute_shop.unit_price_impact * 1.07 / 1.05
WHERE
	ps_product.`id_tax_rules_group` = 2;

 

 

Casper_O

Casper_O

Eine kleine Hilfe für Sie alle für Produkte mit Variantenpreis, dass Sie Produkte korrekt aktualisieren können, je nachdem, ob es 19 oder 7 MwSt. Ist 

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.19 / 1.16
WHERE
    ps_product.`id_tax_rules_group` = 1;

  

UPDATE ps_product_attribute_shop
LEFT JOIN ps_product ON ps_product.id_product = ps_product_attribute_shop.id_product
SET ps_product_attribute_shop.price = ps_product_attribute_shop.price * 1.07 / 1.05
WHERE
    ps_product.`id_tax_rules_group` = 2;

 

 

×
×
  • Create New...