Page 2 of 6 FirstFirst 1234 ... LastLast
Results 11 to 20 of 53
  1. #11
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    3,717
    Plugin Contributions
    60

    Default Re: Global price change?

    I use quick updates (http://www.zen-cart.com/index.php?ma...roducts_id=101) to accomplish this... Nice thing for you is the added ability to change by percentage (like to cover currency fluctuations) for all products or just selected products.

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  2. #12
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: Global price change?

    I want to increase my prices by $1.50 for my whole cart. How would I do that. Thank you.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

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

    Default Re: Global price change?

    Backup your database ...

    In the Tools ... Install SQL Patches ... run the command:
    Code:
    UPDATE products SET products_price= products_price +1.50;
    Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...
    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. #14
    Join Date
    Aug 2009
    Posts
    59
    Plugin Contributions
    0

    Default Re: Global price change?

    Quote Originally Posted by Ajeh View Post
    Backup your database ...

    In the Tools ... Install SQL Patches ... run the command:
    Code:
    UPDATE products SET products_price= products_price +1.50;
    Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...
    I want to decrease my prices globally by 10% how would I do that?

    John

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

    Default Re: Global price change?

    Backup your database and then you can use:
    Code:
    UPDATE products SET products_price= products_price * .90;
    You should then run in the Tools ... Store Manager ... the Update Products Price Sorter ...
    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!

  6. #16
    Join Date
    Jul 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: Global price change?

    i have some different products of mark (casio,seiko,citizen)
    How can I change the price all casio items?

    thanks all answers.

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

    Default Re: Global price change?

    Are you trying to change all the prices for a specific manufacturers_id to be the same price everywhere?
    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!

  8. #18
    Join Date
    Oct 2008
    Posts
    141
    Plugin Contributions
    0

    Default Re: Global price change?

    I'm having a similar nightmare and came across this thread looking for a solution. On the wood building website in my sig almost every price is the result of size attributes, so from what I've read here a global price change isn't going to work for me. On top of that, not every product needs a price rise - there are two categories where I don't want to add 5% to every item.
    At the moment I think the only option is to go and change every price manually, which with some products having a dozen or more size options is going to take me a couple of days to input . Surely there must be a better way than that?
    The instructions say Insert Disk 3, but only two will fit...
    www.shedtraders.co.uk
    www.tobermorychocolate.co.uk

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

    Default Re: Global price change?

    In your case, because the products are Priced by Attributes it would be easier to write a script to manage this where you can say what Category you want updated and only update the Products in that Category that use the Attribute that you want to update the price on ...

    Once written, you can then use that code anytime you need it ...
    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!

  10. #20
    Join Date
    Oct 2008
    Posts
    141
    Plugin Contributions
    0

    Default Re: Global price change?

    Ouch..
    Can you give me just a basic example for a pointer on that?
    The instructions say Insert Disk 3, but only two will fit...
    www.shedtraders.co.uk
    www.tobermorychocolate.co.uk

 

 
Page 2 of 6 FirstFirst 1234 ... 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