How can i include different pricing for Product Options...
Hi there, Im trying to get my head around the following:
I have a products split into categories. Each product will have product options. and for each category there will be different options compared to other categories. for example:
Category Individual Charms:
--Product: Large Daisy Charm:
----Option: Name on Charm [input box]
----Option: Pandora Charm Carrier [YES/NO] (+£10)
----Option: Date on reverse [input box] (+£5)
Category Bracelets:
--Product: Ball Bracelet
----Option: Charm Type1 [list of type] - some will have different price increases
----Option: Charm Name1 [input box]
----Option: Charm Type2 [list of type] - some will have different price increases
----Option: Charm Name2 [input box]
----Option: Date on reverse [input box] (+£5)
So as you can see from the above example, different products will have different options and some will have "list" options (which include added price) and some options will require for the customer to store either a name or a date of birth for their charm.
My question is the "eCommerce mySQL Database" thats available from your website, can it handle such a complex option-base. Or do i need to come up with a different approach (Im thinking also how the Admin when creating new products be able to pick and chose witch options and option lists they want for each new product they add.
I just want to find out this first before going deeper into coding then finding out its not possible with the db structure you provide?
regards
Chris