Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    390
    Plugin Contributions
    0

    Default Adding tax to 2000 products, but would like to make gross price the same as it is now

    Hi,
    I'm about to do a php change to make all my products include tax.
    However, we are absorbing the cost of tax (15%)
    So a $50 item will still cost $50 but include tax.

    How would I mass update all prices to reduce the net price by 15%? (so that the gross becomes the current $ at least)
    Thanks!

  2. #2
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,038
    Plugin Contributions
    3

    Default Re: Adding tax to 2000 products, but would like to make gross price the same as it is

    Are you looking to configure your store to ADD vat @ 15%, so the invoice (checkout confirmation) reflects the tax amount?

    If you want to REDUCE all prices by 15%, then you DIVIDE all your prices by 1.15

    $115 DIVIDED BY 1.15 = $100

    Using SQL via PHPMYADMIN, the following should work...

    BACKUP DBASE FIRST !

    UPDATE `zen_products` SET `products_price` = `products_price`/1.15;
    (This assumes the table HAS the zen_ prefix)

    UPDATE `products` SET `products_price` = `products_price`/1.15;
    (This assumes the table DOES NOT HAVE s the zen_ prefix)
    We host with Terranetwork.

  3. #3
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    390
    Plugin Contributions
    0

    Default Re: Adding tax to 2000 products, but would like to make gross price the same as it is

    Thanks for the reply Schoolboy...
    Yes, was needing to include our NZ tax into our current prices (not add on top)

    For anyone else needing to do this, I inserted:
    1) [FONT=Calibri]update products set products_price = products_price / 1.15, products_price_sorter = products_price_sorter / 1.15, products_last_modified = now();[/FONT]
    [FONT=Calibri]
    [/FONT]
    2)
    [FONT=Calibri]UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;[/FONT]

    At least it seems to have worked so far.
    Thanks again for always helping...

  4. #4
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,038
    Plugin Contributions
    3

    Default Re: Adding tax to 2000 products, but would like to make gross price the same as it is

    Yeah... that all looks clean emough...
    We host with Terranetwork.

 

 

Similar Threads

  1. HELP! Suddenly our sales tax has stopped working, all gross prices are now the same!
    By nathanscrivener in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 9 Nov 2010, 08:23 AM
  2. Tax Net and Tax Gross the same after upgarde
    By thevagr1 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 2 Aug 2010, 02:39 PM
  3. How would i make the products appear like this?
    By shah2k in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 24 Feb 2010, 04:21 PM
  4. Net and Gross price the same when entering product price
    By Craig Robbo in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 6 Feb 2009, 09:47 AM
  5. i would like to list products in the same category...
    By fabrikation in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 2 Nov 2006, 10:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR