close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Edit an Item in Shopping Cart

Thread began 12/30/2010 5:25 pm by SaladoGuy | Last modified 1/19/2011 6:21 pm by SaladoGuy | 2558 views | 16 replies |

SaladoGuyBeta Tester

Edit an Item in Shopping Cart

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.

Sign in to reply to this post

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.

Sign in to reply to this post

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.

Sign in to reply to this post

Jason ByrnesWebAssist

please post a copy of the page so i can see the code.

Sign in to reply to this post

SaladoGuyBeta Tester

Here's my viewcart page. Thanks for your time.

Attached Files
viewcart.php.zip
Sign in to reply to this post

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?

Sign in to reply to this post

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?

Sign in to reply to this post

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").  



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

Sign in to reply to this post

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.

Sign in to reply to this post

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...