Export Epos Now average product sales reports
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 average product sales reports
The flow will fetch the average product sales reports from your Epos Now account ready for filtering
Target the reports that match your filters
You can specify which reports this flow applies to.
See the customisations section later on this page for a full list of available filters.
Export the reports
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.
Avg Product Sales EndDate (Filter)
Avg Product Sales Location ID
Avg Product Sales Location Name
Avg Product Sales Product ID
Avg Product Sales Product Name
Avg Product Sales Qty Sold
Avg Product Sales StartDate (Filter)
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
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 MultipleChoiceNote
Product Name
Product OrderCode
Product PopupNote
Product ProductType
Product Reference Code
Product RrPrice
Product SalePrice
Product SalePriceTaxGroup ID
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product SortPosition
Product Supplier
Product TareWeight
Product UnitOfSale
Product VariantGroupId
Product VolumeOfSale
Brand Description
Brand Id
Brand
Brand Name
ContainerFee Amount
ContainerFee BottleDepositItemID
ContainerFee Name
Location Area Description
Location Area Email Address
Location Area Id
Location Area
Location Area Name
Location Area Parent Id
Measurement Scheme
Measurement Scheme
Multiple Choice Notes Id
Multiple Choice Notes Name
PopupNote Display Once Per Transaction
PopupNote Id
PopupNote Name
PopupNote Note
Category Description
Category Id
Category
Category Is Wet
Category Name
Category Nominal Code
Category Parent
Category Reporting Category
Category Show On Till
Category Sort Position
Product Type Name
Product Type Value
Supplier AddressLine1
Supplier AddressLine2
Supplier ContactNumber
Supplier ContactNumber2
Supplier Country
Supplier Description
Supplier EmailAddress
Supplier Id
Supplier
Supplier Name
Supplier PostCode
Supplier Town
Supplier Type
Unit of Sale Name
Unit of Sale Value
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.
Avg Product Sales Location ID
Avg Product Sales Location Name
Avg Product Sales Product ID
Avg Product Sales Product Name
Avg Product Sales Qty Sold
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 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
Product ArticleCode
Product Barcode
Product Brand
Product ButtonColour
Product Category
Product Colour
Product ContainerFeeId
Product CostPrice
Tax Group Name
Tax Group Id
Product CostPriceTaxGroup
Product Description
Product EatOutPrice
Tax Group Name
Tax Group Id
Product EatOutPriceTaxGroup
Product ExcludeFromLoyaltyPointsGain
Product Id
Product IsArchived
Product IsCostPriceIncTax
Product IsEatOutPriceIncTax
Product IsMultipleChoiceProductOptional
Product IsSalePriceIncTax
Product IsTaxExemptable
Product IsVariablePrice
Product MeasurementDetails CostPriceMeasurementUnitVolume
Product MeasurementDetails CostPriceMeasurementSchemeItemId
Product MeasurementDetails SalePriceMeasurementUnitVolume
Product MeasurementDetails SalePriceMeasurementSchemeItemId
Product MultipleChoiceNote
Product Name
Product OrderCode
Product PopupNote
Product Detailed Description
Product ProductType
Product Reference Code
Product RrPrice
Product SalePrice
Tax Group Name
Tax Group Id
Product SalePriceTaxGroup ID
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product SortPosition
Supplier Type
Supplier EmailAddress
Supplier ContactNumber2
Supplier ContactNumber
Supplier PostCode
Supplier Country
Supplier Town
Supplier AddressLine2
Supplier AddressLine1
Supplier Description
Supplier Name
Supplier Id
Product Supplier
Product TareWeight
Product UnitOfSale
Product VariantGroupId
Product VolumeOfSale