Devart ODBC Driver for ShipStation: Orders and Shipments in Excel and Power BI, Now on ShipStation API v2
Devart ODBC Driver for ShipStation is a Windows ODBC driver, $109.95 a year for one user, that lets Excel, Access, Power BI, Tableau, SQL Server and scripts read ShipStation data with SQL and write changes back. Version 2.0, released October 16, 2026, added ShipStation API version 2 with a single production key, alongside the original API version 1 key-and-secret sign-in.
ShipStation is where an online store's orders turn into labels and tracking numbers. Its built-in reports cover the shipping desk; they don't cover the owner who wants shipping cost per order next to margin in a spreadsheet, or the operations lead matching shipments against the warehouse system. The driver feeds those questions straight from ShipStation.
Quick facts
- Version: 2.0.0, released October 16, 2026 (first released December 15, 2021)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit (Terminal Server included), .NET Framework 4.5 or later
- Sign-in: API version 1 with an API key and secret key (the default), or API version 2 with a production API key
- SQL: SELECT with JOINs, subqueries, grouping and aggregates; INSERT, UPDATE and DELETE
- Price: $109.95 per year for Desktop, $219.95 perpetual
- Trial: 30 days with a trial key from a Devart account
- Refund: within 30 days, only if a technical problem support can't fix stops it working
- What we checked: the order page priced the default Desktop for Windows, 1-year subscription at $109.95 with yearly renewal. The download page listed version 2.0.0, a 32.19 MB EXE and a 36.38 MB MSI. All checked on November 14, 2026. We didn't install the driver or connect a ShipStation account
Before you buy
Check which ShipStation API your account gives you keys for. API version 1 uses two values, an API key and a secret key; API version 2 uses one production key. The driver's DSN dialog changes its fields to match the version you pick. If you're on an older driver version, you need 2.0 or later for API v2. Also remember that writes go to live orders: an UPDATE on the wrong filter can change what ships today.
Download Free Trial Buy Now
Overview
The driver sits between ShipStation's REST API and Windows ODBC. Devart's ShipStation connectivity works with customers, orders, products and other ShipStation objects, and the driver shows them as tables. You set up a DSN with your keys, and from then on Excel's Get Data, Access linked tables, Power BI or a SQL Server linked server can use ShipStation like any database.
The product has had a release every spring and autumn since late 2021. Most of them are compatibility fixes for specific tools: Crystal Reports and Tableau Prep Builder in 2022, Alteryx and Access JOINs on linked tables in 2023, Access linked tables again in 2024, Excel import and Microsoft Query in 2025, and Node.js, Visual FoxPro and DBeaver in the October 2026 release that also brought API v2.
Two versions of the same DSN dialog: on the left, API version 1 with an API key and secret key; on the right, API version 2 with a single production key.
Features
Both ShipStation API versions
Devart ODBC Driver for ShipStation lets you choose Ver1 or Ver2 in an API Version box. Ver1, the default, takes the classic API key and secret; Ver2, added in driver 2.0, takes a production key. You can keep an older DSN running on v1 while you test a new one on v2.
SQL over shipping data
Devart ODBC Driver for ShipStation accepts SQL-92 SELECT statements with JOINs, WHERE filters, subqueries, GROUP BY and aggregates, so "orders shipped per store per week" or "customers with more than five orders this quarter" is one query rather than an export and a pivot.
Changes back to ShipStation
Devart ODBC Driver for ShipStation supports INSERT, UPDATE and DELETE, so product records or order fields can be maintained from a spreadsheet or an Access form instead of the ShipStation web interface.
Keys stored safely
Devart ODBC Driver for ShipStation has stored keys and passwords encrypted in the DSN since version 1.4.0, and each key field has its own Save option, so you can choose not to keep the secret on a shared machine.
Benefits
- Shipping costs where the margins are. Join ShipStation data with sales or accounting figures in one workbook or BI model.
- A view across stores. ShipStation often collects orders from several marketplaces; SQL lets you group and compare them freely.
- Cheap for a small shop. $109.95 a year is Devart's lowest price tier for a single driver.
- Future-proof sign-in. Support for API v2 means the driver keeps up with ShipStation's newer key type.
Real-World Uses
- Monthly fulfillment report. An ecommerce manager pulls orders and their shipment details into an Excel pivot to see volume by marketplace and carrier.
- Customer repeat-rate check. A store owner counts orders per customer in Access to find the best repeat buyers for a loyalty offer.
- ERP reconciliation. An operations analyst joins ShipStation orders with the ERP's invoices through a SQL Server linked server to find orders shipped but not billed.
- Product data upkeep. An admin corrects product records in bulk with an UPDATE from DBeaver.
Who It's For, and Who Should Skip It
Devart ODBC Driver for ShipStation is for online sellers and 3PL or operations teams on Windows who already use Excel, Access, Power BI or SQL Server and want ShipStation data in them without paying a developer to code against the API.
Skip it if ShipStation's own reports and CSV exports give you what you need, or if you work on a Mac. Stores that need ShipStation data copied into a warehouse on a schedule may be better served by an ETL tool or by Devart's SSIS components for ShipStation.
Usage Guide
- In ShipStation's account settings, find your API keys: the API key and secret for v1, or a production key for v2.
- Download the trial from the Download button (Devart account required) and install the EXE or MSI.
- Open ODBC Data Sources (32-bit or 64-bit, matching your application), click Add and choose Devart ODBC Driver for ShipStation.
- Activate the trial key on the License tab.
- Pick Ver1 or Ver2 in API Version and enter the matching keys; add proxy details if needed, then click Test Connection.
- Open the DSN from Excel (Data > Get Data > From Other Sources > From ODBC), Power BI or Access.
Tip
Leave Save Secret Key unchecked on a shared PC, so the secret isn't stored in that machine's DSN and other people who use the PC can't reuse it to pull your store's data.
Where It Falls Short
- Windows only. No macOS or Linux edition is sold.
- API-bound speed. Every query becomes ShipStation API calls, so a year of orders with JOINs is slow compared with a real database, and ShipStation's API limits apply.
- No published table reference. Devart's docs explain setup but don't list each table and column; you discover the schema in your tool.
- Single user per Desktop license. A shared reporting server needs Server Standard at $799.95 a year.
What Users Say
The big software review sites list Devart's ODBC drivers as a single product rather than driver by driver, so what follows is about the family, not the ShipStation driver specifically.
Capterra and Software Advice (4.7 out of 5, 26 reviews)
The same set of reviews appears on Capterra and Software Advice. Reviewers there mention easy installation and fast data transfers, and one who used Devart's connector from on-premise SSIS against cloud Dynamics CRM described it as simple to use once permissions were set correctly, a point that applies to any cloud service, ShipStation included. The recurring complaint is the purchase side: reviewers describe the licensing process as slower than they'd like.
G2 (4.6 out of 5, 18 reviews) and TrustRadius (5.2 out of 10, 58 ratings)
G2's reviewers rate the line well and note a learning curve before complex queries become easy. One G2 reviewer credits the drivers with helping a CRM transition. TrustRadius scores lower and lists the user interface and error handling among the weak points.
Taken together, users trust the drivers once connected and find them inexpensive, but expect to spend some time learning them and to wait a little for license paperwork. Start the trial before you need the report, not the day before.
Comparisons
ODBC driver vs ShipStation's own reports and exports
ShipStation's reports and CSV exports are free and fine for one-off looks at shipping activity. The driver is for refreshable reports, joins with other systems and bulk edits; for $109.95 a year it replaces the weekly export-and-paste routine.
ODBC driver vs Devart SSIS components for ShipStation
Devart's SSIS components for ShipStation load data inside SQL Server Integration Services packages, the right tool for scheduled ETL into a warehouse. The ODBC driver is for live, ad hoc access from desktop and BI tools.
Editions and Pricing
Every edition is bought through the Buy Now button: the order page offers the edition choice and the subscription or perpetual option. Prices as listed on November 14, 2026.
| Edition | 1-year subscription | Perpetual | For |
|---|
| Desktop for Windows (order page default) | $109.95 | $219.95 | One user at a time on one computer |
| Server Standard for Windows | $799.95 | $1,599.95 | A server with up to 6 cores and concurrent users |
| Server Enterprise, Site, OEM | Ask Devart | Ask Devart | Bigger servers, many devices, redistribution |
Subscriptions need internet access for activation and license checks and stop at the end of the term unless renewed; the perpetual license activates offline. 2- and 3-year terms and premium support are offered on the order page too.
FAQs
Does the ShipStation ODBC driver support ShipStation API v2?
Yes. Devart ODBC Driver for ShipStation added API version 2 in version 2.0.0 (October 2026). Choose Ver2 in the DSN and enter your production API key.
Can I use the ShipStation driver with Google Sheets?
Not directly. Devart ODBC Driver for ShipStation is a Windows ODBC driver, so it works with Windows programs such as Excel, Access and Power BI Desktop. Google Sheets runs in the browser and can't use an ODBC data source on your PC.
Do I need a separate license for my laptop and my office PC?
Devart ODBC Driver for ShipStation's Desktop license covers one desktop computer used by one person at a time, so a second computer needs its own license under Devart's terms.
Is there a money-back guarantee?
Only for technical failure. Devart ODBC Driver for ShipStation can be refunded within 30 days of purchase if a bug or technical problem stops it working and Devart's support can't fix it.
Can I install the ShipStation driver silently on many PCs?
Yes. Devart ODBC Driver for ShipStation comes as an MSI package as well as an EXE, which suits silent and Group Policy deployment.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- Only one version of the driver installed
- ShipStation API keys (v1 key and secret, or v2 production key) and HTTPS access, directly or through a proxy
Conclusion
Devart ODBC Driver for ShipStation is a good buy at $109.95 a year for a Windows-based store or fulfillment team that keeps exporting ShipStation data to answer questions in Excel or Power BI; support for both API versions keeps it usable as ShipStation moves to v2 keys. The reason not to buy is volume: it reads through ShipStation's API, so it suits reports and bulk edits, not a full data warehouse. Use the 30-day trial on your own store first.
Download Free Trial Buy Now