| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Multiple-Carrier Tracking Numbers Mod for your Orders page! | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Multiple-Carrier Tracking Numbers Mod for your Orders page!
Hi all,
I am just putting the finishing touches on a very large website I have been doing with X-Cart. One thing we will have a lot of with our orders, is almost everything is drop-shipped on our behalf and a lot of times, that may mean multiple carriers are used (i.e UPS, FedEx, USPS, etc.) I could not find on the forum, anyone that accommodated this in a very thorough way. So I took a shot at it, and am VERY pleased with my modification. I have used a LOT of modifications from others on this forum, and so here is my small contribution back to the community.... What this modification does: - gives your X-Cart Admin the ability to put multiple tracking numbers into the Orders Management order details. Instead of just one generic tracking number textbox, you will now have 4 additional areas to input the tracking number(s) into carrier-specific textareas. - your customer now will see in their "order processed" (if you punch tracking numbers in during that stage of the order) and "order completed" email, a detailed list of tracking numbers by carrier for their order. My disclaimers: - This modification and the following steps described was done to X-Cart 4.0.14. I do not know if all the code is the same in prior versions or revisions. - you DO have to modify one database table with this modification. If this is something you do not feel comfortable with, you should probably pass on this then. It is a very easy update though... trust me, I am not database expert by any means!! If there's any DBA's or database experts that could create a script, that may be the best bet. The way I did it, was within phpMyAdmin (my service provider gives us an account) and it was so easy to add them. Summary of placed were modifications will be performed: - database table modified: (database name)_orders - files modified: (storename)\admin\order.php (storename)\skin1\main\history_order.tpl (storename)\skin1\mail\html\order_customer_process ed.tpl (storename)\skin1\mail\html\order_customer_complet e.tpl (storename)\skin1\mail\order_customer_processed.tp l (storename)\skin1\mail\order_customer_complete.tpl Detailed Steps: 1.) you need to alter one database table to get the new tracking numbers stored. *** MAKE SURE TO BACKUP YOUR DATABASE PRIOR TO ALTERING TABLE *** There's many different ways to alter your database table to add the 4 new columns that we need. You need to go into the "(database name)_orders" table, and right after the "tracking" column, added 4 new fields: tracking_ups VARCHAR(64) tracking_fedex VARCHAR(64) tracking_usps VARCHAR(64) tracking_other VARCHAR(64) 2.) in Admin --> Languages, add the following new Label fields (NOTE: for "Values", what you type into here is what you will see in the Orders Management order details AND what the customer sees in their email): lbl_tracking_number_ups lbl_tracking_number_fedex lbl_tracking_number_usps lbl_tracking_number_other 3.) in order.php, locate this piece of code: Code:
and replace it with: Code:
4.) in history_order.tpl, locate this piece of code: Code:
replace with: Code:
You will see that when adding all these, I also I switched them to be textarea boxes and if you by chance have multiple tracking numbers but with the same carrier, you can place each one on a new line within the textarea. When it places these in the customer's email, a space will be put inbetween them. I found that placing a semi-colon after each helps (visually) in the email for the customer (because more tracking numbers like UPS or Priority Mail typically have spaces in them). 5.) in (storename)\skin1\mail\html\... the following is done in both the order_customer_processed.tpl and order_customer_complete.tpl files: find: Code:
and add directly underneath it: Code:
6.) in (storename)\skin1\mail\... the following is done in both the order_customer_processed.tpl and order_customer_complete.tpl files: find: Code:
and add directly underneath it: Code:
ENJOY!!! Brian
__________________
X-Cart Gold v4.0.18 [unix] - Easy Checkout module - ezUpsell module - CDSEO module X-Cart Gold v4.1.11 [unix] ***38,000+ active products! - CDSEO module - Address Book module - Reorder module - Smart Search module X-Cart Gold v4.4.2 [unix] - in development now! |
|||||||
#2
|
|||||||||
|
|||||||||
sounds good. Thanx for sharing...
__________________
Dongan MercuryMinds Technologies Professional X-Cart Design, X-Cart Development, X-Cart Customization Services www.mercuryminds.com Follow us at Facebook / Twitter |
|||||||||
#3
|
|||||||||
|
|||||||||
btomasie,
Thanks for posting this mod. This is exactly what we need, as we do a lot of drop shipping as well. I am, however, getting stumped on one very important part of this mod. I'm looking in this version of order.php: # $Id: order.php,v 1.1.2.2 2005/01/12 07:41:43 svowl Exp $ and I can not find: Code:
This is a short file, so I eyeballed the file and use "find". Nothing. Is order.php the right file to change? TIA
__________________
x-cart 4.0.13 and 4.1.7 and 4.1.10 |
|||||||||
#4
|
|||||||
|
|||||||
I just double-checked, and yep, that's the correct spot (at least for 4.0.14). I wouldn't think it'd change greatly in one 0.01 version change.
Here is a larger chunk of the code with an entire section before the spot that we need to change, for you to find this section your a bit easier: Code:
Hope this helps. Let us know. Brian
__________________
X-Cart Gold v4.0.18 [unix] - Easy Checkout module - ezUpsell module - CDSEO module X-Cart Gold v4.1.11 [unix] ***38,000+ active products! - CDSEO module - Address Book module - Reorder module - Smart Search module X-Cart Gold v4.4.2 [unix] - in development now! |
|||||||
#5
|
|||||||||
|
|||||||||
Hmmm...
this is the entire .php file: Code:
I've checked if this is the same for 4.0.14 and 4.0.15 and it is. Are you referring to order.php in the cart's root folder, or an order.php in a different folder?
__________________
x-cart 4.0.13 and 4.1.7 and 4.1.10 |
|||||||||
#6
|
|||||||
|
|||||||
Aha, that's the discrepency!! You are looking at the file insid eyour root xcart folder. Look at my reference at the top again:
(storename)\admin\order.php Go inside the admin folder, and then modify the order.php page. You should have it from there! Brian
__________________
X-Cart Gold v4.0.18 [unix] - Easy Checkout module - ezUpsell module - CDSEO module X-Cart Gold v4.1.11 [unix] ***38,000+ active products! - CDSEO module - Address Book module - Reorder module - Smart Search module X-Cart Gold v4.4.2 [unix] - in development now! |
|||||||
#7
|
|||||||||
|
|||||||||
Thank you Brian,
Now I see, I got stuck in the "Detailed Steps:" section, and didn't referrence back to the "Summary of placed were modifications will be performed: " section. You're so organized, it mystified me.
__________________
x-cart 4.0.13 and 4.1.7 and 4.1.10 |
|||||||||
#8
|
|||||||
|
|||||||
No problem!! Trust me, I'm not organized, I just figured I owed it to all the members to walk through all that at such a detailed level, that no one screwed up their site!
Enjoy it! Brian
__________________
X-Cart Gold v4.0.18 [unix] - Easy Checkout module - ezUpsell module - CDSEO module X-Cart Gold v4.1.11 [unix] ***38,000+ active products! - CDSEO module - Address Book module - Reorder module - Smart Search module X-Cart Gold v4.4.2 [unix] - in development now! |
|||||||
#9
|
|||||||||
|
|||||||||
From what I see, it works great with my version...(haven't found problem just yet). Thanks for the great mode.
__________________
_____________ Capture Your Mini-Me Look! - X-CART Gold (Current Version) V4.6 - Reboot - CDSEO |
|||||||||
#10
|
|||||||
|
|||||||
I appreciate this MOD.. it's EXCELLENT.. it's a must have..
I would do it if i know how.. The original one has the link in the email.. <I think> now. it just shows the tracking number. No link.. it'll be so much easier for the customer if they can just click on it and takes them tot the appropriete site for tracking.. Again! Thank you for the MOD... i just thought it'll be nicer if it had that feature. I implemened the mod... however the email sent to the customers when the order is "complete" the Email is not HTML.. and turned into only text.. and all messed up.. I'm using 4.0.17 is there a difference? Also, How would you remove the original "Tracking number" Box? we added 4.. but there was one there already.
__________________
hyratech X-CART Gold 4.1.10 Hosted - Unix |
|||||||
|
|||
X-Cart forums © 2001-2020
|