Missing Customer Details on Invoice

I freshly installed 1.3.8 and moved the database across from an existing website which was using 1.3.6.

Everything works great, except the invoice and the email confirmations are leaving the customer name and address blank for billing and delivery (shipping).

The orders table in the database has all the information. I think the information is just not being passed through to invoice.php properly.

Can somebody help?

url is https://www.valentinewigs.co.uk

Thanks

Richard

Hi,

Did you also upgrade the database from v1.3.6 to v1.3.8?

Ronald.

Hi Azrahn

Yes I upgraded the database to 1.3.8 and manually transferred all the information across from the old 1.3.6 database.

Richard

rikartalex:

Hi Azrahn

Yes I upgraded the database to 1.3.8 and manually transferred all the information across from the old 1.3.6 database.

Richard

Hi.

Let me get this clear.
You upgraded the 1.3.6 to 1.3.8 database and after that you copied the data across, right?

I have copied a database myself last night and had a few issues
For instance, my new database has a different sequence for 1 delivered/2 pending 3 processing etc etc.
So all orders that were delivered suddenly had a status of pending and vice versa.

Hi Ronald

Yes that's what I did but I haven't had the problem with the order sequence changing.

The only issue for me appears to be the missing customer name and address details from the invoice and the email confirmation.

Regards

Richard

Hi Richard,

Maybe you can check the invoice or email confirmation related php files to see if you can find witch table it tries to use for that missing data. I think there must be something missing in your tables.
Did you copy the address_book table?
Ronald.

Hi Ronald

I've checked the tables and they have all the info, it just seems that the file is not reading it properly. The invoice.php file seems fine as well.

Regards

Richard

Hi,

I just made a test order and recieved my confirmation.
The billing and delivery addresses are there and correct.
If you like i can pm them to you.

Ronald.

Hi Roanld

I saw them on the confirmation email and they also appear on the invoice. I am confused!

Thanks for your all your help with this.

Regards

Richard

Hi Ronald

I have worked out why it is doing it now. The address_format_id's are 6 in the orders database table instead of 1. When I manually change them to 1, then the address details appear. I just need to work out why it is doing this now.

Thanks for your help, it is greatly appreciated.

Regards

Richard

Hi Richard,

So only the copied accounts have this problem and not new accounts?
If so, then hopefully you should be able to find a difference between a new account and a copied account.

Maybe you could check MySQL and PHP error logs for more info.

There is a debug tools somewhere in the download section which logs all zencart errors. Maybe that tool can shed some light on the issue.

Hope you find what is going on here.
Ronald.

rikartalex:

Hi Ronald

I have worked out why it is doing it now. The address_format_id's are 6 in the orders database table instead of 1. When I manually change them to 1, then the address details appear. I just need to work out why it is doing this now.

Thanks for your help, it is greatly appreciated.

Regards

Richard

Hi Richard,

Great to hear that you found it.
So it is a little like the problem i had with my db.
Pesky little things like that can be hard to find:frusty:

Good luck with your shop!

Ronald.

Hello,

I just discovered this same problem as well! Everything had been going fine, then we recently got a UK order through PayPal, and no address info was showing in the invoice or packing slip.

I checked the orders table and saw that customers_address_format_id, as well as the other two xx_address_format_id lines were set to 6. When I look in the address_format table, there is no 6. Any idea how to prevent this from happening in the future?

Thanks!

Just checking to see if anyone has any help with this. Let me know where I should start looking, thanks!

Hey guys,

Thanks for the information. I have been receiving orders over the past 3-4 days where the delivery address has been blank. This just started on a very stable install where no modifications have been made in months. It seems to occur on about half of our orders and to date I cannot find anything in common among the orders with errors (such as payment type, etc.).

I found I could use phpMyAdmin to manually enter the data, but that data still did not display in my Zencart Admin panel.

I tried everything to fix it. First I did a restore on the website from backup files saved prior to when the problem began. It was a partial restore of just the admin and includes files. That did not fix it.

Then I contacted my webhost to see if there had been any patches/updates/upgrades to MySql and PHP that might have been incompatible with the ZenCart code (v3.8.1a). The host reported no changes for quite some time.

At this point I was completely at a loss as to what was going on until I read this thread. For whatever reason the address data wasn't stored in the first place, the "delivery_address_format_id" was set as "0" ("2" would be correct for my store.) After manually changing that to "2" my order details in admin began to show the addresses that I manually entered.

I completed a FULL RESTORE of the files tonight and hopefully that will get the new orders to save all the data. If not, at least I know to start looking for where the address_format_ids and the delivery name and address are processed. You saved me a bunch of time as I'm sure the format id's would have been the last thing for me to check.

I have this same problem and im using 1.3.8?

I have recently changed the country's to:
England GB GBR
Northern Ireland IR IRE
Republic of Ireland IR IRE
Scotland GB GBR
Wales GB GBR

Could this be messing the system up? All are set to Address 6?

Cheers

azrahn:

Hi Richard,

Great to hear that you found it.
So it is a little like the problem i had with my db.
Pesky little things like that can be hard to find:frusty:

Good luck with your shop!

Ronald.

Had a similar problem where by all the invoice, billing and delivery details were failing to show on the invoices/packing slip and indeed the customers_address_format_id was being set to 6. To resolve the problem I restored the address_format table from a back up as it wasn't allowing me to browse the table by saying it was empty.