Information on recordsets + ATC Function for items with size options that affect pric
I see from a thread on Dec 4 with Andre363997, a tutorial on adding products with options like size and color is on it's way - can you advise where it is?
My first problem was that the recordset options (in the Add to Cart on product pages) were not displaying in browsers - was advised it was due to my using CF - have switched to PHP and am getting the list dsiplayed.
Now, I need to understand if the data for a SINGLE cart needs to be in the same recordset - in this example a product that has 3 sizes and 2 colors. My database is already built with the needed foreign keys. And I can easily build simple recordsets - one for size, one for color and one for the product. However, since I'm not a PHP programer, I really don't understand the code beyond the recordset names. So I'm relying more on the ecart's wizards to build the php.
This is situation: my DB productID is to a size and color level, with sizeID and colorID as foreign keys to their own tables. Creating the options drop downs (as seen above) has been accomplished, but I don't understand how use the columns of the cart wizard to build it correctly so that the appropriate product is added to the cart.
I can see that I will need to enter dynamic information. I did create a recordset from the product table with productID, name, weight, price, desc. But this rs is not tied to the size so can't be used as is.
IF I have the rsSize include the sizeID (in its recordset for the page) AND the rsproduct include the sizeID (in its recordset page), will this somehow tie together (because it's in the same cart) so that when a customer is on this product page and chooses size L, that will translate to the appropriate price for the product ID that is associated with the productID/sizeID?? From the thread I referenced (up above), it seemed like maybe all info that affects the price would need to be in one recordset. But IF I can figure how to create a more complicated rs that combines all the needed data, I would have 3 records of the same product (same in all respects except size). But the page only needs one actual product. (EDIT - I did create a rs that included all information, but the same color was listed multiple times. And it would seem that I would need a separate recordset for separate data that I wanted sorted differently.)
I'm assuming that since I've paid all this $ for this product, I will need to perservere until I grasp it and create the Add to Cart buttons. My next "problem" is going to be changing the presentation. Mostly with CSS, which for my first page was quite a bit of work. If I have pages with add to cart areas with similar options. Is there a way that I can copy the add to cart code from one page and paste it to another page, then hand code some changes - like recordset names? I know I will have to add the actual Add to Cart button to each page to ge the functionality, but want to be able to copy and paste as much as possible. Is there information on your site how I could do this?
Hope to hear from someone at WA soon. I've really really tried to figure this out on my own, but so far have not.