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 the first variant: Small, Red, $29.99
- You add the next variant: Small, Blue, $29.99
- You add: Medium, Red, $29.99
- You repeat 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. The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the Variants tab 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 the Variants tab. 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 workbook, groups rows by product name, creates one item group per style, attaches every size-color variant, 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 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 workbook 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 workbooks 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 in the Variants tab, 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.
When the size values use inconsistent labels
The workbook mixes "S," "Small," and "Sm" for the same size. Zoho Inventory will create three separate variants.
Normalize the size values in column B of the Variants tab before creating item groups: map "Sm" and "S" to "Small," "Med" and "M" to "Medium," "Lg" and "L" to "Large." 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 workbook includes some styles that were already set up last season.
For each unique product name in column A of the Variants tab, 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 workbook has a mix of new styles and variant updates to existing ones
Some rows are new styles, some are new variants for styles created in Zoho Inventory last week.
For each unique product name in column A of the Variants tab, 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 workbook and write the new item group ID into column E.
The pattern: the workbook 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 workbook, 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 workbook or the Zoho Inventory in Excel overview.