ShipStation Integration

ShipStation supports three kinds of integration:

  • Custom store integration
  • Connect ShipStation as a Store
  • Connect ShipStation as a Shipping Service.


Connecting ShipStation as a Shipping Service currently is only used to estimate Shipping Rates and print Shipping Labels. In the future, this will be expanded to offer the whole fulfilment service, replacing the Custom store integration. See ShipStation as a Shipping Service for more information. 


  • Custom store takes orders from DEAR, sends them to ShipStation to be fulfilled, then sends back a tracking number for the DEAR order.
  • ShipStation Store downloads order data from the ShipStation e-Commerce storefront to be synced with DEAR stock levels.


This document will only focus on ShipStation Store. 


Prerequisites


Table of Content

  1. ShipStation Store Integration 
  2. Catalogue
  3. Orders and Sales
  4. Operations Log


ShipStation Integration Setup

[back to top]


ShipStation Custom Store and Shipping Service are mutually exclusive and cannot be connected at the same time. If you attempt to connect both, you will receive a message in DEAR asking if you wish to change the integration type. ShipStation Store can be connected at the same time as either Custom Store or Shipping Service. 


NOTE: When using both types of integration (Custom Store and ShipStation Store), there are some validations to prevent user data from being damaged:

  • Unable to download data from ShipStation (API) if this data was first exported from DEAR using (Custom Store Integration). Data will not be saved.

  • Unable to export (Custom Store Integration) sale orders that were downloaded from ShipStation (API).

  • You need to use a DEAR login that is linked to a single DEAR Organisation only. When trying to connect ShipStation to a DEAR account with more than one organisation, error code 300 will be generated, preventing data from being exported to ShipStation. 

First, you must connect DEAR to ShipStation. DEAR provides two free external integrations with the standard subscription plan, however, additional external integrations must be purchased from the My Subscription page. 


To connect ShipStation to DEAR:

  1. Navigate to Integration -> ShipStation.



  2. Click + to connect a new store. 
  3. Enter your API credentials and click Connect ShipStation as a Store. You can find your API credentials in the API settings of your ShipStation account.



Integration settings

[back to top]


In the Setup tab, several integration settings can be customised.



Order Capture 

This option specifies when a ShipStation Order will be captured: when it is created, when it is paid, when it is no longer on hold or when it is shipped. This setting is also taken into account when downloads of historical orders from ShipStation are triggered.


Consolidate Orders

DEAR - ShipStation Integration allows two options for order consolidation:

  • No Consolidation

  • Daily Consolidation.


No Consolidation indicates that sales will be captured from ShipStation once an hour as individual sales. Daily Consolidation will consolidate all orders from that day into a single order. When Daily Consolidation is chosen, an additional setting becomes available – Consolidation Time. This is your local time when all pending orders aggregated during the day will be processed.


See the Pending Order Processing section below for more details.


Customer

For the pending order processing to be successful, an existing customer must be selected.

When Consolidation Type is Daily Consolidation, this customer is used to create a new sale task which will combine all daily sales. A customer can be created in DEAR just for this purpose.


Price Tier

Choose which DEAR price tier to use when DEAR downloads products from ShipStation or updates product information. See Managing Price Tiers for more information. 


Pick, Pack and Ship Processing Mode

When pending orders are processed by DEAR, new sale tasks are created. This setting tells DEAR if it should try to Auto Pick, Auto Pack and Auto Ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then Pick will remain in Draft state, and Pack and Ship won’t be completed.


DEAR does not pick up shipment information from ShipStation if Auto Ship is selected and will not create fulfilment in ShipStation in this scenario (if Auto Ship is enabled).


Invoice Status

You can control the Invoice Status for Sale tasks created as a result of pending order processing. By default, the Invoice will not be authorised and will be in Draft state, adjustable and waiting for authorisation. However, if this setting is changed to AUTHORISED, the Invoice will be automatically authorised, and pending sync will be created for it to sync with an accounting application of your choice.


Optional revenue account

Revenue account to be used for all sales downloaded from ShipStation. This will override settings at the Product/Customer level and any other Account mapping. 


ShipStation Dimension Units

To avoid discrepancy, this setting must match the dimension setting from your ShipStation account. You can find your ShipStation dimension settings by going to ShipStation -> Account Settings -> Display Options -> Time and Units.


Sales Representative Name

This option allows the shop name to be used as a Sales Representative. 


Match Product
An option to choose automatic mapping by SKU or manual mapping by the user when products are downloaded from ShipStation (Load Products on the Catalogue tab of the ShipStation integration). When automatic mapping is selected, the existing product will be searched for automatically by SKU, and if a product is found with a matching SKU, then the mapping is done automatically. When manual mapping is selected, the user will have to manually select which DEAR products to link to via the Catalogue tab. Manual mapping can still be performed even if automatic mapping is enabled. See Linking Catalogue Products for more information.


