Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Problem with setting up PayPal in Admin

joemurray

By joemurray
in Other

 Share

Recommended Posts

joemurray

joemurray

Posted
Posted

God this is frustrating. I have never had a problem with this (I've had to reinstall osc a billion times now it seems due to certain things going crazy). I just did a fresh install of oscommerce. I went straight to the admin and installed the paypal module. I choose 'edit'. I enter my paypal email address in the space provided. But everytime I update the information and select 'update', it still keeps the default email address of '[email protected]'. Why is this happening? Is there a way I can install this manually without using admin? This is driving me absolutely insane.

Link to comment
Share on other sites
joemurray

joemurray

Posted
  • Author
Posted (edited)
God this is frustrating. I have never had a problem with this (I've had to reinstall osc a billion times now it seems due to certain things going crazy). I just did a fresh install of oscommerce. I went straight to the admin and installed the paypal module. I choose 'edit'. I enter my paypal email address in the space provided. But everytime I update the information and select 'update', it still keeps the default email address of '[email protected]'. Why is this happening? Is there a way I can install this manually without using admin? This is driving me absolutely insane.

 

This is also happening with ALL of the "modules" options. Every other category in the admin will update as normal except for payment modules. Anyone know what's going on?

Edited by joemurray
Link to comment
Share on other sites
satish

satish

Posted
Posted

check db configuration table and check paypal and this value in some field.

Edit it using PhpMyAdmin.

 

 

Satish

 

 

This is also happening with ALL of the "modules" options. Every other category in the admin will update as normal except for payment modules. Anyone know what's going on?

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites
joemurray

joemurray

Posted
  • Author
Posted
check db configuration table and check paypal and this value in some field.

Edit it using PhpMyAdmin.

Satish

 

On your advice I checked the configuration table. Heres the paypal info that I found:

 

67 Installed Modules MODULE_PAYMENT_INSTALLED paypal.php List of payment module filenames separated by a se... 6 0 2006-09-07 08:02:55 2006-09-07 07:37:02 NULL NULL

Link to comment
Share on other sites
joemurray

joemurray

Posted
  • Author
Posted

Is there something I can do in paypal.php to configure it?

 

<?php
/*
 $Id: paypal.php,v 1.39 2003/01/29 19:57:15 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 class paypal {
var $code, $title, $description, $enabled;

// class constructor
function paypal() {
  global $order;

  $this->code = 'paypal';
  $this->title = MODULE_PAYMENT_PAYPAL_TEXT_TITLE;
  $this->description = MODULE_PAYMENT_PAYPAL_TEXT_DESCRIPTION;
  $this->sort_order = MODULE_PAYMENT_PAYPAL_SORT_ORDER;
  $this->enabled = ((MODULE_PAYMENT_PAYPAL_STATUS == 'True') ? true : false);

  if ((int)MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID > 0) {
	$this->order_status = MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID;
  }

  if (is_object($order)) $this->update_status();

  $this->form_action_url = 'https://secure.paypal.com/cgi-bin/webscr';
}

// class methods
function update_status() {
  global $order;

  if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_ZONE > 0) ) {
	$check_flag = false;
	$check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id");
	while ($check = tep_db_fetch_array($check_query)) {
	  if ($check['zone_id'] < 1) {
		$check_flag = true;
		break;
	  } elseif ($check['zone_id'] == $order->billing['zone_id']) {
		$check_flag = true;
		break;
	  }
	}

	if ($check_flag == false) {
	  $this->enabled = false;
	}
  }
}

function javascript_validation() {
  return false;
}

function selection() {
  return array('id' => $this->code,
			   'module' => $this->title);
}

function pre_confirmation_check() {
  return false;
}

function confirmation() {
  return false;
}

function process_button() {
  global $order, $currencies, $currency;

  if (MODULE_PAYMENT_PAYPAL_CURRENCY == 'Selected Currency') {
	$my_currency = $currency;
  } else {
	$my_currency = substr(MODULE_PAYMENT_PAYPAL_CURRENCY, 5);
  }
  if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD'))) {
	$my_currency = 'USD';
  }
  $process_button_string = tep_draw_hidden_field('cmd', '_xclick') .
						   tep_draw_hidden_field('business', MODULE_PAYMENT_PAYPAL_ID) .
						   tep_draw_hidden_field('item_name', STORE_NAME) .
						   tep_draw_hidden_field('amount', number_format(($order->info['total'] - $order->info['shipping_cost']) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) .
						   tep_draw_hidden_field('shipping', number_format($order->info['shipping_cost'] * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) .
						   tep_draw_hidden_field('currency_code', $my_currency) .
						   tep_draw_hidden_field('return', tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL')) .
						   tep_draw_hidden_field('cancel_return', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'));

  return $process_button_string;
}

function before_process() {
  return false;
}

function after_process() {
  return false;
}

function output_error() {
  return false;
}

function check() {
  if (!isset($this->_check)) {
	$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_PAYPAL_STATUS'");
	$this->_check = tep_db_num_rows($check_query);
  }
  return $this->_check;
}

function install() {
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?', '6', '3', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[email protected]', 'The e-mail address to use for the PayPal service', '6', '4', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Selected Currency', 'The currency to use for credit card transactions', '6', '6', 'tep_cfg_select_option(array(\'Selected Currency\',\'Only USD\',\'Only CAD\',\'Only EUR\',\'Only GBP\',\'Only JPY\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Payment Zone', 'MODULE_PAYMENT_PAYPAL_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Set Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())");
}

function remove() {
  tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
}

function keys() {
  return array('MODULE_PAYMENT_PAYPAL_STATUS', 'MODULE_PAYMENT_PAYPAL_ID', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'MODULE_PAYMENT_PAYPAL_ZONE', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER');
}
 }
?>

Link to comment
Share on other sites
satish

satish

Posted
Posted

'MODULE_PAYMENT_PAYPAL_ID' this value will have you@your....

 

change it in configuration table to what you want using Phpyadmin or any other way.

 

 

or uninstall the module.

 

Then check this in the module

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[email protected]', 'The e-mail address to use for the PayPal service', '6', '4', now())");

change '[email protected]' to your email id and reinstall.

 

 

 

 

Satish Mantri

 

 

 

 

Is there something I can do in paypal.php to configure it?

 

<?php
/*
 $Id: paypal.php,v 1.39 2003/01/29 19:57:15 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 class paypal {
var $code, $title, $description, $enabled;

// class constructor
function paypal() {
  global $order;

  $this->code = 'paypal';
  $this->title = MODULE_PAYMENT_PAYPAL_TEXT_TITLE;
  $this->description = MODULE_PAYMENT_PAYPAL_TEXT_DESCRIPTION;
  $this->sort_order = MODULE_PAYMENT_PAYPAL_SORT_ORDER;
  $this->enabled = ((MODULE_PAYMENT_PAYPAL_STATUS == 'True') ? true : false);

  if ((int)MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID > 0) {
	$this->order_status = MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID;
  }

  if (is_object($order)) $this->update_status();

  $this->form_action_url = 'https://secure.paypal.com/cgi-bin/webscr';
}

// class methods
function update_status() {
  global $order;

  if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_ZONE > 0) ) {
	$check_flag = false;
	$check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id");
	while ($check = tep_db_fetch_array($check_query)) {
	  if ($check['zone_id'] < 1) {
		$check_flag = true;
		break;
	  } elseif ($check['zone_id'] == $order->billing['zone_id']) {
		$check_flag = true;
		break;
	  }
	}

	if ($check_flag == false) {
	  $this->enabled = false;
	}
  }
}

function javascript_validation() {
  return false;
}

function selection() {
  return array('id' => $this->code,
			   'module' => $this->title);
}

function pre_confirmation_check() {
  return false;
}

function confirmation() {
  return false;
}

function process_button() {
  global $order, $currencies, $currency;

  if (MODULE_PAYMENT_PAYPAL_CURRENCY == 'Selected Currency') {
	$my_currency = $currency;
  } else {
	$my_currency = substr(MODULE_PAYMENT_PAYPAL_CURRENCY, 5);
  }
  if (!in_array($my_currency, array('CAD', 'EUR', 'GBP', 'JPY', 'USD'))) {
	$my_currency = 'USD';
  }
  $process_button_string = tep_draw_hidden_field('cmd', '_xclick') .
						   tep_draw_hidden_field('business', MODULE_PAYMENT_PAYPAL_ID) .
						   tep_draw_hidden_field('item_name', STORE_NAME) .
						   tep_draw_hidden_field('amount', number_format(($order->info['total'] - $order->info['shipping_cost']) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) .
						   tep_draw_hidden_field('shipping', number_format($order->info['shipping_cost'] * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency))) .
						   tep_draw_hidden_field('currency_code', $my_currency) .
						   tep_draw_hidden_field('return', tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL')) .
						   tep_draw_hidden_field('cancel_return', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'));

  return $process_button_string;
}

function before_process() {
  return false;
}

function after_process() {
  return false;
}

function output_error() {
  return false;
}

function check() {
  if (!isset($this->_check)) {
	$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_PAYPAL_STATUS'");
	$this->_check = tep_db_num_rows($check_query);
  }
  return $this->_check;
}

function install() {
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?', '6', '3', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[email protected]', 'The e-mail address to use for the PayPal service', '6', '4', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Selected Currency', 'The currency to use for credit card transactions', '6', '6', 'tep_cfg_select_option(array(\'Selected Currency\',\'Only USD\',\'Only CAD\',\'Only EUR\',\'Only GBP\',\'Only JPY\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Payment Zone', 'MODULE_PAYMENT_PAYPAL_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Set Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())");
}

function remove() {
  tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
}

function keys() {
  return array('MODULE_PAYMENT_PAYPAL_STATUS', 'MODULE_PAYMENT_PAYPAL_ID', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'MODULE_PAYMENT_PAYPAL_ZONE', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER');
}
 }
?>

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

Hi,

 

I'm New to OsCommerce, and I'm have trouble enabling PayPal....

 

I have installed the PayPal module but I can't choose PayPal as a method of payment in the check out...

It's not there to choose, :blink: See screen shot below...

 

Any help on this would be great. :D

 

P.S. I've checked the database as detailed above, and all is as it should be, with paypal email id etc...

 

Regards,

Chris.

 

 

no_payment_method.JPG

Link to comment
Share on other sites
satish

satish

Posted
Posted

Payment modules are associated with zones.

For Paypal module set Zones to None and it should.

 

Also did you install the paypal module and set it to true.

 

 

Satish

 

Hi,

 

I'm New to OsCommerce, and I'm have trouble enabling PayPal....

 

I have installed the PayPal module but I can't choose PayPal as a method of payment in the check out...

It's not there to choose, :blink: See screen shot below...

 

Any help on this would be great. :D

 

P.S. I've checked the database as detailed above, and all is as it should be, with paypal email id etc...

 

Regards,

Chris.

no_payment_method.JPG

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites
GemRock

GemRock

Posted
Posted

It looks like you have applied the 060817 update. If that's true then there's a 'bug' in that update that may cause this problem. Have a look at the thread 'osCommerce 2.2 Milestone 2 060817 Update Released' under News and Announcements. The 'bug' is in the compatibility.php .

 

Good luck!

 

Ken

 

This is also happening with ALL of the "modules" options. Every other category in the admin will update as normal except for payment modules. Anyone know what's going on?

commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile).

over 20 years of computer programming experience.

Link to comment
Share on other sites
chrisofgcc

chrisofgcc

Posted
Posted

I'm having the same problem as above, and I think I'm going nuts! I've installed the PayPal IPN v 1.3 and enabled it in admin. I change the info and then it reverts to default settings with "[email protected]". It does the same when I just try to install the basic PayPal payment module. This is my fourth osc install and haven't ever had so many problems. I also went into phpmyadmin and looked for the tables that you discuss, Satish, but there was no "MODULE_PAYMENT_PAYPAL_ID" table. Is there some sql that I'm supposed to query in order to set up the ipn? It wasn't in the downloaded file.

 

I feel like I'm beginning to ramble. Any ideas? What php file are you talking about that I should look for and edit manually? Thanks!

 

'MODULE_PAYMENT_PAYPAL_ID' this value will have you@your....

 

change it in configuration table to what you want using Phpyadmin or any other way.

or uninstall the module.

 

Then check this in the module

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[email protected]', 'The e-mail address to use for the PayPal service', '6', '4', now())");

change '[email protected]' to your email id and reinstall.

Satish Mantri

Link to comment
Share on other sites
satish

satish

Posted
Posted

If you look at My reply the table name is TABLE_CONFIGURATION.

The equivalent name for this is defined in database_tables.php and it is generally configuration.

In this table you need to check for the row that has [email protected] and some paypal values.

There you change this email id.This needs to be done thru PhpMyAdmin.

 

Satish Mantri

 

I'm having the same problem as above, and I think I'm going nuts! I've installed the PayPal IPN v 1.3 and enabled it in admin. I change the info and then it reverts to default settings with "[email protected]". It does the same when I just try to install the basic PayPal payment module. This is my fourth osc install and haven't ever had so many problems. I also went into phpmyadmin and looked for the tables that you discuss, Satish, but there was no "MODULE_PAYMENT_PAYPAL_ID" table. Is there some sql that I'm supposed to query in order to set up the ipn? It wasn't in the downloaded file.

 

I feel like I'm beginning to ramble. Any ideas? What php file are you talking about that I should look for and edit manually? Thanks!

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...