The Scenario
Every Monday morning you do a physical stock count across three stores, enter the results into an Excel workbook, and then try to get those numbers into Simla before the warehouse team starts fulfilling the week's orders. 400 SKUs, three store worksheets, a purchase price column. Simla needs to reflect reality — stale numbers cause oversells, and you've already had two incidents this quarter.
The bad version:
- Navigate to Simla's inventory section, filter by store, find each SKU, update quantity and purchase price one by one.
- Or try Simla's import tool, discover it doesn't handle multi-warehouse inventory in your format, and spend an hour restructuring the workbook as CSV.
- Finish Store 1 by 10 AM, fall behind on Store 2, push Store 3 to tomorrow — by which point the count is 24 hours stale.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Excel. It reads your inventory workbook and pushes updated stock quantities and purchase prices into Simla for all three stores using Simla's inventory update API.
Push the inventory data from my Excel Stock Update table into Simla using the SKU, warehouse code, quantity, and purchase price columns to update leftover stocks.
What You Get
- All 400 SKU inventory records updated in Simla across all three stores
- Failed rows flagged with the reason — offer ID not found, invalid store code, missing quantity
- A per-store update count in the SheetXAI sidebar
- Sync timestamp written into a summary row for your records
What If the Data Is Not Quite Ready
The workbook is wide-format with one row per SKU and three store columns
Unpivot the Stock Update table so each SKU-store combination becomes a separate row, then upload all rows to Simla and mark each Synced or Failed.
Purchase prices are missing for some SKUs
Skip rows where the purchase price column is blank, upload all rows with a purchase price using the SKU, warehouse code, quantity, and price columns — flag skipped rows as "NO PRICE".
SKU codes in the workbook are article codes, not Simla offer IDs
Match article codes in column A to Simla offer IDs using my SKU Mapping worksheet, then upload inventory data for each matched record — flag unmatched codes as "NO MATCH".
Unpivot, map, and sync in one ask
Unpivot to one row per SKU-store, map article codes to Simla offer IDs, skip rows with missing purchase prices, then upload all valid records and mark each row Synced, Failed, or No Match.
One prompt. Structure transformation and sync in one pass.
Try It
Get the 7-day free trial of SheetXAI and open your weekly stock count Excel workbook. See Batch Update Product Prices for catalog price changes, or the full Simla.com hub for all inventory and catalog workflows.