I need to send a shipping confirmation email which includes a tracking number, and also store this tracking number along with the order so that the customer can find it in their order history.
Can Virtuemart do this? I can't find any such feature.
nope: looks like another great feature request! ;D
in the coments section you can update it and let the select the Notify Customer Box.
Quote from: gregcaulder on February 23, 2006, 01:39:42 AM
in the coments section you can update it and let the select the Notify Customer Box.
yes, but the cust. can't see it from their account. only if email note was sent with a status change notify.
Exactly -- I would like the customer to see it. I either need this capability, or order import/export!
might need to submit a feature request sorry. I though it shoed them the coments. lol.
Greg
I developed a hack for UPS tracking:
http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=18022.0
;D
Greetz
Ralf
I would like to know more about your hack.
Ideally this feature would:
1. Allow the user to view a tracking number in their order history
2. Allow the option for automatically sending a shipping-confirm email when the tracking number is entered
3. Allow an upload of tracking numbers from our UPS computer (so we don't have to manually key dozens of tracking numbers every afternoon)
Zen Cart has a great "module" which allows customers to login to their account and click on the tracking number to find the status of their shipment. Additionally, when the admin first enters the tracking number and sends a status email, the output includes the tracking number. I've included some screens, the email text and the actual Zen Cart files if anyone wants to take a look at them and have a go.
Email Text:
QuoteMisticAudio
------------------------------------------------------
Order Number: 1969
Detailed Invoice: http://www.misticaudio.com/index.php?main_page=account_history_info&order_id=XXXX
Date Ordered: Saturday 22 April, 2006
Your USPS Tracking ID is EO0088XXXX8US
Click here to track your package.
If the above link does not work, copy and paste the following link in your address bar.
http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=EO0088XXXX8US
Your order has been updated to the following status:
New status: Order Shipped
Please reply to this email if you have any questions.
Admin Screens:
(http://www.misticaudio.net/images/linkto/zenship1.jpg)
(http://www.misticaudio.net/images/linkto/zenship2.jpg)
[attachment cleanup by admin]
wham bam! let's pipe it to VM man!
EDIT:
----------
This appears to be a hack(tracking) on top of a hack (super_orders)
no piping going to happen there!
it does give us the carrier tracking links though.
hmmmm....
here's the superorders files as well if that helps...
[attachment cleanup by admin]
since the format of OSC is so different...we might as well start over.
Ok, here is my implementation. Fully included in VM:
eMail notification text:
Hi, Test User,
the Status of your Order No. 21 has been changed.
New Status is:
____________________________________________________________
Shipped
____________________________________________________________
To view the Order Details, please follow this link (or copy it into your browser):
http://sosflag.com/content/index.php?option=com_virtuemart&page=account.order_details&order_id=21
____________________________________________________________
Your tracking number for UPS is: 1Z12345E1512345676.
You can check the current delivery status on our webpage
by clicking on 'Account Maintenance' or follow this link:
http://sosflag.com/content/index.php?page=account.ups_tracking&track_num=1Z12345E1512345676&option=com_virtuemart&Itemid=50
____________________________________________________________
SOSFlag Inc.
http://www.sosflag.com
vip@sosflag.com
I plan to move the tracking number to the orderdetails inside the admin area using a new tab.
[attachment cleanup by admin]
@stevendunston: Good idea about bulk import of tracking#! Can you please send me the interface definition of your UPS system? Is it a standard system? I am willing to include a function like this if it can be used by a lot of people.
Greetz
sweet! please share and we'll add it to next ver.
send 2 me via PM?
Ralf,
The company's warehouse manager is out of the office until Monday, but once he is back, I will request a sample data file and some specs on the UPS system.
UPS Worldship?
Any progress here??
AddOn finished. The modifications inside the attached file are based on version 1.0.5 of VirtuelMart.
Just replace the files of your installation and change database using the following SQL statement (remember to change table suffix)
ALTER TABLE `jos_vm_orders` ADD track_num VARCHAR(30);
Actually the code is in test mode. To use live mode of UPS, change the lines 40-43 in account.ups_tracking.php:
$timezone = 'Western'; // set this to the timezone of your server
$protocol = 'https';
$host = 'wwwcie.ups.com'; // use for testing purposes only
//$host = 'www.ups.com'; // use this for live
Currently I only included the english language version. For other languages, please modify your language files.
UPDATE:
I also attached another version based on 1.0.4 of VM. Please check this version because I did not had time to setup an old 1.0.4 version.
Ralf
[attachment cleanup by admin]
Quote from: Ralf Melles on May 09, 2006, 12:29:47 PM
AddOn finished. The modifications inside the attached file are based on version 1.0.5 of VirtuelMart.
Ralf
Great! Your hard work is appreciated... I am wondering though what the differences would be between 1.0.4 and 1.0.5 since probably 95% of the users who could benefit from this are still at 1.0.4. Any major changes?
a lot of bugfixes i think and hope ;)
No, no, Soeren and all the others did a great job and if you check out the changelog and modified files for 1.0.5, it's more then worth.
BTW, for all users still working with 1.0.4 -> I will upload a version based on 1.0.4 in a few hours (seems to me that I have nothing else to do ;D)
Ralf
Quote from: Ralf Melles on May 09, 2006, 17:23:23 PM
BTW, for all users still working with 1.0.4 -> I will upload a version based on 1.0.4 in a few hours (seems to me that I have nothing else to do ;D)
Ralf
That's what I like to see... ;D Thanks Ralf
now, version for 1.0.4 available too. Check out my previous post for attachment.
rme
I added the Mod, really nice. Another feature request would be to have a USPS tracking radial button and have it add tracking numbers for them as well and an if USPS is checked, then track and send USPS, if UPS is checked then send and track UPS. Any thoughts on this?
@stevendunston: any progress about the interface deifinitions for bulk import of tracking#?
Does anybody has more informations about the online tools of different shippers (FedEX, USPS...) If I can get detailed informations about request/response structures, I will enhance this hack to be able to handle different shippers.
Ralf,
There is a thread with some FexEx info and a start to a module for FedEx but it basically fo rjust displaying rates for the customer to select.
http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=14414.0
I found the source from the origional author that Soren used to set this up and it includes many additional sample scripts for adding features like:
track
ship (hopefully with lables to print)
address validation
rate service
http://freshmeat.net/projects/fedexdc/?topic_id=914
You need a FedEx Account and there are links in that tread and in the file readmes to the developement area. You baically need a FedEx account and to register online. Then you need to email websupport@fedex.com requesting access to the test server. I have been trying ot hook up but apparently they are upgrading and rebuilding the server and have had no luck.
I am new to PHP programming but would love to get a more full featured FedEx shipper in ValueCart and I think a lot of others on US would too.
Thanks!
Is there goin to be an update to work with 1.0.6?
is anyone else having trouble with all of the shipping modules built into 1.0.6, mainly UPS and USPS? I NEED these work properly so I can take my store live and they wont even show up, they cause my shipping option page to become disfigured, my orders are not showing in the back end, and there are major flaws in VirtueMart altogether between Mozilla Firefox and Internet Exolorer.
Am I alone here or is anyone else experiencing these same issues?
Someone please help
Ralf, I really like your work!
Hmm, just wonder...
- What happens if you only can delivers some articles of the order and have to deliver the rest a week after (= two tracking numbers)?
- What happens if the order is big and need to ship several packages (at least in Sweden this means different tracking numbers)?
- Since there is another addon (Invoice/Receipt/DeliveryNote Addon - http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=14896.0 ) which is a good addon and handling deliveries, shouldn't the tracking number handling be added in this?
Hi guys 8)
Do you know if there is anyway to do the same with Royal Mail (the main UK service provider) www.royalmail.com?
Thanks Ralf!
Does this hack work with Version 1.0.7 as well?
I am also needing this for 1.0.7. Any idea if this will be developed?
Quote from: misticjeff on May 04, 2006, 23:59:19 PM
hmmmm....
here's the superorders files as well if that helps...
thios file ios for ZENCART we need for VM any body test this on VM
Since we're now up to 1.0.10 , has this UPS Tracking # thing been implemented ?
I am using VM 1.0.12. Will these hacks work for the newest versions?
Is anyone listening?
echo echo
Hello all,
I am bumping this topic. The original hack made by Torin Walker and Ralph Melles was no longer working on VirtueMart 1.0.13a. So I spend some time fixing it and now it is all working fine. You can get the new hack at www.csvimproved.com (http://www.csvimproved.com) from the downloads section.
Please note: this is only for VM 1.0.13a !!. If you have a clean VM installation you can simply copy over the files, otherwise you will have to manually hack your system.
Many thanks to aravot for testing it out.
Enjoy.
Roland,
I'm back from a series of extended assignments and happened upon this hack, which looks beautiful.
I tried it on a 1.0.7 and a 1.0.13a versions. I did notice this hack found upon your site is only for 1.0.13a. I upgraded the 1.0.7 to the latest 1.0.13a. In both cases, with this hack, I am unable to search orders using the search function in the VM admin backend.
Any ideas?
Hello Fidel,
Just had time to check your message. When I search in the backend, it works like a charm. Are you searching for anything in particular?
since adding this hack, I cannot update order status of any order. Any ideas?
Desperately need to have this fixed ASAP
Brad,
What version of VM do you use? Can't you restore the backup?
I got it to work. I forgot that I made a slight modification as I was trying to get the color scheme to match my template. All is good now!!
My next question is:
Is there a way to have multiple tracking numbers listed for one order? I often times have multiple tracking numbers since I supply products from 14 different warehouses across the country. It would be nice to be able to add up to 5 tracking numbers per order, but if only 1 or 2 is needed, the rest of the input fields default to NULL
Brad,
The current hack does not support multiple tracking numbers. This is something that could be improved, if I find the time I will have a look at it.
We've encountered a problem that I think is caused by this hack (or at least cause by my implementation of the hack).
The order.order_list.php file in the hack does not seem to bring up the footer that allows you to move between pages. In other words, it will display the first 50 orders, but there is no footer with "next, previous, pages numbers" to navigate to the next page. If I replace order.order_list.php with the original the footer appears, but obviously the tracking number does not.
Has anyone else encountered this? Any suggestions for things to check?
Thanks
Its great to work together to make things happen but please help us. When a mod is finished, there should be a final zip file with an instruction guide. You do all this work and an extra 10 minutes in notepad , just to explain how to install things wouldnt be to hard, now would it ?
Quote from: iphonethesolution.com on January 12, 2008, 21:58:06 PM
Its great to work together to make things happen but please help us. When a mod is finished, there should be a final zip file with an instruction guide. You do all this work and an extra 10 minutes in notepad , just to explain how to install things wouldnt be to hard, now would it ?
What are you talking about? By taking an extra 5 minute to read you would have found out that the code is zip-ed and includes installation instruction guide.
2All
The footer problem should be solved in the zip that is available from my website (www.csvimproved.com). Get the 1.0.1 version. I had this fixed a while ago but completely forgot about it :)
Does this hack still work with 1.0.14? I had it installed on 1.0.13a. I had forgotten about it until I upgraded! :o But the shipping people sure let me know about it in a hurry!
hello ddc441,
I have not yet had time to check it against 1.0.14. I am inclined to say though that it should pretty much work as 1.0.14 is a security release not a feature release.
Will check it later.
Thanks... just for kicks I uploaded your modified files to a VM 1.0.4 install. The list_order page did pull up the tracking numbers aleady stored in the DB from the 1.3 install, but I got a "security token" error when trying to save a new tracking number. I wonder if that could be caused by the fact that I'm working on the development server with a copy of the site instead of the live site. ???
Also the frontend tracking seems to work fine as well.
HTH
I found the answer on some other posts in the forum. I guess the security token function in the upgrade has been a problem for a lot of hacks.
I added copied a line of code from the new order.order_list/php file to the your hacked 1.0.1 file:
Add before:
<input type="hidden" name="changed" value="0" />
<input type="hidden" name="track_num" value="" />
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="order_id" value="'. $db->f("order_id") .'" />
<input type="hidden" name="current_order_status" value="'. $db->f("order_status").'" />
</form>';
This:
<input type="hidden" name="vmtoken" value="'. vmSpoofValue($sess->getSessionId()) .'" />
I have installed this mod for VM 1.0.15 and tested it. It sent the e-mail with the tracking number and two links. The link that lead to the UPS status check on the site stated there was an error communication with UPS' server. The other link did not work at all. Furthermore, both times the page I landed from the links didn't completely finish downloading.
I attached a screen shot to better explain what I'm trying to say.
I remember reading somewhere suggesting to edit hacked files for versions other than 1.0.13a; unfortunately, I'm still new with PHP. Is there a new release for version 1.0.15?
Thanks.
[attachment cleanup by admin]
I have tested this with version 1.0.15 of Virtuemart, and after a slight modification, I was able to get it working. Initially I was getting a "Security Token" error.
In the order.order_list.php file, it was necessary to change this:
// NOTE: RolandD UPS Tracking
$form_code .= '<input type="hidden" class="inputbox" name="notify_customer" value="N" />
<input type="hidden" name="page" value="order.order_list" />
<input type="hidden" name="func" value="orderStatusSet" />
<input type="hidden" name="changed" value="0" />
<input type="hidden" name="track_num" value="" />
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="order_id" value="'. $db->f("order_id") .'" />
<input type="hidden" name="current_order_status" value="'. $db->f("order_status").'" />
</form>';
And add this line:
// NOTE: RolandD UPS Tracking
$form_code .= '<input type="hidden" class="inputbox" name="notify_customer" value="N" />
<input type="hidden" name="page" value="order.order_list" />
<input type="hidden" name="func" value="orderStatusSet" />
<input type="hidden" name="vmtoken" value="'. vmSpoofValue($sess->getSessionId()) .'" />
<input type="hidden" name="changed" value="0" />
<input type="hidden" name="track_num" value="" />
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="order_id" value="'. $db->f("order_id") .'" />
<input type="hidden" name="current_order_status" value="'. $db->f("order_status").'" />
</form>';
Please note the bolded line. That resolved any errors I was having...
Also, for the previous post by ASIANKNIGHT - make sure that you have configured the "account.up_tracking.php" file to contain your personnal UserID, Password, and XML Access Key.
For testing you will also need to make sure that you change the UPS test server is the one you are sending requests to. You can obtain test UPS tracking numbers from the UPS XML developer's guide available on the UPS website.
Hope that helps!
Thanks MCSE_Crossover for checking this out. I had not yet found the time to check it. I will make the necessary change and put a complete download up if that is OK with you.
No problem! Glad I could help. Attached is a zip file with the updated information. Do with it as you will...
Question for you...would it be hard to modify this so that you could make it so it tracked by reference number instead of UPS tracking number?
I have a customer that adds the customers order number as the UPS reference number in the WorldShip system. Is there a way to make this mod so that the "track" button shown will automatically populate itself with the order number as the UPS reference number and then track it that way?
I know the UPS XML developers guide states that you can send the POST with either specified.
They aren't wanting to have to log into the backend, input the tracking number, and then hit "update" for every order that they get. This type of solution would just make it so the whole process was a bit more automated...
it would seem that it would just be a matter of making the $tracknum variable populate with an "order_id" query instead of a "track_num" query...what do you think?
Just wondering out of curiosity. They were pretty impressed by this mod implementation so far...thanks for taking the time to develop this solution. This is something that definately should be implemented as the standard in future versions of Virtuemart.
::zip file attached::
[attachment cleanup by admin]
MCSE, thank you for the reply. I did check to make sure that I have entered the correct information for the account tracking php file. However, I forgot to send the request to the test server. I shall give it another try as soon as I can.
Once again, thanks. ;D
@MCSE_Crossover
QuoteIs there a way to make this mod so that the "track" button shown will automatically populate itself with the order number as the UPS reference number and then track it that way?
This is a feature that would be very nice to have. Is it really possible to track an order using the VM order number instead of the UPS tracking number?
Quoteit would seem that it would just be a matter of making the $tracknum variable populate with an "order_id" query instead of a "track_num" query...what do you think?
It is just a matter of passing the right number. This is no real magic ;)
QuoteThey aren't wanting to have to log into the backend, input the tracking number, and then hit "update" for every order that they get. This type of solution would just make it so the whole process was a bit more automated...
In response also to the first quote, they put the UPS or the VM order number in as tracking number?
Hi thanks fr this great contrib .....
well all ok to me no error only this message when i click on Track in client account maintenance
250003: Invalid Access License number
any help thx
I downloaded the 1.1 version from your site and installed it on VM 1.1 but get the following error:
Fatal error: Call to undefined method ps_order_status::getOrderStatus() in /home/supreme6/public_html/supreme2/administrator/components/com_virtuemart/html/order.order_list.php on line 222
Any help please?
Has anyone tried this hack on joomla 1.5.14 and vm 1.1.3?
Hey ralph do you think you can make a module for Canada Post that works with the latest VirtueMart. There are 1000 of companies that want to use this, especionally mine. Thank you.
anyone know of a way to add a button or text link under the input box for order.order_list.php so that when I have entered in a UPS tracking number, a button would then appear that when clicked would allow me to link directly to UPS.com with the input tracking number already in the tracking box on ups.com?
It is sort of a pain to have to copy the tracking number out of the order list table, go to ups.com, enter the tracking number, and track when a customer calls for status. It would be so much easier to be able to just hit a button and it would track in a new window without me having to navigate away from the order list.
anyone? anyone? Roland?
I've installed this hack on VM 1.1.4 and it seems to be working with the exception of 2 errors I am receiving:
here's one, this takes place when you click the "Track Order" link in the Account Maintenance section next to all the orders.:
Notice: Undefined variable: callback in html/administrator/components/com_virtuemart/html/account.ups_tracking.php on line 168
And the other takes place when you confirm the order on the checkout:
Notice: Undefined index: track_num in html/administrator/components/com_virtuemart/classes/ps_order.php on line 151
Does any one have any idea why this happens and a possible fix?
I'm using the files from csvimproved.com - ups_tracker_1.5_vm11