Globally Update Tax Percents

If you want to specify some items (or gift certificates, wholesale, etc.) as taxable and some as not taxable, you must use a tax type in Mals that pulls tax from the Buy Now Buttons. If you do this, the tax percents must be filled in for any item that is to be taxed.

To do this, you would need to go through every product and add a tax percent to the Tax % field. Any items without a tax percent will not have taxes applied in the cart, so it's very important to add a tax percent to all taxable items.

If you have a lot of items and want to quickly update the tax percent for all those items, you can globally update it via phpMyAdmin. To do this:

  1. Access phpMyAdmin in the web hosting control panel.

  2. Select the SQL tab

  3. Type:

    UPDATE opc_items SET TaxPercent='5';

    where '5' is the percent you want to add. (Change that value to use a different percent.)

Note that this will not add a tax percent to new items that are added later. The store administrator will need to always add a tax amount when adding a new item, or it will not be taxed. If you choose to set a default tax amount:

  1. Open the items.php page in the /storeadmin/ area

  2. Find the lines:

    if ($Submit == "Add")
    {
  3. Just under that bracket, add:

    $taxpercent = 5;

    to automatically add a 5% tax when a new product is created. (Change the 5 to the correct tax rate.)

  4. If the administrator wants to add a different tax percent, they can change that value by modifying the 'Tax %' field.

Please note: if the client uses a default item, that item's tax value will override the above setting.