Community Add-Ons

Shipping Status 3.3.1 by hochstrb Update 11/24/06
- Removed unneeded (and incorrect) carriers table define in catalog/includes/database_table. The presence of the change prevents the "selective database backup" mod from working correctly.

Shipping Status 3.3 by hochstrb Udpate 11/23/06
- Eliminated duplicate code with the email generation
- Eliminated duplicate code with status information in account_history_info.php and admin/orders.php
- Incorporated updated USPS URL thanks to misterbling
- Added checks to avoid needlessly setting the tracking num, ship date, and delivery date every time an order is updated, and made them all be updated in a single query
- Fixed bug where old tracking num and old ship date were being included in the email generated when status set to delivered.
- Fixed bug where email was not generated when only shipped date and/or tracking number were changed
- Added carrier information in email for shipped & delivered statuses
- Provided patch file

On the clickable link to usps tracking info your customers now get a forwarding address.

Easy fic in

Change

http://trkcnfrm1.smi.usps.com/netdata-cgi/db2www/cbd_243.d2w/output?CAMEFROM=OK&strOrigTrackNum=

to

http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=

Found SQL error...

Error:
ALTER TABLE 'orders' ADD 'carrier_id' TEXT;

Correction:
ALTER TABLE `orders` ADD `carrier_id` TEXT;

Same as previous download, with SQL correction

The sql file to upload was missing a line

//ALTER TABLE 'orders' ADD 'carrier_id' TEXT;

so i went ahead and added it to the file. Hopefully this fixes some issues.

Corrected a mistake in the installation file for orders.php. Features remain the same.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=138268

Shipping Status 3.0 by AlDaffodil Update 7/11/05:
Combines original features plus all modifications and additions provided by others. Thank to everyone who has contributed!

New Changes:
-SQL file has been modified to work with a fresh install. It will delete an existing shipping status with id of 3. It will not work if you have an existing shipping status with id of 4.
-Consolidated some installation steps
-attempted to use better comment tags to identify changes made by this contribution.
-Added "Carrier" field to automatically generate tracking urls.
-Added "Today's Date" and "Clear" buttons next to date fields.
-Automatically set status to "in transit" if "Today's Date" button is used to fill shipping field.
-Automatically set status to "delivered" if "Today's Date" button is used to fill delivered field.
-I have retained the language file submited by 420; I have not added any for the additional definitions required by this update. I don't know the languages.
-I know that the code is a bit messy, but it should work without any problems.

i have made some dhl corrections. I also made the tracking number a click able link. it will take the customer to the dhl web site.. the same can easly be done for usps,fedex,and ups.. and if some really wants to get creative.. then can do a switch statment and code it for all providers insted of hard codeing just one.

here is the fourm link for this project .

http://forums.oscommerce.com/index.php?showtopic=138268

Fixed the DHL tracking button so it autopopulates the tracking number just like the others.

This version adds more functionality...one click order tracking by automatically querying the database for the tracking number and filling it into the url for the appropriate shipping company website. USPS, UPS, FedEx, and DHL/Airborne are supported.

This is a bug fix to a minor mistake in the SQL file that 440 wrote, which prevented it from running.
The rest of the contribution (unchanged) is also included.

I take no credit for any of the code. I simply changed some minor things as listed below. Sorry for being a perfectionist, but I'm anal that way. ;)

Changes to original mod:

- Modified SQL file to include other languages and to properly sort status in Admin CP (DELETE DELIVERY STATUS ID FIRST and then Optimize Table, then run SQL)
- Changed Delivery and Shipped status IDs
- Changed "Delivery Confirmation" field and text to "Tracking Number" so that it can be used universally for all carriers
- Cleaned up the code a bit ... great hack but the code was a mess, extra lines, 1 misplaced change, backwards parentheses, missing line break in customer email w/ no delivery date, etc. (no offense intended, just being honest)
- Changed the email text to shorten it up (you can change it again of coruse to say whatever you want)
- Removed "feedback" text ... commented it though so you can add it back in if you want. I just thought it was redundant as the next line tells customer to reply with any questions. To that 2nd line, I added a final thank you to the customer
- Added changes for other languages (but please don't blame me if translations are inaccurate, did my best. better than nothing I figured)

Big thanks to AlDaffodil for his fine contribution! :)

Shipping Status v.1.1 for 2.2ms2 Updates and Additions
--Fixed bug in e-mail sending
--Corrected some installation instructions
--Adds a filed for delivery date
--Sends e-mail with Ship Date and Confirmation number if status is "in transit"
--Sends e-mail with Ship Date, Confirmation number, and Delivery Date if status is "delivered"
--Asks user to reply with feedback if status is "delivered"
--New Info box in My Account->account_order_history for Shipment Information
--Info box will only each piece of information if it has been entered
--Otherwise will show "Your order has not been shipped"

Shipping Status v.1.0 for 2.2ms2
--Adds an order status "in transit" for when items have been shipped but are not yet delivered
--Adds a field for the shipping date
--Adds a field for a USPS delivery confirmation number. (small modifications could be made to make it say FEDEX delivery confirmation number or similar)
--Includes Ship Date and Delivery Confirmation number in status update emails (if they have been set)
--Includes Ship Date and Delivery Confirmation number in My Account -> orders on catalog side (if they have been set)