All work
AI & Automation
SCM Data-Migration Tooling
Python/Excel/Google Sheets tooling to import sector stock and vendor masters into SCM PostgreSQL.
- Client
- People's Poultry & Hatchery Limited
- Stack
- 4
- Screens
- 3
Problem / Context
SCM needed bulk import of sector stock quantities and vendor/product categories from spreadsheets.
What it does
- Generate per-sector Excel templates from SCM masters
- Extract/verify/import stock CSVs (dry-run matching, skip analysis)
- Vendor product-category dropdown generator for Google Sheets (650 vendors, 22 categories)
Engineering notes
Python, openpyxl/pandas, PostgreSQL, Google Sheets/Apps Script, Laravel artisan import commands.
Outcome / Value
ERP data-migration/import tooling and Google Sheets automation.
Screens
