Cin7 Core Inventory

Cin7 Core Inventory (formerly, 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 Cin7 Core Inventory, exporting Cin7 Core Inventory data to CSV files, and replicating Cin7 Core Inventory data to relational databases, and synchronizing Cin7 Core Inventory data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Cin7 Core Inventory backup.

Query: Skyvia Query supports Cin7 Core Inventory.

Establishing Connection

To create a connection with Cin7 Core Inventory, 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 Cin7 Core Inventory, if you haven’t signed in yet).
  2. Click Integrations on the left of the page.
  3. Click API -> +.
  4. Specify the integration name, for example, Skyvia, and then click Create.
  5. 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

Nested Objects

The The following objects store complex structured data in JSON format.

Object Field
Leads Contacts, Addresses
Workflows Steps
Sale Fulfilments, Invoices, CreditNotes

You can use our Nested Objects mapping feature in Import integrations to insert or update the nested values in such fields. Select the Nested Objects checkbox in Import integration to enable this feature. You can also replicate the nested objects using the Unwind Nested Objects option. Select JSON Columns to replicate nested object fields as columns with JSON data into the target table or select Separate Tables to replicate nested object fields into additional tables in the database.

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 Cin7 Core Inventory objects:

Operations Objects
INSERT, UPDATE, DELETE AdvancedPurchase, AdvancedPurchasePayments, AdvancedPurchaseStockReceived, AttributeSets, BankTransfer, Brands, Carrier, InventoryWriteOffs, Journals, Leads, Locations, MoneyOperation, Opportunities, PaymentTerms, ProductCategories, Purchase, Sale, SalePayments, StockAdjustments, StockTakes, StockTransfers, Tasks, TaskCategories, UnitsOfMeasure, Webhooks, Workflows
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 Cin7 Core Inventory.

On This Page