The Scenario
The new store goes live in two weeks. Product management handed you an Excel workbook with 150 SKUs — product name, article code, catalog ID, and retail price — and all of them need to exist in Simla's product catalog before QA starts testing the checkout flow. You open the catalog admin and see a "New Product" button.
The bad version:
- Click "New Product," fill in the name, article code, catalog ID, and price. Save. Repeat 150 times.
- Reach product 30 and realize you've been entering the catalog ID in the wrong field. Go back and fix the first 30.
- Finish all 150, then spend an hour cross-checking the workbook against Simla's catalog list to confirm nothing was missed.
QA starts Monday. The store goes live in two weeks.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Excel. It reads your product workbook, creates each SKU in Simla's store catalog, and writes the resulting Simla product ID back into the workbook.
Read every row in my Excel New Products table and create each one in Simla's store catalog with the name, SKU, and price; write the resulting product ID back into column E.
What You Get
- All 150 products created in Simla's store catalog
- The Simla product ID written into column E for each row
- Failed rows flagged with the reason — duplicate article code, invalid catalog ID, missing field
- A per-batch success count in the SheetXAI sidebar
What If the Data Is Not Quite Ready
Some article codes already exist from a previous import
Check each article code in column B against Simla's existing catalog, skip duplicates, create only the new products, and write "ALREADY EXISTS" in column E for skipped rows.
Catalog IDs are human-readable names, not Simla's numeric IDs
Match catalog names in column C to Simla's catalog IDs using my Catalog Mapping worksheet, then create all products using the mapped IDs and write the resulting product ID into column E — flag unmatched catalog names.
Price column has blank cells for products being priced later
Filter out rows where the price column is blank, create all rows with a price in Simla, and note skipped rows in column E.
Full check, mapping, and creation in one pass
Check for duplicate article codes, map catalog names to Simla IDs via my Catalog Mapping worksheet, skip rows with blank prices, then batch-create all remaining products and write the product ID into column E.
One ask, all pre-flight checks included.
Try It
Get the 7-day free trial of SheetXAI and open your pre-launch Excel workbook. See Batch Update Product Prices for post-launch price changes, or the full Simla.com hub for all catalog workflows.