The total_price field represents the amount paid by the customer when placing the order. This value is calculated after applying discounts, shipping costs, taxes, and tips. It reflects the finalized total at the time of purchase.
How Does total_price Differ from current_total_price?
In addition to total_price, WorkMagic also tracks current_total_price, which is the adjusted paid amount that reflects any subsequent changes to the order, such as:
Edits to the order (e.g., item changes or price adjustments).
Returns that reduce the total purchase amount.
Refunds issued to the customer.
Key Rule for Managing Refunds and Edits
In the case of a refund, you only need to update the
current_total_price.There’s no need to modify the
total_pricesince it represents the original transaction value before any adjustments.
Best Practices for Managing Pricing Data
Ensure Accurate Data Flow: Always submit both total_price and current_total_price to provide a clear view of original sales and adjusted amounts.
Use current_total_price for Revenue Analysis: This ensures your reporting reflects the most up-to-date financial data.