Sprusify
Get started

Appendix

Use this section as a quick reference for terminology, export columns, and repeatable operations.

Common Export Fields

  • affiliate_id: unique affiliate identifier.
  • affiliate_email: affiliate account email.
  • order_id: source platform order identifier.
  • click_id: click event identifier (if available).
  • gross_amount: attributed gross amount before reversals.
  • refund_amount: total refunded amount tied to the conversion.
  • net_amount: gross amount minus refunds/adjustments.
  • commission_amount: credited or adjusted affiliate earning amount.
  • payout_status: pending, approved, or paid.
  • payout_date: timestamp when payout was issued.

Glossary

  • Click: tracked visit from an affiliate referral.
  • Conversion: order attributed to an affiliate.
  • Attribution window: period where a click remains eligible for credit.
  • Pending earnings: earnings not yet payout-eligible.
  • Approved earnings: payout-eligible earnings.
  • Reversal: negative adjustment due to refund, dispute, or policy violation.

Operational Recipes

Launch a Campaign

  1. Define campaign dates and commission model.
  2. Add product or collection-level rules.
  3. Invite affiliates and share approved assets.
  4. Validate test conversions before public promotion.

Monthly Payout Reconciliation

  1. Export payout and transaction data.
  2. Match order IDs and affiliate IDs to source records.
  3. Apply refunds and approved adjustments.
  4. Mark finalized entries as paid.

Developer Checklist

  • Include affiliate and order identifiers in event logs.
  • Verify webhook signatures before processing.
  • Use idempotent handlers for all order and payout events.
  • Keep UTC timestamps across API and export surfaces.