The Scenario
You are a warehouse manager. A new purchase order is arriving Friday morning and you need 200 new SKUs live in Zoho Inventory before it lands.
Your merchandising team handed you a Google Sheet yesterday — product name in column A, SKU in column B, unit in column C, and sales price in column D. Two hundred rows. The sheet is clean. The problem is getting it in.
The bad version of this week:
- You open Zoho Inventory's item creation screen
- You paste the first row, fill in the unit dropdown, set the price, save
- You move to row two
- By row twelve you have made three typos and had to go back
- By row forty you have skipped the unit field twice and do not know which rows
- You are still at this on Thursday afternoon and the PO arrives Friday.
The fast version is one prompt before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the data and calls Zoho Inventory's item creation API for you, row by row, without you touching the Zoho web interface.
Open the SheetXAI sidebar and type:
Create a Zoho Inventory item for each row in this sheet using product name from column A, SKU from column B, unit from column C, and sales price from column D. Write the returned item ID into column E. Skip any rows where column B is blank and flag them in column F.
SheetXAI reads all 200 rows, calls the Zoho Inventory Items API for each one, writes the item ID back into column E, and flags any skipped rows in column F. The whole run completes while you handle something else.
What You Get
A completed sheet with:
- Column E — the Zoho Inventory item ID for every successfully created item
- Column F — a flag for any rows skipped due to missing SKU
- 200 items live in Zoho Inventory, ready for purchase order line matching
The item IDs in column E are immediately useful. When the next step is creating purchase order lines or sales orders, you already have the IDs in the sheet — no lookup step needed.
If the SKU format needs a prefix before upload, tell SheetXAI to prepend it. If the unit field needs to match Zoho's dropdown values exactly, ask SheetXAI to normalize them first. Both happen in the same prompt.
What If the Data Is Not Quite Ready
Most catalogue sheets handed over by merchandising teams are not perfectly formatted. SheetXAI handles cleanup and the upload in the same prompt.
When SKU values have inconsistent formatting
Some SKUs have leading zeros, some do not. Some have hyphens, some do not. Zoho Inventory will create duplicates if you are not careful.
Normalize the SKU values in column B — strip leading zeros and remove hyphens — then create a Zoho Inventory item for each row using the normalized SKU. Write item IDs into column E and flag duplicates in column F.
When the unit column uses terms Zoho Inventory does not recognize
The sheet says "pcs" and "ea" but Zoho expects "piece" and "each."
Before uploading, map the values in column C: "pcs" to "piece," "ea" to "each," "kg" to "kilogram." Then create a Zoho Inventory item for each row using the mapped unit value, product name from column A, SKU from column B, and price from column D.
When you only want to upload items not already in Zoho Inventory
The sheet includes both new items and items that already exist. You do not want to create duplicates.
For each SKU in column B, check whether a Zoho Inventory item with that SKU already exists. Skip rows where the item exists and write "ALREADY EXISTS" into column E. For new items, create the Zoho Inventory item and write the returned ID into column E.
When the sheet also needs quantity and reorder point set on creation
The catalogue sheet has a starting quantity in column E and a reorder point in column F, and you want both set when each item is created.
Create a Zoho Inventory item for each row using product name from column A, SKU from column B, unit from column C, and sales price from column D. Set initial stock to the value in column E and the reorder point to the value in column F. Write the returned item ID into column G. Flag any rows where column E or F is blank.
The pattern: instead of cleaning the sheet and then uploading, you ask for both in one prompt. SheetXAI handles the normalization, the conditional skipping, and the API calls in sequence.
Try It
Get the 7-day free trial of SheetXAI and open any catalogue sheet with SKU data, then ask it to push the items into Zoho Inventory. The Zoho Inventory integration is included in every plan. For the next step, see how to bulk-create sales orders from a wholesale order sheet or the Zoho Inventory in Google Sheets overview.