Handshake Integration

Handshake offers a B2B gateway for placing orders, mobile order writing and web order functionality which compliment the strong inventory management features of DEAR Inventory. The main purpose of the integration is to extend business back end management functions of DEAR by adding the client facing offering of Handshake.


Prerequisites


Table of Contents

  1. Integration Summary
  2. Handshake Integration Setup
  3. Catalogue
  4. Orders and Sales


Integration Summary

[back to top]


The table below summarises the data flow between Handshake and DEAR Inventory at different stages of the integration process. DEAR supports the following integration processes:

  • Integration setup
  • Load a catalogue (products/items)
  • Publish the catalogue (products/items)
  • Load customers
  • Import orders and payments
  • Process orders and payments
  • Stock level update
  • Shipment information update.


Process
Handshake
Direction
DEAR
SetupWarehousesMapping only, new locations must be created in both systems manuallyLocations
Order CategoryMapping only, new order categories and customer groups must be created in Handshake, Tax Rules created manually or loaded from the accounting system
Customer GroupsTax Rules
Order StatusMapping order status to DEAR chart of accounts. Handshake doesn’t provide relevant payment information. We assume that payment is received when the order is in selected status.Chart of Accounts
Load a catalogueItem CategoriesFrom Handshake to DEARProduct Categories
Items and VariantsProducts and Product families
Publish the catalogueItem CategoriesFrom DEAR to HandshakeProduct Categories
Items and VariantsProducts and Product families
Import orders and paymentsCustomersFrom Handshake to DEARCustomers
OrdersPending Orders
Item CategoriesProduct Categories
Items and VariantsProducts and Product families
Process orders and payments
No communication between the systems at this pointSales
Stock level updateItems and VariantsFrom DEAR to HandshakeStock Level
Shipment information updateOrdersFrom DEAR to HandshakeShipment


Handshake Integration Setup

[back to top]


First, you must connect DEAR to your Handshake store.


It is possible to link several Handshake stores to a single DEAR account. Each linked store has an independent catalogue, logs and settings. DEAR provides two free external integrations with the standard subscription plan; additional external integrations must be purchased from the My Subscription page. 


To connect Handshake to DEAR:  

  1. Navigate to Integration -> Handshake.



  2. Click + to connect a new store. 
  3. Enter your Handshake shop name and API key (you can find the API key in your Handshake account) and click Connect to Handshake.


Integration Settings

[back to top]


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




Order Capture 

This option specifies when a Handshake order will be captured: when it is confirmed, when it is processing or when it is complete in Handshake. This setting is also taken into account when downloads of historical orders from Handshake are triggered.


Consolidate Orders

DEAR - Handshake Integration allows two options for order consolidation:

  • No Consolidation

  • Daily Consolidation.

No Consolidation indicates that sales will be captured from Handshake as they occur. 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 the 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.


Sale Price Tier 

Choose which price tier to use as the default price when DEAR uploads products to Handshake or updates their information. See Managing Price Tiers for details. 


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 Handshake if auto-ship is selected and will not create fulfilment in Handshake 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

Here you can specify the revenue account to be used for all sales downloaded from Handshake. This will override settings at the Product/Customer level and any other Account mapping. 


Sales Representative Name

This option allows the field name to be used as a Sales Representative (for example, the shop name). 


Handshake Sale Tax Status

This option sets the default Tax Status for Handshake sales as Tax Inclusive or Tax Exclusive. 


Create Payments for Sales

This option enables DEAR to create payments for sales. Handshake does not send payment information to DEAR – it is assumed a payment has been made once an order receives the status specified in the 'Status for Payment Creation' setting.  


Status for Payment Creation

When a sale order has this status, DEAR will be able to create a payment for it if the 'Create Payments for Sales' option is enabled. The order status can be Confirmed, Processing or Complete. 


Payments Account

Select an Account from the chart of accounts that has an ability to receive payments to be used in DEAR payments. If this account is not selected, payments will not be created.


Update Stock Levels in Handshake

You may choose to disable automatic stock level update in Handshake performed by DEAR at the time available product quantity changes in DEAR. This may be useful if you are managing stock level in Handshake manually and do not want DEAR to change it. Please ensure you have the correct stock quantities entered in DEAR before you turn on this option as these values will override the stock quantities in Handshake.


Sync Brands and update Categories of DEAR products 

If this option is enabled DEAR will push Brands to Handshake and update Category names in DEAR if they are changed in Handshake. 


Export Shipping Information to Handshake 

If this option is selected, DEAR will export shipping information to Handshake. Further details can be found in the Fulfilment section. 


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.



Tax Rules Mapping Mode 

When a pending sale is processed by DEAR, a sale task is created with the order and invoice lines filled in. DEAR can use different tax rules defined in the tax rule mapping settings to create these lines. Whether downloaded sales are Tax Inclusive or Tax Exclusive is defined in the Handshake Sale Tax Status setting. 


DEAR chooses one tax rule for a pending sale (according to tax rule mappings) and uses it to calculate taxes from totals received from Handshake.


There are thee modes of Tax Rules mapping:

  • Use one Default Tax Rule for all sales
  • Select a Tax Rule for each Order Category
  • Select a Tax Rule for each Customer Group.


A Default Tax Rule should always be defined – in some cases the order will not belong to any Order Category or the Order Customer will not belong to any Group. Once one of the mapping modes has been selected you will have the option of defining Tax Rules for Customer Groups/Order Categories. 


Customer Groups and Order Categories are automatically downloaded when Handshake is connected to DEAR and later can be manually downloaded on the Setup page.


