Admin for Product Options - additional
Hi, I had read another thread on how to impliment an Admin section for Product options, but reading back on it the user had a different approach for what they wanted.
What I would like to know is the correct workflow for the following:
When an Admin decides they want to add a new product - on the same page I would like the optional entry of product options for that particular product. (there are so many way of doing this).
But what I was thinking is that there is another form with a repeat region for each that includes dropdown for "OptionGroups" , "Options" , "PriceIncrement" - How can I add to all 3 tables at once? Also to further expand on Product Options I have created new fields on the ProductOptions table (these include: OptionType, OptionInfo & OptionHierarchy). These are explained below ro why I added them....
OptionType - (tells the ProductDetail page if the product option being displayed is either a checkbox, or a user input field or a dropdown select.
OptioInfo - allows for text for that unique option to display instruction (if the product option is a user input box i could then display info such as "maximum 12 characters")
OptionHierarchy - on product options some dropdown options will relate an additional user input field - eg I have products that you need to select the product shape of a charm (there are 4 different charms a customer can add to their order and for each charm they can add an inscription to it so there for i need to group these together so if i had a heirarchy field to the table i can allow the admin to order the tables as to how they want them displayed on the product detail page).
So to recap, I just want to know the best approach of adding a form on same page as the creation of a new product that will update all the tables involved.