TheJackal

I believe it is not getting data from the rates table. Did you load the data in the rates table correctly?

I have just created a crude USA international zones version. (shipping from USA to other countries only) Let me know if anybody is interested and I will try post in contributions.

For everyone's info, FedEx has officially ended API support today. If you have SOAP problem or any issues with web services and you are in USA, you still have one option: using the local zone rates contribution: http://addons.oscommerce.com/info/490

For those who got a '556' error: There are no valid services available. Just change the shipper State/Province data field (in admin panel) to a 2 character state format for e.g. "CA" instead of "California". Great module!

That's great news! Looking forward to it!

It's either 'Ground' or 'Home Delivery' depending on your 'company' field. If you key in something in the company field when checking out, 'Ground' will appear and 'Home delivery' will not.

Hi All, Need to ask for some ideas as I am stumped. My installation worked for over 5 years..and for some reason, it throws up an upload error. After I choose the file, and click insert, it says File uploaded. Temporary filename: User filename: EPBAC111.txt Size: 0 The file just won't upload. I've checked the epconfigure.php settings and temp folder and the file is not there. The temp folder is 777 permission. If I ftp manually, everything is good to go. Would be grateful if anyone has any idea to solve the upload error.

No, it's not supposed to work that way. It's definitely a bug somewhere (either in your installation or this code).

Warning: The current contribution APIs will not work after May 31, 2012. Please see: http://fedex.com/us/developer/product/migration.html If anyone is working or would like to work on the migration, would appreciate if you post here so that we can support each other. Thanks.

Just wanted to share a bugfix by bitingenious: ========================================== The site I'm working on is US only, so if anyone entered a letter or other character into the shipping zip code field the site will crash: "1054 - Unknown column '8090B' in 'where clause' SELECT * FROM fedex_pcode_to_zone_xref WHERE 8090B >= pcode_from and 8090B <= pcode_to " I fixed it by changing line 60 in "includes/modules/shipping/fedexzipzones.php" to: if (( $zip == '' ) || ( preg_match("/D/", $zip) )) { this detects any non numeric characters and then exits through the normal error system.

1. To remove the series of dots, make sure in the 1st line of the csv files, there is no other characters after the name of the service, e.g. change 'Fedex 2nd day,,,,,,' to 'Fedex 2nd day' 2. Haven't have time to investigate this 3. This feature is not implemented in the current version 4. Use fedex.com and compare the rates.

1. Data is from the shopping cart weight 2. To selectively turn off states, you need to add the following code: // Refuse shipping if the following zip codes matches if ($order->delivery['zone_id'] == 'xxx' || $order->delivery['zone_id'] == 'xxx' || $order->delivery['zone_id'] == 'xxx') { return $this->quotes; } after if ( $zone_id == '' ){ // something is wrong, we didn't find any zone $this->quotes['error'] = MODULE_SHIPPING_FEDEXZIPZONES_NO_ZONE_FOUND; return $this->quotes; } replacing the xxx above with the zone_id with the states you don't ship to. For the exact list of zone_id, look at the OSCommerce zone table in the database.

Hi, I have just uploaded the 2008 rate tables in v3.1.1. The rates have been heavily revised upwards from the previous 2006 tables. Highly recommend that you run the upgrade. Goto the contribution at http://addons.oscommerce.com/info/490 to get it. The install html file is also updated with the new fuel surcharge link location. It's very simple to upgrade for existing users: - Backup your database - Copy catalog/admin/buildfedexdata.php - Copy all the csvs from catalog/admin/fedex_local/ - Run catalog/admin/buildfedexdata.php That's it.

woopie! I am looking forward to it. Many thanks for the great support and work! By the way, would 1.0 have the option of just express checkout without paypal direct? It will save some money for people like me who don't need Paypal direct.

