X-Cart forums - Ability to select shipping carrier for tracking numbers

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Ability to select shipping carrier for tracking numbers (https://forum.x-cart.com/showthread.php?t=9345)

inksticks

09-14-2004 07:51 AM

Ability to select shipping carrier for tracking numbers

X-cart chooses the shipping carrier based and the shipping selection that the customer used when checking out. However, to change the carrier and have the tracking function still work. Here is a mod that will allow you to select which shipping carrier you used: UPS, Fedex, USPS and will associate xcarts tracking functions to the option you selected.

First we need to create a new column in the database xcart_orders. The easiest way to do this is to go to 'Patch/Upgrade' under 'Administration' in your xcart admin. Copy the following in your SQL query(ies): box and click on apply.

Code:

ALTER TABLE xcart_orders 

ADD shipping_vendor char(5) NOT NULL default '' AFTER shippingid;

Then you need to replace the following code in your admin/order.php

Code:

db_query("update $sql_tbl[orders] set tracking='$tracking', notes='$notes', details='".

With this code:

Code:

db_query("update $sql_tbl[orders] set tracking='$tracking', notes='$notes', ".

"shipping_vendor='".$shipping_vendor."', details='".

Then you will need to add a template under 'main' called 'order_shipping_vendor.tpl' containing the following code:

Code:

{* $Id: order_shipping_vendor.tpl,v 1.4 2004/05/28 12:21:03 max Exp $ *}

<SELECT name="shipping_vendor">

{if $status eq ""}<OPTION value="">Select one</OPTION>

{/if}

<OPTION value="FedEx"{if $status eq "FedEx"} selected{/if}>FedEx</OPTION>

<OPTION value="UPS"{if $status eq "UPS"} selected{/if}>UPS</OPTION>

<OPTION value="USPS"{if $status eq "USPS"} selected{/if}>USPS</OPTION>

</SELECT>

Finally you will need to edit template file 'main/history_order.tpl'.

Replace the following:

Code:

{assign var="postal_service" value=$order.shipping|truncate:3:"":true}

With this

Code:

{assign var="postal_service" value=$order.shipping_vendor|truncate:3:"":true}

And add the following:

Code:






Shipping vendor:

{include file="main/order_shipping_vendor.tpl" status=$order.shipping_vendor mode="select" name="shipping_vendor"}

After this line in the main/history_order.tpl

Code:

{include file="main/order_status.tpl" status=$order.status mode="select" name="status"}

After applying this mod when you log in to view your order to enter tracking numbers right above your tracking number box you can select which shipping carrier was used. After applying your changes you will see a 'track it' button at the bottom of the page that allows you to track the shipment.

adpboss

09-14-2004 09:09 AM

Nice mod. I assume this is for 4.0.3.

inksticks

09-14-2004 09:14 AM

version 4.0.3

Yes, it is for 4.0.3.

eleven

09-28-2004 07:23 PM

3.4.11 ?

Do you guys know offhand if this mod will work with 3.4.11? It looks like it's almost a stand-alone mod.

inksticks

09-29-2004 05:47 AM

It was designed for 4.x but you could try on 3.4.11. You should try and post back to the forum your results. I personally have not tried it on 3.4.11.

jimmy_

09-30-2004 11:50 PM

Thank you for this mod, everything seems to be working except the Track It button does not show up.

I was wondering where exactly this track IT button shows up (I assumed it would be on the page around where I chose shipping company, and entered tracking... but I do not see it;(

Any assistance would be greatly appreciated.

Thanks :D

using v4.0.4 X-CART

inksticks

10-01-2004 07:31 AM

The 'track it' button is on the bottom of the 'Order details' page (the same page that you select your shipping carrier and enter your tracking number) You need to select a carrier and enter a tracking number and click apply changes near the bottom of the page. Then go back to the same order again and you will see the 'track it' button at the bottom of the page. Please let me know if you need further assistance.

bluecat

01-08-2005 07:46 PM

I'm using 4.0.9. In your second step, the code doesn't match up and I'm not sure how to change it. Could anyone take a stab? This is my code:

Code:

db_query("update $sql_tbl[orders] set tracking='$tracking', notes='$notes' $details where orderid='$orderid'");

sportruck

04-06-2005 10:56 AM

If your code doesn't match the SQL query listed above, here is what to do.

In admin/order.php, change this line:

Code:

        db_query("update $sql_tbl[orders] set tracking='$tracking', notes='$notes' $details where orderid='$orderid'");

To this:

Code:

        db_query("update $sql_tbl[orders] set tracking='$tracking', shipping_vendor='$shipping_vendor', notes='$notes' $details where orderid='$orderid'");

Works great!

chilll33

04-07-2005 08:19 AM

Works Perfectly with 4.0.13.

jedak

03-27-2006 08:02 PM

This mod is great it comes in very handy when you consider how many times I've switch carriers :oops:
Which brings me to my question how could I get this mod to default to the customer's selected carrier instead of having to select it. I use he real time shipping feature and say for e.g. a customer selects UPS 2nd Day Air the shipping vendor would then be UPS if they had selected USPS Priority Mail hen it would be USPS. Any ideas.
Thanks in advance.

alru111

02-20-2007 07:41 PM

Re: Ability to select shipping carrier for tracking numbers

this should take care of the same thing without adding anything to sql table

{assign var="postal_service" value=$order.shipping|truncate:3:"":true}
{if $active_modules.Order_Tracking ne ""}
UPS
{include file="modules/Order_Tracking/ups.tpl"}
USPS
{include file="modules/Order_Tracking/usps.tpl"}
FEDEX
{include file="modules/Order_Tracking/fedex.tpl"}
{/if}
{/if}

vtonya

04-29-2007 04:19 PM

Re: Ability to select shipping carrier for tracking numbers

What about this mod upgrading to work in 4.1.7 version???

Thank you!

pavant

07-23-2007 12:21 AM

Re: Ability to select shipping carrier for tracking numbers

I really like this mod and I changed it to work with my 4.1.8 xcart. Here is what I have:
First we need to create a new column in the database xcart_orders. The easiest way to do this is to go to 'Patch/Upgrade' under 'Administration' in your xcart admin. Copy the following in your SQL query(ies): box and click on apply.

Quote:

ALTER TABLE xcart_orders
ADD shipping_vendor char(5) NOT NULL default '' AFTER shippingid;

Step 2: In admin/order.php, replace this code:

Quote:

#
# Update order
#
$query_data = array (
"tracking" => $tracking,
"customer_notes" => $customer_notes,
"notes" => $notes
);

With this code:

Quote:

#
# Update order
#
$query_data = array (
"tracking" => $tracking,
"shipping_vendor" => $shipping_vendor,
"customer_notes" => $customer_notes,
"notes" => $notes
);

Step 3: Then you will need to add a template under skin1/main called 'order_shipping_vendor.tpl' containing the following code:

Quote:

{* $Id: order_shipping_vendor.tpl,v 1.4 2004/05/28 12:21:03 max Exp $ *}
<SELECT name="shipping_vendor">
{if $status eq ""}<OPTION value="">Select one</OPTION>
{/if}
<OPTION value="FedEx"{if $status eq "FedEx"} selected{/if}>FedEx</OPTION>
<OPTION value="UPS"{if $status eq "UPS"} selected{/if}>UPS</OPTION>
<OPTION value="USPS"{if $status eq "USPS"} selected{/if}>USPS</OPTION>
<OPTION value="DHL"{if $status eq "DHL"} selected{/if}>DHL</OPTION>
</SELECT>

Step 4: Finally you will need to edit template file skin1/main/history_order.tpl.
Find:

Quote:

Replace with:

Quote:

{if $usertype eq "A"}
{if $active_modules.Google_Checkout ne '' and $order.extra.goid ne ''}
{include file="main/order_status.tpl" status=$order.status mode="select" name="status" extra="disabled='disabled'"}
<br />
{$lng.txt_gcheckout_order_status_note}
<br /><br />
Shipping vendor:
{include file="main/order_shipping_vendor.tpl" status=$order.shipping_vendor mode="select" name="shipping_vendor"}
{else}
{include file="main/order_status.tpl" status=$order.status mode="select" name="status"}
<br /><br />
Shipping vendor:
{include file="main/order_shipping_vendor.tpl" status=$order.shipping_vendor mode="select" name="shipping_vendor"}
{/if}
{else}
<b>{include file="main/order_status.tpl" status=$order.status mode="static"}</b>
{/if}

Find:

Quote:

{include file="main/subheader.tpl" title=$lng.lbl_tracking_order}

{assign var="postal_service" value=$order.shipping_vendor|truncate:3:"":true}

Replace with:

Quote:

{include file="main/subheader.tpl" title=$lng.lbl_tracking_order}

{assign var="postal_service" value=$order.shipping_vendor|truncate:3:"":true}

Find:

Quote:

{elseif $postal_service eq "Fed"}

{include file="modules/Order_Tracking/fedex.tpl"}

After the line above add:

Quote:

{elseif $postal_service eq "DHL"}
{include file="modules/Order_Tracking/dhl.tpl"}

Many thanks to the original author of this mod. It's just what the doctor ordered for my site. I make no promises that this code will work with your site; each environment is different and your code may function differently especially if it has already been moded. I can't provide any support for this mod. Install only if you have the resources to fix any problems that may occur.

2coolbaby

11-05-2007 10:18 AM

Re: Ability to select shipping carrier for tracking numbers

This looks great. Any ideas what effect this has on the tracking link in completed emails?

imexhouse

11-09-2007 04:33 PM

Re: Ability to select shipping carrier for tracking numbers

Does anybody now to implement tracking for Canada Post?

samz724

12-20-2007 08:45 AM

Re: Ability to select shipping carrier for tracking numbers

Quote:

Originally Posted by 2coolbaby

This looks great. Any ideas what effect this has on the tracking link in completed emails?

I second that.. Any idea's!?

Thanks a lot! :mrgreen:

floyd_2

09-25-2008 04:00 AM

Re: Ability to select shipping carrier for tracking numbers

I wasn't keen to add any more tables to my database or make too many mods to my X-cart installation for fear of difficulat upgrades in the future. I was keen to get a Track It button embedded in my Order Completion email, and implemented a slight modification of MoonDog's method.

In MoonDog's method, it looks to rely on extra database fields that relate each order to the shipping method used. As I use two different trackable shipping companies, I was keen to have the Order Completion email offer just one Track It! button that was already coded to go to the correct carrier's tracking web page. Additionally, I wanted the text in the Order Completion email to still refer to the specific carrier that the customer selected (per MoonDog's original method).

Each of my carriers uses a different prefix for their consignment numbers, so I just stripped out the first two characters of the consignment number to differentiate between the two companies. Any order with a con number starting with "EC" belongs to TNT, and any starting with "13" belongs to Couriers Please. Here's my version of MoonDog's Order Completion email that requires no DB mods etc:

Code:

{* $Id: order_customer_complete.tpl,v 1.10 2006/03/31 05:51:43 svowl Exp $ *}

{config_load file="$skin_config"}

{include file="mail/html/mail_header.tpl"}

<p />{$lng.eml_dear|substitute:"customer":"`$customer.title` `$customer.firstname` `$customer.lastname`"},

<p />{$lng.eml_order_complete}

<br>

This is confirmation that the products you ordered have been shipped to you!

<br>

Shipping usually takes 3-5 days depending on your location.

<br>

{if $order.tracking}

{assign var="postal_carrier" value=$order.tracking|truncate:2:"":true}

{if $postal_carrier eq "EC"}

{assign var="postal_carrier_name" value="TNT Road Express"}

{elseif $postal_carrier eq "13"}

{assign var="postal_carrier_name" value="Couriers Please"}

{/if}

Your {$postal_carrier_name} tracking number is  {$order.tracking} 

<br>

Please allow up to 24 hours for the {$postal_carrier_name} tracking system to update this information.

{/if}

<hr size="1" noshade="noshade" />

<p />

<table cellpadding="2" cellspacing="1" width="100%">

<tr>

<td width="20%"><b>{$lng.lbl_order_id}:</b></td>

<td width="10">&nbsp;</td>

<td width="80%"><tt>#{$order.orderid}</tt></td>

</tr>

<tr>

<td><b>{$lng.lbl_order_date}:</b></td>

<td width="10">&nbsp;</td>

<td><tt>{$order.date|date_format:$config.Appearance.datetime_format}</tt></td>

</tr>

{if $order.tracking}

<tr>

<td><b>{$lng.lbl_tracking_number}:</b></td>

<td width="10">&nbsp;</td>

<td><tt>{$order.tracking}</tt></td>

<tr>

<td><b>Track your order:</b></td>

<td width="10">&nbsp;</td>

{assign var="postal_service" value=$order.tracking|truncate:2:"":true}

<td><tt>

{if $postal_service eq "EC"}

{include file="modules/Order_Tracking/tnt.tpl"}

{elseif $postal_service eq "13"}

{include file="modules/Order_Tracking/couriers_please.tpl"}

{else $order.tracking}

{/if}

{/if}

</tt></td></tr>

<tr>

 <td colspan="3">{include file="mail/html/order_data.tpl"}</td>

</tr>

</table>

{include file="mail/html/signature.tpl"}

Please overlook the slight duplication of code. It works well thanks to MoonDog's hard work and my slight mods. If you're worried about having to do too many changes to your X-Cart installation to associate your trackable carrier to your orders, this is a way around it (so long as your carriers use different Con note numbering systems).

Dean

imexhouse

09-25-2008 06:01 PM

Re: Ability to select shipping carrier for tracking numbers

I'm revisiting the issue after almost a year:

Any ideas how to implement tracking for Canada Post services?

Jayk	09-25-2008 07:01 PM

Re: Ability to select shipping carrier for tracking numbers

Quote:

Originally Posted by imexhouse

I'm revisiting the issue after almost a year:

Any ideas how to implement tracking for Canada Post services?

This is one I'd like to see as well. I may take a look at it in the next few days.

Jason

floyd_2

09-25-2008 08:02 PM

Re: Ability to select shipping carrier for tracking numbers

If you're after the ability to get the TRACK IT! button working for Canada Post, would you mind posting a valid tracking number that I can use?

TIA

Dean

floyd_2

09-25-2008 08:42 PM

Re: Ability to select shipping carrier for tracking numbers

Ok, I've worked the Canada Post "Track It" template code out. I grabbed a consignment ID from a friend in Canada to test with.

In your canada_post.tpl in modules/Order_Tracking you need the code to be as follows:

Code:

{* $Id: canada_post.tpl,v 1.0 2008/09/26 14:07:32 twice Exp $ *}

<form name="basicPinForm" method="post" 

action="https://obc.canadapost.ca/emo/basicPin.do" method="post" target="_blank">

<input type="hidden" name="trackingId" value="{$order.tracking}">

<input type="hidden" name="referenceNumberPressed" value="false"> 

<input type="hidden" name="trackingCode" value="PIN">

<input type="hidden" name="language" value="null">

<input type="hidden" name="action" value="query">

<input type="hidden" name="fromPage" value="basicPin">

<input type="submit" value="{$lng.lbl_track_it|strip_tags:false|escape}" />

<br />

{$lng.txt_apost_redirection}

</form>

Hope that helps guys. For the life of me, I can't remember what ties the tracking template to the shipping method though. It was a while ago when I set up my shipping methods and my goldfish-memory is true to form.

Does anyone know what template / php / screen ties shipping methods to tracking templates?

Dean

imexhouse

09-25-2008 10:04 PM

Re: Ability to select shipping carrier for tracking numbers

In skin1/main/history_order.tpl find:

Code:

 

{if $active_modules.Order_Tracking ne ""}

{if $postal_service eq "UPS"}

{include file="modules/Order_Tracking/ups.tpl"}

{elseif $postal_service eq "USP"}

{include file="modules/Order_Tracking/usps.tpl"}

{elseif $postal_service eq "Fed"}

{include file="modules/Order_Tracking/fedex.tpl"}

and change it to:

Code:

 

{if $active_modules.Order_Tracking ne ""}

{if $postal_service eq "UPS"}

{include file="modules/Order_Tracking/ups.tpl"}

{elseif $postal_service eq "USP"}

{include file="modules/Order_Tracking/usps.tpl"}

{elseif $postal_service eq "Fed"}

{include file="modules/Order_Tracking/fedex.tpl"}

{elseif $postal_service eq "Can"}

{include file="modules/Order_Tracking/canada_post.tpl"}

Thanks to floyd_2 for the tracking code!

One more thing, in skin1/modules/Order_Tracking/canada_post.tpl, change

Code:

{$lng.txt_apost_redirection}

Code:

{$lng.txt_cpc_redirection}

floyd_2

09-25-2008 10:12 PM

Re: Ability to select shipping carrier for tracking numbers

Thanks imexhouse - the memories came flooding back when I read your post. I will now be able to sleep peacefully tonight without continuing to wonder where that template was :)

Dean

imexhouse

09-25-2008 10:16 PM

Re: Ability to select shipping carrier for tracking numbers

You're welcome :)

floyd_2

09-25-2008 10:20 PM

Re: Ability to select shipping carrier for tracking numbers

Here's an even better way to interface with TNT Australia for your tracking needs:

HTML Code:

 

{* $Id: tnt.tpl,v 1.1 2008/09/26 14:07:32 twice Exp $ *}

<form id="Tracking" name="Tracking" action="http://www.tntexpress.com.au/InterAction/ASPs/CnmHxAS.asp?{$order.tracking}" method="post" target="_blank">

<input type="submit" value="{$lng.lbl_track_it|strip_tags:false|escape}" />

<br />

{$lng.txt_tnt_redirection}

</form>

Nice and neat, and it returns ONLY the tracking information, without any other TNT web page clutter.

Dean

imexhouse

09-25-2008 10:21 PM

Re: Ability to select shipping carrier for tracking numbers

There's no stopping you now!
:)

floyd_2

09-26-2008 05:03 AM

Re: Ability to select shipping carrier for tracking numbers

Ok...this is my last word on the topic for the evening lol.

Here is a much tidier way of handling Couriers Please in Australia:

HTML Code:



{* $Id: couriers_please.tpl,v 1.1 2008/09/25 14:07:32 twice Exp $ *}

<form name="barcode" action="http://www.couriersplease.com.au/track.php?printable=true&couponid={$order.tracking}" method="post" target="_blank">

<input type="submit" value="{$lng.lbl_track_it|strip_tags:false|escape}" />

<br />

{$lng.txt_cplease_redirection}

</form>

If you prefer a plain HTML result page without the Couriers Please banner on the top, just remove "printable=true&" and you'll get the plain result page. I figure that the printable version of the page with the Couriers Please logo on top is better for my customers.

Don't forget to go to Languages and add txt_cplease_redirection with appropriate text (like "You will be redirected to Couriers Please Delivery service site, by clicking this button."). Also update skin1/main/history_order.tpl using the post above by imexhouse as a guide.

Dean

floyd_2

09-26-2008 06:22 AM

Re: Ability to select shipping carrier for tracking numbers

Looks like I lied...this is really my last post for the evening. I have tidied up the CanadaPost code now - much better this way:

HTML Code:



{* $Id: canada_post.tpl,v 1.1 2008/09/26 14:07:32 twice Exp $ *}

<form name="basicPinForm" action="https://em.canadapost.ca/emo_business/basicPin.do?language=en&trackingId={$order.tracking}&action=query&trackingCode=PIN" method="post" target="_blank">

<input type="submit" value="{$lng.lbl_track_it|strip_tags:false|escape}" />

<br />

{$lng.txt_cpc_redirection}

</form>

Dean

Jayk	09-26-2008 08:58 AM

Re: Ability to select shipping carrier for tracking numbers

Thanks very much for the code Dean. I look forward to getting this implemented into my shop. Now I just need a few spare minutes...

Jason

imexhouse

09-28-2008 06:42 PM

Re: Ability to select shipping carrier for tracking numbers

Perfect! Without all the unnecessary clutter.
Thanks, floyd_2!

imexhouse

03-04-2009 04:36 PM

Re: Ability to select shipping carrier for tracking numbers

I know it's been months since the last post, but does anybody know how to modify the code to make it work with mulitple tracking numbers?

floyd_2

03-05-2009 02:05 AM

Re: Ability to select shipping carrier for tracking numbers

Hi imexhouse,
this is potentially a very simple one. With TNT in Australia for example, you just need to separate your tracking numbers with a comma. For example:

ECN002206500,ECN002206501

When that string is passed in the $order.tracking variable, TNT parses each tracking number in turn in the tracking results page.

With Canada Post, by memory the tracking screen only accepts a single tracking number as input. I don't have any valid tracking numbers any more to test their site though. I know they have a second page for tracking multiple packages too.

For starters, it might be worth just substituting a comma separated list of two tracking numbers into $order.tracking and see if CA Post accepts it.

Are you still using CA Post?

Dean

floyd_2

03-05-2009 02:39 AM

Re: Ability to select shipping carrier for tracking numbers

Ok, you knew I wouldn't let it go at that didn't you...

Assuming you're using CA Post...CA Post uses a slightly different URL for multi consignment tracking. The code you need to use is based on this:

Quote:

https://em.canadapost.ca/emo_business/multiPinPool.do?language=en&action=query&trackingC ode=PIN&trackingId=AA567543257AA%0d%0aAA345678765A A

Forgetting the two dummy consignment numbers in there, you really just need to change basicPin.do to multiPinPool.do in your existing query string. That's the first bit.

Secondly, you need to be able to string your consignment numbers in such a way that a line feed is generated between each one, whilst still keeping the syntax of the URL correct.

This is just a little ugly, but it IS cheap :) Delimit your consignment numbers when you type them into the Tracking Number field for an order inside X-Cart with the following string:

Quote:

%0d%0a

This will generate a line feed in the CA Post multi tracking number input window.

Whilst it will look just a little odd to the end user when they see a tracking number like:

Quote:

AA123456789AA&0d%0aAA987654321AA

it will actually work. Besides....who really looks at the actual number - its the results that we're after!

Give it a try - it worked in my tests here and means absolutely minimal changes to your X-Cart.

Dean

imexhouse

03-05-2009 03:13 AM

Re: Ability to select shipping carrier for tracking numbers

floyd_2:

Thank you for your input. I knew that the URL for the multiple tracking numbers for Canada Post was different. What I choked on was the separation of the 2, or 3, or more tracking numbers.
I'll try %0d%0a.
Now, if I wanted to replace the

Quote:

in the main/history_order.tpl with <textarea>, and then put the numbers on separate lines, how would we represent the split by line in the <textarea> tag? Would we still use the %0d%0a?
If so, than exactly how?
I've tried multiple "solutions", mainly javascript that are floating out there, but nothing seems to split the text by line breaks.
So, although I have in the text area:

717124500043433
717125465055500

the numbers get concatenated when the input gets to CPC tracking page and we get an error :(

To answer your question "Who actually looks at the tracking numbers", my customers do - more and more frequently, they use tracking numbers to locate their shipments, given the poor performance of CPC lately (misdirected and late shipments). In the past week alone, I've had 3 customers complaining about not getting their complete orders, although all their boxes would've been shipped at the same time. This is particularly so with heavy boxes - orders that consists of 2 boxes, one 5 lbs and one 55 lbs. Mysteriously, only the light box would be delievered on time, and the heavy one would get left behind :)

Thanks.

imexhouse

04-28-2009 03:57 AM

Re: Ability to select shipping carrier for tracking numbers

Canada Post has changed their tracking page, and the old tracking code no longer works.

Here's the new version:

Quote:

<form name="findByTrackNumber" action="http://www.canadapost.ca/cpotools/apps/track/personal/findByTrackNumber?trackingNumber={$order.tracking} &language=en" method="post" target="_blank">
<input type="submit" value="{$lng.lbl_track_it|strip_tags:false|escape} " />
<br />
{$lng.txt_cpc_redirection}
</form>

stuartdrennan

03-23-2010 12:57 AM

Re: Ability to select shipping carrier for tracking numbers

Hi

I rellay like this mod by inksticks, would anyone know if this will work ok with 4.2 or is there a mod that will?

Thanks

Stuart

mrerotic

04-13-2010 09:36 AM

Re: Ability to select shipping carrier for tracking numbers

Here is an updated version I did to work with 4.2.x

This version does not add another database table field it uses the existing field and updates the order information accordingly.

Open /admin/order.php
Find:

Code:

require $xcart_dir."/include/history_order.php";

Below add:

Code:

# Get Shipping Options for order admin area to update manually (Addon)

$adminship = func_query("SELECT * FROM $sql_tbl[shipping] WHERE active='Y' ORDER BY code, shipping DESC");

$smarty->assign("adminshipoptions", $adminship);

Find:

Code:

 $query_data = array (

  "tracking" => $tracking,

  "customer_notes" => $customer_notes,

  "notes" => $notes,

  "distr_order_update" => $distr_order_update

 );

Replace with:

Code:

 # Get Updated Shipping Id For Admin Area

 $getshipid = func_query_first_cell("SELECT shippingid FROM $sql_tbl[shipping] WHERE shipping='".$shipcarrier."'");

 

 $query_data = array (

  "tracking" => $tracking,

  "shippingid" => intval($getshipid),

  "shipping" => $shipcarrier,

  "customer_notes" => $customer_notes,

  "notes" => $notes,

  "distr_order_update" => $distr_order_update

 );

Create New Template (order_shipping_vendor.tpl)
Save to /skin1/main/order_shipping_vendor.tpl

Code:

{* $Id: order_shipping_vendor.tpl,v 1.4 2004/05/28 12:21:03 max Exp $ *}

<select name="{$name}">

<option value=""{if $shipping eq ""} selected="selected"{/if}>Select A Carrier</option>

{foreach from=$adminshipoptions item=addship}

<option value="{$addship.shipping}"{if $shipping eq $addship.shipping} selected="selected"{/if}>{$addship.shipping}</option>

{/foreach}

</select>

Open /skin1/main/order_history.tpl
Find:

Code:

{include file="main/order_status.tpl" status=$order.status mode="select" name="status"}

Add After:

Code:

<br /><br />

Shipping Carrier:<br />

{include file="main/order_shipping_vendor.tpl" shipping=$order.shipping|escape mode="select" name="shipcarrier"}

Now login to your admin area and view an order, under the Order Status you will see a new drop down option called "Shipping Carrier" the default selection is what the customer requested as a carrier. You can change this it will update the order to the new carrier.

All times are GMT -8. The time now is 03:19 AM.