Export Epos Now transaction items
This flow template gives you a good starting point and you can customise it as needed.
Send us an enquiry or book in a call, whatever suits you best.
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.
Transactions Item Cost Price
Transactions Item Discount Amount
Transactions Item Discount Reason Id
Transactions EndDate (Filter)
Transactions Item Id
Transactions Item Is Tax Exempt
Transactions Item Multiple Choice Product Id
Transactions Item Notes
Transactions Item Parent Id
Transactions Item Print On Order
Transactions Item Product Id
Transactions Item Quantity
Transactions Item Refund Reason Id
Transactions StartDate (Filter)
Transactions Item Tax Amount
Transactions Item Tax Group Id
Transactions Item Transaction Id
Transactions Item Unit Price
Transactions Item Unit Price Exc Tax
Transactions AdjustStock
Transactions Barcode
Transactions ContainerFee AmountIncTax
Transactions ContainerFee Amount
Transactions ContainerFee Rate
Transactions ContainerFee Name
Transactions ContainerFee ContainerFeeId
Transactions Customer
Transactions DateTime
Transactions Device Name
Transactions DeviceId
Transactions DiscountReason
Transactions DiscountValue
Transactions Gratuity
Transactions Id
Transactions IsTransactionIncTax
Transactions NonDiscountable
Transactions NonTax
Transactions otherTenders itemType
Transactions otherTenders amount
Transactions otherTenders itemTypeId
Transactions ReferenceCode
Transactions ServiceCharge
Transactions ServiceType
Transactions Staff
Transactions Status
Transactions Table
Transactions Tax Amount
Transactions Tax Rate
Transactions Tax Name
Transactions Tax TaxRateId
Transactions Tenders PlatformFees
Transactions Tenders Type
Transactions Tenders IsCashback
Transactions Tenders ChangeGiven
Transactions Tenders Amount
Transactions Tenders TenderTypeId
Transactions TotalAmount
Transactions Transaction Detail PrintOnReceipt
Transactions Transaction Detail PrintOnOrder
Transactions Transaction Detail ShowOnTill
Transactions Transaction Detail Value
Transactions Transaction Detail Name
Product ArticleCode
Product Barcode
Product Brand
Product ButtonColour
Product Category
Product Colour
Product ContainerFeeId
Product CostPrice
Product CostPriceTaxGroup
Product Description
Product EatOutPrice
Product EatOutPriceTaxGroup
Product ExcludeFromLoyaltyPointsGain
Product Id
Product
Product IsArchived
Product IsCostPriceIncTax
Product IsEatOutPriceIncTax
Product IsMultipleChoiceProductOptional
Product IsSalePriceIncTax
Product IsTaxExemptable
Product IsVariablePrice
Product MeasurementDetails CostPriceUnit
Product MeasurementDetails CostPriceFactor
Product MeasurementDetails CostPriceMeasurementUnitVolume
Product MeasurementDetails CostPriceMeasurementSchemeItemId
Product MeasurementDetails SalePriceUnit
Product MeasurementDetails SalePriceFactor
Product MeasurementDetails SalePriceMeasurementUnitVolume
Product MeasurementDetails SalePriceMeasurementSchemeItemId
Product MultipleChoiceNote
Product Name
Product OrderCode
Product PopupNote
Product Detailed Description
Product ProductType
Product RrPrice
Product SalePrice
Product SalePriceTaxGroup
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product SortPosition
Product Supplier
Product TareWeight
Product UnitOfSale
Product VariantGroupId
Product VolumeOfSale
Customer Business Name
Customer Card Number
Customer Contact Number
Customer Contact Number 2
Customer Current Balance
Customer Current Points
Customer Address
Customer Address Is Main Address
Customer Address Post Code
Customer Address County
Customer Address Town
Customer Address Line2
Customer Address Line1
Customer Address Name
Customer Address Customer Id
Customer Address Id
Customer Customer Address
Customer Dateofbirth
Customer Email Address
Customer Expirydate
Customer Forename
Customer Id
Customer
Customer Marketing Consent Mail
Customer Marketing Consent Phone
Customer Marketing Consent Text
Customer Marketing Consent Email
Customer Max Credit
Customer Notes
Customer Referencecode
Customer Sign Up Date
Customer Sign Up Location
Customer Surname
Customer Title
Customer Type
Staff HourlyRate
Staff Id
Staff
Staff MainLocationId
Staff Name
Staff ReferenceCode
Staff RoleId
Staff ShowAtAllLocations
DiscountReason DefaultPercentage
DiscountReason Id
DiscountReason Name
Height
Table ID
Table Name
PosX
PosY
Seating Area ID
Seats
Width
Device Description
Device Id
Device Location
Device Name
Location Address Line 1
Location Address Line 2
Location Bar Tab Spend Limit
Location Country Name
Location County
Location Currency Id
Location Date Format
Location Decimal Separator
Location Description
Location Email Address
Location Group Separator
Location Id
Location
Location Is Warehouse
Location Language
Location Location Area
Location Long Time Format
Location Name
Location No Of Top Sellers
Location Number Of Bar Tabs
Location Phone Number
Location Post Code
Location Predefined Locale Settings
Location Short Time Format
Location Show Bar Tabs
Location Time Zone
Location Town
Location Area Description
Location Area Email Address
Location Area Id
Location Area
Location Area Name
Location Area Parent Id
Actions allow you to make changes to the objects that pass the filter checks.
For example, set the customer balance to 10 or add 20% to the existing balance.
Customer Business Name
Customer Card Number
Customer Contact Number
Customer Contact Number 2
Customer Current Balance
Customer Current Points
Customer Address
Customer Address Is Main Address
Customer Address Post Code
Customer Address County
Customer Address Town
Customer Address Line2
Customer Address Line1
Customer Address Name
Customer Address Customer Id
Customer Address Id
Customer Customer Address
Customer Dateofbirth
Customer Email Address
Customer Expirydate
Customer Forename
Customer Id
Customer Marketing Consent Mail
Customer Marketing Consent Phone
Customer Marketing Consent Text
Customer Marketing Consent Email
Customer Max Credit
Customer Notes
Customer Referencecode
Customer Sign Up Date
Customer Sign Up Location
Customer Surname
Customer Title
Customer Type
Device Description
Device Id
Device Location
Device Name
Product ArticleCode
Product Barcode
Product Brand
Product ButtonColour
Product Category
Product Colour
Product ContainerFeeId
Product CostPrice
Product CostPriceTaxGroup
Product Description
Product EatOutPrice
Product EatOutPriceTaxGroup
Product ExcludeFromLoyaltyPointsGain
Product Id
Product IsArchived
Product IsCostPriceIncTax
Product IsEatOutPriceIncTax
Product IsMultipleChoiceProductOptional
Product IsSalePriceIncTax
Product IsTaxExemptable
Product IsVariablePrice
Product MeasurementDetails CostPriceUnit
Product MeasurementDetails CostPriceFactor
Product MeasurementDetails CostPriceMeasurementUnitVolume
Product MeasurementDetails CostPriceMeasurementSchemeItemId
Product MeasurementDetails SalePriceUnit
Product MeasurementDetails SalePriceFactor
Product MeasurementDetails SalePriceMeasurementUnitVolume
Product MeasurementDetails SalePriceMeasurementSchemeItemId
Product MultipleChoiceNote
Product Name
Product OrderCode
Product PopupNote
Product Detailed Description
Product ProductType
Product RrPrice
Product SalePrice
Product SalePriceTaxGroup
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product SortPosition
Product Supplier
Product TareWeight
Product UnitOfSale
Product VariantGroupId
Product VolumeOfSale
Transactions Item Cost Price
Transactions Item Discount Amount
Transactions Item Discount Reason Id
Transactions Item Id
Transactions Item Is Tax Exempt
Transactions Item Multiple Choice Product Id
Transactions Item Notes
Transactions Item Parent Id
Transactions Item Print On Order
Transactions Item Product Id
Transactions Item Quantity
Transactions Item Refund Reason Id
Transactions Item Tax Amount
Transactions Item Tax Group Id
Transactions Item Transaction Id
Transactions AdjustStock
Transactions Barcode
Transactions ContainerFee AmountIncTax
Transactions ContainerFee Amount
Transactions ContainerFee Rate
Transactions ContainerFee Name
Transactions ContainerFee ContainerFeeId
Transactions Customer
Transactions DateTime
Transactions Device Name
Transactions DeviceId
Transactions DiscountReason
Transactions DiscountValue
Transactions Gratuity
Transactions Id
Transactions IsTransactionIncTax
Transactions NonDiscountable
Transactions NonTax
Transactions ReferenceCode
Transactions ServiceCharge
Transactions ServiceType
Transactions Staff
Transactions Status
Transactions Table
Transactions TotalAmount
Transactions Item Unit Price
Transactions Item Unit Price Exc Tax
Transaction Service Type Name
Transaction Status Name
Staff HourlyRate
Staff Id
Staff MainLocationId
Staff Name
Staff ReferenceCode
Staff RoleId
Staff ShowAtAllLocations
DiscountReason DefaultPercentage
DiscountReason Id
DiscountReason Name
Height
Table ID
Table Name
PosX
PosY
Seating Area ID
Seats
Width