Available Columns
Violet allows you to export financial transactions, from the point of order through payment processing, to eventual payout, with a detailed breakdown of fees, commissions, and other financial metrics related to orders and their components. This page provides details on the columns you are able to export.
The Distributions section outlines the specifics of the split of payments, including refunds, for a given bag in an order. This is the most granular level of financial data available to you, since you're able to see how much commission was received by a specific merchant in a single order. Each record has a unique ID, a creation date, an amount that could be positive (for payments) or negative (for refunds), the currency used, and the type of transaction.
Payment Gateway details involve the mechanics behind processing payments through our payments provider, Stripe. It includes the service name, total fees (which are a sum of fixed and volume-based fees), and an external transaction ID for tracking purposes.
Payouts are the top level funds receieved in your bank account via Stripe, for a collection of Orders. Key information such as the payout ID, date, and amount are initially null until the transfer initiates. It also specifies whether the payout is for a merchant or a channel.
Order and Bags sections are about the sales transactions. Orders are identified by an ID and have a total value, which gets replicated in associated distributions for multi-bag orders. Bags carry detailed information about the sale, including ID, merchant details, commission rates, totals for various calculations (subtotals, taxes, shipping, discounts), and a refund ID if applicable.
Distributions
Distribution ID
distribution_id
id
The id of the Distribution record
Distribution Date Created
distribution_date_created
date_created
The date the Distribution record was created
Distribution Amount
distribution_amount
amount
The amount of the Distribution. Can be positive or negative based on type.
Distribution Currency
distribution_currency
currency
The currency of the Distribution.
Distribution Type
distribution_type
type
The type of the Distribution. Can be of type PAYMENT or REFUND
Payment Gateway
Payment Service
payment_service
payment_service
The payment gateway provider (e.g. Stripe, Nuvei, etc.)
Payment Service Total Fee
payment_service_total_fee
payment_service_total_fee
The total fee is equal to the fixed fee plus the volume fee
Payment Service Fixed Fee
payment_service_fixed_fee
payment_service_fixed_fee
The fixed fee of the charge. Depends on the gateway fee and number of bags in an order. (e.g. Stripe fixed fee on single bag order is $0.30)
Payment Service Volume Fee
payment_service_volume_fee
payment_service_volume_fee
The volume fee of the charge. Depends on the gateway percentage taken and total cost of the bag. (e.g. Stripe volume fee on a $10.00 bag would be $0.29)
External Transaction ID
payment_service_external_transaction_id
external_transaction_id
The id of the charge in the external payment gateway
Payouts
A payout is generated when money begins to transfer to your bank account. Before that happens the id, date, and amount fields on a distribution record will be null.
Payout ID
payout_id
payout_id
The ID of the Payout that the distribution is associated with.
Payout Date
payout_date
payout_date
The date the Payout was created.
Payout Amount
payout_amount
payout_amount
The amount of the payout. This is the amount that will be seen transferred into your bank account. In the export, this amount will be duplicated on each associated distribution.
Payout Account Type
payout_account_type
payout_account_type
This determines whether the Payout was to a merchant or a channel.
Order
Order ID
order_id
order_id
The ID of the Order that the distribution is associated with.
Order Total
order_total
order_total
The total of the Order. In multi-bag orders, this amount will be duplicated on each associated distribution.
Bags
Bag ID
bag_id
bag_id
The ID of the Bag the distribution is associated with.
Merchant ID
bag_merchant_id
merchant_id
The ID of the Merchant on the Bag
Merchant Name
bag_merchant_name
merchant_name
The name of the Merchant
Merchant Commission Rate
bag_merchant_commission_rate
merchant_commission_rate
The commission rate the Channel will receive from the Merchant sale
Bag Total
bag_total
bag_total
The total of the Bag
Bag Sub Total
bag_subtotal
bag_sub_total
The subtotal of the Bag before tax, shipping, and discounts
Bag Tax Total
bag_tax_total
bag_tax_total
The tax of the Bag. Tax is calculated after discounts, before shipping.
Bag Shipping Total
bag_shipping_total
bag_shipping_total
The shipping total of the Bag.
Bag Discount Total
bag_discount_total
bag_discount_total
The discount amount of the Bag, comes from the subtotal. (e.g. 10% off $50, would show $5.00) in this field.
Refund ID
refund_id
refund_id
If the distribution is a refund, this is the ID that can be used to get refund data from the API
Last updated
Was this helpful?