edit usps shipping module -- help needed

[tomarriola]

I need to edit the string that is printed out for usps. We use shipworks to ship and it can only view the 1st 40 characters of the shipping field to determine shipping. I need the shipping type to be within that range.

On a completed order here is what I get
United States Postal Service (1 Boxes) (1 lbs, 1 oz) (Standard Post)

This is what I want
United States Postal Service (Standard Post) (1 Boxes) (1 lbs, 1 oz)

Thanks
tom

[RixStix]

Not using ShipWorks but I'll give it a try.

What database table and what datafield does ShipWorks download for shipping?
The reason I ask is that our database does not save the number of boxes, nor weight in the Orders table => Shipping_method field.

ShipStation uses the shipping_method field to trigger their internal automation filters and rules. Maybe ShipWorks uses a different field or maybe zencart is saving the number of boxes and weight in the shipping_method field and turning that off will resolve your issue?

These are examples of what is in my shipping_method field. If you had that, it sounds like your problem would be resolved since the data needed is within the first 50 characters.

United States Postal Service (First-Class Mail Parcel)
United States Postal Service (Priority Mail™ Small Flat Rate Box)

[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