ezfindit

Figured it out! Located the other query and added the field! $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_id DESC"; Thanks for the tip!

No. I thought the query already pulled all the customer information. Saw the telephone field listed in this query: $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); Is there another query I should modify?

Trying to modify the customers.php file (in admin) to also display the Customer Phone Number in the Summary view (along with First & Last Name, and Account Created fields). I've added the heading in the language file and this code in the /admin/customers.php file: <td class="dataTableContent"><?php echo $customers['customers_telephone']; ?></td> It should work. Unfortunately, when viewing it (in summary view) it shows blank for all customers phone numbers. I'm sure I've missed something. I run osComm 2.3.4. Any thoughts?

Thanks!!!

Yes, only the Order Confirmation email, which, once PayPal App is installed, is sent by the paypal_standard.php file.

Rainer, I have one more question you might be able to help with. In v. 2.2 when an order was placed the State information showed up as the 2 letters abbreviation (CA, NY, etc.) in the order confirmation email (for Delivery and Billing Addresses). In v. 2.3.4 it shows up spelled out fully (California, New York, etc.). I've been looking around to change it back to displaying the 2 letter abbreviation and cannot figure it out. Any ideas where/how I can make the change?

Thank you for the help! Will install and try it out. Thank you also for the quick reply, much appreciated!

Which State Selector Add-on works with osCommerce 2.3.4? I haven't yet migrated to BS.

Thank you! I looked everywhere trying to fix the description also. FYI - I cannot stand how PayPal has re-designed (ugly font choices, poor layout, wasted space, etc.) and re-organized the admin interface in the orders.php file. It SUCKS! They should have left the interface alone and only added the PayPal tab. Instead they messed it up so now it takes us 2-3 more extra clicks to view order information that was all visible in one screen in the osCommerce interface. We're redesigning that whole interface now to fix the idiocy PayPal created! Thanks again Rainer!

Figured out the missing confirmation emails issue! The PayPal App = v5.018 I updated to, does NOT work properly with osCommerce 2.3.4! Uninstalled v5.018 and did a fresh install of PayPal App v5.010, and activated Payments Standard. Updated the PDT token and it worked PERFECTLY!!! Thank you BrockleyJohn for the help with the PDT token needed for the Sandbox testing also. You were a great help!!! Anyone using osComm v. 2.3.4 please DO NOT update PayPal App v5.018!

Order cycle worked with the new Test Account and Test PDT token. Returned back to site with empty Shopping Cart showing. No errors in PayPal. Thank you, Thank you!!! You were right, it was not PayPal App v5.018 that was the issue. However, now have other issues: (1) Test Customer not getting the order notification email. (2) Not getting the 2nd order notification email (SEND_EXTRA_ORDER_EMAILS_TO) to 2nd email account. (3) Order status history shows "Preparing [PayPal Standard]", but customer is not notified (used to say Processing with green checkmark).

Oh, created a new test Business account and was able to login to https://www.sandbox.paypal.com. Woo Hoo! Found the Website preferences (under My Selling Tools)! Reconfiguring and reupdating the information and will run another test.

Oh, ok. Thanks! Can I reuse the same email address or use a different one? I also came across this information on the PayPal site: https://developer.paypal.com/docs/classic/lifecycle/sb_about-accounts/ You can create additional sandbox accounts on the developer site or directly on the sandbox site, https://www.sandbox.paypal.com

I changed the password for the Sandbox (BUSINESS) test account (in Profile area) and tried to login to https://www.sandbox.paypal.com using the test email but it's not recognizing it.

I'm somewhat confused. How is https://developer.paypal.com/developer/accounts/ (where I created test accounts) related to https://www.sandbox.paypal.com (which won't allow me to login)?