The Scenario
You are a merchandising coordinator at a clothing brand. Monday at noon, the buying team sends you a completed Excel file: 40 T-shirt styles, each with two attributes — Size and Color — and a selling price per variant combination.
Your job is to get all of it into Zoho Inventory as item groups before the week's purchase orders go out. Each style is a parent group, each size-color combination is a variant under that group.
The bad version of this week:
- You open Zoho Inventory's item group creation screen
- You type the first style name, add Size as an attribute, add Color as an attribute
- You add variant one: Small, Red, $29.99
- You add variant two: Small, Blue, $29.99
- You add variant three: Medium, Red, $29.99
- You repeat this for every size-color combination under every style
- By style four you hate this job and the week has barely started.
Forty styles with six variants each is 240 individual variant rows to enter. The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the variant matrix and calls Zoho Inventory's item group API for each unique style, adding variants in bulk.
Open the SheetXAI sidebar and type:
Create a Zoho Inventory item group for each unique product name in column A of this sheet. Add variants for each size and color combination in columns B and C with the selling price from column D. Write the returned item group ID into column E for each row.
SheetXAI reads the sheet, groups rows by product name, creates one item group per style, attaches every size-color variant to that group, and writes the item group IDs back. Forty styles in one run.
What You Get
- 40 Zoho Inventory item groups, one per style
- Each group has Size and Color as attributes, with every variant combination attached
- Column E holds the item group ID for each source row — useful when the next step is creating purchase order lines
The attribute names are consistent across all groups. You do not have to re-type "Size" and "Color" for each item group manually. SheetXAI infers the attribute structure from the sheet columns.
If the buying team later sends you an update file with two new styles, the same prompt on the new rows handles it. You do not rebuild anything.
What If the Data Is Not Quite Ready
Variant sheets from buying teams always have at least one issue. SheetXAI handles cleanup and creation in the same prompt.
When some rows are missing a price
A few combinations did not get a selling price assigned before the file was sent.
Before creating item groups, flag any rows in column D that are blank and write "MISSING PRICE" into column E for those rows. Skip those variants when creating item groups. For all other rows, create the item groups and variants normally and write the item group ID into column E.
When the size values use inconsistent labels
The sheet mixes "S," "Small," and "Sm" for the same size. Zoho Inventory will create three separate variants.
Normalize the size values in column B before creating item groups: map "Sm" and "S" to "Small," "Med" and "M" to "Medium," "Lg" and "L" to "Large," "XL" and "Extra Large" to "XL." Then create the item groups and variants using the normalized values.
When you only want to create groups for styles not already in Zoho Inventory
The buying team's file includes some styles that were already set up last season.
For each unique product name in column A, check whether a Zoho Inventory item group with that name already exists. For existing groups, write "ALREADY EXISTS" into column E. For new styles, create the item group with all variants and write the returned ID into column E.
When the sheet has a mix of new styles and variant updates to existing ones
Some rows are new styles, some are new variants for styles that were already created in Zoho Inventory last week.
For each unique product name in column A, check if a Zoho Inventory item group already exists. If it does, add any variant combinations from columns B and C that do not yet exist under that group, and write "VARIANT ADDED" into column E. If the item group does not exist, create it with all variants from the sheet and write the new item group ID into column E.
The pattern: the sheet is the source of truth, and SheetXAI reconciles it against what Zoho Inventory already has before touching anything.
Try It
Get the 7-day free trial of SheetXAI and open any variant matrix sheet, then ask it to push item groups into Zoho Inventory. The Zoho Inventory integration is included in every plan. For the upstream step, see how to bulk-create items from a catalogue sheet or the Zoho Inventory in Google Sheets overview.