Thread: change prices

Results 1 to 10 of 10

Hybrid View

  1. #1
    Join Date
    Apr 2008
    Location
    London
    Posts
    596
    Plugin Contributions
    0

    Default change prices

    I'm surprised this one hasn't been asked before (or if it has i can't find it!)

    A client has a few hundred products and needs to change the prices.
    All prices are the same and need to be changed to another same amount.

    Manually changing is out of the question so ... what's the easiest/ quickest way of doing this?

    Open the DB file and search/ replace?
    Is there a mod?
    Is there something built in? - I looked at price manager but could only find single updates.

    TIA

  2. #2
    Join Date
    Apr 2006
    Location
    Texas
    Posts
    6,196
    Plugin Contributions
    0

    Default Re: change prices

    Quote Originally Posted by bigbadboy View Post
    I'm surprised this one hasn't been asked before (or if it has i can't find it!)

    A client has a few hundred products and needs to change the prices.
    All prices are the same and need to be changed to another same amount.

    Manually changing is out of the question so ... what's the easiest/ quickest way of doing this?

    Open the DB file and search/ replace?
    Is there a mod?
    Is there something built in? - I looked at price manager but could only find single updates.

    TIA
    Big,
    I do not use this from experience but do a little investigation on this and search for the thread before you attack

    http://www.zen-cart.com/index.php?ma...roducts_id=101

  3. #3
    Join Date
    Apr 2008
    Location
    London
    Posts
    596
    Plugin Contributions
    0

    Default Re: change prices

    Attack? Who/ What?
    As I said, I couldn't find anything - maybe it's the forum being lame at searching relevantly or maybe it's simply me not googling the right phrase - either way it wasn't an attack!

    jeesshh!

    (oh ... and thanks for the link!)

  4. #4
    Join Date
    Apr 2006
    Location
    Texas
    Posts
    6,196
    Plugin Contributions
    0

    Default Re: change prices

    Quote Originally Posted by bigbadboy View Post
    Attack? Who/ What?
    As I said, I couldn't find anything - maybe it's the forum being lame at searching relevantly or maybe it's simply me not googling the right phrase - either way it wasn't an attack!

    jeesshh!

    (oh ... and thanks for the link!)
    Big,
    Sorry, what I meant by attack, was not to download right away and proceed, I wanted you to read the thread on this download and find out if it does what you are asking for...

  5. #5
    Join Date
    Apr 2008
    Location
    London
    Posts
    596
    Plugin Contributions
    0

    Default Re: change prices

    Apologises then!


  6. #6
    Join Date
    Apr 2006
    Location
    Texas
    Posts
    6,196
    Plugin Contributions
    0

    Default Re: change prices

    Big,


    Sometimes, I type to fast and shorten my sentences...

    Check out thread #4

  7. #7
    Join Date
    Apr 2006
    Location
    Texas
    Posts
    6,196
    Plugin Contributions
    0

    Default Re: change prices

    Quote Originally Posted by bigbadboy View Post
    I'm surprised this one hasn't been asked before (or if it has i can't find it!)

    A client has a few hundred products and needs to change the prices.
    All prices are the same and need to be changed to another same amount.

    Manually changing is out of the question so ... what's the easiest/ quickest way of doing this?

    Open the DB file and search/ replace?
    Is there a mod?
    Is there something built in? - I looked at price manager but could only find single updates.

    TIA
    Big,
    Read this, but wait for advice or post another thread to ask the correct formula to operate this in your data base..

    http://www.zen-cart.com/forum/showthread.php?t=78136

  8. #8
    Join Date
    Nov 2006
    Location
    Dartmouth, NS Canada
    Posts
    2,378
    Plugin Contributions
    0

    Default Re: change prices

    Quote Originally Posted by bigbadboy View Post
    A client has a few hundred products and needs to change the prices.
    All prices are the same and need to be changed to another same amount.

    Manually changing is out of the question so ... what's the easiest/ quickest way of doing this?
    I'm not very comfortable with directly changing the database, so I'd do this by downloading a data set from your products using the free version of Easy Populate, then making the change in Excel, then uploading the changed file. Should take just a couple of minutes. You can find EP in the Free Software Add Ons. I used it to populate my sites with data and it worked fine.

    Rob

  9. #9
    Join Date
    Apr 2008
    Location
    London
    Posts
    596
    Plugin Contributions
    0

    Default Re: change prices

    First thing I tried AFTER BACKING UP ALL MY FILES AND DATABASE was Quick Update.
    It totally did the job perfectly. i haven't tried it all but it looks very powerful.

  10. #10
    Join Date
    Apr 2006
    Location
    Texas
    Posts
    6,196
    Plugin Contributions
    0

    Default Re: change prices

    Rstevenson,
    Thanks for that handy tip, boy every day I learn a new little mod to simplify a task...

    Thanks again..

 

 

Similar Threads

  1. Need to change prices
    By hamid84 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 14
    Last Post: 18 Feb 2010, 11:14 PM
  2. Change prices to $0.00
    By genesissystem in forum General Questions
    Replies: 12
    Last Post: 23 Oct 2009, 02:50 AM
  3. How to change display from Low prices to Hig prices?
    By euroxtreme in forum General Questions
    Replies: 0
    Last Post: 25 Sep 2009, 07:32 PM
  4. Mass change prices?
    By onlyfullcolor in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 19 Mar 2009, 03:19 AM
  5. Prices change but why ?
    By hendrik6073 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 25 Dec 2006, 10:45 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