Cin7 Core (DEAR) data extraction & reporting fully automated
So you can focus on making informed business decisions
Never export a CSV again
Cin7 Core (DEAR) data automation. Made Easy.
Step 1 - Know what you want to automate
Step 2 - Connect ALL your business data
Step 3 - Centralise non-system data
Step 4 - Excel, Power BI & GSheets automated
We are on hand, every step of the way
14 days free trial or find out more
Are you a technical user?
Grab a FREE 30-day trial and get your DEAR data automated into Power BI, Excel & Google Sheets in just a few minutes!
Trusted by over 250 Global businesses
dataSights has helped us maximise our investment in DEAR Inventory. From the daily email which tells us when we should update pricing, to the excel automation which updates all our pricing in a few clicks, to the forecasting reports and our real-time office dashboards.
dataSights provided us with a central source of data that is accurate and easy to read. With this data, we have been able to create dashboards that are updated every few minutes and given us visibility of things that we didn’t have before.
Want to see how it works?
Automate your DEAR Inventory Systems data to Excel, Power BI, Google Sheets or any other system
Connect DEAR Systems to Microsoft Excel
Connect DEAR Systems to Power BI
Connect DEAR Systems to Google Sheets
Connect DEAR Systems to SAP, 3PL and other systems
Frequently asked questions
-
Create an account (Free trial available), create or bring an existing database, connect DEAR Inventory on the Connectors page, then Sync! Then follow a short video on how to use your database credentials to connect to Power BI in Direct query mode. Done!
-
Create an account (Free trial available), create or bring an existing database, connect DEAR Inventory on the Connectors page, then Sync! Then follow a short video on how to use your database credentials to connect to Excel. Done!
-
Create an account (Free trial available), create or bring an existing database, connect DEAR Inventory on the Connectors page, then Sync! Then follow a short video on how to push your data to Google Sheets. Done!
-
Absolutely. Every customer gets their very own isolated data warehouse. Database credentials are salt-encrypted. Multi-factor authentication can be activated for your account. We take security very seriously.
-
Your DEAR Inventory reports can be updated daily, on-demand, and if it’s DEAR Inventory sales data as frequently as every 5 minutes.
-
Absolutely. We are software developers first, report developers second. Any DEAR Inventory data you need aggregated, calculated and pushed either via an ExcelAddIn or fully automated is no problem at all. Just get in touch and we can explore your requirements and offer multiple solution options.
-
We do! The DEAR Inventory templates will need some customisation, which either we can do, or you can do. Just get in touch and we can figure out how best to progress!
-
Absolutely. We are software developers first, report developers second. Any data you need pushed into Cin7 Core (DEAR) either via an ExcelAddIn or fully automated is no problem at all. Just get in touch and we can explore your requirements and offer multiple solution options.
-
The choice is yours, or you can choose a combination, or we can coach you. Our only goal is to automate all our data, and guide you to 100% automated Cin7 Core (DEAR) report automation.
-
We can consolidate multiple DEAR Inventory’s, Shopify’s, Hubspots, Xero’s, whatever systems you use, we can consolidate into a single DEAR Sales table for example. Get in touch, and we would love to show you how OR start a FREE Trial and connect multiple Cin7 Core (DEAR), and sync away!
How Cin7 Core (DEAR) + Microsoft Power BI Integrations Work
-
Step 1: Create a Free Trial account and authenticate Cin7 Core (DEAR) + Microsoft Power BI.(2 minutes)
-
Step 2: Schedule a time for your data to sync.(15 seconds)
-
Step 3: Trigger sync.(15 seconds + variable syncing time)
-
Step 4: Select the reporting tool you want to use (Excel, Microsoft Power BI, Google Sheets) and build reports with automated data.(2 minutes)
-
That’s it! More time to work on other things.
Not sure how to get started?
We do solutions, not sales, so book a chat and find out how we can help your specific situation
Are you a technical user?
Grab a FREE 30-day trial and get your DEAR Systems data automated into Power BI, Excel & Google Sheets in just a few minutes!
Our Blog
Latest news, tips and best practices.
Bulk update products in Cin7 Core (formerly DEAR) from Excel
Are you struggling to manage your DEAR inventory efficiently? Look no further! In this detailed guide, Kev from DataSights will walk you through the process of installing and using the XLN add-in, a powerful tool that can revolutionize your inventory management in...
Data-Driven Cin7 Core Inventory Management – Part 1: Unveiling Bundling Analysis with ChatGPT into Excel, Power BI, Google Sheets and Looker
Getting instant bundling analysis answers using ChatGPT over your business data Basically we are going to Tarantino this bad boy and start with the end at the beginning. Starting with The How? and end with The Why? Why? Because the how is damn exciting and I'll bet...
How to automate PO creation in DEAR Systems with two clicks
Purchase Order creation is without a doubt a fundamental part of any inventory based business. Without raw materials to manufacture and/or without goods to sell, well, what are we doing here exactly? So now that we have relatively easily established PO's are an...
