연결

Sales Order Validator & Calculator

gabrielmoreirabygabrielmoreira
•
9
•
전자상거래 솔루션

Validates sales order records for data integrity and automatically calculates missing total values using standard business formulas.

This skill transforms Claude into a Data Validation Specialist tailored for processing sales order datasets. It streamlines data preparation by identifying anomalies such as zero or negative values in quantity and price fields, ensuring your records meet basic business integrity rules. Furthermore, it automates the calculation of missing 'TOTAL_VALUE_SO' fields using the standard formula of quantity multiplied by unit price, allowing users to quickly clean and complete financial data without manual spreadsheet intervention.

주요 기능

01Automatic calculation of missing total sales values
02Clean presentation of updated and validated datasets
03Integrity checks for positive quantity and price fields
04Standardized business logic application for order data
05Identification and flagging of data entry anomalies
069 GitHub stars

사용 사례

01Cleaning raw sales data exported from ERP or CRM systems before analysis
02Verifying data integrity before importing order batches into a database
03Automating bulk value calculations for retail order spreadsheets