Jump to content

Archived

This topic is now archived and is closed to further replies.

olsonsp4c

No delivery address in email +

Recommended Posts

In both the order confirmation email and in admin/invoice&packing slip there is no delivery address showing up! It's there in my orders table, so I'm confused. Any thoughts - I've done a diff with originals on checkout process and orders. I've checked for the presence of address_format_id in in address_format table and the countries table and it is there. Any thoughts? Thanks!

 

Scott

Share this post


Link to post
Share on other sites

Just thought that I'd add that the only changes I've made are adding the newest Paypal IPN done by the OSC team, Order Editor, and I reset the counter for customers, customers_info, address_book, and orders tables in MySQL. Any thoughts would be a great benefit as we would like to go "live" with my wife's store by Nov. 1st. Thanks!

 

Scott

Share this post


Link to post
Share on other sites

Friends,

 

I found the problem, now I need help with where to look and how to fix the problem.

 

In the table "orders" there are the follow three fields:

 

customers_address_format_id

delivery_address_format_id

billing_address_format_id

 

When a new order is placed by a new customer...

 

customers_address_format_id = 2 (USA)

billing_address_format_id = 2 (USA)

 

BUT

 

delivery_address_format_id = 0 (It is supposed to be "2" like the others)

 

If I go in and manually change the variable to 2, everything is great, but it is not receiving the variable properly. Help! Appreciate you all!

 

Scott (olsonsp4c)

Share this post


Link to post
Share on other sites

OK! I found a dirty hack that fixes the problem. However, this is a bandaid temporary fix that will not due if I need to service international customers. Does anybody have other thoughts?

 

Scott

Share this post


Link to post
Share on other sites

×