Create a new product if not found by SKU

This option is only available when Match product by SKU is enabled. With this option enabled, if there is a product (SKU) in the Sale channel that does not yet exist in DEAR, then this product can be automatically built in DEAR based on the data received about the product from a Sale channel. The possibility of a manual build is still always available through the DEAR UI.


Use ShipStation as Master Source for DEAR Products

If this option is enabled, if a product has been changed or updated in ShipStation, the linked product in DEAR will be changed to match upon catalogue download. Product changes in DEAR can include changed price, name, weight, length, pictures and other data (except SKU) based on the product data downloaded from ShipStation. Be aware! Turning on this feature can damage your product data in DEAR.


Shipment is taxable

In ShipStation, Tax is entered just as a single amount. In DEAR, tax is attributed per line item, so if we enable the 'Shipment is Taxable' option, it is distributed based on a prorated basis of total invoice lines.


Examples:


If No is selected, the additional charges column won't have tax attributed to it.


If Yes is selected, the additional charges column will have a tax amount attributed to it on a prorated basis taken from the total tax line amount.


Enable Order Routing

When a customer places an order, DEAR can automatically route the order to the seller's inventory location nearest to the provided shipping address for fulfilment. See Order Routing for more information.



Location Mapping

ShipStation supports multiple locations. Map ShipStation warehouses to your DEAR Locations here. 


Tax Rule Mapping

For businesses located in the United States, it is necessary to Add a US place of business by clicking the button and inputting the correct US address (by entering the correct ZIP code first). After that, new Tax rules will be created. Generally this will be three tax rules: State, State,County and State,County,City. These tax rules will be automatically applied to sale invoice lines (products) downloaded from ShipStation and having a Shipping Address in the US.


When a pending order is processed by DEAR, a sale task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines. 


DEAR does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the ShipStation order. This means that if certain products are not Taxable or with varying tax in ShipStation, all data and totals in DEAR will look identical to ShipStation, but with DEAR tax rule name selected in this setting.


In case of tax recalculation, Tax amount will be overwritten with a value calculated by DEAR Taxation rule.


IMPORTANT:  Orders will be skipped on download if Taxation mapping is not finished! 


Payment Account Mapping

DEAR can capture payments made against orders in ShipStation and is able to automatically add payments to a created sale invoice. To do this, Payment Account Mapping must be completed on this integration settings screen. You must choose an account that is able to receive payments from the chart of accounts. 


This setting is not mandatory – if payment mapping is not completed, orders are still captured and downloaded from ShipStation, but payments must be manually added to invoices in DEAR. Some customers prefer to keep invoices open and then reconcile them with payouts from ShipStation. 


Disconnect from ShipStation store

When you disconnect from ShipStation store, DEAR removes all associations between DEAR objects and ShipStation, including Log and Product Catalogue.


Catalogue

[back to top]


The DEAR ShipStation Catalogue page allows the user to Download products from ShipStation, break the link between a DEAR product and its ShipStation listing and update quantities in ShipStation according to DEAR available stock.


Downloading Products

[back to top]


Products can be loaded from ShipStation to DEAR in the Catalogue tab by clicking Load Products. This operation may take some time.



All products in ShipStation are mapped as simple products in DEAR. ShipStation does not support product variations and does not supply quantities, which are required in DEAR. If the customer has bought a product variation in their ShipStation order, information about the selected options will be provided in the Order and Invoice sections of the Sale Order for each line in the comment field.


When a product is created/updated in DEAR during download process, there is a link established between the product and variant unique ShipStation product ID and DEAR unique product ID. This link is used when products are matched against sale order lines in ShipStation and when subsequent product downloads occur.


The Category field is not mandatory for ShipStation but is a required field for DEAR. If a product has no category specified, DEAR will give it the product category Other.


When downloading products, DEAR tries to match existing products first to avoid creating duplicates. In ShipStation, the product Name (Title) could be non-unique whereas DEAR enforces mandatory SKUs. Names that appear more than once will produce an error message, and the user will be able to link products manually. 


During product download DEAR automatically creates product categories for all product types in ShipStation if specified.


Normally this function is not used except for test purposes because DEAR automatically creates products when processing sale orders, and because there is no Quantity information for products in ShipStation.


Data mapping for products between DEAR and ShipStation:


DEAR
ShipStation
SKU

SKU 

NameProduct name
CategoryCategory (if specified) or Other
DescriptionProduct InternalNotes
WeightWeightOz (Converted to KG on download)
WidthWidth
HeightHeight
LengthLength
Product TagsProduct Tags associated with ShipStation Product
Product TypeAlways Stock
Default is Price Tier 1Price
StockLocatorValueProduct WarehouseLocation
ESCCustomField1Product FulfillmentSKU



