In the SHOPLINE Admin, you export a variety of retail store reports, including Order Details, Transaction Lists, Transaction Details, and more. You can use the reports to review the store's operation, sales, and order status and strategize store operations
This article will explain how to use the Transaction Detail Report and describe the report fields.
1. Export Transaction Detail Report
Step 1
In the SHOPLINE Admin, go to [Report & Analytics] > [Report Export] > Retail Store and click Transction Detail Report.
Step 2
Select the transaction date range. You can customize the date range (up to 100 days) or select orders in the last 3 days, 7 days, and 30 days, then click the Export button.
[Coming Soon] Order history auto-archiving: The system supports exporting data from the past 2 years. Data earlier than 2 years will be automatically archived and cannot be selected on the data range.
For example: If today is 10 March 2024, you can view data as early as 10 March 2022. Orders from 9 March 2022 will be archived.
Step 3
The report will be sent to your mailbox. You can either download the report from your mailbox or from [Report and Analysis] > [Bulk Action Progress] in the SHOPLINE Admin.
*Note: The system may take a long time to export if the report data is large. Please consider shortening the date range to export the report more quickly. Before the report is exported, the same type of report will not be able to be exported. Please wait until the report export is completed. (The reports sharing the same type include Order Details Report, Transaction List, and Product Preorder Report).
2. Columns in the Transaction Detail Report
*Note: You can right-click the image and select Open Image in New Tab to enlarge and view the table above.
- Transaction number: Transaction number of order
- Transaction time: Transaction time of the order
- Product Type: Type of the product. For example, Product, Free Gift, etc.
- SKU: Product's SKU. If it is a product set, this field will display the SKU of all the products.
- Product: Product name
- Variation: Product variation. If it is a product set, this field will display all variations of the products.
- Quantity sold: The product quantity sold. If the product is returned or cancelled, the number will be displayed as negative.
- Product price: Product unit price; the number is always positive.
- Discount: The discount amount for this transaction. If the product is returned or cancelled, the number will be displayed as negative.
- Product price after discount: Quantity sold x Product price - Discount
- Order discount amount: The amount of the entire order discount.
- If you have enabled the rounding/rounding off feature, there will be (rounding/rounding off) after the number in this column.
- For free gift promotions, the discount amount will be 0.
- Please refer to [Coming Soon] All Regions Rounding Mechanism for more details.
*Note: You can right-click the image and select Open Image in New Tab to enlarge and view the table above.
| Service charge |
The service charge for this transaction. The number will be shown as negative in case of return or cancellation. Please refer to [Coming soon] POS tax settings for more details. *Note: This feature is currently only available on Android POS App. |
| Sale tax fee |
Sales tax for this transaction. The number will be shown as negative in case of return or cancellation. Please refer to [Coming soon] POS tax settings for more details. *Note: This feature is currently only available on Android POS App. |
| Payment fee |
Payment fee for this transaction. Please refer to the Payment option settings for all currencies for more details. *Note: This feature is only available for Hong Kong merchants. |
| Applied credit | The credits applied to the transaction. The number will be shown as negative in case of return or cancellation. |
| Applied member point | The amount redeemed by the member points to the transaction. The number will be shown as negative in case of return or cancellation. |
| Payment method |
The payment method and amount for this transaction. It will be shown as "Payment method: Payment amount," For example, "Cash: 100." |
| Payment amount |
The paid amount of this transaction. The number will be shown as negative in case of return or cancellation. |
| Order total |
The amount of the order. It can be divided into 2 types - general orders and returned/ cancelled orders. The number will be shown as negative in case of return or cancellation.
|
| Status |
The status of this transaction. The transaction status changes according to different operations, and new transaction records may be generated. For example, after you cancel a general order, the system will generate a new "cancel order transaction record," and there will be a transaction status for the record. The following is the transaction status of different types of orders under different operations. *Note: You can right-click the image and select Open Image in New Tab to enlarge and view the table above. |
| Note | The note of the transaction. |
| Store | The store that created the transaction. |
| Sales | The staff member handling the transaction. |
| Customer |
Customer of the transaction. |
| Customer email |
Customer's email. |
| Customer phone |
Customer's phone number. |
| Invoice number |
The invoice number and invoice status of the transaction. It can be divided into general orders and orders using SHOPLINE Payments. The invoice statuses of the two order types under different operations are as below: *Note: You can right-click the image and select Open Image in New Tab to enlarge and view the table above. |
Read more
- Product Preorder Report | POS Admin
- Customer Analysis Report | POS Admin
- Daily Payment Methods Report | POS Admin
Comments