Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    65
    Plugin Contributions
    0

    Default Can I change price attributes in all products at one time?

    Hello!

    I have around 49 products in my shop. Each product has the same price but has 10 different price options depending on several factors.

    So basically I have 10 price attributes set up for each product. I would like to change the prices of each of the 10 attributes.

    Is it possible to make ONE change that would reflect in all 49 products or do I have to go into EACH of the 49 products one by one and change all 10 price attributes?

    Thanks so much for your help!!!

  2. #2
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: Can I change price attributes in all products at one time?

    Is each of these attributes the same price in all products? Or do you want to alter all of them in exactly the same way (%, $ change, ...)?
    Try this after backing up your database:
    Code:
    UPDATE products_attributes SET options_values_price = ROUND(options_values_price * 1.5)
    WHERE options_values_id = 113;
    Cut & paste in Tools > Install SQL Patches, changing the options_values_id as appropriate and the calculation to whatever you need. MySQL has specific syntax for calculations, so you need to be clear on how you want to change the prices.

 

 

Similar Threads

  1. v150 Different drop-down displays on attributes with recurring v. one-time price
    By KenBaker in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 3 Feb 2013, 01:47 PM
  2. how can I change the price to all my products?
    By bahaa87 in forum General Questions
    Replies: 2
    Last Post: 23 Jul 2010, 04:51 PM
  3. Copy all products to another category in one time
    By hengxi in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 3 Sep 2009, 05:02 PM
  4. Adding attributes to multiple products at one time.
    By nathan08 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 1 Feb 2009, 05:30 PM
  5. How Can I change All products prices in one time ?
    By darknes in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 29 Nov 2008, 01:59 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