Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Taxes


Samsbc12

Recommended Posts

Posted

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

Posted

If your talking about adding tax for sales in your state, just set up the taxes in admin, Ralph

Posted
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

Posted
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!

Posted

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.

Posted
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

Posted
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 <_<

Posted

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...