The Scenario
The new store goes live in two weeks. Product management just handed you a Google Sheet 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've never created products in Simla in bulk before. 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. Click Save. Repeat.
- Reach product 30 and realize you've been entering the catalog ID into the wrong field. Open a tab to fix the first 30 records.
- Finish all 150, then spend an hour cross-checking the sheet against Simla's catalog list to make sure nothing was missed or mistyped.
QA starts Monday. The store goes live in two weeks. You have other things on the pre-launch checklist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Google Sheets. It reads your product spreadsheet, creates each SKU in Simla's store catalog, and writes the resulting Simla product ID back into the sheet — giving you a verified record of what was created.
Batch-create all products from this sheet in Simla using product name in column A, article/SKU in column B, catalog ID in column C, and price in column D.
What You Get
- All 150 products created in Simla's store catalog
- The resulting Simla product ID written into column E for each row
- Failed rows flagged with the reason — duplicate article code, invalid catalog ID, missing required field
- A count of created vs. failed records per batch
What If the Data Is Not Quite Ready
Some article codes already exist in Simla from a previous catalog import
Check each article code in column B against Simla's existing catalog and skip rows that already exist — create only the new products and write the Simla product ID into column E, flagging skipped rows as "ALREADY EXISTS".
Catalog IDs in the sheet are human-readable names, not Simla's numeric IDs
If your sheet has catalog names like "Men's Footwear" but Simla expects catalog numeric IDs, you need a lookup.
Match catalog names in column C to Simla's catalog IDs using my Catalog Mapping tab (column A = name, column B = Simla ID), then create all products in Simla using the mapped catalog IDs and write the resulting product ID into column E — flag rows where the catalog name has no match.
Price column has blank cells for products being priced later
Filter out rows where column D (price) is blank, create all rows with a price in Simla, and write a note in column E for skipped rows — create only what's ready, skip the rest.
Full check, mapping, and creation in one pass
Check for existing article codes, map catalog names to Simla IDs via my Catalog Mapping tab, skip rows with blank prices, then batch-create all remaining products in Simla and write the product ID into column E.
One ask handles all the pre-flight checks before any record is created.
Try It
Get the 7-day free trial of SheetXAI and open your pre-launch product spreadsheet. See Batch Update Product Prices for pushing price changes after go-live, or the full Simla.com hub for all catalog workflows.