I will validate your order CSV and create a clear summary report
Ecommerce Web Developer and Conversion Specialist
About this Gig
Your export is messy. You need to know which rows are usable and why the rest fail.
WHAT YOU SEND ME
A CSV with these seven columns, spelled exactly:
order_id, customer, amount, currency, status, region, created_at
Column order does not matter; names are case-sensitive. Up to 20 columns; extras are not carried over.
WHAT YOU RECEIVE
Three files, never a cleaned copy of your CSV:
- report.json totals, breakdowns, and each rejected row's exact reason
- summary.md the same numbers, formatted to read
- run.log step-by-step log with file hashes and timings
Your original file is read and checked, never rewritten.
WHAT IS NOT INCLUDED
A cleaned or corrected CSV. Live exchange rates: conversion uses a fixed table (USD, MYR, SGD, EUR), not live data. Extra output columns. Scheduled or hosted runs. Custom validation rules.
TESTED, NOT ESTIMATED
Synthetic test: 500 rows, 20 columns, 20 broken rows 480 accepted, 20 rejected, exit code 0. Synthetic data, not a client file.
BEFORE YOU ORDER
Basic: 500 data rows, 20 columns max. USD 50, 3 days, 1 revision. Larger files: message first; scope may be declined, never auto-accepted.
My Portfolio
FAQ
What exactly do I get?
You receive report.json, summary.md and run.log. These contain validation results, totals, breakdowns, rejection reasons and execution information. A cleaned CSV is not included.
What columns are required?
Your CSV must contain order_id, customer, amount, currency, status, region and created_at. Column names are case-sensitive, but their order does not matter.
Which currencies are supported?
USD, MYR, SGD and EUR. Conversion uses fixed rates, not live exchange rates.
How much data is included?
Basic supports up to 500 data rows and 20 input columns.
What happens to invalid rows?
Rejected rows are reported with their line numbers and validation reasons. They are excluded from accepted-row totals.
Can you provide scheduled automation or database integration?
Not in this Basic package. It covers a single CSV validation and reporting run.
