Zoho Inventory

Zoho Inventory is a cloud inventory management software for growing businesses with order management, end-to-end tracking, warehouse management, etc., developed by ZOHO Corporation.

Data Integration: Skyvia supports importing data to and from Zoho Inventory, exporting Zoho Inventory data to CSV files, replicating Zoho Inventory data to relational databases, and synchronizing Zoho Inventory data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Zoho Inventory.

Query: Skyvia Query supports Zoho Inventory.

Establishing Connection

Getting Credentials

While creating a connection to Zoho Inventory, you need to enter Organization Id in case you work with a multiple organizataions.

To get your Organization Id:

  1. Click Settings near your company profile icon in the top right corner.

    Settings button

  2. Click Organization Profile.

    Zoho Inventory Settings

  3. Look for your organization id in the header.

    Zoho Inventory Organization Profile

Creating Connection

Zoho Inventory Connection

To create a Zoho Inventory connection:

  1. Select a Zoho Inventory data center location from the Data Center dropdown.
  2. Enter your Organization Id.
  3. Click Sign In with Zoho and enter your Zoho login credentials.
  4. Click the Create Connection.

Additional Connection Parameters

Suppress Extended Requests

Zoho Inventory API returns only part of the fields for some objects when querying multiple records. To query the values of lacking fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Zoho Inventory because Zoho Inventory API does not return them without extended requests.

The list of additional fields is the following:

OBJECT FIELD
Contacts BillAddr-, ShipAddr-
CompositeItems MappedItems
Bundles LineItems
ItemAdjustments LineItems
TransferOrders LineItems
SalesOrders LineItems
Packages LineItems
Invoices LineItems
PurchaseOrders LineItems
Bills LineItems
SalesReturns LineItems
CreditNotes LineItems
Pricebooks PricebookItems

Connector Specifics

Objects With a Complex-Structured Data

Invoices, Bills, ItemAdjustments, PurchaseOrders, SalesOrders, and TransferOrders objects store complex-structured data. Skyvia represents this information as a LineItems JSON field. Here is an example of the LineItems field value from the Invoice table:

Some of the Zoho Inventory tables store complex structured data. These are the following tables: Invoices, Bills, ItemAdjustments, PurchaseOrders, SalesOrders, TransferOrders. For example, an invoice or a purchase order can have several lines. Skyvia represents this information in such tables as a JSON field LineItems. Here is an example of the LineItems field value from the Invoice table:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
[
  {
    "documents": [],
    "item_id": "369175000000122053",
    "is_combo_product": false,
    "account_id": "369175000000000388",
    "account_name": "Sales",
    "sku": "",
    "salesorder_item_id": "",
    "project_id": "",
    "time_entry_ids": [],
    "expense_id": "",
    "expense_receipt_name": "",
    "name": "ServiceItem",
    "description": "sample description",
    "item_order": 0,
    "bcy_rate": 148.92,
    "rate": 148.92,
    "quantity": 1,
    "unit": "kg",
    "discount": 0,
    "tax_id": "369175000000044076",
    "tax_name": "Tax_our",
    "tax_type": "tax",
    "tax_percentage": 15,
    "item_total": 148.92,
    "tags": [
      {
        "tag_option_id": "369175000000085213",
        "is_tag_mandatory": false,
        "tag_name": "testTag",
        "tag_id": "369175000000000333",
        "tag_option_name": "option1"
      }
    ],
    "item_custom_fields": [],
    "item_type": "sales_and_purchases"
  }
]

For user convenience, data stored in the lines is also available as separate records in objects with Lineitems suffix in their names (InvoiceLineItems, BillLineItems, etc). Since the objects with the LineItems suffix in their names are read-only, they can not be used in Synchronization and as a Target in the Import package. To make changes to the line in a Zoho Inventory object, you need to have your updated line data in a JSON format and map it to the LineItems field.

The objects with the LineItems suffix in their names can be found in Backup. You cannot restore data to these objects, as they are read-only. Instead, make changes to the corresponding main (suffixless) objects and those changes will be applied to the objects with Lineitems suffix automatically.

DML Operations Support

TransferOrders, ItemAdjustments, InvoiceCreditsApplied and Organizations objects do not support all the DML operations.

Operations Objects
INSERT, UPDATE Organizations
INSERT, DELETE TransferOrders, ItemAdjustments, InvoiceCreditsApplied

Zoho Inventory API Calls Limit

By default, Zoho Inventory has a 1000 API calls per day and 60 API calls per minute limit. Performing backup, replication, or querying all the data from complex objects may quickly use all the API calls available. For example, querying LineItems field values uses additional requests.

Supported Actions

Skyvia supports all the common actions for Zoho Inventory.