Data Hierarchy
Within Vrio there is a hierarchy of data mapping. This allows flexibility for the end user to setup their program custom to them, without implementing custom dev or workarounds.
Data Layer | Description |
---|---|
Customer | Highest Level of the data hierarchy. |
Order | An Order is a record that ties the Customer to the goods/services (Items) that they purchased and the billing schedule (Offer) those Items are sold for. |
Sale | A sale is a record tied to the Order. Each billing cycle will have a unique Sale. A sale can contain multiple transactions (attempts if it is declined and child transactions of Refunds, Voids, Alerts and Chargebacks). |
Order Offer - Line Item | An Order Offer is the individual line item that details the specific [Item+ Offer] combination purchased. |
Transaction | A Transaction is the overall payment transaction of the Sale. |
Shipment | Item(s) being shipped to the customer. |
FAQ
What does the customer purchase as configured in the UX?
A: The customer is purchasing an Item + Offer for a Specific Campaign.
How do I make a subscription?
A: A subscription differs from other types of Offers because it schedules future payment attempts and shipments. The Offer type is recurring.
How do I create a shipment for successful sales?
A: The item must be set to "is shippable." Anytime this Item is contained on a sale, it will create a shipment automatically when the payment is successful. The shipment can be sent directly to third party systems (i.e Shipstation) per our integration or can be managed manually within the UX.
How do I manage a payment attempt that failed?
A: Initial declines may be reattempted through the Payment Router settings. Ongoing decline reattempts for subscriptions is managed through Dunning Profiles. The dunning profile is a UX tool that lets you configure how often to retry a failed payment for a Sale. The process can retry the full amount or a discounted amount. Additionally, you can use a third party dunning connection.
What records are created for a customer?
A: The Customer, Order, Sale, Transaction, Shipment and Subscription (if applicable) are created at the same time on the first Sale of the Order. If the Order contains a Subscription, then each renewal will create a Sale, Transaction and Shipment.
Why does an Order have more than one Sale?
A: The Order contains a product that is on a subscription. Each subscription renewal will create a Sale, then attempt payment collection by creating a transaction.
Why does a Sale have more than one Transaction?
A: The Sale will have multiple transactions if the first payment attempt is unsuccessful. Each new payment attempt will create a new transaction. Additionally, a Sale will have more than one transaction if a refund, alert and/or dispute are applied against a payment.
Updated 13 days ago