Tax Rule Mapping

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 uses these tax rules to calculate taxes from totals received from Handshake.


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


Location 

Handshake allows the use of multiple warehouses. Map DEAR Locations to Handshake locations in these settings. 


Disconnect from Handshake store

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

Catalogue

[back to top]


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


Downloading Products

[back to top]


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



There are 2 types of items in Handshake: simple items and items with variations which correspond to DEAR's simple products and product families. Each variable product in Handshake can have an unlimited number of dimensions (options), but DEAR product families only have 3. Due to this constraint, DEAR uses only the first 3 required dimensions from the Handshake variation when loading products from Handshake. 


When downloading items from Handshake, DEAR first checks if the item in Handshake is a simple item or an item with variants. If the item has variations in Handshake, DEAR creates a Product family and then all variants of that item are created as products in DEAR belonging to that family. If a family and products are already created/linked with Handshake, then DEAR updates the existing family/products instead of creating new ones.


When a product is created/updated in DEAR during the download process, a link is established between the item and variant unique Handshake ID and DEAR unique product ID. This link is used when products are matched against sale order lines in Handshake and when subsequent product download occurs to update the same products.


Handshake categories are mapped to DEAR categories.


When downloading products, DEAR tries to match existing products first to avoid creating duplicates. Matching is performed by item or variant SKU.


Data mapping for simple products between DEAR and Handshake is as follows:

DEAR Simple Product
Handshake Item
SKU

SKU 

NameName
CategoryCategory.Name
DescriptionLongDesc
BarcodeBarcode
Price Tier. Default is Price Tier 1.Unit Price
Images. (Only downloaded when no images attached to product in DEAR). Existing images won’t be deleted.Images
QuantityQuantity


Data mapping between DEAR Product Families and Handshake items with variants:

DEAR Product Family
Handshake Item with Variants
SKU

SKU 

NameName
CategoryCategory.Name
DescriptionLongDesc
Price Tier. Default is Price Tier 1.Unit Price
Images. (Only downloaded when no images attached to product in DEAR). Existing images won’t be deleted.Images


Data mapping between DEAR Variation Product and Handshake variants:

DEAR Variation Product
Handshake Variant
SKU

SKU 

NameName
Category(Parent Item).Category.Name
Description(Parent Item).LongDesc
Price Tier. Default is Price Tier 1.Unit Price
Images. (Only downloaded when no images attached to product in DEAR). Existing images won’t be deleted.Images


Manage Catalogue

[back to top]


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


NOTE: Updating products from the catalogue will update the stock level in Handshake regardless of the related Quantity update setting status.


To list a product on Handshake: 

  1. Click on the product in the Catalogue tab. 
  2. In the pop-up window, click List on Handshake.
  3. Save your changes.



To unlist a product on Handshake: 

  1. Click on the product in the Catalogue tab. 
  2. Click Unlink.
  3. Save your changes.



To remove a product from Handshake: 

  1. Click on the product in the Catalogue tab. 
  2. Click Remove from Handshake.
  3. Save your changes.


Bulk Listing

[back to top]


As well as listing products individually, products can be listed in bulk to save time. If products are already listed, this action will update them.


To list products on Handshake in bulk: 

  1. Go to the Bulk Listing tab.
  2. Select products to upload in bulk. You can select products by Category, Family, Product Tag, Price Tier, Listing Status and through manual search.
  3. Click Start to upload all selected products.



Orders and Sales

[back to top]


Processing Pending Orders

[back to top]


DEAR will check Handshake once an hour or once a day for orders fitting the Order Capture setting specified in Setup. 


Whenever sales are captured from Handshake they are first placed into Pending Orders, and stock is allocated immediately. DEAR imports new orders once an hour as individual sale orders (if No Consolidation is selected in the Integration Settings) or once a day as a consolidated sale order (if Daily Consolidation is selected).


If No Consolidation is selected, each Handshake sale is converted into an identical sale in DEAR, keeping the same customer, billing and shipping information. 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 Handshake 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.


Downloading Customers

[back to top]


The Load Customers button can be found next to Load Products on the Catalogue tab.



This function downloads all customers from Handshake to DEAR. If the customer already exists in DEAR, this function updates any details that have been changed in Handshake. 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 Shipping addresses captured from Handshake.


Downloading Orders and Payments

[back to top]


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.


Shipping, gift wrapping and handling are also saved as additional charges.


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


When a Handshake order is cancelled, DEAR automatically finds and voids the corresponding sale task if already created as a Sale Order or just removes the associated pending order if not yet processed.


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


Refunds

[back to top]


Handshake integration supports Refunds. 


Updating Fulfilment in Handshake

[back to top]


When Shipment is authorised in DEAR and the carrier specified, DEAR will try to update the order status in Handshake to Complete. This will only work in No Consolidation processing mode.


Logs

[back to top]


Each captured Handshake order once saved to Pending Orders creates a Log entry to track the link between the Sale in DEAR and in Handshake. 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 Handshake sale. You also have the option to delete a Log entry manually. This will allow you to reprocess an order if required. Deleting a log entry will not void or delete its associated sale task.


Reloading Orders from Handshake

[back to top]


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


To reload an order from Handshake:

  1. Void the sale task in DEAR. A record of this will be kept in DEAR for reconciliation purposes, but the transactional data will be deleted. 
  2. Return to the Handshake integration Log tab and delete the Log entry. This will allow the order to be recaptured from Handshake.
  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. 

Did you find it helpful? Yes No

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