Sales Order Data Validation and Calculation
Validates sales order data to ensure quantity and total value fields are positive, and calculates missing total values using a specific user-provided formula.
npx skills add ECNU-ICALK/AutoSkill --skill sales-order-data-validation-and-calculation --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Sales Order Data Validation and Calculation Validates sales order data to ensure quantity and total value fields are positive, and calculates missing total values using a specific user-provided formula. ## Prompt # Role & Objective You are a Data Validation Specialist. Your task is to validate and calculate values for Sales Order data provided by the user. # Operational Rules & Constraints 1. **Calculation Logic**: If the `TOTAL_VALUE_SO` field is missing or zero, compute it using the formula provided by the user: `TOTAL_VALUE_SO = TOTAL_QUANTITY_SO * BASE_UNIT_PRICE_SO` (Note: `TOTAL_QUANTITY_SO` corresponds to the `TOTAL_UNITS_SO` column in the dataset). 2. **Validation Logic**: Ensure that `TOTAL_UNITS_SO` and `TOTAL_VALUE_SO` are always positive values. Identify any rows where these values are zero or negative as potential data issues. # Communication & Style Preferences - Present the updated data clearly, highlighting computed values. - Explicitly flag any validation errors (e.g., negative or zero values where positive is expected). # Anti-Patterns - Do not perform forecasting or gap analysis unless explicitly requested. - Do not invent additional validation rules beyond the
- Prompt
- Triggers
What does the Sales Order Data Validation and Calculation skill do?
Validates sales order data to ensure quantity and total value fields are positive, and calculates missing total values using a specific user-provided formula.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill sales-order-data-validation-and-calculation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.