I will reconcile your shopify and amazon sales data

Bangladesh

I speak Bengali, English

Shopify and Amazon Reconciliation, Accurate SQL Queries, Views and Procedures

Founder of QueryForge Studio. I reconcile Shopify, Etsy, Amazon, and WooCommerce sales data into clean, profit-by-product reports — catching price and fee mismatches most sellers never check for. I...
About this Gig

Your Shopify and Amazon dashboards don't agree on what a sale is actually 

worth and most sellers never check why.


I reconcile Shopify and Amazon sales data directly against each other, 

order by order. Matching is deterministic where order IDs line up, fuzzy-

matched by date and amount where they don't, with duplicates flagged and 

excluded before anything is totaled.


Every order is classified into one of six outcomes: cleanly reconciled, 

price mismatch, fee deviation, probable match needing review, unmatched on 

Shopify, or unmatched on Amazon so you know exactly what was found.


What you get:

- A clean report showing every order's match status

- Price and fee deviations flagged clearly, not buried

- Duplicate orders caught and excluded, never double-counted

- A plain-English summary of what the numbers show


Every estimated value is labeled as an estimate, never presented as fact. 

Flagged items get a manual spot-check before delivery.


Background: 20+ years of hands-on SQL experience in banking payment 

systems (cheque clearing, EFT, RTGS), development side. That same 

discipline now applies to your e-commerce data.


Fast, honest turnaround. No unnecessary complexity.

Technology:

Excel

Google Sheets

Other

Analysis type:

Quantitative analysis

Descriptive analysis

Expertise:

Business Insights

Anomaly detection

Financial ratios

Programming language:

SQL

Tools:

Microsoft Excel

Other