eCart samples of stores using options

I've build a few sites using eCart, but know I'm facing a new challenge to incorporate multiple options to an item that affect the price.

Could you point me in the right direction where I could find tuturials, examples etc to review before attempting this.

I've already downloaded the e-commerce solutions and review the solution 5. However I'm looking for information on having options that add to the price of an item.

Basically, where a price goes up depending on the options selected.

There are not any current how to's or tutorials on this subject but I can give you an overview of how you could accomplish this.

You will need options in a table that have an item id column to relate to the items and the other values for you options like the price and name.

With this in place you can create a recordset that pulls from this table for the current item. You can use this recordset with a select list to display all the options for a product.

Next you would need to have a recordset that will select the option that the user selected based on the id of the option that was submitted. You can then use the price from this record as the price binding in your add to cart server behavior.

This is very broad overview for you to get an idea about how this can be accomplished. Post back with any questions that you have about any part of this and I will be glad to help with whatever I can.

If I understand you correctly, is this the rough idea?

1. Create a table in MySql for the options that have a unique ID.
The might look like:

Options Table
ID, Name, Price

2. Add an options button for each product with the data coming from the recordset “Options”

3. Create a server behavior that binds the “options” price to the item selected and adds it to the cart.

For the table you create you will need to have a foreign key to join the options with the corresponding item unless all items will have the same options. This new column would be the an item id column.

You would then have your rs for the options, you would use this rs to populate a select list on the page.

To get the price for this option you will need to have another recordset on the page that will be filtered on the id of the posted option. You would then use this recordset to get the options price. You can either use the price for the option as the price for the item if it includes the item costs, or you can add it to the price for the item. This final part would be done in the add to cart for the item.

Hi,

I have also been thinking about how this may be achieved. I downloaded the e-commerce sample database from WebAssist, which is very helpful, and have built a complete back-end for the store using PHP, including adding product option groups and options.

The problem I have is that there seems to be no easy way of getting this to work with eCart. I know there was reference to future tutorials using this ecommerce database and think a tutorial on adding product options in eCart using the sample database would be an excellent idea. I love the design flexibility eCart gives me, but have yet to use it on a live site due to the inability to add dynamic product options.

Pretty please :-)

We hear your requests and we are definitely working on getting out a tutorial for this but it is not available presently. For now this is a custom implementation that will rely on how you have your store setup and how you would like the options to be applied. If you are interested in trying this out you can post back here with any questions that you have about any part and I will be happy to help out with whatever I can.

I had a question where I wanted the size to determine the price that took me some time to get worked out. The key is in the add to cart section of the php code you need to have recordsets that will grab the price information and add everything together.

Yeah, it's a custom implementation and you will need to understand some php in order to pull it off. It should be doable though.