[PayPal is not returning customer extra fields]

Dear All,

 

Using OSC v2.2 and PayPal Website Payments Standard.

 

I live in Singapore and to accommodate the local address format i have added 2 extra customer address field. They are for the house / block number and unit number.

 

Is it possible to get PayPal to return these 2 fields?

 

PayPal also ignore the suburb filed. Is it possible to pass this field to PayPal so that it is return to the order invoice?

 

At the moment, only the "STREET_ADDRESS" field is capture by PayPal and return to the OSCommerce which was record in the successful order invoice.

 

Thank you in advance for your help.

[Products Extra Fields]

I have successful installed the contribution but the "Product Listing" does not display the Product Name instead it display only the product extra field. Is this a norm or do i have to enable the product name display?

[Cool Flash Carousel Menu]

Thanks Sam, it work! B) But after mod the"kampanya.php" as per your contribution, the product price shown was before tax. Have i done some wrong or it it suppose to be without tax?

 

 

To list new products:

 

Find:

 

$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC LIMIT $limit_product_number";
$specials_query = tep_db_query($specials_query_raw);
while ($specials = tep_db_fetch_array($specials_query)) {
if ((!isset($HTTP_GET_VARS['sID']) || (isset($HTTP_GET_VARS['sID']) && ($HTTP_GET_VARS['sID'] == $specials['specials_id']))) && !isset($sInfo)) {
$products_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int)$specials['products_id'] . "'");
$products = tep_db_fetch_array($products_query);
}

 

Replace with:

 

$date = strtotime("-60 days"); // set max age of displayed product
$date = strftime("%Y-%m-%d",$date); 
$specials_query_raw = "select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . $limit_product_number;
$specials_query = tep_db_query($specials_query_raw);
while ($specials = tep_db_fetch_array($specials_query)) {

 

Find:

 

$xmlfile .= "\t\t" . '<product filename="'.$new_image.'" productname="'.$specials['products_name'].'" productprice="'.$kampanya->display_price($specials['specials_new_products_price'],'').'" url="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']). '" />'."\n";

 

Replace with:

 

$xmlfile .= "\t\t" . '<product filename="'.$new_image.'" productname="'.$specials['products_name'].'" productprice="'.($specials['products_price'] > 0 ? $kampanya->display_price($specials['products_price'],'') : 'P.O.A').'" url="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']). '" />'."\n";

 

I`ve not tested, but that should work fine.

 

B)