Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    help question Bulk Product Prices & Quantity Increases

    Hi everyone,

    As always I browse through the forums first before posting but could not find exactly what I needed.

    Using the "SQL Query Executor" I need the lines necessary for the following:

    changing all prices from $2.96 to $2.99 (not a percentage increase)

    and

    changing all stock level quantities to 100 pieces (or whatever i will need).


    In summary....I need to change all prices to $2.99 and increase my on hand quantities to 100 for all products in all categories.

    Thanks for your help.....:)

    http://treefreegreetingcards.com/

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    4,732
    Plugin Contributions
    3

    Default Re: Bulk Product Prices & Quantity Increases

    Quote Originally Posted by RetailProductsGroup View Post
    Using the "SQL Query Executor" I need the lines necessary for the following:

    changing all prices from $2.96 to $2.99 (not a percentage increase)
    and changing all stock level quantities to 100 pieces (or whatever i will need).
    Code:
    UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;
    Code:
    UPDATE `products` SET `products_quantity`= 100 WHERE 1 ;
    Usual caveats apply. Use at your own risk. Make backups first.

    Cheers
    Rod

    ps "WHERE 1" effectively means "match all"

  3. #3
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default Re: Bulk Product Prices & Quantity Increases

    OK......

    this line worked perfectly:

    UPDATE `products` SET `products_quantity`= 100 WHERE 1 ;


    however, this line had no effect:

    UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;


    Any thoughts?

    I appreciate the help.....:)

    Thanks,
    Garry

    http://treefreegreetingcards.com/

  4. #4
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default Re: Bulk Product Prices & Quantity Increases

    anyone?

 

 

Similar Threads

  1. Bulk Update Attribute Prices
    By RicM in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 14 Dec 2011, 12:14 AM
  2. Updating Inventory increases prices- EZ Populate
    By mfederko in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 20 Jul 2010, 01:38 PM
  3. Sell Product in Bulk Pack or Box Quantity
    By DarthPixel in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 24 Aug 2007, 11:34 PM
  4. Why my price of the product increases from $100 to $111.13?
    By qm360 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 11 Jul 2007, 03:21 PM
  5. One product, mulitple prices based on quantity
    By DMUK in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 6 Dec 2006, 08:54 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
  •