Export Epos Now transaction items
Run automatically or manually
You can run this flow automatically on a schedule, for example every weekday at midnight, or choose to run it manually via our dashboard when you need it.
Fetch the transactions
The flow will fetch all transaction items from your Epos Now account ready for filtering
Target the transaction items that match your filters
You can specify which transactions this flow applies to. Works well with filters by location or location area.
See the customisations section later on this page for a full list of available filters.
Export the transactions
This is where you can specify what you want to export. Add as many columns as you like and you can even chain together actions for the same field.
See the customisations section later on this page for a full list of available actions.
Customisation
Learn more
Triggers are the events that start the flow.
For example, run at 6pm on Mondays, Wednesdays and Fridays.
Scheduler
Set your flow to run automatically at a specific time or interval. Choose from monthly, weekly, daily or hourly.
Manual Run
Run your flow manually using our dashboard. This is useful for testing your flow or running it on demand.
Filters allow you to apply the actions only to the objects that pass the filter criteria you specify.
For example, filter by the customer type or where the customer name contains certain characters.
Address Line 1
Address Line 2
Address Line1
Address Line1
Address Line1
Address Line1
Address Line2
Address Line2
Address Line2
Address Line2
Age Restriction
Amount
Amount
Amount
Amount
Amount
Amount
Amount Including Tax
Article Code
Article Code
Bar Tab Spend Limit
Barcode
Barcode
Basket Discount Portion
Basket Discount Portion Excluding Tax
Bin
Bottle Deposit Item I D
Brand I D
Brand I D
Brand Name
Business Name
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour Name
Can Access Back Office
Can Access Back Office
Can Access Misc Products
Can Access Misc Products
Can Access Table Plan
Can Access Table Plan
Can Access Till
Can Access Till
Can Access Till Admin Options
Can Access Till Admin Options
Can Accesss Customers
Can Accesss Customers
Can Adjust Float
Can Adjust Float
Can Apply Basket Discounts
Can Apply Basket Discounts
Can Apply Item Discounts
Can Apply Item Discounts
Can Change Tab Spend Amount
Can Change Tab Spend Amount
Can Clear Transaction
Can Clear Transaction
Can Delete Unordered Items
Can Delete Unordered Items
Can Disable Service Charge
Can Disable Service Charge
Can Edit Customer Points
Can Edit Customer Points
Can Hold Transaction
Can Hold Transaction
Can Manually Select Customer
Can Manually Select Customer
Can Order Allocation Server
Can Order Allocation Server
Can Order Allocation Table Manager
Can Order Allocation Table Manager
Can Order Allocation Team Server
Can Order Allocation Team Server
Can Receive Stock
Can Receive Stock
Can Refund Items
Can Refund Items
Can Remove From Table
Can Remove From Table
Can Run End Of Day
Can Run End Of Day
Can See End Of Day Report
Can See End Of Day Report
Can Send Stock
Can Send Stock
Can Server Baking
Can Server Baking
Can Stock Take
Can Stock Take
Can Tip Out Others
Can Tip Out Others
Can Tip Out Self
Can Tip Out Self
Can Unlock Device Via Pin
Can Unlock Device Via Pin
Can Unrestricted Stock Take
Can Unrestricted Stock Take
Can Use Number Sale
Can Use Number Sale
Can Use Payouts
Can Use Payouts
Can Use Petty Cash
Can Use Petty Cash
Can Void Items
Can Void Items
Card Number
Category I D
Category I D
Category I D
Category I D
Category I D
Category I D
Category Name
Change Given
Code
Colour I D
Colour I D
Colour Name
Contact Number
Contact Number
Contact Number
Contact Number2
Contact Number2
Contact Number2
Container Fee I D
Container Fee I D
Container Fee I D
Container Fee Name
Container Fee Value
Cost Price
Cost Price
Cost Price Ex Tax
Cost Price Excluding Tax
Cost Price Including Tax
Cost Price Measurement Scheme Item I D
Cost Price Measurement Scheme Item I D
Cost Price Measurement Unit Volume
Cost Price Measurement Unit Volume
Cost Price Tax Group I D
Cost Price Tax Group I D
Cost Price Tax Group Name
Country Name
County
County
County
County
County
Currency I D
Current Balance
Current Points
Customer Address I D
Customer I D
Customer I D
Customer Type I D
Customer Type Name
Date Format
Date Of Birth
Decimal Separator
Default Expiry Length
Default Max Credit
Default Percentage
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Detailed Description
Discount
Discount Amount
Discount Reason I D
Display Once Per Transaction
Eat Out Price
Eat Out Price
Eat Out Price
Eat Out Price Ex Tax
Eat Out Price Including Tax
Eat Out Price Tax Group I D
Eat Out Price Tax Group I D
Eat Out Price Tax Group Name
Email Address
Email Address
Email Address
Email Address
Email Address
End Date
Exclude From Loyalty Points Gain
Exclude From Loyalty Points Gain
Expiry Date
Forename
Group Separator
Has Swipe Card
Height
Hourly Rate
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
Image U R L
Is Admin On Till
Is Admin On Till
Is Archived
Is Cashback
Is Cost Price Including Tax
Is Cost Price Including Tax
Is Eat Out Price Including Tax
Is Eat Out Price Including Tax
Is Main Address
Is Main Address
Is Multiple Choice Product Optional
Is Sale Price Including Tax
Is Sale Price Including Tax
Is Tax Exempt
Is Tax Exemptable
Is Variable Price
Is Variable Price
Is Warehouse
Item Type
Item Type I D
Language I D
Last4
Line Item Type
Location Area I D
Location Area I D
Location I D
Location I D
Long Time Format
Main Image
Main Location I D
Margin
Max Basket Discount Amount
Max Basket Discount Amount
Max Basket Discount Percentage
Max Basket Discount Percentage
Max Credit
Max Customer Credit Limit
Max Customer Credit Limit
Max Item Discount Amount
Max Item Discount Amount
Max Item Discount Percentage
Max Item Discount Percentage
Max Refund Amount
Max Refund Amount
Measurement Scheme Item I D
Measurement Unit Volume
Multi Choice Note Name
Multiple Choice Items Child Product Ids
Multiple Choice Note I D
Multiple Choice Note I D
Multiple Choice Product I D
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Nominal Code
Nominal Code
Nominal Code
Nominal Code
Note
Notes
Notes
Number Of Bar Tabs
Number Of Top Sellers
Order Code
Order Code
Order Quantity Limit
Parent I D
Parent I D
Parent I D
Parent I D
Parent I D
Parent I D
Phone
Phone Number
Platform Fees
Popup Note I D
Popup Note I D
Popup Note Short Description
Pos X
Pos Y
Post Code
Post Code
Post Code
Post Code
Post Code
Predefined Locale Settings I D
Price I D
Print On Order
Print On Order
Print On Receipt
Product I D
Product I D
Product I D
Product Type
Product Type
Quantity
R R Price
Rate
Rate
Rate
Reference Code
Reference Code
Reference Code
Refund Reason I D
Reporting Category I D
Reporting Category I D
Reporting Category I D
Reporting Category I D
Return Items To Stock
Role I D
Rr Price
S K U
S K U
Sale Price
Sale Price
Sale Price
Sale Price Ex Tax
Sale Price Including Tax
Sale Price Measurement Scheme Item I D
Sale Price Measurement Unit Volume
Sale Price Tax Group I D
Sale Price Tax Group I D
Sale Price Tax Group Name
Scannable Only
Seating Area I D
Seating Area I D
Seats
Select Brands
Select Customer Addresses
Select Customer Addresses
Select Customer Types
Select Customers
Select Locations
Select Parent Categories
Select Product Categories
Select Products
Select Products Catalogue
Select Reporting Categories
Select Role
Select Role
Select Root Categories
Select Staff
Select Suppliers
Select Suppliers
Select the location area
Sell On Till
Sell On Till
Sell On Web
Sell On Web
Short Time Format
Show At All Locations
Show Bar Tabs
Show On Till
Show On Till
Show On Till
Show On Till
Show On Till
Sign Up Date
Sign Up Location I D
Size
Sort Position
Sort Position
Sort Position
Sort Position
Sort Position
Start Date
Supplier I D
Supplier I D
Supplier Name
Surname
Table I D
Tag Type I D
Tare Weight
Tare Weight
Tax Amount
Tax Exempt Eligible
Tax Group I D
Tax Rate I D
Tax Rate I D
Tender Type I D
Text
Till Order
Time Zone I D
Title
Town
Town
Town
Town
Town
Transaction Adjust Stock
Transaction Barcode
Transaction Customer I D
Transaction Date Time
Transaction Device
Transaction Device I D
Transaction Discount Reason I D
Transaction Discount Value
Transaction Gratuity
Transaction I D
Transaction I D
Transaction Is Transaction Including Tax
Transaction Non Discountable
Transaction Non Tax
Transaction Reference Code
Transaction Service Charge
Transaction Service Type
Transaction Staff I D
Transaction Status I D
Transaction Table I D
Transaction Total Amount
Type
Type
Type
Type
Unit Of Sale
Unit Of Sale
Unit Price
Unit Price Excluding Tax
Value
Value
Value
Value
Value
Value
Value
Value
Variant Description
Variant Group I D
Variant I D
Variant Item I D
Volume Of Sale
Volume Of Sale
Wet
Wet
Wet
Wet
Width
You can choose which columns you would like to be in the export.
You can change the column title to whatever you like and set the column order to match your export requirements.
For example, you can set the column title to “Customer Balance” and also apply transformations such as add 10%.
Address Line 1
Address Line 2
Address Line1
Address Line1
Address Line1
Address Line1
Address Line2
Address Line2
Address Line2
Address Line2
Age Restriction
Amount
Amount
Amount
Amount
Amount
Amount
Amount Including Tax
Article Code
Article Code
Bar Tab Spend Limit
Barcode
Barcode
Basket Discount Portion
Basket Discount Portion Excluding Tax
Bin
Bottle Deposit Item I D
Brand I D
Brand I D
Brand Name
Business Name
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour I D
Button Colour Name
Can Access Back Office
Can Access Back Office
Can Access Misc Products
Can Access Misc Products
Can Access Table Plan
Can Access Table Plan
Can Access Till
Can Access Till
Can Access Till Admin Options
Can Access Till Admin Options
Can Accesss Customers
Can Accesss Customers
Can Adjust Float
Can Adjust Float
Can Apply Basket Discounts
Can Apply Basket Discounts
Can Apply Item Discounts
Can Apply Item Discounts
Can Change Tab Spend Amount
Can Change Tab Spend Amount
Can Clear Transaction
Can Clear Transaction
Can Delete Unordered Items
Can Delete Unordered Items
Can Disable Service Charge
Can Disable Service Charge
Can Edit Customer Points
Can Edit Customer Points
Can Hold Transaction
Can Hold Transaction
Can Manually Select Customer
Can Manually Select Customer
Can Order Allocation Server
Can Order Allocation Server
Can Order Allocation Table Manager
Can Order Allocation Table Manager
Can Order Allocation Team Server
Can Order Allocation Team Server
Can Receive Stock
Can Receive Stock
Can Refund Items
Can Refund Items
Can Remove From Table
Can Remove From Table
Can Run End Of Day
Can Run End Of Day
Can See End Of Day Report
Can See End Of Day Report
Can Send Stock
Can Send Stock
Can Server Baking
Can Server Baking
Can Stock Take
Can Stock Take
Can Tip Out Others
Can Tip Out Others
Can Tip Out Self
Can Tip Out Self
Can Unlock Device Via Pin
Can Unlock Device Via Pin
Can Unrestricted Stock Take
Can Unrestricted Stock Take
Can Use Number Sale
Can Use Number Sale
Can Use Payouts
Can Use Payouts
Can Use Petty Cash
Can Use Petty Cash
Can Void Items
Can Void Items
Card Number
Category I D
Category I D
Category I D
Category I D
Category I D
Category I D
Category Name
Change Given
Code
Colour I D
Colour I D
Colour Name
Contact Number
Contact Number
Contact Number
Contact Number2
Contact Number2
Contact Number2
Container Fee I D
Container Fee I D
Container Fee I D
Container Fee Name
Container Fee Value
Cost Price
Cost Price
Cost Price Ex Tax
Cost Price Excluding Tax
Cost Price Factor
Cost Price Including Tax
Cost Price Measurement Scheme Item I D
Cost Price Measurement Scheme Item I D
Cost Price Measurement Unit Volume
Cost Price Measurement Unit Volume
Cost Price Tax Group I D
Cost Price Tax Group I D
Cost Price Tax Group Name
Cost Price Unit
Country Name
County
County
County
County
County
Currency I D
Current Balance
Current Points
Customer Address I D
Customer I D
Customer I D
Customer Type I D
Customer Type Name
Date Format
Date Of Birth
Decimal Separator
Default Expiry Length
Default Max Credit
Default Percentage
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Detailed Description
Discount
Discount Amount
Discount Reason I D
Display Once Per Transaction
Eat Out Price
Eat Out Price
Eat Out Price
Eat Out Price Ex Tax
Eat Out Price Including Tax
Eat Out Price Tax Group I D
Eat Out Price Tax Group I D
Eat Out Price Tax Group Name
Email Address
Email Address
Email Address
Email Address
Email Address
Exclude From Loyalty Points Gain
Exclude From Loyalty Points Gain
Expiry Date
Forename
Group Separator
Has Swipe Card
Height
Hourly Rate
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
I D
Image U R L
Is Admin On Till
Is Admin On Till
Is Archived
Is Cashback
Is Cost Price Including Tax
Is Cost Price Including Tax
Is Eat Out Price Including Tax
Is Eat Out Price Including Tax
Is Main Address
Is Main Address
Is Multiple Choice Product Optional
Is Sale Price Including Tax
Is Sale Price Including Tax
Is Tax Exempt
Is Tax Exemptable
Is Variable Price
Is Variable Price
Is Warehouse
Item Type
Item Type I D
Language I D
Last4
Line Item Type
Location Area I D
Location Area I D
Location I D
Location I D
Long Time Format
Main Image
Main Location I D
Margin
Max Basket Discount Amount
Max Basket Discount Amount
Max Basket Discount Percentage
Max Basket Discount Percentage
Max Credit
Max Customer Credit Limit
Max Customer Credit Limit
Max Item Discount Amount
Max Item Discount Amount
Max Item Discount Percentage
Max Item Discount Percentage
Max Refund Amount
Max Refund Amount
Measurement Scheme Item I D
Measurement Unit Volume
Multi Choice Note Name
Multiple Choice Items Child Product Ids
Multiple Choice Note I D
Multiple Choice Note I D
Multiple Choice Product I D
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Nominal Code
Nominal Code
Nominal Code
Nominal Code
Note
Notes
Notes
Number Of Bar Tabs
Number Of Top Sellers
Order Code
Order Code
Order Quantity Limit
Parent I D
Parent I D
Parent I D
Parent I D
Parent I D
Parent I D
Phone
Phone Number
Platform Fees
Popup Note I D
Popup Note I D
Popup Note Short Description
Pos X
Pos Y
Post Code
Post Code
Post Code
Post Code
Post Code
Predefined Locale Settings I D
Price I D
Print On Order
Print On Order
Print On Order
Print On Order
Print On Receipt
Print On Receipt
Print On Receipt
Product I D
Product I D
Product I D
Product Type
Product Type
Quantity
R R Price
Rate
Rate
Rate
Reference Code
Reference Code
Reference Code
Refund Reason I D
Reporting Category I D
Reporting Category I D
Reporting Category I D
Reporting Category I D
Return Items To Stock
Role I D
Rr Price
S K U
S K U
Sale Price
Sale Price
Sale Price
Sale Price Ex Tax
Sale Price Factor
Sale Price Including Tax
Sale Price Measurement Scheme Item I D
Sale Price Measurement Unit Volume
Sale Price Tax Group I D
Sale Price Tax Group I D
Sale Price Tax Group Name
Sale Price Unit
Scannable Only
Seating Area I D
Seating Area I D
Seats
Select the location area
Sell On Till
Sell On Till
Sell On Web
Sell On Web
Short Time Format
Show At All Locations
Show Bar Tabs
Show On Till
Show On Till
Show On Till
Show On Till
Show On Till
Show On Till
Show On Till
Sign Up Date
Sign Up Location I D
Size
Sort Position
Sort Position
Sort Position
Sort Position
Sort Position
Supplier I D
Supplier I D
Supplier Name
Surname
Table I D
Tag Type I D
Tare Weight
Tare Weight
Tax Amount
Tax Exempt Eligible
Tax Group I D
Tax Rate I D
Tax Rate I D
Tender Type I D
Text
Till Order
Time Zone I D
Title
Town
Town
Town
Town
Town
Transaction Adjust Stock
Transaction Barcode
Transaction Customer I D
Transaction Date Time
Transaction Device
Transaction Device I D
Transaction Discount Reason I D
Transaction Discount Value
Transaction Gratuity
Transaction I D
Transaction I D
Transaction Is Transaction Including Tax
Transaction Non Discountable
Transaction Non Tax
Transaction Reference Code
Transaction Service Charge
Transaction Service Type
Transaction Staff I D
Transaction Status I D
Transaction Table I D
Transaction Total Amount
Type
Type
Type
Type
Unit Of Sale
Unit Of Sale
Unit Price
Unit Price Excluding Tax
Value
Value
Value
Value
Value
Value
Value
Value
Value
Value
Variant Description
Variant Group I D
Variant I D
Variant Item I D
Volume Of Sale
Volume Of Sale
Wet
Wet
Wet
Wet
Width