Sprusify

Appendix

This appendix contains reference material merchants and developers will find useful when operating Sprusify: export column definitions, a short glossary of terms, and a few quick recipes for common tasks.

Export fields

  • affiliate_id: internal identifier for the affiliate account.
  • affiliate_email: email address associated with the affiliate.
  • clicks: total recorded clicks for the time window.
  • conversions: attributed orders credited to the affiliate.
  • gross_revenue: revenue before refunds and fees for attributed conversions.
  • refunds: total refunded amount associated with attributed orders.
  • net_amount: gross revenue minus refunds and fees.
  • payout_status: pending, approved, paid.
  • payout_date: date the payout was issued.

Glossary (quick)

  • Click: a recorded visit from an affiliate link.
  • Conversion: an order attributed to an affiliate.
  • Referral window: how long a click remains eligible for attribution.
  • Cookie/coupon matching: the primary attribution mechanisms.
  • Chargeback/Refund: adjustments that reduce affiliate earnings.

Quick recipes

  • Create a Black Friday campaign: set campaign dates, set commission %, exclude low-margin SKUs, notify affiliates via email template.
  • Reconcile payouts: export payout CSV, match order_id and affiliate_id, apply refunds and adjustments, then mark payouts as paid.

Notes for developers

  • Include affiliate_id and order_id in all logs for traceability. Maintain an audit table for manual adjustments and disputes.

If you need more fields exported or a custom CSV format, use the API or contact support to request a schema extension. Quick references

  • Sample tracking link: https://yourstore.com/?aff=AFFILIATE_ID
  • Example webhook event: order.created with order and affiliate metadata.

Admin shortcuts

  • Export transactions: Admin > Transactions > Export CSV.
  • Re-run attribution on an order: Admin > Orders > Select order > Recalculate attribution.

Developer notes

  • Webhook signature: verify using the X-Spru-Signature header and your app secret.
  • API rate limits: keep calls under 5 requests/sec for standard plans.