Edit an Item in Shopping Cart

12/30/2010 5:25 pm | #1 SaladoGuyBeta Tester

I'm setting up a shopping cart with eCart, each of my products have a list of available accessories, customizable engraving, colors & sizes. Not all options are available with all products, I've got all of this working like a charm.
My main holdup is this, once an item is in the cart, the buyer may realize that he want's to change his selection of color, accessory, etc. I have this working (somewhat) on accessories for example, I have a radio group with all available accessories for that particular product. The problem is this, when you change the radio selector and click "Update Cart", everything but the price increment is updated, unless you "Update Cart" again.
I was thinking to remedy this by allowing the customer to click a button "Edit Options", that would take them to a page or "LightBox PopUp" that would allow them to edit the accessories, engraving, etc. for selected item.

WHEW! All of that to say, is there a way to reference a specific item that is in the cart. All I need is a basic "recordset" of what is in the cart, that I can then filter by a session variable (which is set when customer clicks "Edit Options"). I think I can take care of it from there.

Thanks in advance for any advice.

P.S. If anybody knows of a better approach to changing options and updating the price, I'm very open to suggestions!

Thanks again.

1/03/2011 10:53 am | #2 Jason ByrnesWebAssist

The problem is this, when you change the radio selector and click "Update Cart", everything but the price increment is updated, unless you "Update Cart" again.

this sounds like an issue with code order.

make sure that the recordset that is performing the price lookup is before the cart update code.

1/03/2011 6:44 pm | #3 SaladoGuyBeta Tester

Originally Said By: Jason Byrnes

make sure that the recordset that is performing the price lookup is before the cart update code.

Originally, the update behavior was at the very top of the page (above the html), I moved it down below the recordset, which is in the <body>. Now clicking the "Update Cart" does the same thing as before, except that you have to click it: FIRST to POST the newly selected option, AGAIN to update the price increment of the specific product and AGAIN to update the Grand Total.

1/10/2011 6:12 pm | #6 SaladoGuyBeta Tester

Originally Said By: SaladoGuy

Is there a way to reference a specific item that is in the cart. All I need is a basic "recordset" of what is in the cart, that I can then filter by a session variable (which is set when customer clicks "Edit Options"). I think I can take care of it from there.

Is there any hope of doing this?

1/11/2011 8:39 am | #7 SaladoGuyBeta Tester

I've been thinking about this whole issue, and I'm realizing that what I really need is for the accessories and LASER engraving to be "sub items".
What I mean by that is they really should go into a child table, it's relationship to the `orderdetails` table would be the same as `orderdetails` is with `orders`.
So basically `orderengraving` would have a field to reference `orderdetails.DetailID`.
I know this will require a good bit of hand coding, but the main reason I need this is because when I do an export for our accounting program from my DB, I need the engraving and accessories to be separate line items.
I don't know where to start, if this is what I should do. Any advice?

1/11/2011 5:59 pm | #8 SaladoGuyBeta Tester

Originally Said By: SaladoGuy

If somebody knows of a way to do this, I'm still very interested, even though I don't need it for this particular cart, I will on my next project (which I'm supposed to start on next week).

P.S.
I'm not trying to be pushy, I just don't want this to be dropped because of my last post.

Thanks

1/12/2011 10:11 am | #9 SaladoGuyBeta Tester

I'm sorry to keep posting here without waiting for an answer... But I've actually figured out how to do the other suborder tables. Basically I setup two more table that have the same relationship as `orderdetails` does with `orders`, and I'm storing the engraving and accessory "product attributes" in the new tables. This works great, but I still need to resolve the issue where it takes hitting the "Update" button several times to do all of the calculations. Unless there is a way to "Edit" one item in the cart by pulling all of it's attributes into a "recordset" os sorts.

Thanks for your patience.

1/12/2011 3:15 pm | #10 Jason ByrnesWebAssist

The only reliable way to accomplish this would be to hand code a function to delete the item from the cart, then re add it again with the new options. A basic update wont work since you have price dependent options.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Edit an Item in Shopping Cart

12/30/2010 5:25 pm | #1 SaladoGuyBeta Tester