DEAR Inventory

DEAR Inventory is an online accounting and inventory management system designed to improve and boost operational efficiency and productivity of business.

Data integration: Skyvia supports importing data to and from DEAR Inventory, exporting DEAR Inventory data to CSV files, and replicating DEAR Inventory data to relational databases, and synchronizing DEAR Inventory data with other cloud apps and relational databases.

Backup: Skyvia Backup supports DEAR Inventory backup.

Query: Skyvia Query supports DEAR Inventory.

Establishing Connection

To establish a connection, you need to specify the Account ID and API Key.

Getting Credentials

To get Account ID and API Key, perform the following steps:

  1. Open the following page: https://inventory.dearsystems.com/ExternalAPI (sign in to DEAR Inventory, if you haven’t signed in yet).
  2. Click Integrations on the left of the page.
  3. Click API.
  4. Click +.
  5. Specify the integration name, for example, Skyvia, and then click Create.
  6. Copy the displayed Account ID and API Application Key.

See https://dearinventory.docs.apiary.io/#introduction/api-introduction for more details.

Creating Connection

Paste your Account ID and API Key to the corresponding boxes in the connection editor.

Connection window

Connector Specifics

Incremental Replication and Synchronization

Synchronization and Replication with Incremental Updates enabled are not supported for objects without UpdatedDate field. Thus, only Customers, Products, ProductFamilies, Suppliers objects support Synchronization and Replication with Incremental Updates.

DML Operations Support

Skyvia supports the following DML operations for DEAR Inventory objects:

Operations Objects
INSERT, UPDATE, DELETE AdvancedPurchase, AdvancedPurchasePayments, AdvancedPurchaseStockReceived, AttributeSets, BankTransfer, Brands, Carrier, InventoryWriteOffs, Journals, Locations, MoneyOperation, PaymentTerms, ProductCategories, Purchase, Sale, SalePayments, StockAdjustments, StockTakes, StockTransfers, UnitsOfMeasure, Webhooks
INSERT, UPDATE Customers, FixedAssetTypes, ProductFamilies, Products, Suppliers, Tax
INSERT, DELETE Disassembly, FinishedGoods
INSERT AdvancedPurchaseCreditNote, AdvancedPurchaseInvoices, AdvancedPurchaseManualJournals, AdvancedPurchasePutAway, DissasemblyOrders, FinishedGoodsOrders,FinishedGoodsPicks, PurchaseOrders, SaleCreditNoteTasks, SaleFulfilments, SaleInvoicesTasks, SaleManualJournals, SaleOrders, SaleQuotes, StockTransferOrders

Supported Actions

Skyvia supports all the common actions for DEAR Inventory.