The Scenario
You are a commercial photography studio launching a new service menu for the upcoming season. You have 40 new products in an Excel workbook — commercial session packages, licensing tiers, and delivery add-ons — with product names, types, prices, and SKUs on the Products tab. You need them all in Tave before the first new inquiry comes in.
Tave's product management interface lets you add one product at a time.
The bad version:
- You open Tave, go to the Products section, and click "Add Product"
- You type the name, select the type, enter the price, and enter the SKU
- You save and click "Add Product" again
- Forty products means forty forms
- By product twenty-two you have entered the wrong price on three products and have to go back and edit them.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads each row and calls the Tave API to create the product.
Open the SheetXAI sidebar and type:
Create a product in Tave for each row in the Products tab — column A is product name, B is product type, C is price, D is SKU. Write the result status into column E.
SheetXAI reads each row from the Products tab, creates the Tave product, and logs the result in column E. Forty products created. Done.
What You Get
Forty new Tave products, each with:
- Product name — from column A
- Product type — from column B
- Price — from column C
- SKU — from column D
- Status column — column E confirms success or surfaces an error with detail
If a SKU already exists in Tave, column E tells you which row conflicted so you can update the SKU and rerun just that row.
What If the Data Is Not Quite Ready
New service menus are drafted in a hurry. SheetXAI handles the messiness inline.
When product type values do not match Tave's accepted types
Your workbook has "Package" but Tave expects a specific product type string.
For each row in the Products tab, map the product type in column B to Tave's accepted types — "Package" maps to "package", "Print" to "print", "Add-On" to "addon". Then create a Tave product using column A for name, the mapped type, column C for price, and column D for SKU. Write the result status into column E.
When prices are formatted with currency symbols
Excel cells have "$450.00" instead of "450.00" because someone formatted the column.
Strip any currency symbols or commas from the values in column C of the Products tab before creating the Tave products. Then create one product per row using column A for name, B for type, cleaned price for price, and D for SKU. Write the result status into column E.
When some products are missing a SKU
A few rows have no SKU yet.
For rows in the Products tab where column D is blank, generate a SKU from the product name in column A — use the first three letters of each word joined by a dash in uppercase. Then create a Tave product for each row using column A for name, B for type, C for price, and the filled SKU. Write the result status and the generated SKU into columns E and F.
When you want to verify the product list before creating anything in Tave
You want a confirmation step before any products go live.
Read all rows in the Products tab and write a summary to a new section below the data — count of products by type, total price range, and a list of any rows missing a price or SKU. I will review and confirm before you create any Tave products.
The pattern: instead of forty product forms, you describe the batch once and SheetXAI runs it across all rows.
Try It
Get the 7-day free trial of SheetXAI and open your price list workbook, then ask it to create Tave products from every row. The Tave integration is included in every SheetXAI plan. For related workflows, see how to export the Tave product catalog for pricing review or the Tave in Excel overview.