mikca Posted March 22, 2006 Posted March 22, 2006 I just upgraded a four year old OSC site with the latest OSC. No real problems. I started with a fresh install, moved all our customization over to it, then converted the older DB to the new. There were very few conversions to the new structure. I've since found that older, existing customers and billing data are not populating the orders table after a purchase. The delivery info is in the orders table, the payment information is there (method, type, owner etc), but not the customer data. Newer customers do not have this problem. This problem exists with both paypal and the split number CC module. Did I miss something when I moved the DB over? Where does the ordering module update the order with the customer information? Any ideas?
mikca Posted March 23, 2006 Author Posted March 23, 2006 I just upgraded a four year old OSC site with the latest OSC. No real problems. I started with a fresh install, moved all our customization over to it, then converted the older DB to the new. There were very few conversions to the new structure. I've since found that older, existing customers and billing data are not populating the orders table after a purchase. The delivery info is in the orders table, the payment information is there (method, type, owner etc), but not the customer data. Newer customers do not have this problem. This problem exists with both paypal and the split number CC module. Did I miss something when I moved the DB over? Where does the ordering module update the order with the customer information? Any ideas? Found one more db conversion I missed. In address_book table the old and new db's have address_book_id and customers_id in switched positions resulting in my insertinc cust# into address# and vice versa. Is the address_book where the pending orders queries to obtain the info that's missing, as described above? Still looking for the actual script that updates the pending orders fields in admin. Sam
Recommended Posts
Archived
This topic is now archived and is closed to further replies.