Shipment Tracker
Shipment
Customer Orders
Order
Leadtek GPU Pricer
Quote
ASUS Quote Tool
Quote — Package A
Sapphire GPU Pricer
Quote
ASUS VGA Pricer
Quote
Stock Overview
Admin Dashboard
Master Inventory & Cost
Upload your daily Master Inventory file. This updates stock and cost for ASUS, Leadtek, and Sapphire simultaneously.
ℹ Format
Columns: Brand · Item No · Description · Memory (optional) · In Stock · Committed · Ordered · Available · Cost
Brand values: asus · leadtek · sapphire (case insensitive)
Vendor Pricelists
Upload new pricing structures when vendors release them.
ASUS SDP Pricelist
Filename must contain "asus" and "sdp"
ℹ Format
Columns: … · … · … · Segment · AC-Item No · Description · … · SDP · SRP
Col F = AC- item no, Col G = desc, Col I = SDP, Col J = SRP
ASUS Config (PWP & Rebates)
Filename must contain "asus" and "config"
ℹ Format
Sheet "Rebates": Package · Platform · Chipset Group · Min Qty · Rebate
Sheet "CPU Rebates": Platform · Chipset · Rebate · Exception Item No · Exception Rebate
ASUS VGA Pricelist
Filename must contain "asus", "vga" and "pricelist"
ℹ Format
Header row must contain: Model Name · P/N · Product positioning · FOB · SDP · SRP
ASUS VGA Promo
Filename must contain "asus", "vga" and "promo"
ℹ Format
P/N (or "pn" / "item no") · Promo SDP (or "promo" / "price")
Sapphire GPU Pricelist
Filename must contain "sapphire"
ℹ Format
Category markers in col A: "Graphic Cards" · "Motherboard"
Series markers in col A: "Item No." (col B = series name)
Product rows: Col A = SAP-xxx · Col B = Description · Col C = SDP · Col D = Promo SDP
Leadtek FOB Pricelist
Filename must contain "pricelist" or "fob"
ℹ Format
Cell G1: FX rate (e.g. 4.07)
Columns: Model · Type · PN · (blank) · New FCA · (blank) · MOQ · Landed · Brightstar · GMC · Lowest · SDP · (blank) · MSRP · … · ACC (col S)
Optional sheet "Channel Config": display_order · name · field_name · margin_pct · show_customer (yes/no) · show_internal (no=hide) · min_margin_pct
Sales Dashboard Data
Filename must contain "sales"
ℹ Format
Columns: Month · Group Code · Product · Emp Code · Emp Name · Quantity · Sales Amt · Gross Profit · GP%
Month format: april'26 · may'26 etc.
Product values: ASUS-COMP · LEADTEK · SAPPHIRE · CPU
ASUS MB — Package Margins
Margin % used to compute cost-based prices (Package A/B/C × chipset group). Edit a value and press Enter or click away to save.
ASUS MB — Promo Rebates
On-top promo rebates shown in the quote summary. Filter by chipset group and/or platform (blank = applies to all).
Sales Targets
Edit targets per product/region for any month. Changes save immediately to the database.
Recent Uploads
Last 20 file uploads across all types.