The Scenario
You are the buyer at a 50-person retailer. A new supplier just sent over their product catalog, 300 rows in an Excel workbook: SKU in column A, product name in column B, description in column C, gross price in column D, EAN code in column E.
The launch date is in four days. Every product needs to be in BaseLinker before then so the warehouse can configure stock levels and the team can list them on the marketplaces.
The bad version:
- Open BaseLinker's product creation form
- Fill in the first product: SKU, name, description, price, EAN
- Save, open the form again
- Fill in the second product
- Look at the workbook, look at the form, look at the workbook again
- Lose your place at row 47
- You finish 240 products on day one, restart on day two, and the launch is delayed by 24 hours.
The fast version is one prompt, and you move on to something else.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the supplier workbook and creates every product in BaseLinker in one operation, so you do not have to touch the product creation form at all.
Open the SheetXAI sidebar and type:
For every row in this workbook, create a product in BaseLinker catalog ID 55667788 using SKU in column A, name in column B, description in column C, gross price in column D, and EAN in column E. Write the resulting BaseLinker product ID into column F for each row.
SheetXAI reads every row, calls BaseLinker's product creation API, and writes the new product ID back to column F. Every row now has both the supplier SKU and the BaseLinker product ID.
What You Get
300 BaseLinker products, created in one prompt:
- Product ID — written back to column F, one per row
- SKU, name, description, price, EAN — all mapped from the workbook columns
- Catalog assignment — all products in the catalog ID you specified
The product IDs in column F are your new source of truth. Stock updates, price changes, marketplace listings — every future operation can look up the BaseLinker product ID here.
What If the Data Is Not Quite Ready
Supplier workbooks are never perfectly formatted. SheetXAI handles the cleanup and the creation in the same prompt.
When EAN codes have inconsistent formatting
Some EAN codes in column E have leading zeros stripped. BaseLinker expects 13-digit EAN codes.
Before creating products in BaseLinker, check column E for EAN codes that are fewer than 13 digits. Pad them with leading zeros to make them 13 digits. Then create all 300 products in catalog ID 55667788.
When some products are duplicates of existing catalog items
You have imported products from this supplier before and some SKUs already exist in BaseLinker.
Before creating products from this workbook, check whether each SKU in column A already exists in BaseLinker catalog ID 55667788. If it does, skip the creation and write "already exists" into column F. If it does not, create the product and write the new product ID into column F.
When prices need a markup applied before import
The supplier prices in column D are cost prices. You want to mark them up by 40% before loading them into BaseLinker.
Multiply every price in column D by 1.4 and write the result into column G as the selling price. Then create all 300 products in BaseLinker catalog ID 55667788 using the selling price from column G.
When the workbook has products for two different catalogs
Column F indicates which catalog each row belongs to.
Create BaseLinker products from this workbook. Use the catalog ID in column F for each row. Column A = SKU, column B = product name, column C = description, column D = gross price, column E = EAN. Write the resulting BaseLinker product ID into column G for each row.
The pattern: the cleanup runs in the same prompt as the creation. No separate "clean the data" step.
Try It
Get the 7-day free trial of SheetXAI and open your supplier product workbook, then ask it to create the products in BaseLinker. The BaseLinker integration is included in every SheetXAI plan. For a related workflow, see how to bulk-update stock after a warehouse audit or the BaseLinker in Excel overview.