Forums / General Questions / Two questions pertaining to cart / checkout process

Two questions pertaining to cart / checkout process

Locked

Views: 969

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
4 Feb 2008, 10:09 PM
#1
0be1 avatar

0be1

Totally Zenned

Join Date:
Sep 2004
Location:
Murfreesboro, TN
Posts:
479
Plugin Contributions:
0

Two questions pertaining to cart / checkout process

I have a two part question to the cart building / checkout process. When a cart is being built by the customer where is the data being stored in the table(s) until they checkout?

We had a customer somehow lodge an error by overriding the qty min max levels. We have a product that was setup as 3 3 and somehow she managed to get 11 in her cart instead of 9 or 12, not quite sure what qty she was trying to order.

I did find her error in the zen_sessions table (looked at the hyperlink status when my mouse the shopping cart link) and in her session I found this:

customers_host_address|s:11:"xxx.xxx.x.x";prev_request_type|s:3:"SSL";cartID|s:
0:"";cart|O:12:"shoppingcart":9:{s:9:"observers";a:0:{}s:8:"contents";a:20:
{i:4851;a:1:{s:3:"qty";s:1:"6";}i:4856;a:1:{s:3:"qty";s:2:"12";}i:4910;a:1:
{s:3:"qty";s:1:"1";}i:952;a:1:{s:3:"qty";s:1:"1";}i:4126;a:1:{s:3:"qty";s:1:"1";}
i:3842;a:1:{s:3:"qty";s:1:"6";}i:4904;a:1:{s:3:"qty";s:1:"6";}i:3920;a:1:
{s:3:"qty";s:1:"6";}i:1123;a:1:{s:3:"qty";s:1:"1";}i:1134;a:1:
{s:3:"qty";s:1:"1";}i:5024;a:1:{s:3:"qty";s:1:"1";}i:190;a:1:
{s:3:"qty";s:1:"6";}i:192;a:1:{s:3:"qty";s:1:"6";}i:227;a:1:{s:3:"qty";s:1:"6";}
i:186;a:1:{s:3:"qty";s:1:"6";}i:199;a:1:{s:3:"qty";s:1:"6";}i:4696;a:1:
{s:3:"qty";s:2:"12";}i:3052;a:1:{s:3:"qty";s:1:"6";}i:3357;a:1:
{s:3:"qty";s:2:"26";}i:3056;a:1:{s:3:"qty";s:1:"3";}}s:5:
"total";d:341.8100000000000591171556152403354644775390625;s:6:
"weight";d:13.320000000000003836930773104541003704071044921875;
s:6:"cartID";N;s:12:"content_type";b:0;s:18:"free_shipping_item";i:0;s:20:
"free_shipping_weight";i:0;s:19:"free_shipping_price";i:0;}navigation|O:17
:"navigationhistory":3:{s:9:"observers";a:0:{}s:4:"path";a:3:{i:0;a:4:
{s:4:"page";s:6:"logoff";s:4:"mode";s:3:"SSL";s:3:"get";s:0:"";s:4:"post";a:0:
{}}i:1;a:4:{s:4:"page";s:5:"login";s:4:"mode";s:3:"SSL";s:3:"get";a:1:
{s:6:"action";s:7:"process";}s:4:"post";a:0:{}}i:2;a:4:
{s:4:"page";s:5:"index";s:4:"mode";s:3:"SSL";s:3:"get";s:0:"";s:4:"post";a:0:
{}}}s:8:"snapshot";a:0:{}}check_valid|s:4:"true";language|s:7:"english";languages_id|
s:1:"1";languages_code|s:2:"en";currency|s:3:"USD";updateExpirations|b:1
;session_counter|b:1;customers_ip_address|s:11:"xxx.xxx.x.x";customer_id|
etc.etc.etc... ;valid_to_checkout|b:0;cart_errors|s:163:"Product Name: JR. USHER BADGE - PK 3 ... Quantity Units errors - <br /> You ordered a total of: 26 <span class="alertBlack">Min: 3 Units: 3</span> <br />";

Any ideas on how to fix this, PLUS be able to delete her built cart since she cannot checkout or view / remove any items from her cart.

This problem is preventing this customer from doing any transactions on our site. All other customers are working fine.

tia...

0be1

"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley

5 Feb 2008, 3:12 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Two questions pertaining to cart / checkout process

The cart itself is stored in the customers_basket and customers_basket_attributes ...

Delete the records that match the customers_id in both of these tables and the cart is empty ...

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!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Feb 2008, 1:40 PM
#3
0be1 avatar

0be1

Totally Zenned

Join Date:
Sep 2004
Location:
Murfreesboro, TN
Posts:
479
Plugin Contributions:
0

Re: Two questions pertaining to cart / checkout process

Thank Linda :o) I can now log in as the customer. Now the fun part to see why that happened. My theory is with the customer putting in the wrong qty and with the php errors turned off we could not trap what was going on.

Thanks again...

0be1

"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley