OK, so I downloaded the 75MB SW zipfile, then the MSFT SQLserver 2008 files, then finally got the zencart php file.

Looks like SW is downloading Table:Orders_total:TITLE which in my case is identical to Table:Orders:shipping_method with the exception of a trailing colon.

From my database, the data is
United States Postal Service (First-Class Mail Parcel)

From your example, it appears that SW is inserting other information in the middle
United States Postal Service (1 Boxes) (1 lbs, 1 oz) (Standard Post)

If SW would remove, or not insert, their additional data, your needed information would be within the first 50 characters. The info that you need is within the first 50 characters that SW appears to be receiving from ZC.

What does the shipping show on a printed invoice?
  • United States Postal Service (1 Boxes) (1 lbs, 1 oz) (Standard Post): OR
  • United States Postal Service (Standard Post):