Hello, I am setting up a site for http://sounddiaperservice.com/produts and he just received his first order. He got the order confirmation email telling him that the order had been made but it does not include the customers information like their street address. This will be useful to him as this is a delivery business. The customer is required to enter this info when they purchase, but he doesn't want to have to go to the site to look that up, just get it off the email on his smart phone as he is driving.

How do I set up that email to retrieve that information?

Please be specific as to the location of the PHP file that needs to be altered.

Thank you in advance for considering this issue.

Here is the email that he received, the billing address and delivery address are blank:

From: "Sound Diaper Service" <>
Date: Jun 6, 2009 1:45 PM
Subject: [NEW ORDER] Order Confirmation No: 1
To: <>

AuthCode: 05885C TransID: 2466279993

Order Confirmation from Sound Diaper Service

Janae Huber

Thanks for shopping with us today!
The following are the details of your order.
------------------------------

------------------------
Order Number: 1
Date Ordered: Saturday 06 June, 2009
Detailed Invoice:
https://products.sounddiaperservice.com/index.php?main_page=account_history_info&order_id=1

It would be great if you could clarify if we just call to set up our first
delivery or if it's automatic based on our due date? Thanks! Janae

Products

1 x New Client Account Set up = $74.86
Due date or birth date June 20, 2009
new born

Sub-Total: $74.86
Per Item (Best Way): $2.50
Total: $77.36

Delivery Address

,

Billing Address

,

Payment Method

Credit Card

Visa XXXXXXXXXXXX6622

---

This email address was given to us by you or by one of our customers. If you
feel that you have received this email in error, please send an email to

---

Copyright (c) 2009 Sound Diaper Service. Powered by Zen Cart

Office Use Only:
From:
Email:
Login Name: Janae Huber
Login Email: yahoocom
Telephone: 360 870.0227
IP Address: 76.28.184.222 - 76.28.184.222
Host Address: c-76-28-184-222.hsd1.wa.comcast.net
Date and Time: Sat Jun 6 2009 13:45:30 PDT

Zen Cart normally does include the billing address, and if the order is shippable, also the shipping address, in the order confirmation emails.
Something you've customized is apparently leaving address information blank.
Surely you tested the normal operation before you let the store start taking orders, right?

Well, ahem, I tested some things...:blush: It all seems to be working and he really didn't want a delay in business from his previous web site. I will look into settings that I may have changed. Any direction would be appreciated. I am a bit new at using Zen Cart, This being my second installation, and the first I did little more than install it for a client and let him figure it out. I learn very quickly though...:smile:

I'm not sure why you're getting no address details. That's very unusual.

well, I did another test and it worked just fine, I guess I will just have to wait until another sale comes in to see. Thank you for your response.:D

Hello, All tests that I have done worked just fine, but my client just received another order that contains no address. Any ideas?

AuthCode: 00536C TransID: 2514500587

Order Confirmation from Sound Diaper Service

Marsha Z.

Thanks for shopping with us today!
The following are the details of your order.
------------------------------

------------------------
Order Number: 4
Date Ordered: Saturday 11 July, 2009
Detailed Invoice:
https://products.sounddiaperservice.com/index.php?main_page=account_history_info&order_id=4

Products

1 x Gift Certificates (GIFT-25) = $25.00

Sub-Total: $25.00
Free Shipping: $0.00
Total: $25.00

Billing Address

,

Payment Method

Credit Card

Visa XXXXXXXXXXXXxxxx

What add ons or modifications have you made to the code?

I haven't done a whole lot. I set up Authorize.net, I have messed with the css to change the template, I haven't added any Mods or add-ons, I have added 3 products with options...I don't know, nothing that seems out of the ordinary.

Which Authnet module? If you're not using the AIM module, I would suggest trying it.
I'm not clear on which version of Zen Cart you've installed either.

Zen Cart 1.3.8a

Enable Authorize.net (AIM) Module
True

I've tried but cannot seem to create circumstances that cause that problem.

