The Scenario
You are an e-commerce operations manager. A product launch is six days away. You have 120 new SKUs ready to go — names, prices, VAT rates, and product family assignments already filled into an Excel workbook by the merchandising team.
Every SKU needs to exist in Altoviz before the launch. Your billing system cannot issue invoices for products that are not in the catalog.
The bad version of this week:
- Open Altoviz → Products → New Product
- Type the SKU name
- Enter the price
- Set the VAT code
- Assign to the product family
- Save
- Repeat 120 times
- Discover on item 47 that one of the product families does not exist yet and have to stop to create it
- You finish at midnight two days before launch, with errors you find tomorrow.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the product catalog rows and creates each Altoviz product, handling the family assignments and writing back the IDs.
Open the SheetXAI sidebar and type:
For each row in the "Product Catalog" tab of this workbook with columns SKU, name, price, VAT rate, and family, create an Altoviz product. Skip rows where column F already has a product ID. Write new product IDs into column F.
SheetXAI reads the tab, creates each product in Altoviz with the right VAT code and family assignment, and writes the returned product ID into column F. It skips any row that already has an ID, so re-running is safe.
What You Get
A fully populated Altoviz product catalog from one prompt:
- 120 Altoviz products — one per row, with name, price, VAT rate, and family set correctly
- Product IDs in column F — so you can audit which rows created successfully
- Skip logic built in — rows with an existing ID in column F are left untouched
The skip logic is what makes this re-runnable. If 15 products fail because a VAT code was wrong, you fix those rows and run the prompt again. SheetXAI only touches the blank rows in column F.
What If the Data Is Not Quite Ready
Product tabs from merchandising teams tend to have inconsistencies. SheetXAI handles them in the same prompt.
When product family names in the workbook do not match Altoviz exactly
The tab says "Accessories" but Altoviz has "Accessories & Add-Ons." The API call will fail.
Before creating products, fetch all existing product families from Altoviz and list their exact names. For each row in the "Product Catalog" tab, match the value in the family column to the closest existing Altoviz family name. If no match exists, flag the row in column G as "FAMILY NOT FOUND" and skip it. Create Altoviz products for all matched rows and write product IDs into column F.
When some rows have missing VAT rates
The merchandising team left the VAT rate blank on 12 rows because they are not sure.
For rows in the "Product Catalog" tab where the VAT rate column is blank, use the default VAT rate of 20%. For all other rows, use the rate in the tab. Create Altoviz products for every row and write product IDs into column F.
When you need to create the product families first
The workbook has 8 unique values in the family column, but only 3 of those families exist in Altoviz yet.
Read the "Product Catalog" tab and create a product family in Altoviz for each unique value in column D that does not already exist. Then create each product under the correct family and write the product ID back to column F.
When the catalog has duplicates from two sources
The merchandising team merged two supplier catalogs and some SKUs appear twice with slightly different names.
Before creating Altoviz products, deduplicate the "Product Catalog" tab by SKU (column A), keeping the row with the higher price where there are duplicates. Flag removed duplicates in column G as "DUPLICATE REMOVED." Then create Altoviz products for all remaining rows and write product IDs into column F.
The pattern: cleanup conditions and creation steps go in the same prompt. SheetXAI applies them in order.
Try It
Get the 7-day free trial of SheetXAI and open any product list or catalog workbook, then ask it to push the rows into Altoviz. The Altoviz integration is included in every plan. For related workflows, see how to bulk-create customers and invoices from a workbook or the Altoviz in Excel overview.