The Scenario
You are a pricing analyst. A promotion is going live in three days and you need to review the pricing structure for 400 products before the discount rules are applied.
The problem: your three price groups, retail, wholesale, and VIP, live in BaseLinker's catalog. You have never seen them side by side in one place. You need to check whether the VIP price for any product is higher than the retail price (which happens after bulk imports), whether any product has a zero wholesale price, and whether the margin between retail and wholesale is at least 20% across the board.
The bad version:
- Open BaseLinker, go to the catalog
- Click on the first product, note the retail price, click on wholesale, note it, click on VIP, note it
- Open your sheet, type the three values in columns B, C, and D
- Repeat for product 2
- By product 40 you have made your first transcription error. By product 100 you genuinely hate this job. The promotion goes live tomorrow and you have reviewed 150 of 400 products.
The fast version is one prompt and you spend the time on the actual analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads BaseLinker's price groups directly and builds the comparison table for you, so you never have to click through individual product records.
Open the SheetXAI sidebar and type:
Fetch BaseLinker prices for all products in catalog ID 11223344 and write product ID, SKU, and prices for each price group as separate columns into this sheet. Label the columns: Product ID, SKU, Retail Price, Wholesale Price, VIP Price.
SheetXAI calls the BaseLinker inventory API, retrieves all price groups for every product, and writes a clean comparison table. All 400 products, all three price tiers, in one sheet.
What You Get
A 400-row comparison table with one column per price group:
- Product ID and SKU — for cross-referencing with other systems
- Retail Price — the customer-facing price
- Wholesale Price — the B2B price
- VIP Price — the loyalty or partner price
- Ready for formula analysis — add a margin column with a simple formula once the data is in the sheet
The comparison table is the artifact Finance and Merchandising have been asking for. It does not exist anywhere in BaseLinker's UI in this form. SheetXAI assembles it in one prompt.
What If the Data Is Not Quite Ready
Price data from BaseLinker is often messier than the API suggests. SheetXAI handles the analysis inline.
When some products have a zero wholesale price
Products imported from a supplier file sometimes land with a zero price in one tier if the import did not include that price group.
Fetch prices for all products in BaseLinker catalog ID 11223344. Write product ID, SKU, retail, wholesale, and VIP prices into this sheet. In column F, flag any product where wholesale price is zero or missing with "MISSING WHOLESALE." Leave column F blank for the rest.
When you want the margin analysis done automatically
You do not want to write the formulas yourself. Tell SheetXAI to do the calculation.
Fetch prices for all products in BaseLinker catalog ID 11223344. Write product ID, SKU, retail price, and wholesale price into this sheet. Calculate the gross margin percentage as (retail minus wholesale) divided by retail and write it into column E as a percentage. Flag any row where the margin is below 20% with "LOW MARGIN" in column F.
When you need to compare prices across two catalogs
You manage two separate BaseLinker catalogs and want to make sure prices are consistent.
Fetch prices for all products in BaseLinker catalog IDs 11223344 and 55443322. Write one row per product showing catalog ID, product ID, SKU, retail price, wholesale price, and VIP price. For products that appear in both catalogs (matched by SKU), add a note in column G if the retail prices differ.
When you need to identify anomalies, flag them, and generate the summary for the promotion brief in one pass
The promotion brief needs a table of products with anomalies plus a summary count.
Fetch prices for all products in BaseLinker catalog ID 11223344 and write product ID, SKU, retail, wholesale, and VIP prices into this sheet. In column F, flag any anomaly: "VIP HIGHER THAN RETAIL" if VIP price exceeds retail price, "ZERO WHOLESALE" if wholesale is zero, "LOW MARGIN" if retail minus wholesale margin is below 20%. For products with no anomaly, leave column F blank. After processing all rows, write a summary in row 1 showing the count of each anomaly type.
The pattern: pull the data, run the analysis, and surface the anomalies in one prompt. The promotion brief writes itself from the flagged output.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to fetch your BaseLinker price group data. The BaseLinker integration is included in every SheetXAI plan. For a related workflow, see how to import a full product catalog into BaseLinker or the BaseLinker in Google Sheets overview.