Jump to content

dynamically updating product attributes from database


Recommended Posts

Ok,  so here goes nothin......



I'm trying to build a site for a client that sells custom made hula-hoops.  There are several types of "tapes" types, and each having multi colors/patterns.   There are  Grip, Vinyl, Prism, Sparkle, and Ribbon tape types.    For example purposes each having a red, blue, and green color option.        HoopStyle1  only uses 1 GRIP and 1 VINYL tape.  HoopStyle2 uses 2 Grips and 1 Vinyl.     So the user would select a color from each of those tape types.    My problems is this,  not every tape color will be available all the time.  And over time, new colors will be added.    When I add them to the product attributes list the new colors do not get added to the Hoop products already available.   I currently have to go to EACH  and EVERY product and manually add the new colors or delete the old colors.   Is there a way to have this update dynamically from a database?  I currently have my own database set up with all my tape colors and types and info.   


So I guess my question is this,  can I make the product attribute that is selected to go with each product query my own database ?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More