Is There A Way To Bulk Delete All Combinations Via Webservice?

[peorthyr]

as the title says, is there a way (i maean a resource and a command to send) to bulk delete all combinations for all the (ora a single) products?

 

i mean, i use webservice to update the quantities and product combinations, but if a particular color (part of combination) is no more present, that color isn't passed to me, so i have to check all the combinations i have for a product, to know if one of them isn't present in my database.

 

 

a faster way could be to delete all combinations and repopulate all the products, so if something is gone, simply is not reinserted.

 

i bet i'll not receive a single answer... but you know, i'm optimistic hope to convert this desolation called forum into a well... a forum (?)

[peorthyr]

as always, here the solution, i found by myself:

 

$sql_del_2 = "TRUNCATE TABLE ps_product_attribute";

$sql_del_3 = "TRUNCATE TABLE ps_product_attribute_combination";

mysql_query($sql_del_2);

mysql_query($sql_del_3);

 

here you are

[Microame]

Hi Peorthyr,

 

Could you please explain bit more about how to set up this trigger.

 

Regards