The Scenario
You are the Shopify store owner who just activated Klaviyo's product recommendations feature. The personalized recommendation emails cannot go out until your product catalog is inside Klaviyo. You have 200 products in an Excel workbook — SKU, name, price, product URL, and image URL. You need them all to become Klaviyo catalog items before you can send a single recommendation email.
The bad version:
- Read Klaviyo's catalog API documentation and discover that bulk catalog creation requires a batch job endpoint with a specific JSON structure — not a CSV upload.
- Try to format 200 rows into that structure using Power Query or a helper sheet, run a manual API call, and watch 12 items fail because the price column had currency formatting the API could not parse.
- Fix those 12 manually through Klaviyo's catalog UI, item by item.
You are a store owner, not a backend developer. The catalog feature looked like a settings page. It turned out to be an API integration project.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your product data and calls Klaviyo's bulk catalog item creation endpoint in batches — no API knowledge needed.
For each row in this workbook, create a Klaviyo catalog item using the product name in column A, SKU in column B, price in column C, and image URL in column D, then write the returned item ID into column E
What You Get
- Up to 100 catalog items are submitted per batch job, with SheetXAI looping through all 200 rows automatically.
- Each returned Klaviyo item ID is written back into column E on the corresponding row.
- Failed rows surface with their row number and the Klaviyo error reason.
What If the Data Is Not Quite Ready
Prices have dollar signs that the API rejects
For each row in this workbook, create a Klaviyo catalog item using product name (A), SKU (B), price (C) — strip the dollar sign and parse it as a float first — and image URL (D), writing the returned item ID into column E
Products need to be grouped into category relationships
Read all rows from this workbook and create Klaviyo catalog items in bulk, grouping them into category relationships based on the category value in column F — create each category first if it does not already exist
The product URL column is missing for 30 rows
Create Klaviyo catalog items for all rows in this workbook; for rows where column E (product URL) is blank, use "https://yourstore.com/products/" concatenated with the SKU in column B as the URL; write the returned item ID into column F
Full catalog seed with error recovery in one pass
Create Klaviyo catalog items for all 200 rows using name (A), SKU (B), price (C) — strip currency formatting — image URL (D), and product URL (E); write the returned item ID into column F, write "FAILED" and the error reason into column G for any failed row, then summarize total created and total failed at the bottom of column F
The catalog is seeded and the recommendation flow can go live.
Try It
Get the 7-day free trial of SheetXAI and open the product workbook you use to manage your Shopify inventory, then ask it to push everything into Klaviyo's catalog. Also see how to bulk create catalog variants for products with multiple SKUs.