Yes, the MOM Forum would have gotten you an answer much quicker!
Why is your customer not using the integrated UPSLink, whereby MOM acts as UPS, picks, pack, scan, and ship all packages from within MOM and have instant tracking numbers in the system without the need for exporting and importing files? Ask MOM Tech Support about the integrated UPSLink HTTP Interface.
NOTE: I don't believe you can run UPSLink on any computer that has had UPS Worlship currently or previously installed on it.
For the limited international shipments they do, you would still have MOM export the international shipping file to Worldship. You have to properly map the appropriate fields in WorldShip to be able to read the file, and setup Keyed Import. Then the customer would enter the order number, and WorldShip will automatically fill in most fields. Upon End Of Day, it would then export a file back to MOM, which needs to be imported in MOM. Again, MOM can help with all of this, since there are so many details. Ask MOM for the WorldShip Integration Addendum. It sounds like whomever setup the UPS system set the file to Append, rather than Replace. That is probably whjy you are re-importing so many records.
I've been talking to UPS and Dydacomp about using UPS Online but I was told it may actually be more effort for the client.. doing the keyed import sounds best for right now, though it sounds like the keyed import rquires mapping directly to the MOM database, and that's where I've not been able to find any good information.. can we do a keyed import straight off the dbf file coming over now? if so then it sounds like we might just need to change the primary key on the import.
I've got a post on the official forums now as well, so we'll see.. I do appreciate the response! this is our first MOM integration.. aside from this whole worldship piece, everything else has been great.. www.estherprice.com if you are curious to see some of our sitelink modifications