No delivery address in email +

[olsonsp4c]

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

[olsonsp4c]

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

[olsonsp4c]

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)

[olsonsp4c]

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