Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Idea or Suggestion Update Attribute on All Product, Without Messing up with other attribute in product?

    I have a problem, where i would like to add one update to all of my product attribute whiteout changing any other attribute. example:

    All my Product have this attributes:

    ColorBlack

    Sizes52- 16- 140

    Lens TypeBifocal (With Line)
    Progressive Lens (No Line)
    Single Vision (Far/Close-up)

    Change to:


    ColorBlack

    Sizes52- 16- 140

    Lens TypeBifocal (With Line) $49.99
    Progressive Lens (No Line) $89.99
    Single Vision (Far/Close-up) 99.99

    without changing the Size of all product and color.

    How is this possible?

  2. #2
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default How can i make an update to all product on one attribute?

    I would like to update pricing on one attribute for all my product, without touching other attribute setting of all product . for example, if you follow this URL, you can see Lens type (attribute) don't have price
    http://observevision.com/index.php?m...&products_id=8
    but if you follow this link the lens type have Price right by it.
    http://observevision.com/index.php?m...&products_id=4

    my problem is i wanna put price on "lense Type" attribute without changing Sizes, Colors, or any other attribute of the product.

    i know i can do this if i go and add it to the each product manually, but i was wondering if there is a way i can do this faster?

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

    Default Re: How can i make an update to all product on one attribute?

    Are you trying to change ALL Products that have the Attributes:
    Lens TypeBifocal (With Line)
    to ALL be:
    Lens TypeBifocal (With Line) $49.99
    on *every product* in your shop if they already have the attributes:
    Lens TypeBifocal (With Line)

    and then ...
    change ALL Products that have the Attributes:
    Progressive Lens (No Line)
    to ALL be:
    Progressive Lens (No Line) $89.99
    on *every product* in your shop if they already have the attributes:
    Progressive Lens (No Line)

    and then ...
    change ALL Products that have the Attributes:
    Single Vision (Far/Close-up)
    to ALL be:
    Single Vision (Far/Close-up) 99.99
    on *every product* in your shop if they already have the attributes:
    Single Vision (Far/Close-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. #4
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default Re: How can i make an update to all product on one attribute?

    Yes, how is it possible?

  5. #5
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default Re: How can i make an update to all product on one attribute?

    And i don't want any other attribute to be effected of all product.

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

    Default Re: How can i make an update to all product on one attribute?

    To replace an Attribute Price, which is the options_values_price, for a specific Attribute on ALL Products regardless of the original Price of the options_values_price ...

    You need to find the:
    options_id

    for the Option Name Lens Type ...

    You need to find the:
    options_values_id

    for the Option Values:
    Bifocal (With Line)
    Progressive Lens (No Line)
    Single Vision (Far/Close-up)

    Backup your database ...

    Did you backup your database? (very important step)

    Then you can use this in the Tools ... Install SQL Patches ...

    For the Bifocal (With Line) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=16 with the options_values_id for the Bifocal (With Line) use:
    Code:
    UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE options_id= 1 and options_values_id = 16;
    For the Progressive Lens (No Line) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=17 with the options_values_id for the Progressive Lens (No Line) use:
    Code:
    UPDATE products_attributes SET price_prefix='+', options_values_price = 89.99 WHERE options_id= 1 and options_values_id = 17;
    For the Single Vision (Far/Close-up) you can run, by replacing the options_id=1 with your options_id for Lens Type and the options_values_id=26 with the options_values_id for the Single Vision (Far/Close-up) use:
    Code:
    UPDATE products_attributes SET price_prefix='+', options_values_price = 99.99 WHERE options_id= 1 and options_values_id = 26;
    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. #7
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default Re: How can i make an update to all product on one attribute?

    Where can i get the options_id=1, and options_values_id=16 for example. I check my phpmyadmin but i dont see lenses type.

  8. #8
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default Re: How can i make an update to all product on one attribute?

    for example this is what type in

    UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE products_options= 4 and products_options_values = 124;

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

    Default Re: How can i make an update to all product on one attribute?

    In your Zen Cart Admin in the Catalog ... Option Name Manager ... the ID next to the Lens Type is the options_id ...

    In your Zen Cart Admin in the Catalog ... Option Value Manager ... the ID next to the:
    Bifocal (With Line)
    Progressive Lens (No Line)
    Single Vision (Far/Close-up)

    are the options_values_id ... that you are looking for ...


    WARNING: you need to use the code that I gave you ... if the Lens Type ID is 4 and the is Bifocal (With Line) ID is 124, then you need to use:
    Code:
    UPDATE products_attributes SET price_prefix='+', options_values_price = 49.99 WHERE options_id= 4 and options_values_id = 124;
    NOTE: Again, be sure to backup your database before attempting this ...
    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. #10
    Join Date
    Sep 2012
    Posts
    11
    Plugin Contributions
    0

    Default Re: How can i make an update to all product on one attribute?

    Thank you for all your help, now i have one more question how can i make everything in order? for example i want my attribute to shoe in order for all products, now is a mess. I want to be order for all product, like in this order

    Color & Size Section:
    1 (color)
    2 (Sizes)

    Lenses Section:
    1 (Lens Type)
    2 (Right (OD) - Sphere, Right (OD) - Cylinder, Right (OD) - Axis, Left (OS) - Sphere, Left (OS) - Cylinder, Left (OS) - Axis, PD)
    3 (Lens Thickness)



    and is it possible to write short description on top of each section?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. how to copy one product's attribute to all other products?
    By andy2012 in forum Setting Up Categories, Products, Attributes
    Replies: 13
    Last Post: 5 Oct 2012, 01:39 AM
  2. Update all products to the same attribute?
    By rkmoore11 in forum General Questions
    Replies: 6
    Last Post: 28 Jul 2010, 05:45 PM
  3. Can I add a custom attribute form, without using built in attribute manager?
    By infocom in forum Setting Up Categories, Products, Attributes
    Replies: 16
    Last Post: 12 Apr 2010, 10:17 AM
  4. Download Instruction Manual on Linked Product - Order one product with attribute - pu
    By JPWheelr in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 19 Oct 2006, 07:45 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