Is there any particular pattern you've noticed that might point to the root cause?

There is this:

WARNING: YOU HAVE DUPLICATE SORT ORDERS WHICH WILL RESULT IN CALCULATION ERRORS
PLEASE CORRECT THESE ISSUES NOW!I only have two payment modules activated; authorize.net (sort order 1) and check/M.O. (sort order 2). I don't know if that may be something related.

also the order status of Authorize.net is "pending". I have it set to "default". I don't know why it says that or if that has anything to do with it.

It seems that the first two customers have both registered at the same time they purchased rather than registering ahead of time. We have not had a sale from a returning customer yet to see what would happen. I guess I could set up a one cent product and purchase it myself to see if we get the same result. I could also test Authorize.net and create a new registration as I purchase as my previous tests were with my already registered account. I am not sure what that would prove though.

Here is something odd that may relate. When I try to set up a test account while testing Authorize.net, I get this message on a blank white screen:

1062 Duplicate entry '' for key 2
in:
[insert into phpbb_users (user_id, username, user_password, user_email, user_regdate) values ('1069', 'test1', '5a105e8b9d40e1329780d62ea2265d8a', '[email protected]', '1247633716')]
I have only used that email once for a similar test, but I deleted that account. When I hit the back button, it has me logged in as test1 but it wont let me buy anything because: > Sorry, we are not accepting payments from your region at this time. even though I know it is the right region.

I tried it again with an email address that I know I have never used and get the same thing again. > 1062 Duplicate entry '' for key 2

in:
[insert into phpbb_users (user_id, username, user_password, user_email, user_regdate) values ('1069', 'test2', 'ad0234829205b9033196ba818f7a872b', '[email protected]', '1247634537')]

I don't know if this is another symptom of the address being missing.

One other thing that I noticed was that when I got error messages as I was registering, like "you need to fill in the email space" they are in a box with a orange triangle but the text is in white on a white background. This is probably just a CSS issue, but thought id mention it as I really don't know what is causing the address issue.

I found the answer to the not accepting payments from your region error.

azwli:

One other thing that I noticed was that when I got error messages as I was registering, like "you need to fill in the email space" they are in a box with a orange triangle but the text is in white on a white background. This is probably just a CSS issue, but thought id mention it as I really don't know what is causing the address issue.Yes, that'll be a CSS issue.

I am still trying to figure out the missing address issue. I ran another test and did an error log. I see in the log that the address is not present:

Jul-15-2009 10:36:20

Response Code: 1.
Response Text: (TESTMODE) This transaction has been approved.

Sending to Authorizenet: Array
(
[x_login] => *******
[x_tran_key] => *******
[x_relay_response] => FALSE
[x_delim_data] => TRUE
[x_delim_char] => |
[x_encap_char] => *
[x_version] => 3.1
[x_type] => AUTH_CAPTURE
[x_method] => CC
[x_amount] => 25.00
[x_currency_code] => USD
[x_card_num] => XXXXXXXXXXXXXXXX8525
[x_exp_date] => 1109
[x_card_code] => ****
[x_email_customer] => FALSE
[x_email_merchant] => TRUE
[x_cust_id] => 19
[x_invoice_num] => TEST-5-gSeDHf
[x_first_name] =>
[x_last_name] =>
[x_company] =>
[x_address] =>
[x_city] =>
[x_state] =>
[x_zip] =>
[x_country] =>
[x_phone] => 1234567890
[x_email] => [email protected]
[x_ship_to_first_name] =>
[x_ship_to_last_name] =>
[x_ship_to_address] =>
[x_ship_to_city] =>
[x_ship_to_state] =>
[x_ship_to_zip] =>
[x_ship_to_country] =>
[x_description] => Gift Certificates (qty: 1)
[x_recurring_billing] => NO
[x_customer_ip] => 76.121.157.202
[x_po_num] => Jul-15-2009 10:36:19
[x_freight] => 0.00
[x_tax_exempt] => FALSE
[x_tax] => 0.00
[x_duty] => 0
[Date] => July 15, 2009, 10:36 am
[IP] => 76.121.157.202
[Session] => fmqbsi5ve495tnurgmd28p9es3
[x_test_request] => TRUE
[url] => https://secure.authorize.net/gateway/transact.dll
)

