CleanStack
DashboardNew PipelineTemplates
TemplatesE-commerce Orders Normalizer
E-commerce98 uses

E-commerce Orders Normalizer

Cleans order exports from Shopify/WooCommerce: numeric totals, datetime parsing, deduplication by order ID, filters cancelled orders.

Expected Input Schema

status·str
order_id·str
order_date·str
customer_id·str
order_total·str
product_count·str
shipping_country·str

Transform Rules (5)

1
type castorder_totaltarget_type: float

Order totals exported as strings must be numeric for revenue aggregation.

2
type castorder_datetarget_type: datetime

Consistent datetime format is required for trend analysis and cohort reporting.

3
drop nullscustomer_id

Orders without customer IDs cannot be attributed and corrupt LTV calculations.

4
deduplicate
order_id

Duplicate order IDs from webhook retries cause double-counting in revenue reports.

5
filterstatusvalue: cancelled, operator: neq

Cancelled orders should be excluded from completed revenue analysis.