[Done] Current customers can checkout w/o any address

[Mishko]

Zen Cart 1.3.7.1
PayPal IPN, Zone Rates

Hi, I believe I found a bug within the ordering process that affects customers who currently have accounts. In short, these customers can order without an address. Here's are the details:

Customers with pre-existing accounts are able to checkout using no address. They add an item to their cart, sign in, attempt to checkout and are presented with a comma (,) as their address and $0 shipping fee. No errors stop them from continuing the order process.

It seems that freshly created accounts (add items to cart then create new account) are immune to this. Instead of seeing a comma as their address, these new account holders will see the address that they just finished typing.

My client just alerted me to this yesterday in reference to 2 new orders, but indicated that it has been happening intermittently since ZC install. Some orders do not show names in the summary pages but you can see the name on the individual order page. Many have just 1 or 2 of the 3 addresses inputted (customer, billing, shipping) rather than all 3. One of the new problem orders actually had NO shipping addresses in either 3 locations.

Has anyone else experienced this before? Any ideas on how to ensure that real addresses are required on every order? (Yes, the Minimum Values are all above 0)

[Ajeh]

Clean install or an Upgrade?

When you say create account appears to work ... later ... if you log out of the new account then log back in ... does the new account still work?

It almost sounds like you have some bad data on your old customers table or address_book table that might be causing grief ...

Also, save all settings to Zone Rates zones to NotePad and then REMOVE and INSTALL and reconfigure it ...

Then, save all settings to PayPal IPN to NotePad and then REMOVE, INSTALL and reconfigure it ...

Then, INSTALL the PayPal Express ... and then REMOVE it ... this updates some database changes ...

Now try with a new account then try with an old account ... how does it go ...

[Mishko]

Thank you for the suggestions. I found more info that leads me to believe that this isn't a bug but possibly a problem with the database. This website used to run OSC (which I installed and managed) but then it switched to ZC (installed by someone else; I was not a part of this project at all but I am now cleaning up the mess). At first everything seemed OK with the install, but then the client discovered this ordering/address error. Although the client had never mentioned it, I just found an error in their admin section on the customer pages:

Warning: reset() [function.reset]: Passed variable is not an array or object in .../admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in .../admin/includes/classes/object_info.php on line 30

I searched this on the board and it appears that "This typically happens only when you've got customers in the customers table but no corresponding addresses in the address_book table". Does that sound right? Oddly though, that doesn't appear to be the case:

When looking at a customer's data from the backend (admin/customers.php), it appears as though ALL the old/imported customers have NO addresses on file. However, when I go into the database, I see the addresses in there. For example, I am actually customer ID #1 and I have created 4 test addresses. In address_book, I see all 4 addresses attributed to ID #1 and in customers I see me listed as ID #1. When I log into my account on the front end, I am able to access all 4 of these addresses. Essentially, the address_book_id and customer_id seem to match.

If the data is in the DB, why can't we see it in the admin section?

[DrByte]

If the data is in the DB, why can't we see it in the admin section?

Are the address-id references between both tables fully in sync?

[Mishko]

Well, there are over 1,300 customers so manually going through each one is not really an option. However, I randomly selected some of the old customers and they all the address_book_id and customer_id seem to match. If this is the case (that they are all matching) then what could be causing the problem? Or does that seem unlikely that they all match, given that the database has the info yet it does not show up in the admin section?

Sorry for my slow replies on this everyone; I'm definitely trying to get this issue fixed but am playing telephone a little bit with the clients and the person who installed ZenCart. Thank you for your help so far!

[Taipa]

Are the address-id references between both tables fully in sync?

How do we check this?

I'm having this same problem. When a previous customer makes an order, it skips their address. :/

I did recently upgrade to 1.3.8 from 1.3.7, and everything else works, but I'm not sure what to check for this problem.

[ladyhypnotist]

zencart 1.3.8a from fresh install
addons: group price per item 1.3, custom quantity discounts, template cherry zen, discount preview 138-4, fedex shipping 1.3.7, custom product hiding, edit orders 1.5.3, popup invoice 1.1, google analytics 2.2.1, sales report 104, admin login as customer 2.1
***

I too have been searching to the answer for this for a while (see my post: http://www.zen-cart.com/forum/showthread.php?t=111990).

When I look at the data in the database, the addresses match up with the customers. When the customer checks out, they have addresses in their address book, but the default that shows is blank (just a comma), so they are able to checkout without any customer address or billing address (they need to fill something in for the shipping address in order to get a shipping price).

This is only customers that have been added in to the database from a separate membership program, all of their data copied over into zencart. The membership software people say it's a problem with zencart, since the data is copied over correctly to the database (which it is).

Is there any way to require real addresses for each step? Or make sure the default address is not blank?

Thank you,
Melissa