Linking Catalogue Products 

[back to top]


There are two possible statuses for products in the Catalogue: Not Listed or Listed.


You can download products from ShipStation and perform automatic product mapping to products in DEAR. Products in DEAR cannot be listed in ShipStation. 


There are three linking options:

  • Leave blank (do not tie to a product in DEAR)

  • Link to an existing product

  • Create a new product in DEAR (available if the product with the required SKU does not exist).

 



Orders and Sales

[back to top]


Processing Pending Orders

[back to top]


If No Consolidation is selected, each ShipStation sale is converted into an identical sale in DEAR, keeping the same customer and shipping information. These orders will be captured once an hour. If Daily Consolidation is selected, the single daily sale task will use the customer selected in the integration settings, and customer, billing and shipping information imported from ShipStation will be ignored. 


When processing orders, the logic is identical to that of the DEAR UI. DropShipping, Kitting and other important scenarios are implemented in the same way as through the DEAR UI.


Pending Orders can be processed manually by clicking Process. They can then be viewed in the Log tab.


Cancelling an order in ShipStation will NOT cancel or void the linked sale task in DEAR. The sale must be manually voided in DEAR.


Downloading Customers

[back to top]


The Load Customers button can be found next to Load Products



This function downloads all customers from ShipStation to DEAR. If the customer already exists in DEAR, this function updates any details that have been changed in ShipStation. As DEAR automatically creates customers when processing sale orders (if 'No Consolidation' option is selected), this function is generally only used for testing purposes. 


This function creates a customer in DEAR with Contact, Billing and Business addresses captured from ShipStation.



Downloading Orders and Payments

[back to top]


Orders are automatically downloaded every hour if they have been created or changed in ShipStation. 


NOTE: Generally, you do not need to trigger manual order download, however if an order was not captured by DEAR or to load historical sales you can use the manual Load Order option.


Any imported order is saved to the Pending Orders section. It is a temporary storage of all sales and payments in DEAR. If an order already has an entry in the Log (i.e. was imported previously), it will be skipped. This guarantees that no duplicate sales will be created by DEAR.


While saving orders, DEAR captures customer information, billing and shipping addresses. All line items are captured together with quantities, prices and totals. Total order discounts are applied as are additional charges to the whole order, without distribution by lines to reduce the chance of discrepancy.


Invoice Adjustment lines are also saved  in the Sale invoice as additional charges named Shipping.


If a Payment Account has been specified in the Integration Settings, DEAR will always assign associated payments to the captured ShipStation orders.


For each line in the Sale Order DEAR tries to locate a corresponding product by SKU. If no product is found, DEAR tries to download product info from ShipStation with the same logic as in Download Products function. If product info is not found, DEAR marks this line as Service (Non-product). Next, the Sale line is saved to pending orders with all data from ShipStation: Tax, quantity and Total.


The final step in the order download is to trigger update of stock levels in other ShipStation stores and other connected eCommerce channels.


Cancelling an order in ShipStation will NOT cancel or void the linked sale task in DEAR. The sale must be manually voided in DEAR. 


Returns and Refunds

[back to top]


ShipStation Store supports returns and refunds. 


Updating Fulfilment in ShipStation

[back to top]


When Shipment is authorised in DEAR and the carrier specified, DEAR will try to create order shipment information in ShipStation. This will only work in No Consolidation processing mode.


Logs

[back to top]


Each captured ShipStation order once saved to Pending Orders creates a Log entry to track the link between the Sale in DEAR and in ShipStation. This eliminates the possibility of creating duplicated orders when capturing the same order several times during manual order load. 


Each Log entry has a link to the sale task in DEAR. Depending on the settings selected by the user in the Setup tab, this sale task could be draft or authorised, one or more of the Pick, Pack and Ship tabs could be authorised, and payment could have been applied to the invoice. 


Log entries allow you to see which Sale task reflects a particular ShipStation sale. You also have the option to delete a Log entry manually. This will allow to reprocess an order if required. Deleting a log entry will not void or delete its associated sale task.


Reloading Orders from ShipStation

[back to top]


If for any reason you need to reload an order from ShipStation, this can be managed from DEAR.


To reload an order from ShipStation:

  1. Void the sale task. A record of this will be kept in DEAR for reconciliation purposes but the transactional data will be deleted. 
  2. Return to the ShipStation integration Log tab and delete the Log entry. This will allow the order to be recaptured from ShipStation.
  3. Navigate to the Pending Orders tab and click Load Orders, making sure the date is set to before the order to reload was made. 


Operations Log

[back to top]


Each time the user or DEAR downloads sales, an appropriate record is added to the operation log. It also contains information about results of downloading, including the count of processed, skipped or cancelled orders.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.