Product Margin Calculator

WHAT IT DOES

Product Margin Calculator scans product and price list pages, extracting product data including product name, selling price, and cost price. The tool then calculates gross margin percentage and markup percentage for each product, providing a clear view of profitability. Results are displayed with color-coded indicators — high margin (green), medium margin (yellow), and low margin (red) — making it easy to spot your most and least profitable products. The tool also calculates total revenue, total cost, total profit, and the weighted average margin across all products, giving you a comprehensive view of your product portfolio's profitability.

WHERE IT RUNS

This userscript runs inside major CRM and e-commerce platforms including Salesforce, HubSpot, Pipedrive, Zoho, Freshworks, Shopify, and BigCommerce in your browser, powered by the free BotGentz extension. It operates entirely on the page you are viewing — it does not send your product data anywhere else. All data extraction and margin calculations happen locally in your browser. The script works on all product list, price list, and inventory pages.

HOW TO USE

Install the BotGentz extension, then install this userscript from the BotGentz catalogue. Navigate to your CRM or e-commerce platform's product or price list page. Configure your settings — set a target margin percentage, define the high/medium/low tier thresholds, choose a currency symbol, and optionally enable tax inclusion with a tax rate. Click "Save Settings" to persist your configuration, then "Scan Page" to extract all products and calculate margins. The tool displays total revenue, total cost, total profit, and weighted average margin, along with a tier breakdown showing how many products fall into each margin category. A list of the top 5 highest-margin products is also shown. Click "Copy Results" to export the full product margin data to your clipboard.

HOW IT WORKS UNDER THE HOOD

The script uses a multi-strategy extraction approach to identify product tables across different platforms. It first attempts to locate product tables using selectors like table.product-table, .product-list, .price-list, and [data-testid="product-list"]. If those fail, it scans for any table containing product, price, cost, margin, or inventory keywords. The script intelligently identifies table headers and maps values to product name, selling price, and cost price. For products without explicitly listed cost prices, the script will still calculate margin if both price and cost are available. Gross margin is calculated as (selling price - cost) / selling price × 100, and markup is calculated as (selling price - cost) / cost × 100. Weighted average margin is calculated as total profit divided by total revenue. All calculations are performed locally and displayed with color-coded indicators based on your configured thresholds.

THE PANEL

The tool runs in the BotGentz panel, a draggable floating interface that stays on top of the page. You can drag the panel by its header, collapse it to a small bubble, and resize it. The panel remembers its position per site, so it stays where you left it when you return to your platform. Press Escape to close the panel when you are done. The panel includes settings for margin targets and tiers, a results section showing the margin summary and tier breakdown, and action buttons for scanning and copying.

PLEASE NOTE

This tool requires the free BotGentz extension to run. CRM and e-commerce platforms frequently update their interfaces — if the tool stops working, check for an updated version or report the issue. All data stays in your browser and is never sent to any external server. The tool works only on the current page; to analyze products from multiple pages, scan each page individually. The tool extracts visible data only and cannot access data not loaded on the current page. Margin calculations are estimates and should be verified against your organization's official accounting records. The tool does not modify your product data — it only reads and displays information.