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 need to see them side by side in an Excel workbook to check for anomalies before the promotion brief goes to the merchandising team.
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 Excel, 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 in your workbook, so you never have to click through individual product records.
Open the SheetXAI sidebar and type:
Pull product pricing data from BaseLinker catalog ID 55443322 for all price groups and create a comparison table in this workbook with one row per product and one column per price group. 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 workbook.
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 margin columns with Excel formulas once the data is in the workbook
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.
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.
Fetch prices for all products in BaseLinker catalog ID 55443322. Write product ID, SKU, retail, wholesale, and VIP prices into this workbook. In column F, flag any product where wholesale price is zero or missing with "MISSING WHOLESALE."
When you want the margin analysis done automatically
You do not want to write the formulas yourself.
Fetch prices for all products in BaseLinker catalog ID 55443322. Write product ID, SKU, retail price, and wholesale price into this workbook. 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 promotion summary in one pass
The promotion brief needs a table of anomalous products plus a count summary.
Fetch prices for all products in BaseLinker catalog ID 55443322 and write product ID, SKU, retail, wholesale, and VIP prices into this workbook. In column F, flag: "VIP HIGHER THAN RETAIL" if VIP price exceeds retail, "ZERO WHOLESALE" if wholesale is zero, "LOW MARGIN" if retail minus wholesale margin is below 20%. After 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.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, 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 Excel overview.