Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

stamps.com module


kalyan.acpl

Recommended Posts

Hi Kalyan,

 

Sorry to hear you’re encountering issues importing orders into Stamps.com. Please see https://stamps.custhelp.com/app/answers/detail/a_id/1218/kw/oscommerce for additional details on importing orders from OsCommerce. If you continue to experience issues, please call the Stamps.com Technical Support Team at 1-888-434-055 (open Monday through Friday, 6am to 6pm PT) so they can help troubleshoot and resolve this issue for you.

 

Hope this information helps! Please let us know if you have additional questions.

 

Thanks!

Divya

Stamps.com

Link to comment
Share on other sites

  • 3 months later...

Hey just wanted to drop a note in case others had the same issue.

 

1) Make sure that your server or hosting plan has SOAP installed.

2) if you make any changes to the shippingZoscommerce.php (ie posting back tracking numbers) make sure that the XML CDATA sent to their "priming servers" is case sensitive.

 

As a side note if you want tracking numbers to be posted back you can do so by:

 

1) create a new entry in your orders table ( via phpmyAdmin or sql ) called

 

usps_track_num varchar(40)

 

 

2) find the function

//prepare $comments & save it
$comments="Shipped on $shipped_on".$Carrier.$Service.", Tracking number $TrackingNumber";

if(OSCOMMERCE_SHIPPED_STATUS_SET_TO_STATUS_3_DELIVERED==1)
{

tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int)$OrderNumber . "', '3', now(), '0', '" . $comments. "')");

//update order status
tep_db_query(" update ".TABLE_ORDERS." set orders_status='3' where orders_id='". (int)$OrderNumber ."'");
}
else
{
tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int)$OrderNumber . "', '".$current_order_status."', now(), '0', '" . $comments. "')");
}
$this->SetXmlMessageResponse($this->wrap_to_xml('UpdateMessage',"Success"));

 

and replace with

//prepare $comments & save it
$comments="Shipped on $shipped_on".$Carrier.$Service.$TrackingNumberString;



if(OSCOMMERCE_SHIPPED_STATUS_SET_TO_STATUS_3_DELIVERED==1)
{

tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
	 (orders_id, orders_status_id, date_added, customer_notified, comments)
	 values ('" . $this->MakeSqlSafe($OrderNumber,1) . "', '3', now(), '0', '" . $this->MakeSqlSafe($comments). "')");

//update order status
 tep_db_query(" update ".TABLE_ORDERS." set orders_status='3' where orders_id='". $this->MakeSqlSafe($OrderNumber,1) ."'");
 tep_db_query(" update ".TABLE_ORDERS." set usps_track_num='". $TrackingNumber."' where orders_id='". $this->MakeSqlSafe($OrderNumber,1) ."'");

}
else
{
 if($current_order_status==1)
 $change_order_status=2;
else if($current_order_status==2)
 $change_order_status=3;
else
 $change_order_status=$current_order_status;


 tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
	 (orders_id, orders_status_id, date_added, customer_notified, comments)
	 values ('" . $this->MakeSqlSafe($OrderNumber,1) . "', '".$change_order_status."', now(), '0', '" . $this->MakeSqlSafe($comments). "')");

 tep_db_query(" update ".TABLE_ORDERS." set orders_status='".$change_order_status."' where orders_id='".$this->MakeSqlSafe($OrderNumber,1)."'");
 tep_db_query(" update ".TABLE_ORDERS." set usps_track_num='". $TrackingNumber."' where orders_id='". $this->MakeSqlSafe($OrderNumber,1) ."'");
}
$this->SetXmlMessageResponse($this->wrap_to_xml('UpdateMessage',"Success"));

 

 

side not to change what it adds to the history change the $comments var.

 

happy coding

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.

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.

×
×
  • Create New...