Inventory Google Sheets Setup

Заказчик: AI | Опубликовано: 19.11.2025

Google Sheet Experts - Freelancer "Google Sheets Expert" + "Inventory Management" "Google Apps Script Developer" "Spreadsheet Automation Specialist" "Inventory Management System Developer" "ERPNext Consultant" (with Google Sheets skills) "MIS Executive" or "MIS Analyst" (with advanced Excel/Google Sheets) Essential Skills to Look For: Technical Skills (Must-Have): Advanced Google Sheets: Complex formulas (VLOOKUP, INDEX-MATCH, QUERY, FILTER, ARRAYFORMULA) Data validation and dependent dropdowns Named ranges Conditional formatting Pivot tables and reporting Google Apps Script: Custom functions Automated triggers User forms and dialogs Data manipulation across sheets API integration capabilities Database Design: Relational data structure understanding Normalization principles SKU coding systems Domain Knowledge (Important): Inventory Management: GRN (Goods Receipt Note) processes Inward/Outward registers Stock reconciliation FIFO/LIFO methods Bin location management Manufacturing/Engineering Products: Understanding of product specifications Multi-attribute item coding BOM (Bill of Materials) concepts Integration Skills (Desirable): ERPNext Knowledge: ERPNext API understanding Data import/export formats Integration workflows