I have a small but weird issue in Express Checkout. A customer reported about using Credit Card (instead of PayPal account balance) and when it reaches the confirm screen, it throws an error. It happens to only 1 in 10+ cases. The address is confirmed and the delivery address matches the credit card. Anyone else getting this error? I was wondering whether it is a PayPal fault or a profile settings issue? The admin settings are 'Yes' for verified accounts and confirmed address. *puzzled*

Essentially, the label is just a .png. Try changing the browser settings such as margins, scaling etc until it works. If you still can't get it right, try another browser. It prints perfectly on mine. I use firefox.

I tried your way initially . But I ran into the problem of trying to match the address correctly. Eg 7th St vs 7th Street etc. So I decided to overwrite the default address instead to simplify things. But yes, your method should be more comprehensive. Yes, I confirm that I am getting the contact number 100% of the time so far in Production and Sandbox.

Hint: Go to the 1st post and look under the author's signature. ;)

Maybe the message is too big. I think most people do not like long code on the forum..so I will paste only ec_step2 function of paypal_wpp.php: The changes have "Bug 0.92" comments. Do a diff to see all the changes. function ec_step2() { global $_GET, $_SESSION, $customer_id, $customer_first_name, $language; global $customer_default_address_id, $sendto; global $customer_default_address_id, $billto; // Bug 0.92 Empty billing address for change //Visitor just came back from PayPal and so we collect all the info returned, create an account if necessary, //then log them in, and then send them to checkout_shipping.php. What a long, strange trip it's been. if ($_SESSION['paypal_ec_token'] == '') { if (isset($_GET['token'])) { $_SESSION['paypal_ec_token'] = $_GET['token']; } else { $this->away_with_you(MODULE_PAYMENT_PAYPAL_DP_INVALID_RESPONSE, true); } } //Make sure the token is in the correct format if (!ereg("([C-E]{2})-([A-Z0-9]{17})", $_SESSION['paypal_ec_token'])) { $this->away_with_you(MODULE_PAYMENT_PAYPAL_DP_INVALID_RESPONSE, true); } $token_info = array('PAYPAL_TOKEN' => $_SESSION['paypal_ec_token']); $response = $this->wpp_execute_transaction('getExpressCheckoutDetails', $token_info); if(!is_array($response) || ($response['GetExpressCheckoutDetailsResponse'][0]['Ack'] != 'Success' && $response['GetExpressCheckoutDetailsResponse'][0]['Ack'] != 'SuccessWithWarning')) { if ($this->enableDebugging == '1') { tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'PayPal Error Dump', "In function: ec_step2()\r\n\r\n" . var_dump($response), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } $this->away_with_you(MODULE_PAYMENT_PAYPAL_DP_GEN_ERROR . $this->return_transaction_errors($response['GetExpressCheckoutDetailsResponse'][0]['Errors']), true); } else { $payer_info = $response['GetExpressCheckoutDetailsResponse'][0]['GetExpressCheckoutDetailsResponseDetails'][0]['PayerInfo'][0]; $payer_contactphone = $response['GetExpressCheckoutDetailsResponse'][0]['GetExpressCheckoutDetailsResponseDetails'][0]['ContactPhone']; //Bug 0.92 if(MODULE_PAYMENT_PAYPAL_DP_REQ_VERIFIED == 'Yes' && strtolower($payer_info['PayerStatus']) != 'verified') { $this->away_with_you(MODULE_PAYMENT_PAYPAL_DP_TEXT_UNVERIFIED, true); } tep_session_register('paypal_ec_payer_id'); $_SESSION['paypal_ec_payer_id'] = $payer_info['PayerID']; tep_session_register('paypal_ec_payer_info'); //To ensure there is always value in telephone field, default to your store's number $paypal_phone = '1234567890';//Bug 0.92 if ($payer_contactphone != '') $paypal_phone = $payer_contactphone; $_SESSION['paypal_ec_payer_info'] = array( 'payer_id' => $payer_info['PayerID'], 'payer_email' => $payer_info['Payer'], 'payer_firstname' => $payer_info['PayerName'][0]['FirstName'], 'payer_lastname' => $payer_info['PayerName'][0]['LastName'], 'payer_business' => $payer_info['PayerBusiness'], 'payer_status' => $payer_info['PayerStatus'], 'ship_owner' => $payer_info['Address'][0]['AddressOwner'], 'ship_name' => $payer_info['Address'][0]['Name'], 'ship_street_1' => $payer_info['Address'][0]['Street1'], 'ship_street_2' => $payer_info['Address'][0]['Street2'], 'ship_city' => $payer_info['Address'][0]['CityName'], 'ship_state' => $payer_info['Address'][0]['StateOrProvince'], 'ship_postal_code' => $payer_info['Address'][0]['PostalCode'], 'ship_country' => $payer_info['Address'][0]['Country'], 'ship_country_name' => $payer_info['Address'][0]['CountryName'], 'ship_phone' => $paypal_phone, 'ship_address_status' => $payer_info['Address'][0]['AddressStatus']); //Get the customer's country ID. $country_query = tep_db_query("SELECT countries_id, address_format_id FROM ".TABLE_COUNTRIES." WHERE countries_name = '".$_SESSION['paypal_ec_payer_info']['ship_country_name']."' LIMIT 1"); if (tep_db_num_rows($country_query) > 0) { $country = tep_db_fetch_array($country_query); $country_id = $country['countries_id']; $address_format_id = $country['address_format_id']; } else { $country_id = ''; $address_format_id = '2'; //2 is the American format } $states_query = tep_db_query("SELECT zone_id FROM ".TABLE_ZONES." WHERE zone_code = '".$_SESSION['paypal_ec_payer_info']['ship_state']."' AND zone_country_id = '".$country_id."' LIMIT 1"); if (tep_db_num_rows($states_query) > 0) { $states = tep_db_fetch_array($states_query); $state_id = $states['zone_id']; } else { $state_id = ''; } $order->customer['name'] = $_SESSION['paypal_ec_payer_info']['payer_firstname'] . ' ' . $_SESSION['paypal_ec_payer_info']['payer_lastname']; $order->customer['company'] = $_SESSION['paypal_ec_payer_info']['payer_business']; $order->customer['street_address'] = $_SESSION['paypal_ec_payer_info']['ship_street_1']; $order->customer['suburb'] = $_SESSION['paypal_ec_payer_info']['ship_street_2']; $order->customer['city'] = $_SESSION['paypal_ec_payer_info']['ship_city']; $order->customer['postcode'] = $_SESSION['paypal_ec_payer_info']['ship_postal_code']; $order->customer['state'] = $_SESSION['paypal_ec_payer_info']['ship_state']; $order->customer['country'] = $_SESSION['paypal_ec_payer_info']['ship_country_name']; $order->customer['format_id'] = $address_format_id; $order->customer['email_address'] = $_SESSION['paypal_ec_payer_info']['payer_email']; $order->customer['telephone'] = $_SESSION['paypal_ec_payer_info']['ship_phone']; //For some reason, $order->billing gets erased between here and checkout_confirmation.php $order->billing['name'] = $_SESSION['paypal_ec_payer_info']['payer_firstname'] . ' ' . $_SESSION['paypal_ec_payer_info']['payer_lastname']; $order->billing['company'] = $_SESSION['paypal_ec_payer_info']['payer_business']; $order->billing['street_address'] = $_SESSION['paypal_ec_payer_info']['ship_street_1']; $order->billing['suburb'] = $_SESSION['paypal_ec_payer_info']['ship_street_2']; $order->billing['city'] = $_SESSION['paypal_ec_payer_info']['ship_city']; $order->billing['postcode'] = $_SESSION['paypal_ec_payer_info']['ship_postal_code']; $order->billing['state'] = $_SESSION['paypal_ec_payer_info']['ship_state']; $order->billing['country'] = $_SESSION['paypal_ec_payer_info']['ship_country_name']; $order->billing['format_id'] = $address_format_id; /*Disabled for now //If they selected an address on PayPal's site with a different zipcode than was previously selected //send them back to the shipping page if ($order->delivery['postcode'] == $_SESSION['paypal_ec_payer_info']['ship_postal_code']) { $goto_shipping = false; } else { $goto_shipping = true; } */ $order->delivery['name'] = $_SESSION['paypal_ec_payer_info']['payer_firstname'] . ' ' . $_SESSION['paypal_ec_payer_info']['payer_lastname']; $order->delivery['company'] = $_SESSION['paypal_ec_payer_info']['payer_business']; $order->delivery['street_address'] = $_SESSION['paypal_ec_payer_info']['ship_street_1']; $order->delivery['suburb'] = $_SESSION['paypal_ec_payer_info']['ship_street_2']; $order->delivery['city'] = $_SESSION['paypal_ec_payer_info']['ship_city']; $order->delivery['postcode'] = $_SESSION['paypal_ec_payer_info']['ship_postal_code']; $order->delivery['state'] = $_SESSION['paypal_ec_payer_info']['ship_state']; $order->delivery['country'] = $_SESSION['paypal_ec_payer_info']['ship_country_name']; $order->delivery['format_id'] = $address_format_id; if (!tep_session_is_registered('paypal_ec_temp')) tep_session_register('paypal_ec_temp'); if (tep_session_is_registered('customer_first_name') && tep_session_is_registered('customer_id')) { //They're logged in, so forward them straight to checkout_shipping.php $order->customer['id'] = $customer_id; //there's a bug here //if logged in, and paypal address is different from addr book default, change the addr book entry /* Bug in 0.92 It is wrong to assume that the default address in Oscommerce is correct when customer is logged in coz PayPal customer could have chosen another delivery address from PayPal */ //if logged in, and paypal address is different from addr book default, change the addr book entry //get customer id $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_paypal_payerid, customers_paypal_ec, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $check_customer = tep_db_fetch_array($check_customer_query); if (tep_db_num_rows($check_customer_query) > 0) { $default_address_customer_id = $check_customer['customers_default_address_id']; //get address $check_address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where address_book_id = '" . (int)$default_address_customer_id . "'"); $check_address = tep_db_fetch_array($check_address_query); if (tep_db_num_rows($check_address_query) > 0) { if (strcasecmp($check_address['entry_street_address'], $_SESSION['paypal_ec_payer_info']['ship_street_1']) != 0) { //Update database address book with Paypal address if different $sql_data_array = array('customers_id' => (int)$check_customer['customers_id'], 'entry_firstname' => $_SESSION['paypal_ec_payer_info']['payer_firstname'], 'entry_lastname' => $_SESSION['paypal_ec_payer_info']['payer_lastname'], 'entry_street_address' => $_SESSION['paypal_ec_payer_info']['ship_street_1'], 'entry_suburb' => $_SESSION['paypal_ec_payer_info']['ship_street_2'], 'entry_city' => $_SESSION['paypal_ec_payer_info']['ship_city'], 'entry_zone_id' => $state_id, 'entry_postcode' => $_SESSION['paypal_ec_payer_info']['ship_postal_code'], 'entry_country_id' => $country_id); tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "address_book_id = '" . (int)$default_address_customer_id . "'"); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$default_address_customer_id . "' where customers_id = '" . (int)$check_customer['customers_id'] . "'"); $address_id = $default_address_customer_id; $customer_default_address_id = $default_address_customer_id; if (tep_session_is_registered('shipping')) tep_session_unregister('shipping'); //required? } } } //end if (!tep_session_is_registered('sendto')) tep_session_register('sendto'); $_SESSION['sendto'] = $customer_default_address_id; $_SESSION['paypal_ec_temp'] = false; // Bug 0.92 Empty Billing Address $billto = $_SESSION['billto'] = $customer_default_address_id; if (!tep_session_is_registered('billto')) tep_session_register('billto'); // End $this->away_with_you(); /*disabled for now //0.6.2b modification. If they already have a shipping amount calculated for this zip code, send them on instead of backwards if ($goto_shipping) { $this->away_with_you(); } else { $this->away_with_you('', false, FILENAME_CHECKOUT_CONFIRMATION); } */ } else { //They're not logged in. Create an account if necessary, and then log them in. //First, see if they're an existing customer //If Paypal didn't send an email address, something went wrong if (trim($_SESSION['paypal_ec_payer_info']['payer_email']) == '') $this->away_with_you(MODULE_PAYMENT_PAYPAL_DP_INVALID_RESPONSE, true); $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_paypal_payerid, customers_paypal_ec from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($_SESSION['paypal_ec_payer_info']['payer_email']) . "'"); $check_customer = tep_db_fetch_array($check_customer_query); if (tep_db_num_rows($check_customer_query) > 0) { $check_customer = tep_db_fetch_array($check_customer_query); $acct_exists = true; if ($check_customer['customers_paypal_ec'] == '1') { //Delete the existing temporary account $this->ec_delete_user($check_customer['customers_id']); $acct_exists = false; } } //Create an account if (!$acct_exists) { //Generate a random-looking 8-char password $salt = "46z3haZzegmn676PA3rUw2vrkhcLEn2p1c6gf7vp2ny4u3qqfqBh5j6kDhuLmyv9xf"; srand((double)microtime()*1000000); $password = ''; for ($x = 0; $x < 7; $x++) { $num = rand() % 33; $tmp = substr($salt, $num, 1); $password = $password . $tmp; } $sql_data_array = array('customers_firstname' => $_SESSION['paypal_ec_payer_info']['payer_firstname'], 'customers_lastname' => $_SESSION['paypal_ec_payer_info']['payer_lastname'], 'customers_email_address' => $_SESSION['paypal_ec_payer_info']['payer_email'], 'customers_telephone' => $_SESSION['paypal_ec_payer_info']['ship_phone'], 'customers_fax' => '', 'customers_newsletter' => '0', 'customers_password' => tep_encrypt_password($password), 'customers_paypal_payerid' => $_SESSION['paypal_ec_payer_id']); tep_db_perform(TABLE_CUSTOMERS, $sql_data_array); $customer_id = tep_db_insert_id(); $sql_data_array = array('customers_id' => $customer_id, 'entry_firstname' => $_SESSION['paypal_ec_payer_info']['payer_firstname'], 'entry_lastname' => $_SESSION['paypal_ec_payer_info']['payer_lastname'], 'entry_street_address' => $_SESSION['paypal_ec_payer_info']['ship_street_1'], 'entry_suburb' => $_SESSION['paypal_ec_payer_info']['ship_street_2'], 'entry_city' => $_SESSION['paypal_ec_payer_info']['ship_city'], 'entry_zone_id' => $state_id, 'entry_postcode' => $_SESSION['paypal_ec_payer_info']['ship_postal_code'], 'entry_country_id' => $country_id); tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $address_id = tep_db_insert_id(); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'"); tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())"); if (MODULE_PAYMENT_PAYPAL_DP_NEW_ACCT_NOTIFY == 'Yes') { require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT); $email_text = sprintf(EMAIL_GREET_NONE, $_SESSION['paypal_ec_payer_info']['payer_firstname']) . EMAIL_WELCOME . EMAIL_TEXT; $email_text .= EMAIL_EC_ACCOUNT_INFORMATION . "Username: " . $_SESSION['paypal_ec_payer_info']['payer_email'] . "\nPassword: " . $password . "\n\n"; $email_text .= EMAIL_CONTACT; tep_mail($_SESSION['paypal_ec_payer_info']['payer_firstname'] . " " . $_SESSION['paypal_ec_payer_info']['payer_lastname'], $_SESSION['paypal_ec_payer_info']['payer_email'], EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $_SESSION['paypal_ec_temp'] = false; } else { //Make it a temporary account that'll be deleted once they've checked out tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_paypal_ec = '1' WHERE customers_id = '" . (int)$customer_id . "'"); $_SESSION['paypal_ec_temp'] = True; } } else { $_SESSION['paypal_ec_temp'] = false; } /* Bug in 0.92 It is wrong to assume that the default address in Oscommerce is correct when customer is not logged in and account exists in OSCommerce coz PayPal customer could have chosen another delivery address from PayPal */ //get customer id $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_paypal_payerid, customers_paypal_ec, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($_SESSION['paypal_ec_payer_info']['payer_email']) . "'"); $check_customer = tep_db_fetch_array($check_customer_query); if (tep_db_num_rows($check_customer_query) > 0) { $default_address_customer_id = $check_customer['customers_default_address_id']; //get address $check_address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where address_book_id = '" . (int)$default_address_customer_id . "'"); $check_address = tep_db_fetch_array($check_address_query); if (tep_db_num_rows($check_address_query) > 0) { if (strcasecmp($check_address['entry_street_address'], $_SESSION['paypal_ec_payer_info']['ship_street_1']) != 0) { //Update database address book with Paypal address if different $sql_data_array = array('customers_id' => (int)$check_customer['customers_id'], 'entry_firstname' => $_SESSION['paypal_ec_payer_info']['payer_firstname'], 'entry_lastname' => $_SESSION['paypal_ec_payer_info']['payer_lastname'], 'entry_street_address' => $_SESSION['paypal_ec_payer_info']['ship_street_1'], 'entry_suburb' => $_SESSION['paypal_ec_payer_info']['ship_street_2'], 'entry_city' => $_SESSION['paypal_ec_payer_info']['ship_city'], 'entry_zone_id' => $state_id, 'entry_postcode' => $_SESSION['paypal_ec_payer_info']['ship_postal_code'], 'entry_country_id' => $country_id); tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "address_book_id = '" . (int)$default_address_customer_id . "'"); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$default_address_customer_id . "' where customers_id = '" . (int)$check_customer['customers_id'] . "'"); //$address_id = $default_address_customer_id; if (tep_session_is_registered('shipping')) tep_session_unregister('shipping'); //required? } $address_id = $default_address_customer_id; } } //End Bug 0.92 $sendto = $address_id; if (!tep_session_is_registered('sendto')) tep_session_register('sendto'); // Bug 0.92 Empty Billing Address tep_session_unregister('billto'); $billto = $address_id; if (!tep_session_is_registered('billto')) tep_session_register('billto'); // End $this->user_login($_SESSION['paypal_ec_payer_info']['payer_email']); } } }

The changes are quite simple and all contained in the paypal_wpp.php file. However, I thought it is more appropriate for Dynamo himself to update since he is still actively supporting this module. Strange, the error messages are appearing correctly on mine.

Just implemented the module and thanks Dynamo for the fabulous contribution!! I've corrected few bugs in version 0.92 such as: 1. Change of address in PayPal doesn't get propagated to the final checkout screen (only temporarily in shipping screen) 2. Billing address is blank 3. Phone number doesn't get propagated I will send my changes to Dynamo for his consideration in the next version. Many thanks again for the great contribution and support rendered!!

Use FedEx automated labels contribution: http://addons.oscommerce.com/info/2244 Support of this forum is at http://www.oscommerce.com/forums/index.php?showtopic=101186

What did not work? Did the test script write correctly to the file?

Hi, I believe it's either a path or permissions problem. 1. if .htaccess is present, temporarily rename your .htaccess to .htaccess1 2. make sure both the permissions on the folder and file is 777 3. if above still fails, you can test your permission or path setting using the following simple 'test writing' script: (paste it to anywhere appropriate) $myfile = "admin/images/fedex/post.txt"; $myfile = DIR_FS_CATALOG . $myfile; $fp = fopen($myfile,"a"); $line="Testing 123"; fputs($fp,$line); fclose($fp); 4. You should see "Testing 123" in post.txt. If not, you know for sure its a path or permissions problem.