Results Received back from Authorizenet: Array
(
[0] => Response from gateway
[1] => 1
[2] => 1
[3] => 1
[4] => (TESTMODE) This transaction has been approved.
[5] => 000000
[6] => P
[7] => 0
[8] => TEST-5-gSeDHf
[9] => Gift Certificates (qty: 1)
[10] => 25.00
[11] => CC
[12] => auth_capture
[13] => 19
[14] =>
[15] =>
[16] =>
[17] =>
[18] =>
[19] =>
[20] =>
[21] =>
[22] => 1234567890
[23] =>
[24] => [email protected]
[25] =>
[26] =>
[27] =>
[28] =>
[29] =>
[30] =>
[31] =>
[32] =>
[33] => 0.0000
[34] => 0.0000
[35] => 0.0000
[36] => FALSE
[37] => Jul-15-2009 10:36:19
[38] => F9EEAF16EFCDBB5DC7BB97F68AFDB2B8
[39] =>
[40] =>
[41] =>
[42] =>
[43] =>
[44] =>
[45] =>
[46] =>
[47] =>
[48] =>
[49] =>
[50] =>
[51] =>
[52] =>
[53] =>
[54] =>
[55] =>
[56] =>
[57] =>
[58] =>
[59] =>
[60] =>
[61] =>
[62] =>
[63] =>
[64] =>
[65] =>
[66] =>
[67] =>
[68] =>
[69] => July 15, 2009, 10:36 am
[70] => 76.121.157.202
[71] => fmqbsi5ve495tnurgmd28p9es3
[Expected-MD5-Hash] => F9EEAF16EFCDBB5DC7BB97F68AFDB2B8
[HashMatchStatus] => PASS
)

CURL communication info: Array
(
[url] => https://secure.authorize.net/gateway/transact.dll
[content_type] => text/html
[http_code] => 200
[header_size] => 237
[request_size] => 1077
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.153495
[namelookup_time] => 0.006943
[connect_time] => 0.025872
[pretransfer_time] => 0.114474
[size_upload] => 0
[size_download] => 501
[speed_download] => 3263
[speed_upload] => 0
[download_content_length] => 501
[upload_content_length] => 0
[starttransfer_time] => 0.153362
[redirect_time] => 0
)

RAW data received:
1|1|1|(TESTMODE) This transaction has been approved.|000000|P|0|TEST-5-gSeDHf|Gift Certificates (qty: 1)|25.00|CC|auth_capture|19|||||||||1234567890||[email protected]|||||||||0.0000|0.0000|0.0000|FALSE|Jul-15-2009 10:36:19|F9EEAF16EFCDBB5DC7BB97F68AFDB2B8||||||||||||||||||||||||||||||**|July 15, 2009, 10:36 am|76.121.157.202|fmqbsi5ve495tnurgmd28p9es3

I think I may have solved or at least fixed it. I disabled my PHPBB installation and now at least testing mode works. I have seen the "1062 Duplicate entry" problem listed in other threads, but no resolution. I figured that there had to be a correlation and their seems to be a bug in their somewhere, but since my client has decided that he does not want to deal with a BB anyway this works to solve it. We will see what happens when a real purchase comes through.:smile:

azwli:

I think I may have solved or at least fixed it. I disabled my PHPBB installation and now at least testing mode works. I have seen the "1062 Duplicate entry" problem listed in other threads, but no resolution. I figured that there had to be a correlation and their seems to be a bug in their somewhere, but since my client has decided that he does not want to deal with a BB anyway this works to solve it. We will see what happens when a real purchase comes through.:smile:

I got the same problem. Do you mean that your just trun the Enable phpBB linkage? to false?

yes, and I also deleted all PHPBB files, although I don't know if that was necessary.