Edit an Item in Shopping Cart

12/30/2010 2: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 7: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 3: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 3: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 5: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 2: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 7: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 12: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.

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Edit an Item in Shopping Cart

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