Inventory Data Consolidation & Cleanup
Budget: $10 – $30 USD
We need support in organizing and standardizing our inventory records. At present, product lists are spread across multiple spreadsheets and export files, making it difficult to track accurate stock levels and prepare purchase orders efficiently.
Your Responsibilities:
Consolidate all provided inventory files (CSV and XLSX) into one master workbook.
Remove duplicate entries.
Standardize column labels based on a naming convention guide we will provide.
Flag and document any discrepancies, anomalies, or missing data for review.
Deliverables:
A clean, well-structured master workbook (Google Sheets or Excel) containing:
Active Items (in stock)
Low Stock Items
Discontinued Items
A Notes tab summarizing discrepancies and any issues requiring clarification.
Key Requirements:
Accuracy and consistency are the top priorities.
Attention to detail in spotting errors or irregularities.
Once you’ve reviewed a sample file, please confirm your preferred tool (Google Sheets or Excel) and provide an estimated completion time
Your Responsibilities:
Consolidate all provided inventory files (CSV and XLSX) into one master workbook.
Remove duplicate entries.
Standardize column labels based on a naming convention guide we will provide.
Flag and document any discrepancies, anomalies, or missing data for review.
Deliverables:
A clean, well-structured master workbook (Google Sheets or Excel) containing:
Active Items (in stock)
Low Stock Items
Discontinued Items
A Notes tab summarizing discrepancies and any issues requiring clarification.
Key Requirements:
Accuracy and consistency are the top priorities.
Attention to detail in spotting errors or irregularities.
Once you’ve reviewed a sample file, please confirm your preferred tool (Google Sheets or Excel) and provide an estimated completion time