hitec-shopify-automation
Hi-Tec Shopify Automation
Hi-Tec Bearings sells thousands of parts online, but its stock counts and costs lived in a different spreadsheet from the shop's product list, so matching them by hand took hours every cycle. These three tools do it: export the shop's spreadsheet, run a tool, and get back corrected quantities, costs, and the bearing sizes buried in product descriptions. A person reviews the result; the tools never touch the live store.
Solo work by Salman Adnan. Real client data was removed and replaced with a fabricated sample; end-to-end runs against the live Shopify store were done during the original 2023 engagement and not re-verified here.
Overview
Freelance automation tools for Hi-Tec Bearings that reconcile stock quantities, costs, and product specs by working directly on the CSV and XLSX files exported from the Shopify admin. Nothing here touches the Shopify API; a human review step sits in front of every catalogue change.
Key features
- A quantity and pricing updater that merges the internal stock list into a Shopify export, matching by title or variant value against HI-TEC brand rows and adding updated-quantity and updated-cost columns.
- A dimensions extractor that pulls bore, outside diameter, and width out of HTML descriptions into three columns for filterable metafields.
- A tkinter desktop app bundling both tools plus variant detection (parsing bearing designation suffixes into Bore, Cage, and Seal Type columns).
- CLI tools that run headless with file paths or open a file picker with no arguments.
- PyInstaller specs to ship the tools as Windows executables.
Results
Both command-line tools were verified against the sample data (the dimensions extractor recovers all three dimensions from the sample HTML), and the GUI was smoke-tested to the point of building its window.