Customer Address not showing on order (or through the checkout process)

I moved to a new server, started with a clean install of zencart and then imported the customers and orders from the old server. That was fine until I got to checkout.

Had a few sql errors which I fixed but in order to fix them I had to remove all the customers and orders that I had brought over. Now I have managed to get the customers back but not the orders. Not really a problem but annoying.

But now when I go through the checkout process, the address (both billing and shipping) will not show. The addresses are being recorded in the customer details. The order can be placed and I will receive the order as normal just minus the address details.

So how do I get the address details to show up?

Sounds like you've messed things up by importing one set of customer/order data overtop of another set, and now you're getting mismatches because your data is all out of sync.

You need to go back and fix your import problems -- it needs to import clean before you start taking new orders/customers. The most efficient way is to wipe all the related tables and import the data fresh. Unfortunately that means completely losing all data added since when your data backup was made.

DrByte:

Sounds like you've messed things up by importing one set of customer/order data overtop of another set, and now you're getting mismatches because your data is all out of sync.

You need to go back and fix your import problems -- it needs to import clean before you start taking new orders/customers. The most efficient way is to wipe all the related tables and import the data fresh. Unfortunately that means completely losing all data added since when your data backup was made.

damn that is what I thought and I have already had orders and new customers sign up. - typical!

is there anyway to do this without having to wipe the slate clean?

Yes, but you'll need to manually renumber and renormalize all the data in all the affected tables in order to add all those new records back in after you've fixed the original problem.
That requires careful study of all the database tables, relationships between tables, and database access tools.
If you're not up to it, you might post in Commercial Help Wanted to hire someone after checking their suitability and references.

which database controls the address coming up on the orders? I assume it is customer info?

If you look in the orders table you'll see the address details used when placing that order.
As I said, a careful detailed study of all the data in all the affected tables is ESSENTIAL if you're going to muddle with the data as you've described.

DrByte:

If you look in the orders table you'll see the address details used when placing that order.
As I said, a careful detailed study of all the data in all the affected tables is ESSENTIAL if you're going to muddle with the data as you've described.

Thanks!

Upon further investigation, all customer details are being recorded with each order and can be accessed by the orders table so that part seems to be working.

For some reason these details are not showing up on the orders during checkout, email and admin.

I can't edit the orders to change them from pending to processing to delivered.

Is this still a database error or something in the code?

Sorry I'm totally self taught and learn as I go along and not completely understanding the relationship between the database and zen-cart.

Thank you for patience and all your help while I try to figure this out.

Thought I would let you know that I have managed to solve this problem so if anyone has the same issue in the future, they can look at this and hopefully it will help them out too.

So the problem of the address not showing up on orders was an issue with the ADDRESS FORMAT TABLE.

My first step was to create a test website and create some dummy orders and customers so I could see the database tables as they should be.

Then using the export feature of myphpadmin, I compared the 2 tables (from my store and the test store) and was able to see the mistakes and fix them up.