Overview

unifiprice.py is a standalone Python utility that fetches current pricing data for Ubiquiti UniFi devices directly from the store’s Next.js JSON endpoints and compiles it into an Excel workbook. Each device category (“Switching”, “Access Points”) is written to its own worksheet, with prices formatted in USD and static column widths. The output filename is timestamped so each run produces a uniquely‑named file.

Features

• Zero‑browser, JSON‑driven
  Leverages Next.js’s _next/data/{buildId}/…json endpoints—no Selenium or headless browser required.

• Multi‑sheet workbook
  Each category slug maps to a human‑readable sheet tab (Switching, Access Points, etc.).

• Currency formatting & column sizing
  Column C (“PRICE (USD)”) is formatted as $#,##0.00, with columns A, B, C fixed at widths 45, 40, and 15.

• Timestamped exports
  Output files named unifi_pricing_MM-DD-YYYY_HH-MM.xlsx for unambiguous versioning.

Requirements

• Python 3.7+
• pip (or your preferred environment manager)

Installation

git clone https://github.com/SebastianLester/UnifiPriceExtractor.git
cd Unifi-Store-Price-Extractor
pip install requests pandas XlsxWriter