Thread: 10% Off Prices

Results 1 to 10 of 11

Hybrid View

  1. #1
    Join Date
    Sep 2005
    Posts
    912
    Plugin Contributions
    1

    Default 10% Off Prices

    Is there an sql code i can run to make al lthe products price 10% lower

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: 10% Off Prices

    Is this to change the actual price or to offer 10% off all items?
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Sep 2005
    Posts
    912
    Plugin Contributions
    1

    Default Re: 10% Off Prices

    change the actual price

  4. #4
    Join Date
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: 10% Off Prices

    quick updates can do that for you (depends on the amount of products if it really will be a quick update though).

    But if I remember well you already use quick updates?

    edit: sorry that is not an answer to your question I realize now :-)

  5. #5
    Join Date
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: 10% Off Prices

    Like this:
    Code:
    UPDATE `products` SET `products_price` = `products_price` * 0.9;
    ?

    Backup first!

  6. #6
    Join Date
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: 10% Off Prices

    Forgot to tell: you need to update the sprice sorter too, after the above.

 

 

Similar Threads

  1. turn off prices, based on login
    By pageblair in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 9 Jun 2010, 05:10 PM
  2. Turn prices in 'new__products_box' off?
    By jensderknipser in forum Basic Configuration
    Replies: 15
    Last Post: 4 Nov 2009, 06:24 AM
  3. authorized/logged in to see prices wont turn off!
    By heimskr75 in forum Managing Customers and Orders
    Replies: 1
    Last Post: 31 Oct 2008, 10:06 PM

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