Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Location
    Queenstown, New Zealand
    Posts
    386
    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
    9,956
    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)
    Our latest project is Pet Tags.

  3. #3
    Join Date
    Jan 2007
    Location
    Queenstown, New Zealand
    Posts
    386
    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
    9,956
    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...
    Our latest project is Pet Tags.

 

 

Similar Threads

  1. v138a Adding attribute gross price
    By Troll in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 13 Feb 2012, 05:03 PM
  2. Adding 2000+ Products in one time
    By sychurn in forum General Questions
    Replies: 1
    Last Post: 21 Aug 2009, 04:14 AM
  3. Replies: 0
    Last Post: 26 Jun 2008, 01:29 PM
  4. Net & gross price while adding a product
    By Veronika7747 in forum Basic Configuration
    Replies: 3
    Last Post: 13 Mar 2008, 05:12 AM

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
  •