সব কাজ
AI ও অটোমেশন
SCM Data-Migration Tooling
Python/Excel/Google Sheets tooling to import sector stock and vendor masters into SCM PostgreSQL.
- ক্লায়েন্ট
- People's Poultry & Hatchery Limited
- স্ট্যাক
- 4
- স্ক্রিন
- 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.
স্ক্রিনশট
