Skip to content
Book a demoStart free
Connectors

Zoho Inventory connector

Set up the Zoho Inventory connector in Kaivo: authentication, configuration, the 13 BigQuery tables it syncs, and answers to common questions.

Zoho Inventory connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zoho Inventory data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your ERP data instead of moving it.

Sync your Zoho Inventory data into BigQuery with Kaivo to analyse stock, orders, and purchasing in one place.

CategoryERP
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Inventory connector

Section titled “Getting started with the Zoho Inventory connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Zoho Inventory account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Zoho Inventory credentials. You provide:

Field Description
OAuth Client Secret
The Client Secret of your Zoho Inventory developer application.

| | OAuth Refresh Token |

The refresh token obtained after completing the OAuth authorization flow.

|

Prerequisites

Zoho Inventory only supports OAuth, so you need your own Zoho developer application:

  1. Go to the Zoho API Console, create a Self Client (the simplest option for a data sync), and note your Client ID and Client Secret.
  2. Generate a grant token for the ZohoInventory.fullaccess.all scope, then exchange it for a Refresh Token (see Zoho Inventory OAuth docs). Use the accounts URL for your account’s domain, e.g. accounts.zoho.com (US) or accounts.zoho.eu (EU).

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Domain
The domain suffix for the Zoho Inventory API based on your data center location (e.g., ‘com’, ‘eu’, ‘in’, etc.)

| | OAuth Client ID |

The Client ID of your Zoho Inventory developer application.

| | Start Date |

Any data before this date will not be fetched.

|

Tables and columns synced from Zoho Inventory

Section titled “Tables and columns synced from Zoho Inventory”

Kaivo syncs 13 tables from Zoho Inventory into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

