Quickbooks Commerce (formerly Tradegecko)

Quickbooks Commerce (formerly Tradegecko) is inventory and order management software. QuickBooks Commerce integrates data with QuickBooks Online to create a single platform that manages your entire business. Your inventory, sales data, customer information, and expenses will automatically be recorded in your books to save you time and give you confidence that your finances are accurate.

Quickbooks Commerce will shut down on August 31, 2023!

Please see their Data Exporter Guide - QuickBooks Commerce Offering Discontinuation page if you have questions.

Quickbooks Commerce Requirements

Connection Requirements:

  • An active subscription with Intuit Quickbooks Online.

  • The username, password, and URL to Custom Page provided by Intuit for ShipStation.

Order Import Requirements:

  • Orders must include a Ship To address.

Connect a Quickbooks Commerce Account to ShipStation

To connect your Quickbooks Commerce account to ShipStation:

  1. Login to your Quickbooks Online account.

  2. Go to the following URL: https://shipstation.tradegecko.com

  3. Click Authorize to allow ShipStation to communicate with your Quickbooks Commerce account.

  4. Copy the Username, Password, and URL to Custom Page provided on the ShipStation Integration page.

  5. Select TradeGecko.

    Trade gecko logo. Button that reads, Connect
  6. Enter the Username, Password, and URL to Custom Page details.

    Then, map any custom statuses if needed.

    Tip

    You can restrict the connection so that ShipStation will only receive orders from a single stock location by adding ?stock_location_id%5B%5D=stock_location_id to the end of the URL.

    EX: https://shipstation.tradegecko.com/fulfillments/99999.xml?stock_location_id%5B%5D=123456

After you've completed the connection steps, the store's Settings page will open. You can adjust your store-specific settings like branding and customer notifications, if you wish. Or click Save to close.

Available Features for Quickbooks Commerce

The ShipStation integration to Quickbooks Commerce supports the following standard features:

Order Status Mapping

ShipStation Status

QB Commerce Status

Awaiting Payment

Unpaid

Awaiting Shipment

Paid

Shipped

Fulfilled

Cancelled

Cancelled

On Hold

Not Mapped

Data Sent with Shipment Notification

This table indicates which data ShipStation sends to Quickbooks Commerce with the marketplace shipment notification:

Field

Sent to Marketplace?

Status Update

Green checkmark. Supported feature. Yes.

Tracking Number

Green checkmark. Supported feature. Yes.

Carrier

Green checkmark. Supported feature. Yes.

Service

Green checkmark. Supported feature. Yes.

Carrier Fee

Green checkmark. Supported feature. Yes.

Note to Buyer

Green checkmark. Supported feature. Yes.

Item Information

Red X mark. Unsupported feature. No.

Status UpdateTracking NumberCarrierServiceCarrier Fee

The shipment update ShipStation sends to the selling channel will include any Notes to Buyer set on the order in ShipStation.

Item Information

If a store allows custom statuses, this means you define that statuses your orders use in your selling channel. In most cases, if you have custom statuses you'll need to define which ShipStation statuses each custom order status corresponds to.

ShipStation will import the customer's email address with the order data and can send shipment confirmation and delivery emails to that email address (configured in your Store settings).

ShipStation will import the customer phone number with the order data.

ShipStation will import the shipping method chosen by the customer during their store checkout.

ShipStation will import the payment method used to pay for the order.

ShipStation will import discount and coupon information for the order.

ShipStation can determine if an order is a gift from the order data sent by the store.

ShipStation will import internal notes or order activity from the store into the ShipStation Internal Notes field.

ShipStation will import notes provided by the customer when they made their purchase.

ShipStation will import the total order weight from the store.

ShipStation will import the weight for each line item in the order.

ShipStation will import an image URL for each line item in the order. These images will appear as thumbnails in your Order Details and can be included in email notifications and packing slips.

ShipStation will import item options (such as color or size) for each line item in the order. This data will appear in your Order Details and can be included in customer emails and packing slips.

ShipStation will import a product stock location for each line item in the order.

Status UpdateTracking NumberCarrierServiceCarrier Fee

The shipment update ShipStation sends to the selling channel will include any Notes to Buyer set on the order in ShipStation.

Item Information

Quickbooks Commerce Integration Notes

  • The Sales Order ID imports into ShipStation as the Order ID. The Sales Order number imports into ShipStation as the Order number. ShipStation does not import PO numbers from QB Commerce.

  • Quickbooks Commerce orders should not be combined or split in ShipStation. ShipStation is unable to successfully update Quickbooks Commerce with shipment details for combined or split orders.

    If you must combine or split a Quickbooks Commerce order, you'll need to update the order in Quickbooks Commerce manually.

  • ShipStation cannot send shipment information to Quickbooks Commerce if all the products in the order are already packed, or if there is existing tracking information for the products.

  • For more details about using Quickbooks Commerce with ShipStation, review the ShipStation Sync Guide on the Quickbooks Commerce help center.

Quickbooks Commerce Troubleshooting Tips

Here are some common issues experienced by users, potential causes, and available troubleshooting tips.

Issue

How to troubleshoot or resolve

Error: There was a validation error when creating this shipment: {"fulfillment_line_items.quantity":["must be less than or equal to the unpacked quantity of the order line item"],"base":["Cannot create fulfillment on an order in the fulfilled state"]}

What it means: This error has two potential causes:

  • "Packing" the order in Quickbooks Commerce before shipping the order in ShipStation.

  • If you split a Quickbooks Commerce order in ShipStation, this error will occur when attempting to ship any order after the initial label is created. Quickbooks Commerce will not accept more than one shipment notification.

What to do: Check the option Do Not Notify Marketplace before creating labels for additional shipments.

For best results, do not split Quickbooks Commerce orders in ShipStation.

If a store allows custom statuses, this means you define that statuses your orders use in your selling channel. In most cases, if you have custom statuses you'll need to define which ShipStation statuses each custom order status corresponds to.

ShipStation will import the customer's email address with the order data and can send shipment confirmation and delivery emails to that email address (configured in your Store settings).

ShipStation will import the customer phone number with the order data.

ShipStation will import the shipping method chosen by the customer during their store checkout.

ShipStation will import the payment method used to pay for the order.

ShipStation will import discount and coupon information for the order.

ShipStation can determine if an order is a gift from the order data sent by the store.

ShipStation will import internal notes or order activity from the store into the ShipStation Internal Notes field.

ShipStation will import notes provided by the customer when they made their purchase.

ShipStation will import the total order weight from the store.

ShipStation will import the weight for each line item in the order.

ShipStation will import an image URL for each line item in the order. These images will appear as thumbnails in your Order Details and can be included in email notifications and packing slips.

ShipStation will import item options (such as color or size) for each line item in the order. This data will appear in your Order Details and can be included in customer emails and packing slips.

ShipStation will import a product stock location for each line item in the order.

Status UpdateTracking NumberCarrierServiceCarrier Fee

The shipment update ShipStation sends to the selling channel will include any Notes to Buyer set on the order in ShipStation.

Item Information