Samsbc12 Posted March 17, 2006 Posted March 17, 2006 We have listed over 1000 products in our store but now we want to add taxes in taxe zones, is there way to set all items into a tax class at onces as oppssed to each item at a time? I don't care if i have to add a script of modify code anything that is faster Thanks In advance
Guest Posted March 17, 2006 Posted March 17, 2006 If your talking about adding tax for sales in your state, just set up the taxes in admin, Ralph
Samsbc12 Posted March 17, 2006 Author Posted March 17, 2006 If your talking about adding tax for sales in your state, just set up the taxes in admin, Ralph no no what i mean is that the taxes have been added in the admin control panel, but not applied to the items yet and since we have over 1000 items i was wonder if there is a way to set it to all of them as opposed to going back and editing item at a time
mtechama Posted March 17, 2006 Posted March 17, 2006 no no what i mean is that the taxes have been added in the admin control panel, but not applied to the items yet and since we have over 1000 items i was wonder if there is a way to set it to all of them as opposed to going back and editing item at a time go and edit where you add your products and go down to where your add your price and go to where it say "Tax Class" and change it from: --None-- to Taxable Goods. that will do it Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP!
Guest Posted March 17, 2006 Posted March 17, 2006 or, to do all of them in one hit, log into your sql control panel, and run the following statement: UPDATE products SET `products_tax_class_id` = 1 WHERE `products_id` = `products_id` obviously, you may need to change 1 depending on which tax_class_id you are using.
Samsbc12 Posted March 17, 2006 Author Posted March 17, 2006 or, to do all of them in one hit, log into your sql control panel, and run the following statement:UPDATE products SET `products_tax_class_id` = 1 WHERE `products_id` = `products_id` obviously, you may need to change 1 depending on which tax_class_id you are using. Thank you tony thats exactly what I was looking for
bjkralik Posted March 18, 2006 Posted March 18, 2006 or, to do all of them in one hit, log into your sql control panel, and run the following statement:UPDATE products SET `products_tax_class_id` = 1 WHERE `products_id` = `products_id` obviously, you may need to change 1 depending on which tax_class_id you are using. Hi, Can you explain this in more depth? Sorry... I'm in my SQL Database and I see where to input the info above, but what do you mean "change 1 depending on which tax_class_id you using"???? I just charge tax to buyers in California. I have a "Tax Zone" folder named California and a "Tax Class" named Sales Tax. Everything works fine and it just charges tax to California residents... but now I need to update all my products (over 3000) so that they are affected. Sounds simple according to your instructions above... I'm just wondering what my line would look like??? instead of running this: UPDATE products SET `products_tax_class_id` = 1 WHERE `products_id` = `products_id` would mine look like this?? UPDATE products SET `California` = 1 WHERE `products_id` = `products_id` Sorry im confused <_<
Guest Posted March 18, 2006 Posted March 18, 2006 when you are in your admin panel tweaking the tax class for california, have a look int he url, there will be an id= somewhere int here - this is the id you need. Probably the easiest way is just to run the sql command i put above, then see if it works, if it doesn't, run the same command again with 2 and so on until it does if my explanation about the id above doesnt help! Good luck!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.