The Scenario
You are the buyer at a 50-person retailer. A new supplier just sent over their product catalog, 300 rows in a Google Sheet: 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 spreadsheet, look at the form, look at the spreadsheet 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 sheet 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:
Create BaseLinker inventory products from this sheet: column A = SKU, column B = product name, column C = description, column D = gross price, column E = EAN. Add all 300 rows to catalog ID 11223344 and 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. When it is done, you have a sheet where every row has both the supplier SKU and the BaseLinker product ID, which is the cross-reference you need for every subsequent operation.
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 sheet 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 that needs a BaseLinker product ID can look it up in this sheet.
If BaseLinker returns an error for a row (duplicate SKU, invalid EAN format), SheetXAI writes the error into column F instead of a product ID, so you can see exactly which rows need attention before the launch.
What If the Data Is Not Quite Ready
Supplier sheets 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 11223344.
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 sheet, check whether each SKU in column A already exists in BaseLinker catalog ID 11223344. 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 11223344 using the selling price from column G.
When the sheet has products for two different catalogs
Rows 2 to 180 belong to catalog 11223344 and rows 181 to 300 belong to catalog 55667788. Column F already indicates which catalog.
Create BaseLinker products from this sheet. 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. You do not need a "clean the data" step and a "create the products" step. It is one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your supplier product sheet, 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 Google Sheets overview.