Integration Manager

Updated on February 23rd, 2023

+ More

Order Sources

Setting Up DEAR Systems

Integration Specs:

Supported functions:

Order Download

Shipment Confirmation - Detailed

Invoicing

Inventory Sync

Required Parameters

Account ID
API Key

Additional Fee

DEAR charges an additional $50 per month on some plans for a Extensiv Integration Manager connection.

Step-by-step guide

To find your Account ID and API Key login to Dear Systems and click Integration > DEAR API Setup
Click + next to Overview in the upper left to add a New API Application. Enter a name like Integration Manager
Copy down the Account ID and Key which will be entered into Integration Manager
Click Save

You can come back to this page any time to look up your existing credentials or reset them if needed.

Dear Locations

In order to perform inventory sync with Dear, you must setup one cart connection in Integration Manager for each Dear Warehouse Location. Set the " Location Name" in the Dear cart settings.

Changing Location on Ship:

Dear sets the order's Shipment Location when the order is first placed. By default, Integration Manager will mark the order as shipped at that same Location Dear provided to us on the order.

If your WMS may change the warehouse that shipped the order and you need this changed location reported back to Dear, you must set up your Dear location codes in the Integration Manager warehouse list. To do this, Click on Locations & Products in Integration Manager, select a warehouse, click Edit Warehouse, click Add Address.

Place the Dear Location Name in the "AddressLocationNumber" field in the Integration Manager Warehouse Address.

Notice, if you Pick or Pack your orders automatically before having Integration Manager pull them, Integration Manager may be unable to change the order's shipment location. In this case you must either let Integration Manager Pick and pack your Dear orders, or you must remove the AddressLocationNumber from Integration Manager so we do not attempt to change the location when the order ships.

Dear Sale Status List

Status	Description
DRAFT	No data is added to sale details. Quote and order are empty and not authorized
VOIDED	Task has been voided
ESTIMATING	QuoteStatus = DRAFT, OrderStatus = NOT AVAILABLE
ESTIMATED	QuoteStatus = AUTHORISED or Skip Quote=true, OrderStatus = NOT AVAILABLE
ORDERING	OrderStatus = DRAFT
ORDERED	OrderStatus = AUTHORISED, all products in sale order are in stock, no backordering. PickStatus = NOT AVAILABLE
BACKORDERED	OrderStatus = AUTHORISED, at least one product in sale order has been backordered PickStatus = NOT AVAILABLE
PICKING*	PickStatus = DRAFT
PICKED*	PickStatus = AUTHORISED, PackStatus = NOT AVAILABLE
PACKING*	PackStatus = DRAFT
PACKED*	PackStatus = AUTHORISED, ShipStatus = NOT AVAILABLE
SHIPPING*	ShipStatus = DRAFT
INVOICING*	OrderStatus=AUTHORISED, ShipStatus=AUTHORISED, InvoiceStatus=DRAFT
INVOICED*	ShipStatus=AUTHORISED, InvoiceStatus = AUTHORISED or InvoiceStatus = PAID, TotalInvoice – TotalPaid <> 0
CREDITED	CreditNoteStatus = AUTHORISED, TotalInvoice – TotalPaid <> 0
COMPLETED	InvoiceStatus = PAID, ShipStatus=AUTHORISED, TotalInvoice – TotalPaid = 0

* Statuses denoted can only be used to retrieve Sales Orders if they are simple sales within Dear. Advanced sales orders cannot be pull from Dear using these statuses.

Address Issues

A common issue is that the Address Dear sends to Integration Manager doesn't match what is displayed on the screen in Dear. This is caused by editing the address in Dear on the order screen. DO NOT DO THIS! Be sure to add the corrected address to the system and use the new address with the order. This is the only way Integration Manager can load the corrected address information.

setup dear systems

Integration Manager

Setting Up DEAR Systems

Integration Specs:

Step-by-step guide

Dear Locations

Dear Sale Status List

Related Articles

Not finding the help you need?