X-Cart forums

[jedak]

This mod is great it comes in very handy when you consider how many times I've switch carriers
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]

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]

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

Thank you!

[pavant]

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.

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

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

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

With this code:

#
# 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:

{* $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:

{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}
{else}
{include file="main/order_status.tpl" status=$order.status mode="select" name="status"}
{/if}
{else}
<b>{include file="main/order_status.tpl" status=$order.status mode="static"}</b>
{/if}

Replace with:

{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:

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

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

Replace with:

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

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

Find:

{elseif $postal_service eq "Fed"}

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

After the line above add:

{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]

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

[imexhouse]

Does anybody now to implement tracking for Canada Post?

[samz724]

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!

[floyd_2]

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:

{* $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]

I'm revisiting the issue after almost a year:

Any ideas how to implement tracking for Canada Post services?

[Jayk]

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