
Pull from Cin7
What is Cin7?
Cin7 is a cloud-based inventory management and order management platform designed for small to medium-sized businesses, including manufacturers, wholesalers, and retailers. It serves as a comprehensive ERP solution that connects inventory tracking, sales, purchasing, warehouse management, and manufacturing into one unified system. With over 700 integrations—including Shopify, Amazon, Xero, and QuickBooks—Cin7 helps businesses manage multi-channel sales, automate fulfillment workflows, and maintain real-time visibility across their entire operation.
Connecting Cin7 to Parabola enables operations teams to automate reporting, reconcile data across systems, monitor inventory performance, and build custom workflows without engineering support. Whether you're tracking stock levels across multiple warehouses, auditing purchase orders, or creating real-time dashboards for sales and fulfillment, Parabola gives you the power to turn Cin7 data into actionable automation.
How to use Parabola's Cin7 integration
Parabola helps Cin7 customers automate critical workflows and extract real-time insights from their inventory and order data.
- Pull live inventory, order, and product data automatically
- Reconcile purchase orders against receipts to catch discrepancies
- Combine Cin7 data with carrier tracking, 3PL systems, or sales channels for end-to-end visibility
- Automate daily reports, low-stock alerts, and fulfillment performance dashboards
- Audit pricing, quotes, and invoices without manual spreadsheet work
Learn more about Parabola's Cin7 integration below.
Pull from Cin7 Core
How to authenticate
Cin7 Core uses API Key authentication with two required credentials: an Account ID and an API Application Key.
Creating API credentials in Cin7 Core
- Log in to your Cin7 Core account at https://inventory.dearsystems.com
- Navigate to Settings, then go to Integrations & API > Cin7 Core API (or go directly to https://inventory.dearsystems.com/ExternalAPI)
- Click the plus icon or Add API Connection button to create a new application
- Give your application a descriptive name (e.g., "Parabola Integration")
- Once created, you'll see two credentials:
- Account ID (also called api-auth-accountid)
- API Application Key (also called api-auth-applicationkey)
- Copy both values and store them securely
Tip: Each company you have access to in Cin7 Core will have a different Account ID. You can create multiple API Applications for the same account, which is useful for tracking usage across different integrations.
Note: Your Account ID and API Application Key are equivalent to a login and password. Keep them secret and never share them publicly.
Connecting in Parabola
- In your Parabola flow, add a Pull from Cin7 step and select the “Core” service.
- Click Authorize and you'll be prompted to enter:
- Give your connection a memorable name (e.g., "Production Cin7 Core Account")
- API Account ID - Your Cin7 Core Account ID
- API Application Key - Your API Application Key
Once connected, you can select from Cin7 Core's available endpoints to bring live data into your flow.
Available data
Using the Cin7 Core integration in Parabola, you can pull in a wide range of operational data:
- Products: Product master data including SKUs, names, descriptions, pricing, categories, suppliers, inventory attributes, and product families. Access product availability across locations and markup pricing details.
- Sales and Orders: Complete sales order information including customer details, line items, quantities, pricing, order status, fulfillment details, shipments, invoices, credit notes, and payments.
- Purchases: Purchase order data with supplier information, line items, costs, receiving status, quantities, invoices, credit notes, and payment records.
- Customers: Customer records with contact information, addresses, payment terms, tax rules, price tiers, credit limits, tags, and custom attributes.
- Suppliers: Supplier details including contact information, addresses, payment terms, currencies, and related purchase history.
- Locations: Warehouse and location data including addresses, active status, and location-specific inventory settings.
Common use cases
- Reconcile inventory levels from Cin7 Core, Shopify, Amazon, and other sales channels into a single source of truth. Automatically flag discrepancies, low stock levels, or oversell risks across locations.
- Track purchase order status from creation through receiving and invoicing. Analyze supplier lead times, identify delayed shipments, and automate supplier follow-ups when orders fall behind schedule.
- Monitor sales orders from placement through picking, packing, and shipment. Calculate fulfillment times, flag orders at risk of missing delivery SLAs, and generate real-time fulfillment dashboards for operations teams.
- Reconcile purchase orders, receipts (stock received), and supplier invoices to catch pricing discrepancies, quantity variances, and billing errors before payment.
- Combine inventory data with financial transactions to calculate inventory value by location, track cost of goods sold (COGS), and generate automated reports for finance teams and accounting systems.
Tips for using Parabola with Cin7 Core
- Schedule your flow based on business needs: Set up daily or hourly runs for inventory reconciliation and order tracking. For financial reporting and purchase order monitoring, weekly schedules may be sufficient.
- Join related data for complete visibility: Combine data from multiple endpoints to create comprehensive reports. For example, join Sales Orders with Shipments and Invoices to track the complete order lifecycle, or merge Products with Inventory Availability across multiple locations.
- Combine with other systems for end-to-end automation: Integrate Cin7 Core data with your accounting software (Xero, QuickBooks), 3PLs, carrier tracking systems, and BI tools to build comprehensive operational dashboards and automated reconciliation workflows.
- Document your logic with cards: Add cards to your Parabola flow to explain business rules, calculations, and data transformations. This makes it easier for your team to maintain and audit flows over time.
- Export results back to systems or create dashboards: Push processed data to Google Sheets for team visibility, update records in your ERP, or create custom dashboards that refresh automatically with the latest Cin7 Core data.
By connecting Cin7 Core with Parabola, you transform your inventory and order management data into powerful automation—enabling real-time visibility, faster reconciliations, and smarter operations across your entire supply chain.
Pull from Cin7 Omni
How to authenticate
Cin7 Omni uses Basic Authentication with a username and API key. You'll need to generate an API key from your Cin7 Omni account to connect.
Creating an API key in Cin7 Omni
- Log in to Cin7 Omni as an administrator
- From the user menu in the navigation, open Settings
- Under Integrations & API, select API v1
- Here you'll see your API Username
- Select Add New API Connection
- If you receive an error about connection limits, contact Cin7 Omni support to add your connection
- Give your connection a descriptive App Name (we suggest including "Parabola" to identify this connection) and configure the permissions for this connection based on what data you want Parabola to access
- Once created, copy your Connection Key (API Key) and store it somewhere secure
Connecting in Parabola
- In your Parabola flow, add a Pull from Cin7 step and select the “Omni” service.
- Click Authorize and enter your credentials when prompted:
- Username: Your API Username from Cin7 Omni
- Password: Your Connection Key (API Key)
Once authenticated, select the resource you want to pull (Orders, Products, Inventory, etc.)
Available data
Using the Cin7 Omni integration in Parabola, you can pull the following operational data:
- Branch Transfers: Inter-warehouse transfer records showing inventory movements between locations, including line items, quantities transferred, dispatch dates, and approval status. Perfect for tracking stock redistribution across your fulfillment network.
- Products: Complete product catalog including SKUs, names, descriptions, pricing, dimensions, weights, and cost information. Pull product attributes, categorization, and custom fields to maintain synchronized product data across systems.
- Product Options: Product variant data including size, color, and other option combinations. Retrieve pricing tiers, SKU variants, and inventory levels for each product option to manage complex product catalogs.
- Purchase Orders: Inbound purchase order data with supplier information, order details, line items, quantities, expected costs, and receiving status. Track what's been ordered, what's in transit, and what's been received.
- Quotes: Sales quote records including customer information, quoted products, pricing, terms, and quote status. Monitor quotes from creation through approval and conversion to sales orders.
- Sales Orders: Outbound order information with customer details, order lines, fulfillment status, shipping information, payment status, and order totals. Track orders from placement through fulfillment and delivery.
Common use cases
- Reconcile Cin7 inventory data with 3PL systems, Shopify, or Amazon to identify stock discrepancies, flag negative inventory, and maintain accuracy across all warehouses and sales channels.
- Track purchase orders against received quantities and expected costs to catch receiving discrepancies, supplier delays, or pricing variances before they impact your operations.
- Pull sales orders, branch transfers, and product data to create real-time dashboards showing fulfillment velocity, order status distribution, pending shipments, and warehouse utilization by location.
- Monitor inventory levels across all branches and trigger automated alerts when products fall below reorder thresholds. Combine with sales velocity data to predict stockouts before they happen.
- Consolidate sales orders and quotes across channels to analyze sales performance, quote-to-order conversion rates, average order values, and sales trends by product category or customer segment.
Tips for using Parabola with Cin7 Omni
- Schedule your flows based on operational needs: Run inventory reconciliations hourly during peak fulfillment periods, daily for overnight reporting, or weekly for performance analysis. Align your schedule with your team's workflow.
- Use filters to control data volume: Leverage date ranges, status filters, and branch-specific queries to pull only the data you need. This keeps your flows fast and focused on recent or relevant records.
- Join related data for complete context: Combine sales orders with product data to add descriptions and costs, or join purchase orders with branch transfers to track inventory from supplier to warehouse to fulfillment center.
- Create validation checks for data quality: Use filters and formulas to flag anomalies like orders missing shipping info, inventory adjustments without reason codes, or purchase orders with quantity mismatches between ordered and received.
- Set up alerts for critical thresholds: Configure Slack or email notifications when inventory drops below safety stock, when orders are stuck in processing longer than your SLA, or when purchase orders are overdue for receiving.
- Normalize IDs early in your flow: Standardize product SKUs, order references, and location identifiers at the beginning of your flow so downstream joins to other systems (Shopify, NetSuite, warehouse systems) are consistent and reliable.
By connecting Cin7 Omni with Parabola, you can automate the tedious manual work of exporting data, reconciling spreadsheets, and generating reports—freeing your operations team to focus on strategic decisions instead of data wrangling.