Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2007
    Location
    North Carolina
    Posts
    64
    Plugin Contributions
    0

    Default Deleting Saved Items in Cart

    Hey Fellow Zen Cart-ers,

    We have have a customer that has gummed up the shopping cart (on www.curlygirlstore.com) with multiple quantities of 75 items. When she tries to access the cart she keeps getting a 500 Internal Server error.

    We have tried to go in a delete these items from her cart for her, but we keep getting the same error when we sign in as her and try to access the shopping cart.

    Is there a way to delete this information from the database or from the admin end? The only solution I can think of right now is to delete her as a customer and then have her sign up again.

    Thanks for any advice!

    Charles
    Using Zen Cart 1.3.9h

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    2,873
    Plugin Contributions
    27

    Default Re: Deleting Saved Items in Cart

    There are two tables in the database (customers_basket and customers_basket_attributes) that hold a customer's not-yet-purchased products. If you search through those tables and delete the records associated with your specific customer's customer_id value, s/he should be good-to-go.

    Remember to back up your database first!

  3. #3
    Join Date
    Oct 2007
    Location
    North Carolina
    Posts
    64
    Plugin Contributions
    0

    Default Re: Deleting Saved Items in Cart

    Thanks a bunch for the pointer!


  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    66,819
    Plugin Contributions
    6

    Default Re: Deleting Saved Items in Cart

    NOTE: v1.5 has a clean up on restored carts for when Products or Attributes are deleted from Products to clean up the shopping cart ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  5. #5
    Join Date
    Mar 2012
    Posts
    2
    Plugin Contributions
    0

    Default Re: Deleting Saved Items in Cart

    I'm very interested in what you've just said about restored cart deletions for product attribute cleanups, Ajah, for I think I may be having an issue with this.

    I've a client using 1.3.8a and only rarely, like during sales events where they have 2,000+ orders in a day, will we see this issue popup a few times within the ~2,000 orders: a customer's order will have one or more products properly ordered, but also a quantity listed (usually just 1, but we've seen other multiples) for a product that is priced by attributes, yet no attribute is shown as being selected so the resulting price for that product(s) is $0.00.

    I'm apprehensive about upgrading their system, for we've made a lot of custom revisions (i.e. max dollar value for Percentage based coupons, referrer/affiliate sales tracking, etc) to their system.

    Please know that any thought you may have about what may be causing this issue, will be much appreciated.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    66,819
    Plugin Contributions
    6

    Default Re: Deleting Saved Items in Cart

    This is what I suggested for and extra check on stock:
    http://www.zen-cart.com/forum/showth...ra+check+stock

    You might adapt that to your code and see if it helps ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  7. #7
    Join Date
    Mar 2012
    Posts
    2
    Plugin Contributions
    0

    Default Re: Deleting Saved Items in Cart

    Thank you for the suggestion. When they have another big sale (next quarter) I'll be sure to let you know if their issue is resolved.

 

 

Similar Threads

  1. Cart items not saved in Opera
    By Magic Muscle in forum General Questions
    Replies: 4
    Last Post: 17 Mar 2011, 04:50 AM
  2. Saved Cart Items From Last Session
    By lucchesi in forum General Questions
    Replies: 5
    Last Post: 30 Dec 2010, 04:36 PM
  3. Saved cart items from previous session
    By Loque in forum Managing Customers and Orders
    Replies: 25
    Last Post: 15 Aug 2008, 09:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •