Using ShipWorks with Magento (USPS, UPS, Fedex Shipping integration)

In this post we will be exploring the integration of Interapptive's ShipWorks with Magento.

ShipWorks is a Windows-only desktop application that integrates a number of different shopping carts with the most common shipping services. It uses the Microsoft SQL server as it's data storage engine, allowing it be installed on multiple computers on the same network.

ShipWorks currently has support for the following shipping methods:

UPS (direct integration)
UPS Worldship
DHL (direct integration)
Fedex
USPS (Label printing, w/out postage)
USPS (via Stamps.com desktop application - domestic shipping only)
USPS (via Endicia desktop application)

Benefits of using ShipWorks

Fast shipping fulfillment
Less error-prone than copy-and-pasting
Integration with multiple different shipping methods
Low cost (max. of $49.95/mo - see pricing)

Disadvantages

Windows-only (this is a common trend with shipping management software)
Desktop-based (as opposed to web-based)

Typical Magento/ShipWorks Order Fulfillment Workflow

Here are the steps a typical order fulfillment process will look like, once the Magento/ShipWorks integration is completed:

Download new orders from Magento by going to "Order > Download Orders" in Magento. This will download all orders since the last order download.
Select all orders that aren't marked as "Closed" or "Complete". You can create filters in ShipWorks that will only show orders that match certain parameters. If you offer multiple shipping providers (eg, UPS & Fedex), you'll want to select and process orders from each shipping provider separately.
Click the button on the toolbar for the shipping provider associated with the selected orders.
You'll then customize the shipping options (delivery confirmation, insurance, etc...) for the orders. You can do this individually or as a group.
1. Note: I did notice that when you open the shipping label dialog, ShipWorks doesn't properly associate shipping services imported from Magento to their respective service type in. For example, when you select three orders, one with "USPS Priority" and the others with "USPS First-Class" mail, the "USPS Priority" option is selected for all orders. Here is a screenshot demonstrating this.
Once you're done customizing the shipping options, you'll print the shipping labels.
Once an order is shipped, it will be marked as "Complete" in Magento. A Shipment will also be created that will be associated with the associated Order and Invoice. If a tracking number was provided from the associated shipping service, it will be added to the Shipment. This will allow a customer to login to the "My Account" section of the Magento store and see that their order has been shipped.
ShipWorks has the ability to send shipping confirmation emails directly to the customer. This may work fine for many merchants, but there will be those that want Magento to send the shipment confirmation email. Based on my perusal of shipworks.php file, it doesn't look like a shipment notification email is sent from Magento when a shipment is created. If a merchant wants to have all emails sent from Magento, it would require a small change to be made to the shipworks.php file.

Alternative Solutions for Integrating Magento with UPS, USPS, or Fedex

There are alternatives to using ShipWorks. Here are a few alternatives. If you know of any integration methods that aren't listed here, please let me know and I'll add them to the list.

Installation - Magento Script

In order to install the Magento script for ShipWorks, all you have to do is copy the provided shipworks.php file into your Magento installation directory.

Installation - ShipWorks

Here are screenshots of the ShipWorks installation process:

[caption id="attachment_104" align="alignnone" width="521" caption="Initial Setup Screen"]

[/caption] [caption id="attachment_105" align="alignnone" width="515" caption="Installation Location"]

[/caption] [caption id="attachment_106" align="alignnone" width="514" caption="Database Location Selection"]

[/caption]

If you choose the "Connect to and existing ShipWorks" database, you'll see the following:

[caption id="attachment_107" align="alignnone" width="515" caption="SQL Server Selection"]

[/caption]

If you choose the "Create a new ShipWorks database" option, you'll see this:

: You can either install the packaged version of Microsoft SQL Version, or you can use an existing installation

[caption id="attachment_111" align="alignnone" width="513" caption="ShipWorks connects to the Interapptive servers to download the latest version"]

[/caption]

: You'll create an SQL account on your newly installed server

[caption id="attachment_112" align="alignnone" width="513" caption="After installing MSDE (SQL Server Desktop Engine) and restarting your computer, you'll create a database"]

After installing MSDE (SQL Server Desktop Engine) and restarting your computer, you'll create a database

[/caption] [caption id="attachment_113" align="alignnone" width="513" caption="Setup ShipWorks user account"]

[/caption] [caption id="attachment_114" align="alignnone" width="509" caption="Software Licensing Screen"]

[/caption] [caption id="attachment_116" align="alignnone" width="511" caption="Magento Store Setup Wizard"]

[/caption] [caption id="attachment_117" align="alignnone" width="512" caption="Shipment Settings"]

[/caption] [caption id="attachment_118" align="alignnone" width="718" caption="ShipWorks will use these settings to send emails to customers (if you configure it to send email notifications)"]

ShipWorks will use these settings to send emails to customers (if you configure it to send email notifications)

[/caption]

ShipWorks Screenshots

Here are some screenshots of ShipWorks in action. More screenshots/screencasts can be found on the Interapptive site.

[caption id="attachment_119" align="alignnone" width="718" caption="Once you connect ShipWorks to Magento, you can "Orders > Download Orders" to download all orders from Magento"]

Once you connect ShipWorks to Magento, you can "Orders > Download Orders" to download all orders from Magento

[/caption] [caption id="attachment_120" align="alignnone" width="718" caption="Orders View - You can view all orders that have been imported from Magento (customer data is blurred). "]

Orders View - You can view all orders that have been imported from Magento (customer data is blurred).

[/caption] [caption id="attachment_121" align="alignnone" width="718" caption="Customer View - See all customers that are associated with the imported orders. ShipWorks groups all orders for a specific customer together, allowing you to see an entire order history for a customer."]

Customer View - See all customers that are associated with the imported orders. ShipWorks groups all orders for a specific customer together, allowing you to see an entire order history for a customer.

[/caption] [caption id="attachment_122" align="alignnone" width="718" caption="Here is an example of 7 orders being prepared to print labels using Endicia's Dazzle application"]

Here is an example of 7 orders being prepared to print labels using Endicia's Dazzle application

[/caption]

Posted on August 15, 2009

Posted by Erik Hansen

Comments

i have used the same system

Submitted by ozcan on Wed, 08/29/2012 - 00:01.

i have used the same system on http://www.incontinencestore.co.uk

Wow so much information on

Submitted by Order Fulfillment on Tue, 04/24/2012 - 16:43.

Wow so much information on Shipworks. Thanks for the Article, good information. I was looking around for Order Fulfillment options.

I really like this article, i

Submitted by Beyonce lace front wigs on Tue, 06/28/2011 - 08:21.

I really like this article, i will try it , but where i can buy this

I am wondering if you have

Submitted by Thanik B on Thu, 06/23/2011 - 02:36.

I am wondering if you have tried out TrueShip and, if so, what might be your opinion? I found them from UPS Ready Application provider list.

ShipWorks is now available as

Submitted by Anonymous on Sun, 07/15/2012 - 13:53.

ShipWorks is now available as a UPS Ready solution as well. Contact your UPS rep for more details.

Thanks for writing this. I

Submitted by John K on Mon, 12/27/2010 - 15:47.

Thanks for writing this. I also think you should add ShipSync to the list of other products to look at...

http://www.illapps.com/shipsync.html

@Dan - I'm not sure if either

Submitted by ehansen on Mon, 08/02/2010 - 14:03.

@Dan - I'm not sure if either one of those apps plays better with ShipWorks than the other. One thing to keep in mind is that Stamps.com DOESN'T support international shipping, at least at the time I wrote this article. I would recommend contacting Shipworks (http://www.interapptive.com/company/contact.html) to get their take on which app they'd recommend.

Hello all! Great post! I am

Submitted by Dan on Mon, 08/02/2010 - 03:27.

Hello all!
Great post! I am still on the fence, weighing out the advantages and disadvantages. I want to go with shipworks, but can anyone recommend which postage solution works better with is, Endicia or Stamps.com? They both cost about the same and their features are nearly identical, but does one of them play better with Shipworks than the other? Any advice is greatly appreciated!

Has anybody compared

Submitted by bj0rn on Wed, 06/16/2010 - 20:04.

Has anybody compared ShipWorks head-to-head with Webgility's eCC? I'm trying to figure out the best way to connect Magento with Endicia :)

@Vijay - Thanks for the link.

Submitted by ehansen on Mon, 05/31/2010 - 14:28.

@Vijay - Thanks for the link.

If you want to save some time

Submitted by Vijay Das on Mon, 05/31/2010 - 01:32.

If you want to save some time on the above integration try a Magento only FedEX module called:
ShipSync - A Magento FedEx API extension that has rate estimations, automatic shipment creation, label printing (including thermal), tracking codes, address validation, and bunch more. $250. I have been using ShipSync for almost a year now for my ecommerce site and I have been very happy with it.
http://www.illapps.com/shipsync.html

@PapaCuppa - You'll want to

Submitted by ehansen on Tue, 05/04/2010 - 21:17.

@PapaCuppa - You'll want to contact ShipWorks directly with that question: http://www.interapptive.com/

Is this USA only? Thanks

Submitted by PapaCuppa on Tue, 05/04/2010 - 21:12.

Is this USA only?

Thanks

@Sammy - This is something

Submitted by ehansen on Mon, 02/08/2010 - 13:43.

@Sammy - This is something that I don't believe has been done by anyone up to this point. I'd recommend contacting Shipworks @ http://www.interapptive.com/company/contact.html to see how much they would charge to make this customization. If they're not able to make the customization, we can make the customization of the shipworks.php file. If you're interested, just get in touch with us using our contact form.

"If a merchant wants to have

Submitted by Samy on Sat, 02/06/2010 - 01:31.

"If a merchant wants to have all emails sent from Magento, it would require a small change to be made to the shipworks.php file."

Where can we get additional info on how to do the above statement or link with instructions?

Great post BTW!!!

@Neil Thanks for your

Submitted by ehansen on Mon, 01/11/2010 - 14:05.

@Neil Thanks for your feedback on ShipWorks. I'd love to hear how the rest of your trial period goes.

I'm about 5 days into a

Submitted by Neil on Sat, 01/09/2010 - 19:22.

I'm about 5 days into a 30-day evaluation and so far I'm impressed. We're bricks and clicks. 90% of our shipments weigh less that 2 lbs.

I currently use a Pitney Bowes Mailstation ($50 month rental) to print regular postage and first class packages, this is a problem in that I can't do delivery conf without a trip to the post office.

I have to manually enter address info into USPS Click and Ship for priority mail and manually maintain the magento status for each order.

It's all very time consuming.

With Shipworks and Magento and stamps.com and UPS online I can now do everything from the Shipworks desktop application, and apply delivery confirmation/tracking if I want. I'll print 44c stamps from stamps.com. Magento status is updated automatically and emails are sent to the customer.

This is going to be a huge productivity win for us.

I'm going to send the mailstation back and cancel the Pitney Bowes account, and my initial service fees (stamps.com and shipworks will be less than $50 - by my calculation they could max out at $64.95/month.

Still another 25 days of evaluation, but so far so good.

@steff I would recommend

Submitted by ehansen on Mon, 12/28/2009 - 21:30.

@steff I would recommend contacting ShipWorks about this issue. You can contact them here: http://www.interapptive.com/company/contact.html

HI - this is great info. Any

Submitted by steff on Sat, 12/12/2009 - 05:53.

HI - this is great info.
Any idea why Shipworks would not be able to download all the orders in my store? I have everything set up, but am only getting 8 order downloaded out of 60?

any ideas of where i can go to figure this out would be appreciated...

cheers,
Steff

Thanks for this guide. I

Submitted by Carl on Wed, 08/26/2009 - 16:31.

Thanks for this guide. I have been using a version (apparently older) with my zen cart store and I'm in the process of switching to Magento. I didn't think it was supported, and here I find out that not only is it supported, but apparently my software is quite out of date . . .

Thanks!

Classy Llama Studios

Main menu

Blog