Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default global parts increase/decrease?

    Hi All,

    So im assuming

    UPDATE `zen_products` SET `products_price`=`products_price`+7.50 adds £/$7.50 to all my product range and

    UPDATE products SET products_price = products_price * 1.25;

    does 25% accross the range

    so heres the question, can i do a global decrease as in

    UPDATE products SET products_price = products_price -* 1.25;

    and

    UPDATE `zen_products` SET `products_price`=`products_price`-7.50
    ##############################___

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

    Default Re: global parts increase/decrease?

    The SYNTAX of your SQL queries is correct...

    You need to get the maths correct, though.

    UPDATE `zen_products` SET `products_price`=`products_price`+7.50
    adds £/$7.50 to all my product range and

    UPDATE products SET products_price = products_price * 1.25;
    does 25% accross the range
    These are OK

    But...
    UPDATE products SET products_price = products_price -* 1.25;
    is not correct mathematically.

    To REDUCE a price by 25%...

    Consider a price of $100.

    You want to take off 25% ($25)

    Therefore you want 75% to remain. ($75)

    100.00 *0.75 = 75.00 ($75.00 remains)

    UPDATE `zen_products` SET `products_price`=`products_price`-7.50
    Is mathmatically correct if you want a fixed value to be removed.

    100.00 - 7.50 = 92.50
    We host with Terranetwork.

  3. #3
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: global parts increase/decrease?

    Hi Again,

    Just put the correct formula in now and it worked fine , thanks for the advice and helping me know a little more about the admin side of things.

  4. #4
    Join Date
    Aug 2005
    Posts
    327
    Plugin Contributions
    0

    Default Re: global parts increase/decrease?

    Please advise if in Version 1.5.1 there is a function in Admin to modify price for ALL Products?

    Or technique in this thread is still the best way to do it?

    Thank you.

 

 

Similar Threads

  1. Price Increase/Decrease by Percentage [Support Thread]
    By badarac in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 4 Apr 2016, 03:23 PM
  2. Price increase decrease (+/-) option not working well
    By omerhanif in forum General Questions
    Replies: 2
    Last Post: 22 Jan 2010, 03:10 PM
  3. How to decrease/increase ALL prices
    By Vadfloyd in forum General Questions
    Replies: 2
    Last Post: 28 Jan 2008, 05:29 AM
  4. Increase/Decrease QTY from categories.php Page
    By jakedownhere in forum Customization from the Admin
    Replies: 5
    Last Post: 9 May 2007, 12:44 PM
  5. Daily Storewide Price Increase/Decrease
    By irischant in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 26 Jul 2006, 12:29 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR