Page 5 of 6 FirstFirst ... 3456 LastLast
Results 41 to 50 of 53
  1. #41
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,471
    Plugin Contributions
    6

    Default Re: Global price change?

    Backup your database and you can use:
    Code:
    UPDATE products SET products_price = 46.00 WHERE products_price= 45.00;
    This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  2. #42
    Join Date
    Mar 2010
    Posts
    4
    Plugin Contributions
    0

    Default Re: Global price change?

    I tried using it but it didn't change any prices. Here's the text I got for one of my result

    Query Results:
    UPDATE zen_products SET products_price = 28.98 WHERE products_price= 28.00;

  3. #43
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,471
    Plugin Contributions
    6

    Default Re: Global price change?

    In phpMyAdmin run the command:
    SELECT * from zen_products WHERE products_price= 28.00;

    How many come up?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #44
    Join Date
    Mar 2010
    Posts
    4
    Plugin Contributions
    0

    Default Re: Global price change?

    0

    However I did discover the problem. I'm from Australia so I'm used to working on prices after tax has been included. So the reason it didn't work is that I was working of the final price...not the pre-taxed price.

    Once I readjusted back to the pre tax price they all changed. Thankyou for your help.

  5. #45
    Join Date
    Oct 2008
    Posts
    141
    Plugin Contributions
    0

    Default Re: Global price change?

    Quote Originally Posted by Ajeh View Post
    Backup your database and you can use:
    Code:
    UPDATE products SET products_price = 46.00 WHERE products_price= 45.00;
    This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...
    This is SO close to what I need, but not quite there
    I need: update product set price 1.99 where price 1.95 by attribute - all products that are priced by attribute have the same price (1.95) for attribute A, or (3.85) for attribute B. I want to add 4p to each of the cheaper ones.
    The instructions say Insert Disk 3, but only two will fit...
    www.shedtraders.co.uk
    www.tobermorychocolate.co.uk

  6. #46
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,471
    Plugin Contributions
    6

    Default Re: Global price change?

    If all of these are based on Priced by Attribute, then the Price is in the Attributes table:
    products_attributes

    Browse the products_attributes table and see if what you are wanting is to change the options_values_price to 1.99 where it is currently set to 1.95 ...

    If so, you want to backup your database and you can then use:
    Code:
    UPDATE products_attributes SET options_values_price = 1.99 WHERE options_values_price = 1.95;
    And, when done, you would want to go to the Tools ... Store Manager and run the:
    Update ALL Products Price Sorter
    to be able to sort by displayed prices:
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #47
    Join Date
    Oct 2008
    Posts
    141
    Plugin Contributions
    0

    Default Re: Global price change?

    That was exactly it! Many thanks, saved a laborious manual update of dozens of items
    The instructions say Insert Disk 3, but only two will fit...
    www.shedtraders.co.uk
    www.tobermorychocolate.co.uk

  8. #48
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,471
    Plugin Contributions
    6

    Default Re: Global price change?

    Thanks for the update that this worked for you ... remember us when you are rich and famous ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #49
    Join Date
    Feb 2010
    Posts
    28
    Plugin Contributions
    0

    Default Re: Global price change?

    i used
    PHP Code:
    UPDATE products SET products_price products_price 1.11 
    to update all items in my shop buy 11% , seems to work :)

  10. #50
    Join Date
    Jun 2011
    Location
    Isle of Wight
    Posts
    19
    Plugin Contributions
    0

    Default Re: Global price change?



    Hi

    After reading posts this seems to b right place for this..

    OK I need to change prices from trade price which are uploaded via easy populate but the price structure (increase) needs to be for example ..0.00-10.00 100% 11.00-50.00 40 % 51.00-100.00 35% etc ..... Please point me in right direction lol for an sql patch ? or exel/open office calc formula

    I will continue to read open office help files while i wait lol

 

 
Page 5 of 6 FirstFirst ... 3456 LastLast

Similar Threads

  1. v151 Distributor Global Price Change
    By tmpinsnty in forum General Questions
    Replies: 1
    Last Post: 22 Jul 2016, 02:25 PM
  2. Global price change
    By Vintage in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 3
    Last Post: 1 Feb 2010, 06:37 PM
  3. Prifix Price - Global change???
    By Video Steve in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 1 Oct 2007, 04:40 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