I am working with a customer who sells products using a buying club model wherein monthly deliveries to nearby cities go to the residence of a specified buying club member for each city in the network. The club members for that city go to the specified residence to pick up and pay for the orders at specified dates and times.

The standard way of handling this with Zen Cart is for each subscriber to enter the DELIVERY ADDRESS of their local city delivery contact as a secondary address in addition to the primary payment address in their own account. Then they have to select this each time they place an order using the “Change Your Address” button. This is a bit cumbersome and confusing. We are trying to make this as user friendly and idiot proof as possible.

As a solution, my client wants to have a dropdown list in the checkout process (Step 1) so that the user chooses their city from the drop down list and the delivery information for the local contact person automatically appears in the delivery/shipping information fields for that order.

I am guessing this would involve linking the “address_book_id” field for the local delivery person (from the “address_book” table in the DB) to the city for that designated delivery person in the drop down list. Then the appropriate delivery data gets inserted into the shipping/information field automatically. Does this sound plausible? Any suggestions on how to proceed?