Airtable + Cin7 Core Inventory

Airtable + Cin7 Core Inventory integrations

Create new Airtable records when invoices are authorised in Cin7 Core Inventory

Streamline your inventory management process with this workflow. When a sale invoice is authorised in Cin7 Core Inventory, a corresponding record is instantly created in Airtable. This way, you can keep your records up-to-date, reduce manual data entry, and ensure every sale is accounted for in an organized manner. This automation makes inventory management efficient, saving your time for other important tasks.

When this happens...
Sale Invoice AuthorisedTriggers when a sales invoice authorised.
TriggerInstant
automatically do this!
Create RecordCreates a new record with auto-populating fields.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Cin7 Core Inventory and Airtable

Discover other triggers and actions you can use with Cin7 Core Inventory and Airtable

- Status
  Required
Trigger
Instant
Try It
- Status
  Required
Trigger
Instant
Try It
Sale Attachment Added
Triggers when an attachment is added to a sale
Trigger
Instant
Try It
New Sale
Triggers when a new sale is created.
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Event Type
  Required
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Status
  Required
Trigger
Instant
Try It
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Payment Type
- Reference
- Amount
  Required
- Date Paid
  Required
- Account
  Required
- Currency Rate
  Required
Action
Write
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- SKU
  Required
- Quantity
  Required
- Price
  Required
- Tax
  Required
- Total
  Required
- Line Order
- Discount
- Sale Account
- Tax Rule
  Required
- Comment
- DropShip
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Invoice Status
- Order Status
- AutoPickPackShip Mode
- Sales Representative
- Invoice Date
- Invoice Due Date
- Currency Rate
- Order Memo
- Invoice Memo
- Reference
- Amount
- DatePaid
- Account
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Effective Date
  Required
- Account
- Reference
- SKU
  Required
- Quantity
  Required
- Unit Cost
  Required
- Location
  Required
- Batch Serial Number
- Expiry Date
- Comments
Action
Write
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Product ID
  Required
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- ID
  Required
- Name
  Required
- Currency
  Required
- PaymentTerm
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Assembly Status
- Search
- Sale ID
Action
Search
- Sale ID
- Order Number
- Invoice Number
- Credit Note Number
Action
Search
- Product ID
- Product Name
- Product SKU
Action
Search
- Task ID
  Required
Action
Search
- Sale ID
  Required
Action
Search
- Name
  Required
- Contact Name / Email
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Search or write
- Help Text
- Base
  Required
- Table
  Required
- Last modified time column
  Required
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
Action
Write
- Name
  Required
- Workspace ID
  Required
- Number of Tables
  Required
Action
Write
- Base
  Required
- Table Name
  Required
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Base
  Required
- Table
  Required
- Record ID
  Required
Action
Search
- Base
  Required
- Table ID
  Required
Action
Search
- Base ID
  Required
Action
Search
- Base
  Required
Action
Search

- Status
  Required
Trigger
Instant
Try It
Sale Additional Info Added
Triggers when an additional information is added to a sale
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It
Sale Credit Note Authorised
Triggers when a sales credit note authorised.
Trigger
Instant
Try It
Sale Invoice Authorised
Triggers when a sales invoice authorised.
Trigger
Instant
Try It
Sale Shipment Tracking Number Changed
Triggers when a sale's shipment tracking number changed.
Trigger
Instant
Try It
Stock Level Update
Triggered when a change is made to product availability.
Trigger
Instant
Try It
- Sale ID
  Required
- File Name
  Required
- Is Processed
- File Content
- File Download URL
Action
Write
- Sale ID
  Required
- Status
  Required
- SKU
  Required
- Location
  Required
- Package #
- Quantity
  Required
- Batch Serial Number
- Expiry Date
Action
Write
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- Sale ID
  Required
- Keep Existing Shipment Lines
- Status
  Required
- Require By Date
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Shipping Notes
- Shipment Date
  Required
- Carrier
- Package #
  Required
- Tracking Number
Action
Write
- From Location
  Required
- To Location
  Required
- Departure Date
  Required
- Completion Date
  Required
- Reference
- SKU
  Required
- Transfer Quantity
  Required
- Batch Serial Number
- Expiry Date
- Comment
Action
Write
- ID
  Required
- Name
- Currency
- Payment Term
- Discount
- TaxRule
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
- Revenue Account
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Sales Representative
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Customer Name
- Contact Name / Email
Action
Search
- Page number
  Required
- Limit per page
  Required
- ID of product
- Name of product
- Sku of product
- Non Zero Products Only
  Required
- Location
- Batch #
- Category
Action
Search
- Task ID
  Required
Action
Search
- Task ID
  Required
Action
Search
- Search
- Status
Action
Search
- Base
  Required
- Table
  Required
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
- Record
  Required
- Comment
  Required
Action
Write
- CacheCopy
- Base
  Required
- Table
  Required
Action
Write
- Base
  Required
- Table
  Required
- Help Text
- Primary lookup field
  Required
- Secondary lookup field
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Base
  Required
- Table
  Required
- Number of Records
  Required
Action
Write
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- Base
  Required
- Search Keyword
  Required
- Search In
Action
Search
- Search Keyword
  Required
Action
Search
- Base
  Required
- Table
  Required
Action
Search
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn moreLearn moreHelpHelp

Related categories

Databases

Similar apps

Quickbase

App Builder

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Cin7 Core Inventory

Cin7 Core Inventory is an all in one holistic solution for Inventory Management, POS & B2B eCommerce. Easily manage all your inventory, purchases, sales, suppliers and customers in one easy to use system.

Learn moreLearn moreHelpHelp

Related categories

Accounting

Related Zap Templates

Update Airtable records with new or updated customers from Cin7 Core Inventory

Related Zap Templates

Update Airtable records with new or updated customers from Cin7 Core Inventory