Cin7 Omni Connector Reference
The Cin7 Omni connector exposes 239 fields (59 metrics, 180 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Cin7 Omni Fields
Cin7 Omni credit_note_line_items fields
The credit_note_line_items report of the Cin7 Omni connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| credit_note_line_items__barcode | TEXT | credit_note_line_items.barcode | Barcode. |
| credit_note_line_items__code | TEXT | credit_note_line_items.code | Line item code. |
| credit_note_line_items__cogs | NUMERIC | credit_note_line_items.cogs | Cost of goods sold for the line (unit cost times quantity). |
| credit_note_line_items__credit_note_id | TEXT | credit_note_line_items.credit_note_id | Parent credit note ID. |
| credit_note_line_items__discount | NUMERIC | credit_note_line_items.discount | Line item discount. |
| credit_note_line_items__line_id | TEXT | credit_note_line_items.line_id | Line item ID. |
| credit_note_line_items__name | TEXT | credit_note_line_items.name | Line item name. |
| credit_note_line_items__product_id | TEXT | credit_note_line_items.product_id | Line item product ID. |
| credit_note_line_items__product_option_id | TEXT | credit_note_line_items.product_option_id | Product option ID. |
| credit_note_line_items__qty | NUMERIC | credit_note_line_items.qty | Line item quantity. |
| credit_note_line_items__qty_shipped | NUMERIC | credit_note_line_items.qty_shipped | Line item quantity shipped. |
| credit_note_line_items__style_code | TEXT | credit_note_line_items.style_code | Style code. |
| credit_note_line_items__unit_cost | NUMERIC | credit_note_line_items.unit_cost | Line item unit cost. |
| credit_note_line_items__unit_price | NUMERIC | credit_note_line_items.unit_price | Line item unit price. |
Cin7 Omni credit_notes fields
The credit_notes report of the Cin7 Omni connector includes 25 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| credit_notes__branch_id | TEXT | credit_notes.branch_id | Branch ID. |
| credit_notes__company | TEXT | credit_notes.company | Customer company. |
| credit_notes__completed_date | credit_notes.completed_date | Completion timestamp. | |
| credit_notes__created_date | credit_notes.created_date | Credit note creation timestamp. | |
| credit_notes__credit_note_date | credit_notes.credit_note_date | Credit note date. | |
| credit_notes__credit_note_id | TEXT | credit_notes.credit_note_id | Credit note ID. |
| credit_notes__credit_note_number | TEXT | credit_notes.credit_note_number | Credit note number. |
| credit_notes__currency_code | TEXT | credit_notes.currency_code | Currency code. |
| credit_notes__currency_rate | NUMERIC | credit_notes.currency_rate | Currency exchange rate. |
| credit_notes__discount_total | NUMERIC | credit_notes.discount_total | Discount total. |
| credit_notes__email | TEXT | credit_notes.email | Customer email. |
| credit_notes__freight_total | NUMERIC | credit_notes.freight_total | Freight total. |
| credit_notes__is_approved | BOOLEAN | credit_notes.is_approved | Whether the credit note is approved. |
| credit_notes__member_id | TEXT | credit_notes.member_id | Customer member ID. |
| credit_notes__modified_date | credit_notes.modified_date | Modification timestamp. | |
| credit_notes__product_total | NUMERIC | credit_notes.product_total | Product total. |
| credit_notes__reference | TEXT | credit_notes.reference | Credit note reference. |
| credit_notes__sales_person_id | TEXT | credit_notes.sales_person_id | Sales person ID. |
| credit_notes__sales_reference | TEXT | credit_notes.sales_reference | Reference to the original sales order. |
| credit_notes__source | TEXT | credit_notes.source | Credit note source. |
| credit_notes__status | TEXT | credit_notes.status | Credit note status. |
| credit_notes__surcharge | NUMERIC | credit_notes.surcharge | Surcharge. |
| credit_notes__tax_rate | PERCENT | credit_notes.tax_rate | Tax rate. |
| credit_notes__tax_status | TEXT | credit_notes.tax_status | Tax status. |
| credit_notes__total | NUMERIC | credit_notes.total | Credit note total. |
Cin7 Omni payments fields
The payments report of the Cin7 Omni connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| payments__amount | NUMERIC | payments.amount | Payment amount. |
| payments__batch_reference | TEXT | payments.batch_reference | Batch reference. |
| payments__branch_id | TEXT | payments.branch_id | Branch ID. |
| payments__created_date | payments.created_date | Payment creation timestamp. | |
| payments__is_authorized | BOOLEAN | payments.is_authorized | Whether the payment is authorized. |
| payments__method | TEXT | payments.method | Payment method. |
| payments__modified_date | payments.modified_date | Payment modification timestamp. | |
| payments__order_id | TEXT | payments.order_id | Order ID the payment applies to. |
| payments__order_ref | TEXT | payments.order_ref | Order reference. |
| payments__order_type | TEXT | payments.order_type | Order type. |
| payments__payment_date | payments.payment_date | Payment timestamp. | |
| payments__payment_id | TEXT | payments.payment_id | Payment ID. |
| payments__reconcile_date | payments.reconcile_date | Reconciliation timestamp. | |
| payments__transaction_ref | TEXT | payments.transaction_ref | Transaction reference. |
Cin7 Omni product_options fields
The product_options report of the Cin7 Omni connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_options__barcode | TEXT | product_options.barcode | Barcode. |
| product_options__created_date | product_options.created_date | Option creation timestamp. | |
| product_options__modified_date | product_options.modified_date | Option modification timestamp. | |
| product_options__option_1 | TEXT | product_options.option_1 | Option 1 value. |
| product_options__option_2 | TEXT | product_options.option_2 | Option 2 value. |
| product_options__option_3 | TEXT | product_options.option_3 | Option 3 value. |
| product_options__option_barcode | TEXT | product_options.option_barcode | Product option barcode. |
| product_options__option_code | TEXT | product_options.option_code | Product option code. |
| product_options__option_id | TEXT | product_options.option_id | Product option ID. |
| product_options__price_columns | TEXT | product_options.price_columns | Account price lists as a JSON object. |
| product_options__product_id | TEXT | product_options.product_id | Parent product ID. |
| product_options__retail_price | NUMERIC | product_options.retail_price | Retail price. |
| product_options__size | TEXT | product_options.size | Size. |
| product_options__special_price | NUMERIC | product_options.special_price | Special price. |
| product_options__status | TEXT | product_options.status | Option status. |
| product_options__stock_available | NUMERIC | product_options.stock_available | Available quantity for the option. |
| product_options__stock_on_hand | NUMERIC | product_options.stock_on_hand | Stock on hand for the option. |
| product_options__style_code | TEXT | product_options.style_code | Parent product style code. |
| product_options__supplier_code | TEXT | product_options.supplier_code | Supplier code. |
| product_options__vip_price | NUMERIC | product_options.vip_price | VIP price. |
| product_options__wholesale_price | NUMERIC | product_options.wholesale_price | Wholesale price. |
Cin7 Omni products fields
The products report of the Cin7 Omni connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| products__brand | TEXT | products.brand | Brand. |
| products__category | TEXT | products.category | Category. |
| products__created_date | products.created_date | Product creation timestamp. | |
| products__description | TEXT | products.description | Product description. |
| products__height | NUMERIC | products.height | Product height. |
| products__image_url | IMAGE_URL | products.image_url | URL of the first product image. |
| products__length | NUMERIC | products.length | Product length. |
| products__modified_date | products.modified_date | Product modification timestamp. | |
| products__order_type | TEXT | products.order_type | Order type. |
| products__product_id | TEXT | products.product_id | Product ID. |
| products__product_name | TEXT | products.product_name | Product name. |
| products__product_type | TEXT | products.product_type | Product type. |
| products__status | TEXT | products.status | Product status. |
| products__stock_control | BOOLEAN | products.stock_control | Whether stock is controlled. |
| products__style_code | TEXT | products.style_code | Style code. |
| products__sub_category | TEXT | products.sub_category | Product sub-category. |
| products__supplier_id | TEXT | products.supplier_id | Default supplier ID. |
| products__tags | TEXT | products.tags | Comma-separated product tags. |
| products__volume | NUMERIC | products.volume | Product volume. |
| products__weight | NUMERIC | products.weight | Product weight. |
| products__width | NUMERIC | products.width | Product width. |
Cin7 Omni purchase_order_line_items fields
The purchase_order_line_items report of the Cin7 Omni connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| purchase_order_line_items__barcode | TEXT | purchase_order_line_items.barcode | Barcode. |
| purchase_order_line_items__code | TEXT | purchase_order_line_items.code | Line item code. |
| purchase_order_line_items__discount | NUMERIC | purchase_order_line_items.discount | Line item discount. |
| purchase_order_line_items__holding_qty | NUMERIC | purchase_order_line_items.holding_qty | Holding quantity. |
| purchase_order_line_items__line_id | TEXT | purchase_order_line_items.line_id | Line item ID. |
| purchase_order_line_items__name | TEXT | purchase_order_line_items.name | Line item name. |
| purchase_order_line_items__product_id | TEXT | purchase_order_line_items.product_id | Line item product ID. |
| purchase_order_line_items__product_option_id | TEXT | purchase_order_line_items.product_option_id | Product option ID. |
| purchase_order_line_items__purchase_order_id | TEXT | purchase_order_line_items.purchase_order_id | Parent purchase order ID. |
| purchase_order_line_items__qty | NUMERIC | purchase_order_line_items.qty | Line item quantity. |
| purchase_order_line_items__qty_shipped | NUMERIC | purchase_order_line_items.qty_shipped | Line item quantity received. |
| purchase_order_line_items__style_code | TEXT | purchase_order_line_items.style_code | Style code. |
| purchase_order_line_items__unit_price | NUMERIC | purchase_order_line_items.unit_price | Line item unit price (supplier cost). |
Cin7 Omni purchase_orders fields
The purchase_orders report of the Cin7 Omni connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| purchase_orders__branch_id | TEXT | purchase_orders.branch_id | Branch ID. |
| purchase_orders__cancellation_date | purchase_orders.cancellation_date | Cancellation timestamp. | |
| purchase_orders__company | TEXT | purchase_orders.company | Supplier company. |
| purchase_orders__created_date | purchase_orders.created_date | Order creation timestamp. | |
| purchase_orders__currency_code | TEXT | purchase_orders.currency_code | Currency code. |
| purchase_orders__currency_rate | NUMERIC | purchase_orders.currency_rate | Currency exchange rate. |
| purchase_orders__discount_total | NUMERIC | purchase_orders.discount_total | Discount total. |
| purchase_orders__estimated_arrival_date | purchase_orders.estimated_arrival_date | Estimated arrival timestamp. | |
| purchase_orders__estimated_delivery_date | purchase_orders.estimated_delivery_date | Estimated delivery timestamp. | |
| purchase_orders__freight_total | NUMERIC | purchase_orders.freight_total | Freight total. |
| purchase_orders__fully_received_date | purchase_orders.fully_received_date | Fully received timestamp. | |
| purchase_orders__invoice_date | purchase_orders.invoice_date | Invoice timestamp. | |
| purchase_orders__is_approved | BOOLEAN | purchase_orders.is_approved | Whether the order is approved. |
| purchase_orders__is_void | BOOLEAN | purchase_orders.is_void | Whether the order is void. |
| purchase_orders__member_id | TEXT | purchase_orders.member_id | Supplier member ID. |
| purchase_orders__modified_date | purchase_orders.modified_date | Modification timestamp. | |
| purchase_orders__product_total | NUMERIC | purchase_orders.product_total | Product total. |
| purchase_orders__purchase_order_id | TEXT | purchase_orders.purchase_order_id | Purchase order ID. |
| purchase_orders__reference | TEXT | purchase_orders.reference | Purchase order reference. |
| purchase_orders__source | TEXT | purchase_orders.source | Order source. |
| purchase_orders__stage | TEXT | purchase_orders.stage | Order stage. |
| purchase_orders__status | TEXT | purchase_orders.status | Order status. |
| purchase_orders__supplier_invoice_reference | TEXT | purchase_orders.supplier_invoice_reference | Supplier invoice reference. |
| purchase_orders__surcharge | NUMERIC | purchase_orders.surcharge | Surcharge. |
| purchase_orders__tax_rate | PERCENT | purchase_orders.tax_rate | Tax rate. |
| purchase_orders__tax_status | TEXT | purchase_orders.tax_status | Tax status. |
| purchase_orders__total | NUMERIC | purchase_orders.total | Order total. |
Cin7 Omni sales_order_line_items fields
The sales_order_line_items report of the Cin7 Omni connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sales_order_line_items__barcode | TEXT | sales_order_line_items.barcode | Barcode. |
| sales_order_line_items__code | TEXT | sales_order_line_items.code | Line item code. |
| sales_order_line_items__cogs | NUMERIC | sales_order_line_items.cogs | Cost of goods sold for the line (unit cost times quantity); order COGS is the sum over the order's line items. |
| sales_order_line_items__created_date | sales_order_line_items.created_date | Line creation timestamp. | |
| sales_order_line_items__discount | NUMERIC | sales_order_line_items.discount | Line item discount. |
| sales_order_line_items__holding_qty | NUMERIC | sales_order_line_items.holding_qty | Holding quantity. |
| sales_order_line_items__line_comments | TEXT | sales_order_line_items.line_comments | Line comments. |
| sales_order_line_items__line_id | TEXT | sales_order_line_items.line_id | Line item ID. |
| sales_order_line_items__name | TEXT | sales_order_line_items.name | Line item name. |
| sales_order_line_items__option_1 | TEXT | sales_order_line_items.option_1 | Option 1 value. |
| sales_order_line_items__option_2 | TEXT | sales_order_line_items.option_2 | Option 2 value. |
| sales_order_line_items__option_3 | TEXT | sales_order_line_items.option_3 | Option 3 value. |
| sales_order_line_items__product_id | TEXT | sales_order_line_items.product_id | Line item product ID. |
| sales_order_line_items__product_option_id | TEXT | sales_order_line_items.product_option_id | Product option ID. |
| sales_order_line_items__qty | NUMERIC | sales_order_line_items.qty | Line item quantity. |
| sales_order_line_items__qty_shipped | NUMERIC | sales_order_line_items.qty_shipped | Line item quantity shipped. |
| sales_order_line_items__sales_order_id | TEXT | sales_order_line_items.sales_order_id | Parent sales order ID. |
| sales_order_line_items__sort | NUMERIC | sales_order_line_items.sort | Line sort order. |
| sales_order_line_items__stock_control | BOOLEAN | sales_order_line_items.stock_control | Whether stock is controlled. |
| sales_order_line_items__style_code | TEXT | sales_order_line_items.style_code | Style code. |
| sales_order_line_items__tax_rate | PERCENT | sales_order_line_items.tax_rate | Line item tax rate. |
| sales_order_line_items__unit_cost | NUMERIC | sales_order_line_items.unit_cost | Line item unit cost. |
| sales_order_line_items__unit_price | NUMERIC | sales_order_line_items.unit_price | Line item unit price. |
Cin7 Omni sales_orders fields
The sales_orders report of the Cin7 Omni connector includes 41 fields.
Cin7 Omni sales_orders fields (sales_orders__billing_city to sales_orders__total)
| ID | Type | Name | Description |
|---|---|---|---|
| sales_orders__billing_city | CITY | sales_orders.billing_city | Billing city. |
| sales_orders__billing_country | COUNTRY | sales_orders.billing_country | Billing country. |
| sales_orders__billing_postal_code | TEXT | sales_orders.billing_postal_code | Billing postal code. |
| sales_orders__billing_state | REGION | sales_orders.billing_state | Billing state. |
| sales_orders__branch_id | TEXT | sales_orders.branch_id | Branch ID. |
| sales_orders__cancellation_date | sales_orders.cancellation_date | Cancellation timestamp. | |
| sales_orders__company | TEXT | sales_orders.company | Customer company. |
| sales_orders__created_date | sales_orders.created_date | Sales order creation timestamp. | |
| sales_orders__currency_code | TEXT | sales_orders.currency_code | Currency code. |
| sales_orders__currency_rate | NUMERIC | sales_orders.currency_rate | Currency exchange rate. |
| sales_orders__customer_order_no | TEXT | sales_orders.customer_order_no | Customer order number. |
| sales_orders__delivery_city | CITY | sales_orders.delivery_city | Delivery city. |
| sales_orders__delivery_country | COUNTRY | sales_orders.delivery_country | Delivery country. |
| sales_orders__delivery_postal_code | TEXT | sales_orders.delivery_postal_code | Delivery postal code. |
| sales_orders__delivery_state | REGION | sales_orders.delivery_state | Delivery state. |
| sales_orders__discount_total | NUMERIC | sales_orders.discount_total | Discount total. |
| sales_orders__dispatched_date | sales_orders.dispatched_date | Sales order dispatch timestamp. | |
| sales_orders__email | TEXT | sales_orders.email | Customer email. |
| sales_orders__estimated_delivery_date | sales_orders.estimated_delivery_date | Estimated delivery timestamp. | |
| sales_orders__freight_total | NUMERIC | sales_orders.freight_total | Freight total. |
| sales_orders__invoice_date | sales_orders.invoice_date | Sales order invoice timestamp. | |
| sales_orders__invoice_number | TEXT | sales_orders.invoice_number | Invoice number. |
| sales_orders__is_approved | BOOLEAN | sales_orders.is_approved | Whether the sales order is approved. |
| sales_orders__is_void | BOOLEAN | sales_orders.is_void | Whether the order is void. |
| sales_orders__logistics_carrier | TEXT | sales_orders.logistics_carrier | Logistics carrier. |
| sales_orders__member_id | TEXT | sales_orders.member_id | Customer member ID. |
| sales_orders__modified_date | sales_orders.modified_date | Order modification timestamp. | |
| sales_orders__payment_terms | TEXT | sales_orders.payment_terms | Payment terms. |
| sales_orders__product_total | NUMERIC | sales_orders.product_total | Product total. |
| sales_orders__project_name | TEXT | sales_orders.project_name | Project name. |
| sales_orders__reference | TEXT | sales_orders.reference | Sales order reference. |
| sales_orders__sales_order_id | TEXT | sales_orders.sales_order_id | Sales order ID. |
| sales_orders__sales_person_id | TEXT | sales_orders.sales_person_id | Sales person ID. |
| sales_orders__source | TEXT | sales_orders.source | Order source. |
| sales_orders__stage | TEXT | sales_orders.stage | Order stage. |
| sales_orders__status | TEXT | sales_orders.status | Order status. |
| sales_orders__surcharge | NUMERIC | sales_orders.surcharge | Surcharge. |
| sales_orders__tax_rate | PERCENT | sales_orders.tax_rate | Order tax rate. |
| sales_orders__tax_status | TEXT | sales_orders.tax_status | Tax status. |
| sales_orders__total | NUMERIC | sales_orders.total | Order total. |
Cin7 Omni sales_orders fields (sales_orders__voucher_code to sales_orders__voucher_code)
| ID | Type | Name | Description |
|---|---|---|---|
| sales_orders__voucher_code | TEXT | sales_orders.voucher_code | Voucher code. |
Cin7 Omni stock fields
The stock report of the Cin7 Omni connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| stock__available | NUMERIC | stock.available | Available quantity. |
| stock__barcode | TEXT | stock.barcode | Barcode. |
| stock__branch_id | TEXT | stock.branch_id | Branch ID. |
| stock__branch_name | TEXT | stock.branch_name | Branch name. |
| stock__code | TEXT | stock.code | Product option code. |
| stock__holding | NUMERIC | stock.holding | Holding quantity. |
| stock__incoming | NUMERIC | stock.incoming | Incoming quantity. |
| stock__modified_date | stock.modified_date | Stock modification timestamp. | |
| stock__open_sales | NUMERIC | stock.open_sales | Open sales quantity. |
| stock__option_1 | TEXT | stock.option_1 | Option 1 value. |
| stock__option_2 | TEXT | stock.option_2 | Option 2 value. |
| stock__option_3 | TEXT | stock.option_3 | Option 3 value. |
| stock__product_id | TEXT | stock.product_id | Product ID. |
| stock__product_name | TEXT | stock.product_name | Product name. |
| stock__product_option_id | TEXT | stock.product_option_id | Product option ID. |
| stock__size | TEXT | stock.size | Size. |
| stock__stock_on_hand | NUMERIC | stock.stock_on_hand | Stock on hand quantity. |
| stock__style_code | TEXT | stock.style_code | Style code. |
| stock__virtual | NUMERIC | stock.virtual | Virtual stock quantity. |
Cin7 Omni other fields
The Cin7 Omni connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
