Email the day’s refunded items from Lightspeed Retail (X-Series)
Receive a daily report of the day’s returned items at 8pm, with staff, outlet, receipt details and available item values. No email is sent when there are no matches.
What this template is ready to do.
Email managers the day’s refunded items from Lightspeed Retail (X-Series), with no minimum refund value. This ready-to-use template checks closed sales at 20:00 in the user’s timezone and selects only items explicitly marked as returns. New purchases on the same sale are excluded.
The date filters cover the start and end of the current calendar day. The report contains sales available when it runs; items entered after 20:00 are outside that evening’s report. Choose a later send time if your working day ends later.
The 16-column CSV includes sale date and time, sale and receipt references, original sale reference where available, staff, outlet, register, product, SKU, quantity, item totals excluding and including tax, line tax, return reason, item notes and net sale total.
The email includes a table of up to 100 matching items and the CSV contains the full report. No email is sent when there are no matching items. Add your managers’ email addresses and customise the subject and message before using the flow.
Return reasons may be blank when not recorded. Return-marked adjustment lines can have positive values; values retain the source signs. Manually entered negative items without the return flag are excluded. Net sale totals repeat on each item row and must not be summed across item rows.
- Uses
- Lsx Line Items
- Definition
- 4 dashboard stages
- Run control
- Manual or scheduled
Defaults: daily at 20:00, From/To set to the day’s local boundaries, closed sales only, item Is Return set to Yes, and no value threshold. The template timezone is blank so a customer copy can use the user’s timezone. The only configured trigger is the schedule.
You can narrow the report by outlet or staff and choose additional filters where supported by your connection. This is an end-of-day report, not an instant notification. Test the selected reporting period and recipients before enabling your copy.
The dashboard definition, from trigger to finished export.
Every stage below comes directly from this template in the Slynk dashboard.
- 01trigger
Run daily at 8pm
Run at 20:00 in the user’s timezone. Change this to your end-of-day time.
- 02fetch
Read the day’s sale items
Fetch sales using the From and To date filters and read their individual items.
- 03filter
Select returned items from closed sales
Include only items marked as returns. No value threshold applies, and new purchases on the same sale are excluded.
- 04action
Email the refund report
Email the matching items and CSV to your configured recipients. Skip the email when no items match.
A recurring data delivery needs to be reliable.
- You need lsx line items outside the POS regularly.
- The recipient needs selected, renamed or joined fields rather than a basic export.
- The result should run manually or arrive on a dependable schedule.
- Product
- Flow
- What it does
- Export data
- POS platform
- Lightspeed Series X
- Uses
- Lsx Line Items
- Starting point
- Ready to adapt
Start here. Make it fit the business.
This is the list of triggers, filters and export columns available for this exact template. Learn how customisation works.
Choose what starts the workflow
Triggers are the events that start this template. Use a dependable schedule or keep control with a manual run.
Scheduler
Run automatically at a specific time or interval: monthly, weekly, daily or hourly.
Manual run
Start the template from the dashboard for testing or whenever it is needed on demand.
Fields you can filter on
Use one or more conditions to target only the records that matter. Related POS information is available without building a separate integration.
Browse all 479 fields by POS data group.
Attributes4 fields
Brands10 fields
Customer Groups8 fields
Customers49 fields
Customization Files4 fields
Ecom Custom Charges5 fields
Global Payment Types14 fields
Image Sizes14 fields
Images6 fields
Line Item Customizations4 fields
Line Item Promotions5 fields
Line Item Surcharges1 field
Line Items19 fields
Other POS data72 fields
Outlets20 fields
Payment External Applications4 fields
Payment External Attributes3 fields
Payment Surcharges2 fields
Payment Types11 fields
Product Attributes2 fields
Product Categories6 fields
Product Category Path Items6 fields
Product Codes3 fields
Product Outlet Taxes2 fields
Product Packages8 fields
Product Suppliers6 fields
Product Types5 fields
Products56 fields
Rate Rules3 fields
Registers24 fields
Sale Adjustments3 fields
Sale External Applications5 fields
Sale Tax Components8 fields
Supplier Contacts23 fields
Suppliers7 fields
Tags8 fields
Tax Rates4 fields
Taxes8 fields
User Images7 fields
User MFA Factors3 fields
User Roles3 fields
Users21 fields
Variant Options3 fields
Columns you can export
Select the POS fields that should appear in the output, then rename, order and format the columns for the destination.
Browse all 466 fields by POS data group.
Attributes4 fields
Brands10 fields
Customer Groups8 fields
Customers49 fields
Customization Files4 fields
Ecom Custom Charges5 fields
Global Payment Types15 fields
Image Sizes14 fields
Images6 fields
Line Item Customizations4 fields
Line Item Promotions5 fields
Line Item Surcharges1 field
Line Items20 fields
Other POS data54 fields
Outlets20 fields
Payment External Applications4 fields
Payment External Attributes3 fields
Payment Surcharges2 fields
Payment Types12 fields
Product Attributes2 fields
Product Categories6 fields
Product Category Path Items6 fields
Product Codes3 fields
Product Outlet Taxes2 fields
Product Packages8 fields
Product Suppliers6 fields
Product Types5 fields
Products56 fields
Rate Rules3 fields
Registers24 fields
Sale Adjustments3 fields
Sale External Applications5 fields
Sale Tax Components8 fields
Supplier Contacts23 fields
Suppliers7 fields
Tags8 fields
Tax Rates4 fields
Taxes8 fields
User Images7 fields
User MFA Factors3 fields
User Roles3 fields
Users23 fields
Variant Options3 fields
Use the same starting point for these dashboard-published outcomes.
- 01
Review the day’s refunded items
- 02
Check returns by staff and outlet
- 03
Investigate recorded return reasons and item notes
Know what happens before the first run.
More lsx line items jobs to explore.
Export Epos Now Transactions
Start with a blank template to fetch and export Epos Now Transactions. Add filters and choose the fields you want to export.
View templateExport Epos Now Transaction Items
Start with a blank template to fetch and export Epos Now Transaction Items. Add filters and choose the fields you want to export.
View templateExport Epos Now Tabs
Start with a blank template to fetch and export Epos Now Tabs. Add filters and choose the fields you want to export.
View templateMake this delivery automatic.
Choose a Flow plan to start from this template, then tailor the fields, schedule and delivery.
