interwoven

Ok I did get this to work in a really roundabout way but the end result is the customer can press a button and track their package from within an email...in most cases.

I had to use the UPS Online tools integration to track orders by reference number. MOM enters the order number as a reference number with UPS. The first thing you would have to do is sign up for UPS Online tools and get a developer key and some other info. There appears to be no charge for that. The code I used is below:

<FORM method="get" action = "http://wwwapps.ups.c...ng/OnlineTool">
<INPUT type="hidden" size=25 name="ReferenceNumber" value=" %%order# ">
<INPUT type="hidden" name="SenderShipperNumber" value="your shipper number">
<P> <P><INPUT type="submit" name="submit" value="Track this package if shipped UPS">
<INPUT type="hidden" name="UPS_HTML_License" value="your license number">
<INPUT type="hidden" name="UPS_HTML_Version" value="3.0">
<INPUT type="hidden" name="TypeOfInquiryNumber" value="R">
</FORM>

There is some limitations to it as submitting forms from an email is not the best method. You also have to be sending html emails as ship to notices. It won't work in MSN or Hotmail email accounts as they strip all the form tags from the email. It doesn't work with AOL emails either but that comes as no suprise. It did work in yahoo and gmail but popped up a box asking if you wanted to submit info to an outside site. It worked in Outlook and Thunderbird.

Couple of notes if you want to try this. The %%order# has to have a space after the first quotes and before the second. If you remove those spaces it will not work. Also you have to use the Form method="get" action for a form to work from an email. If you place this form on your website then you need to use "post" in place of "get".

I don't know if this will help anyone but I wanted to share it just in case it might help someone. I am sure it's not the best method but I am going to start sending emails today with it and if any problems arise I will let you know.

Thanks and if anyone sees any potential problems let me know and thanks for the suggestions.

Brian
Hanks Clothing

Well I just tested something and was seeing if some other people could test this out also.

I use Thunderbird for email at home and thought I would do a test. I downloaded it on a box at work here and set up an email account in it and set it as my default email client. I then went into MOM under Global Preferences>Notices and unchecked using Outlook 2000 or later under Email/Fax Settings.

I then went to an order and sent some HTML notices and Thunderbird popped up a message asking if you wanted it to warn you whenever an application tried to send mail. I unchecked that and the mail sent.

The mail came thru formatted perfectly, unlike Outlook express which we had used in the past. We had switched back to Outlook with Express Click yes but that program frequently requires a re-boot of the PC it is installed on as it seemd to quit working often.

At any rate maybe some other MOM users could test this and see if it might be a possible solution for some to avoid the warning box from Outlook.

This is an annoying thorn in the side for us on a daily basis and perhaps installing Thunderbird on a machine to send notices from would be a possible solution for some.

Thanks

Brian
Hanks Clothing

Hi Videoflicks,

I was generating the notice from the order entry screen and will be generating them from the batch order screen when done. It's really wierd that when I do it it shows the tracking number of the order following it. If there is no tracking number on the order following the one I am creating the notice for it shows none. I think I'll re-index and try it then although that seems like a little more critical error than re-indexing would fix but I'll give it a shot. Thanks and let me know if you have any other suggestions. If you can't help I am afraid no one can

Brian
Hanks Clothing

Hi Hank,

I setup a tracking number on an order and generated a quick email notice:

October 1, 2006



Re: Order Number: 467900

Dear Linda ,

Z10293905-2-2--

WEB ORDER



I got the correct tracking number to show. Are you doing this in batch notices or with an outside app?

Best,

Videoflicks2004

Here are all the account states as they are listed in the mom database, I have labeled the ones that I am pretty sure I know. Can anyone help me figure out the ones that I don't know or fill in any states that are missing and their associated values?

Order States:

BO = Back Ordered Item In Order
CA = ?
CD = Credit Card Problems
CN = Order Canceled
CP = ?
IN = ?
PE = ?
PI = ?
PS = ?
QO = ?
SH = Order Shipped
UO = Order On Hold
Account States:

BL = ?
CO = ?
HP = ?
QO = ?
RF = ?
FYI, these are the raw states as they are listed in the database.

Thanks,

Dana

Line Item Status Codes

The following status codes apply to each line item. These codes provide an easy way of determining the last completed stage of Order Processing for the item.

For stocked items filled with in-house inventory.

BO - back ordered. The item is currently out-of-stock.

CM - committed for sale to the customer. No processing has been completed. The item has not yet been picked, invoiced, packed or shipped.

PI - picked, but not invoiced or packed. Stage 1, Pick List/Tickets, of order processing has been completed.

PB - partial backorder.

PS - pending shipment - packed but not shipped. Stages 2 (Packing Slips), 3 (Gift Certificates) and 4-5 (Box Labels/COD Tags) of order processing have been completed.

SH - shipped. All order processing has been completed for the item. The ship date is displayed in the Line Item Detail tab in the LINE ITEM STATUS field.

QO - quotation. This indicates that an item is part of a quotation and has not actually been ordered yet.

SV - service item. This indicates that the item is a service item that does not have any physical inventory and is therefore not tracked with the status codes for a regular item that has to be shipped.

For drop-shipped items filled directly by suppliers.

ND - not ordered. The item has been sold to the customer but not ordered from the supplier.

OD - ordered. The item has been ordered from the supplier. If the customer has paid by credit card, the card has been charged and a drop ship purchase order has been generated in Stage 8-9 of order processing.

FD - filled. The item has been recorded as delivered in the Receive Product function, but the item has not been invoiced in Stage 11 of order processing.

SH - drop shipped. All order processing has been completed for the item.

QO - quotation. This indicates that an item is part of a quotation and has not actually been ordered yet.

For all items.

HS - hold shipment. The item has been assigned a future ship date in the SCHEDULE SHIP DATE field of the Line Item Detail tab.

RT - return. The item is a returned item from the customer.

From the MOM Help file but I see it's still not complete.

Go to Tools>Options> then the Security Tab.

Uncheck "Warn me when other applications try to send mail as me"

Just a disclaimer here real quick.
This does open up a security hole if you do not keep your computer updated or an employee browses to somewhere they shouldn't so this is at your own risk. It might be wise to keep it checked and then when it is time to send a batch of emails just go in and uncheck it, and when they are done re-check it. Only takes a second and might be the wise thing to do.

Also a no-brainer but NEVER EVER open any attachments that you are not 100% sure about.

Hope this helps.

Brian

johnay,

How did you disable the warning in outlook express?

Aaron