Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    313
    Plugin Contributions
    0

    Default Bulk change the Attributes in MySQL

    Hey everyone...

    I have a customer who has manually put in about 300 attributes.. When I am looking over the site, I noticed she must have had the 'Attribute is a Display Only' button checked on all of them. Awesome...

    Rather than have her edit all of them over by hand... is there a way I can bulk change them all in PHP MySQL? As well, as remove the 'This Attribute is default' ... I assume i could do it the same way.

    I'm not very comfortable with MySQL just yet. and any help would be greatly appreciated.

    Thanks so much, in advance...

  2. #2
    Join Date
    May 2006
    Posts
    313
    Plugin Contributions
    0

    Default Re: Bulk change the Attributes in MySQL

    okay, just figured it out incase anyone needs to know for later.

    UPDATE zen_products_attributes SET attributes_display_only=0
    worked for me...

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

    Default Re: Bulk change the Attributes in MySQL

    Thanks for posting the solution to this ... that is exactly how to fix a global replace on the Attributes when you know the setting you need to update ...

    NOTE: Always be sure to backup your database before attempting something like 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!

 

 

Similar Threads

  1. v139h MySQL quary admin log who change the product value?
    By explorer1979 in forum General Questions
    Replies: 1
    Last Post: 5 Mar 2015, 05:56 AM
  2. Bulk change default attribute in mySQL?
    By RandyRand in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 21 Apr 2011, 11:38 PM
  3. Bulk creation of attributes
    By brianko in forum Contribution-Writing Guidelines
    Replies: 2
    Last Post: 12 Jul 2009, 05:21 AM
  4. how do change the mysql socket?
    By rptodd1 in forum Installing on a Mac Server
    Replies: 5
    Last Post: 3 Mar 2009, 02:46 PM
  5. Recommend product and attribute bulk upload to mySQL?
    By JackA in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 18 Feb 2009, 06:19 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