running SQL scrpt every day

[DKP1]

is there a way to run multiple copies of the same basic script but set to different categories every day so that it will update all the tax information for new products as they come in? this is a couple of copies of the script I want to run not all of them.

UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 26;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 103;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 92;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 162;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 159;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 132;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 9;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 200;
UPDATE products SET products_tax_class_id = 7 WHERE master_categories_id = 202;

[swguy]

Nothing is built in. You'd need to write your own script and run it using cron.

[DKP1]

Ok so if that won't really work will creating more that 1 general product type assigning the tax class I want as default and then assigning the products to the different categories or subcategories work?

[kobra]

Ok so if that won't really work

It will work - just write your script and run it as a "cron job" with your host

[swguy]

Another option: look at includes/init_includes/init_special_funcs.php to see how they do the specials updates.