Connecting to 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.

DEAR Inventory-Specific Features and Limitations

Skyvia has the following limitations for DEAR Inventory:

  • Objects that support import operations: Customers, ProductFamilies, Products (INSERT, UPDATE); Purchase, Sales (INSERT, DELETE); SalePayments (INSERT, UPDATE, DELETE).

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

DEAR Inventory Connections

To connect to DEAR Inventory, you need to specify the Account ID and API Key.

Connection window

  • Account ID — an automatically generated Account ID used for connecting to DEAR Inventory. It is generated when you create an organization in the DEAR Inventory account. Your Account ID can be found in your organization setup.
  • API Key — an automatically generated API key used for connecting to DEAR Inventory. It is generated when you create an organization in the DEAR Inventory account. Your API Key can be found in your organization setup. More information can be found here: https://dearinventory.docs.apiary.io/#introduction/api-introduction.

At the end, use the Test Connection button to make sure that the connection is successful and then click Create Connection.