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.
To establish a connection, you need to specify the Account ID and API Key.
To get Account ID and API Key, perform the following steps:
- Open the following page: https://inventory.dearsystems.com/ExternalAPI (sign in to DEAR Inventory, if you haven’t signed in yet).
- Click Integrations on the left of the page.
- Click API.
- Click +.
- Specify the integration name, for example, Skyvia, and then click Create.
- Copy the displayed Account ID and API Application Key.
See https://dearinventory.docs.apiary.io/#introduction/api-introduction for more details.
Paste your Account ID and API Key to the corresponding boxes in the connection editor.
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:
|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|
Skyvia supports all the common actions for DEAR Inventory.