Search the Community
Showing results for tags 'checkout'.
-
I have setup Google Enhanced Analytics on my website to track each stage of the checkout process. I.E. 1) Step 1 - View Cart 2) Step 2 - Add Billing Details (Checkout page in book) 3) Step 3 - Review order, add payment details This triggers when a user loads each page. However the Google analytics is showing more users are reaching Step 3 than are reaching the Step 2 (an impossible event). So I am wondering, as per the book: "The shopping part of the site purposefully does not use sessions (in order to give longevity to the customer’s cart and wish list), but the checkout process will." - Does starting a new session at Step 2 cause this issue? Has anyone else had an issue with this? Or am I barking up the wrong tree?
-
On the Shipping Information page, when a phone number is provided that has an area code greater than "214", after the "continue on to billing" button is clicked, the following error results: "An error occurred in script 'C:\wamp64\www\effortlessECommerce\effortless_ecommerce_2nd\ex2\html\checkout.php' on line 158: Your order could not be processed due to a system error." This is because the add_customer stored procedure's "p" (aka "phone") parameter is stored as an "int", and ints have a maximum value of 2,147,483,647. Therefore, a phone number with an area code larger than 214 will fail. I fixed the error like this: 1) Go to PHPMyAdmin. 2) Click "Procedures" 3) Click the "edit" button next to "add_customer" 4) Scroll down to the second to last row and change parameter "p" from an "int" to a "char". 5) Change parameter "p"'s "length/values" field from blank to "10" (no quote marks). 6) Click "Go" button. Now it "works on my machine".
- 2 replies
-
- stored procedure
- add_customer
- (and 5 more)