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.
Hi-Tec Bearings runs a Shopify store with thousands of product variants whose stock system and catalogue lived in separate spreadsheets, and keeping them in sync by hand took hours per cycle. The workflow is export, run a tool, review the output, re-import.
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.
Tech stack
A challenge worth noting
The stock list and the Shopify export do not share a key, and an item like 6205 can appear under different brands. The fix filters the stock list to the HI-TEC brand before matching, then joins on title for single-variant products and on the variant value for variants. Matching records without a shared key is mostly about picking the right disambiguator first.