Missing Customer Details on Invoice

[azrahn]

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.

[azrahn]

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

Good luck with your shop!

Ronald.

[aeolidia]

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!

[aeolidia]

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

[ronlee67]

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.

[yorkshiregc]

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

[TonyB6]

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

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.