contacts (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ach_supported BOOL
company_name STRING
contact_id STRING
contact_name STRING
contact_type STRING
contact_type_formatted STRING
created_time STRING
created_time_formatted STRING
currency_code STRING
currency_id STRING
customer_name STRING
customer_sub_type STRING
email STRING
facebook STRING
first_name STRING
has_attachment BOOL
is_linked_with_zohocrm BOOL
language_code STRING
language_code_formatted STRING
last_modified_time STRING
last_modified_time_formatted STRING
last_name STRING
mobile STRING
outstanding_payable_amount FLOAT64
outstanding_payable_amount_bcy FLOAT64
outstanding_receivable_amount FLOAT64
outstanding_receivable_amount_bcy FLOAT64
pan_no STRING
payment_terms FLOAT64
payment_terms_label STRING
phone STRING
portal_status STRING
portal_status_formatted STRING
source STRING
status STRING
twitter STRING
unused_credits_payable_amount FLOAT64
unused_credits_payable_amount_bcy FLOAT64
unused_credits_receivable_amount FLOAT64
unused_credits_receivable_amount_bcy FLOAT64
vendor_name STRING
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
credit_notes (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
applied_invoices STRING
balance FLOAT64
client_viewed_time STRING
color_code STRING
created_time STRING
creditnote_id STRING
creditnote_number STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
exchange_rate FLOAT64
has_attachment BOOL
is_emailed BOOL
is_viewed_by_client BOOL
last_modified_time STRING
price_precision FLOAT64
reference_number STRING
salesperson_id STRING
salesperson_name STRING
status STRING
template_id STRING
template_type STRING
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (73 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
ach_payment_initiated BOOL
adjustment FLOAT64
balance FLOAT64
billing_address__address STRING
billing_address__attention STRING
billing_address__city STRING
billing_address__country STRING
billing_address__fax STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__street2 STRING
billing_address__zipcode STRING
client_viewed_time STRING
color_code STRING
company_name STRING
country STRING
created_by STRING
created_time STRING
currency_code STRING
currency_id STRING
currency_symbol STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
documents STRING
due_date STRING
due_days STRING
email STRING
exchange_rate FLOAT64
has_attachment BOOL
invoice_id STRING
invoice_number STRING
invoice_url STRING
is_emailed BOOL
is_pre_gst BOOL
is_viewed_by_client BOOL
last_modified_time STRING
last_payment_date STRING
last_reminder_sent_date STRING
no_of_copies FLOAT64
payment_expected_date STRING
phone STRING
reference_number STRING
reminders_sent FLOAT64
salesperson_id STRING
salesperson_name STRING
schedule_time STRING
shipping_address__address STRING
shipping_address__attention STRING
shipping_address__city STRING
shipping_address__country STRING
shipping_address__fax STRING
shipping_address__phone STRING
shipping_address__state STRING
shipping_address__street2 STRING
shipping_address__zipcode STRING
shipping_charge FLOAT64
show_no_of_copies BOOL
status STRING
template_id STRING
template_type STRING
total FLOAT64
transaction_type STRING
unprocessed_payment_amount FLOAT64
updated_time STRING
write_off_amount FLOAT64
zcrm_potential_id STRING
zcrm_potential_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
item_adjustments (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
adjustment_type STRING
created_by_id STRING
created_by_name STRING
created_time STRING
date STRING
inventory_adjustment_id STRING
item_id STRING
last_modified_by_id STRING
last_modified_by_name STRING
last_modified_time STRING
name STRING
quantity_adjusted FLOAT64
reason STRING
reference_number STRING
status STRING
total FLOAT64
value_adjusted FLOAT64
warehouse_id STRING
warehouse_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
item_groups (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id STRING
attribute_id1 STRING
attribute_id2 STRING
attribute_id3 STRING
attribute_name1 STRING
attribute_name2 STRING
attribute_name3 STRING
attribute_type1 STRING
attribute_type2 STRING
attribute_type3 STRING
brand STRING
category_id STRING
created_time STRING
cumulative_stock_on_hand FLOAT64
group_id STRING
group_name STRING
inventory_account_id STRING
is_taxable FLOAT64
last_modified_time STRING
manufacturer STRING
product_type STRING
purchase_account_id STRING
tax_exemption_id STRING
tax_id STRING
unit STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
actual_available_stock FLOAT64
attribute_option_data1 STRING
attribute_option_data2 STRING
attribute_option_data3 STRING
attribute_option_id1 STRING
attribute_option_id2 STRING
attribute_option_id3 STRING
attribute_option_name1 STRING
attribute_option_name2 STRING
attribute_option_name3 STRING
available_stock FLOAT64
ean STRING
initial_stock FLOAT64
initial_stock_date STRING
is_returnable BOOL
isbn STRING
item_id STRING
name STRING
part_number STRING
purchase_rate FLOAT64
rate FLOAT64
reorder_level STRING
sku STRING
status STRING
stock_on_hand FLOAT64
upc STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
items (69 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id STRING
account_name STRING
actual_available_stock FLOAT64
attribute_id1 STRING
attribute_id2 STRING
attribute_id3 STRING
attribute_name1 STRING
attribute_name2 STRING
attribute_name3 STRING
attribute_option_data1 STRING
attribute_option_data2 STRING
attribute_option_data3 STRING
attribute_option_id1 STRING
attribute_option_id2 STRING
attribute_option_id3 STRING
attribute_option_name1 STRING
attribute_option_name2 STRING
attribute_option_name3 STRING
attribute_type1 STRING
attribute_type2 STRING
attribute_type3 STRING
available_stock FLOAT64
brand STRING
created_time STRING
dimension_unit STRING
ean STRING
group_id STRING
group_name STRING
has_attachment BOOL
height STRING
image_document_id STRING
image_name STRING
image_type STRING
is_combo_product BOOL
is_linked_with_zohocrm BOOL
is_returnable BOOL
is_storage_location_enabled BOOL
isbn STRING
item_id STRING
item_name STRING
item_type STRING
last_modified_time STRING
length STRING
manufacturer STRING
name STRING
part_number STRING
product_type STRING
purchase_account_id STRING
purchase_account_name STRING
purchase_description STRING
purchase_rate FLOAT64
rate FLOAT64
reorder_level STRING
sku STRING
source STRING
status STRING
stock_on_hand FLOAT64
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
unit STRING
upc STRING
weight STRING
weight_unit STRING
width STRING
zcrm_product_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organizations (72 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
account_created_date STRING
account_created_date_formatted STRING
can_change_timezone BOOL
can_sign_invoice BOOL
contact_name STRING
country STRING
country_code STRING
currency_code STRING
currency_format STRING
currency_id STRING
currency_symbol STRING
custom_field_type FLOAT64
digital_signature_mode STRING
email STRING
field_separator STRING
fiscal_year_start_month FLOAT64
is_org_active BOOL
is_org_not_supported BOOL
is_default_org BOOL
is_designated_zone BOOL
is_dsign_required BOOL
is_export_with_payment_enabled BOOL
is_free_zone BOOL
is_gst_india_version BOOL
is_hsn_or_sac_enabled BOOL
is_international_trade_enabled BOOL
is_invoice_pmt_tds_allowed BOOL
is_org_active BOOL
is_quick_setup_completed BOOL
is_registered_for_composite_scheme BOOL
is_registered_for_gst BOOL
is_registered_for_tax BOOL
is_sales_inclusive_tax_enabled BOOL
is_sales_reverse_charge_enabled BOOL
is_search360_enabled STRING
is_sku_enabled BOOL
is_solo_org BOOL
is_tax_registered BOOL
is_trial_period_extended BOOL
is_user_dsign_mandatory BOOL
is_ziedition BOOL
is_zpayroll_grid BOOL
language_code STRING
mode STRING
name STRING
org_action STRING
org_created_app_source FLOAT64
org_settings BOOL
org_type STRING
organization_id STRING
partners_domain STRING
phone STRING
plan_name STRING
plan_period STRING
plan_type FLOAT64
price_precision FLOAT64
sales_tax_type STRING
source FLOAT64
state STRING
state_code STRING
tax_group_enabled BOOL
time_zone STRING
time_zone_formatted STRING
user_status FLOAT64
user_status_formatted STRING
version_formatted STRING
zi_zb_client FLOAT64
zi_zb_edition FLOAT64
zoho_one_org STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
index FLOAT64
label STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: organizations__org_joined_app_list

Section titled “Subtable: organizations__org_joined_app_list”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
packages (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_time STRING
customer_id STRING
customer_name STRING
date STRING
delivery_method STRING
is_carrier_shipment BOOL
is_tracking_enabled BOOL
label_format STRING
last_modified_time STRING
package_id STRING
package_number STRING
quantity STRING
salesorder_id STRING
salesorder_number STRING
shipment_date STRING
shipment_id STRING
shipment_type STRING
shipping_charge FLOAT64
status STRING
tracking_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_orders (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billed_status STRING
client_viewed_time STRING
color_code STRING
company_name STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
date STRING
delivery_date STRING
delivery_days STRING
due_by_days STRING
due_in_days STRING
has_attachment BOOL
is_backorder BOOL
is_drop_shipment BOOL
is_po_marked_as_received BOOL
is_viewed_by_client BOOL
last_modified_time STRING
order_status STRING
price_precision STRING
purchaseorder_id STRING
purchaseorder_number STRING
quantity_marked_as_received FLOAT64
quantity_yet_to_receive FLOAT64
received_status STRING
reference_number STRING
status STRING
total FLOAT64
total_ordered_quantity FLOAT64
vendor_id STRING
vendor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sales_orders (50 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
balance FLOAT64
bcy_total FLOAT64
color_code STRING
company_name STRING
created_time STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
delivery_date STRING
delivery_method STRING
delivery_method_id STRING
due_by_days STRING
due_in_days STRING
email STRING
has_attachment BOOL
invoiced_status STRING
is_backorder BOOL
is_drop_shipment BOOL
is_emailed BOOL
is_manually_fulfilled BOOL
last_modified_time STRING
order_fulfillment_type STRING
order_status STRING
paid_status STRING
pickup_location_id STRING
quantity FLOAT64
quantity_invoiced FLOAT64
quantity_packed FLOAT64
quantity_shipped FLOAT64
reference_number STRING
sales_channel STRING
sales_channel_formatted STRING
salesorder_id STRING
salesorder_number STRING
salesperson_name STRING
shipment_date STRING
shipment_days STRING
shipped_status STRING
source STRING
status STRING
total FLOAT64
total_invoiced_amount FLOAT64
zcrm_potential_id STRING
zcrm_potential_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transfer_orders (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_by_id STRING
created_by_name STRING
created_time STRING
date STRING
from_warehouse_id STRING
from_warehouse_name STRING
last_modified_by_id STRING
last_modified_by_name STRING
last_modified_time STRING
quantity_transfer FLOAT64
status STRING
to_warehouse_id STRING
to_warehouse_name STRING
transfer_order_id STRING
transfer_order_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
invitation_type STRING
is_current_user BOOL
is_customer_segmented BOOL
is_employee BOOL
is_super_admin BOOL
is_vendor_segmented BOOL
mobile STRING
name STRING
photo_url STRING
role_id STRING
status STRING
user_id STRING
user_role STRING
user_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
warehouses (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
address1 STRING
address2 STRING
attention STRING
city STRING
country STRING
default_receiving_storage_id STRING
default_receiving_storage_name STRING
email STRING
is_fba_warehouse BOOL
is_org_level_primary BOOL
is_primary BOOL
is_storage_location_enabled BOOL
phone STRING
state STRING
state_code STRING
status STRING
total_storagelocations FLOAT64
total_zones FLOAT64
warehouse_id STRING
warehouse_name STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Zoho Inventory supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Zoho Inventory?

Section titled “How long does the initial sync take for Zoho Inventory?”

It depends on how much history is in your Zoho Inventory account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Zoho Inventory’s schema changes?

Section titled “What happens when Zoho Inventory’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Zoho Inventory, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Zoho Inventory instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Zoho Inventory connector in Kaivo and all of its synced data is deleted with it.

Use sales_orders and invoices to track revenue and demand over time.

Join items with warehouses and item_adjustments to monitor stock levels.

Use purchase_orders to track buying and restocking.

Use Zoho Inventory data in your AI and BI tools

Section titled “Use Zoho Inventory data in your AI and BI tools”

Once Zoho Inventory data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Zoho Inventory data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Zoho Inventory connector pricing and plan details.