edit usps shipping module -- help needed

[RixStix]

It appears that ShipWorks is building its own text string for what you pasted since that data is not located anywhere within the ZC database in the format that you posted.

IF ShipWorks used the ZenCart orders table; shipping_method field (without modification), the information that you say you need within the first 40 characters. (50 characters according to a SW comment that I read recently.)

Can you ask SW about how they arrive at the datastring that you posted?

[RixStix]

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):

[tomarriola]

RixStix-- thanks. My invoices do show
United States Postal Service (1 Boxes) (1 lbs, 1 oz) (Standard Post)

I will dig into the shipworks template that I think is used to generate the labels. I'll post an update.

Again-- I appreciate you looking at this.
Tom