The Scenario
You are the head of operations at a subscription box company. You have 35 products in an Excel workbook — name in column A, description in column B, unit price in paise in column C.
Your billing team creates recurring invoices in Razorpay every month. Without a Razorpay item catalog, they search for each product name manually in the dashboard before adding it to an invoice. 35 products, one at a time, every invoice cycle.
The item catalog in Razorpay needs to be built from the workbook. Right now the two systems are out of sync.
The slow version:
- Log into the Razorpay dashboard, go to Items
- Click "Create Item" for each product, type name, description, and unit amount
- Copy the item ID, paste back into the workbook
- Repeat 35 times
- On item 28, realize you've been entering rupees instead of paise. Start over.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can create all 35 Razorpay items and write each item ID back, without you opening the Razorpay dashboard.
Open the SheetXAI sidebar and type:
For each product in this workbook, create a Razorpay item using the name in column A, description in column B, and unit price in paise in column C. Write the resulting item ID to column D. Log any error in column E.
SheetXAI creates all 35 items and writes each item ID back to column D. Your billing team now has the IDs they need, in the same workbook, next to the product names.
What You Get
A fully linked product workbook:
- Column D — the Razorpay item ID for every product
- Column E — any error for rows that failed
- Ready for invoice creation — billing team references column D instead of searching the dashboard
The monthly invoice cycle is now a lookup, not a search.
What If the Data Is Not Quite Ready
When unit prices are in rupees, not paise
Column C has values like 499.00 (rupees) instead of 49900 (paise).
Before creating the Razorpay items, multiply all values in column C by 100 to convert from rupees to paise. Then create the items and write the item ID to column D.
When some products already exist in Razorpay
For each row, search Razorpay items by the name in column A. If an item with that name already exists, write the existing item ID to column D and "Existing — not created" to column E. If no matching item is found, create a new one and write the new item ID to column D.
When descriptions need to be generated for empty rows
For each row where column B is empty, generate a one-sentence description based on the product name in column A and unit price. Write the description to column B. Then create the Razorpay item and write the item ID to column D.
When you want the full catalog build — normalize prices, generate descriptions, create items, and log IDs
Multiply all values in column C by 100 to convert from rupees to paise. For rows where column B is empty, write a one-sentence product description based on column A and the converted price. Create a Razorpay item for each row using name, description, and unit price. Write the item ID to column D and any errors to column E.
The pattern: the price normalization, the description generation, and the API calls all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your product workbook, then ask it to create the Razorpay items and write the IDs back. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to bulk-create Razorpay invoices in Excel or the Razorpay in Excel overview.