Jump to content

  2. → Viewing Profile: gaspower

Corporate Sponsors


Latest News: (loading..)

gaspower

Member Since 14 Aug 2003
Offline Last Active Yesterday, 23:41
-----

Topics I've Started

Choice Of Payment Method For International Orders

Yesterday, 23:45

Hello,

I was wondering if there is a contribtion or directions to allow international orders to only have Paypal as a payment method? Right now we allow both credit cards and Paypal for orders, but when someone is from outside the US, it defaults to Paypal only. Is this possible?

Thanks JR

UPS XLM Returns Low Rates OSC 2.31

15 December 2011, 22:00

Hello,

I am using UPS XML on OSC 2.31. For some reason the site is returning lower UPS rates, not retail. I do not have the option in the setup to show my rates. I have the tare weight in admin set to zero.

Example of rate return, I shipped a 17lb package, site showed $23.01, but when I went to UPS and entered the same info, it shows $28.93.

Thanks JR

USPS Methods 5.2.2 Incorrect Weight Tare Weight =0

09 December 2011, 22:56

Hello,

Just curious is anyone else is having weight issue in OSC 2.31 and USPS Methods 5.2.2? The system is adding weight at checkout. Sample, I checked out with a 2lb item, at checkout, it shows 2 lbs 3.2oz? I have the Tare Weight set to zero. Any ideas?

Thanks Jr

Why Is Database Not Updating With Admin File

04 December 2011, 16:07

Hello,

I have this file below to do a mass price update for SPPC groups. I am using OSC2.31, but for some reason it is not updating the database tables? I am not getting any errors. If the file looks correct, can the database permissions be set incorrectly?

Thanks JR

<?php
  require('includes/application_top.php');
 
?>
<!DOCTYPE html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="popupcalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'template_top.php'); ?>
<!-- header_eof //-->
 
 
<?php
if (isset($_POST['Update']))
{
	$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
	$sppc_query = tep_db_query($sppc_query_raw);
	while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
 
	 if ($sppc["customers_group_name"] != "Retail"){
//$sppc['customers_group_id']
	$c = "CG_".$sppc['customers_group_id'];
	$tmp = $_POST[$c];
	if ($tmp != 0)
	{
	$p = (100-$_POST[$c])/100;
	tep_db_query("delete from products_groups where customers_group_id = ".$sppc['customers_group_id']);
 
	tep_db_query ("insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p");
	}  //if not 0
	}  //if not Retail
	}
}
 
?>
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
	<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
	</table></td>
<!-- body_text //-->
	<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="pageHeading"><?php echo "Special Pricing Discount Setup"; ?></td>
			<td class="specialPrice" align="right"> </td>
		  </tr>
		</table></td>
	  </tr>
 
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="2">
			  <tr class="dataTableHeadingRow">
				<td class="dataTableHeadingContent" align="left">
				<?php
				if (isset($_POST['Update']))
				{
					echo "<center>Updated!</center>";
				}
				?>
				 </td>
			  </tr>
<?php
 
	$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
	$sppc_query = tep_db_query($sppc_query_raw);
	while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
?>
			  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
				 <td class="dataTableContent" align="left">
				  <?php
				  if ($sppc["customers_group_name"] != "Retail"){
					  echo $sppc["customers_group_name"];
				  }
				  if (isset($_POST['Update']))
				  {
						if ($sppc["customers_group_name"] != "Retail"){
						$c = "CG_".$sppc['customers_group_id'];
						$tmp = $_POST[$c];
						echo " Current Discount is $tmp%" ;
 
						}
				  }
				  ?>
 
				  </td>
			  </tr>
<?php
	 }
?>
		</table></td>
	  </tr>
	  <tr>
	   <td valign="top">
	   <form action="" method="post">
		<table border="0" width="40%" cellspacing="0" cellpadding="2">
			  <tr>
				<td class="smallText" align="left"> </td>
				<td> </td>
			  </tr>
<?php
	$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
	$sppc_query = tep_db_query($sppc_query_raw);
	while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
 
	if ($sppc["customers_group_name"] != "Retail"){
?>
			  <tr>
				<td class="smallText" align="left">Set New Percentage (%) Discount for <?=$sppc["customers_group_name"]?> :</td>
				<td><input name="CG_<?=$sppc['customers_group_id']?>" type="text" size="5" value="0"></td>
			  </tr>
<?php
			  }
	 }
?>
			  <tr>
				<td colspan="2" align="center"><input type="submit" name="Update" value="Update"></td>
			  </tr>
		</table>
		</form>
	   </td>
	  </tr>
	</table></td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Help With Re-size Image In Product_Info OSC 2.31

06 November 2011, 21:57

Hello,

Can someone please explain how to re-size the main image in product_info.php in OSC 2.31. I see the code,

<script type="text/javascript">
$('#piGal ul').bxGallery({
  maxwidth: 300,
  maxheight: 200,
  thumbwidth: <?php echo (($pi_counter > 1) ? '75' : '0'); ?>,
  thumbcontainer: 300,
  load_image: 'ext/jquery/bxGallery/spinner.gif'
});
</script>

All my images are 450x450 pixel. I would like in product_info.php that the be 250x250.

Thanks Jr

  1. osCommerce Support Forum
  2. → Viewing Profile: gaspower
  3. Forum Rules