Export Epos Now product sales report
reports Available
This is a blank template where you can add filters and actions as needed to build you own custom export. We have a large selection of filters and actions that can be applied in any sequence you like.
This flow template gives you a good starting point and you can customise it as needed.
We’d love to hear about what you want to automate and can advise on how to use flow to meet your requirements.
Send us an enquiry or
book in a call, whatever suits you best.
When this happens…
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.
Trigger
Get the data …
Fetch the product sales report
The flow will fetch the product sales reports from your Epos Now account ready for filtering.
Fetch
Apply filters…
Target the reports that match your filters
Define the start and end date in the filters. You can also add filters for other fields.
See the customisations section later on this page for a full list of available filters.
Filter
Then do this…
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.
Action
Customisation
This template can be easily customised by changing the triggers, filters and actions
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.
epn_daily_sales_report_Barcode
epn_daily_sales_report_Brand
epn_daily_sales_report_Description
epn_daily_sales_report_Discount
epn_daily_sales_report_FromDate
epn_daily_sales_report_Margin
epn_daily_sales_report_MarginPerc
epn_daily_sales_report_MeasuredQty
epn_daily_sales_report_Name
epn_daily_sales_report_OrderCode
epn_daily_sales_report_ProductID
epn_daily_sales_report_Qty
epn_daily_sales_report_ReferenceCode
epn_daily_sales_report_Size
epn_daily_sales_report_Sku
epn_daily_sales_report_ToDate
epn_daily_sales_report_TotCost
epn_daily_sales_report_Value
epn_daily_sales_report_ValueExcVAT
epn_daily_sales_report_ValueIncVAT
epn_products_buttonColourId
epn_products_containerFeeId
epn_products_costPriceTaxGroupId
epn_products_eatOutPriceTaxGroupId
epn_products_excludeFromLoyaltyPointsGain
epn_products_isCostPriceIncTax
epn_products_isEatOutPriceIncTax
epn_products_isMultipleChoiceProductOptional
epn_products_isSalePriceIncTax
epn_products_isTaxExemptable
epn_products_isVariablePrice
epn_products_multipleChoiceNoteId
epn_products_referenceCode
epn_products_salePriceTaxGroupId
epn_products_sortPosition
epn_products_variantGroupId
epn_products_volumeOfSale
epn_container_fees_amount
epn_container_fees_bottle_deposit_item_id
epn_measurement_scheme_name
epn_measurement_scheme_value
epn_multiplechoicenotes_id
epn_multiplechoicenotes_name
epn_popupnotes_displayOncePerTransaction
epn_product_categories_description
epn_product_categories_id
epn_product_categories_id_name
epn_product_categories_isWet
epn_product_categories_name
epn_product_categories_nominalCode
epn_product_categories_parentId
epn_product_categories_reportingCategoryId
epn_product_categories_showOnTill
epn_product_categories_sortPosition
epn_suppliers_addressLine1
epn_suppliers_addressLine2
epn_suppliers_contactNumber
epn_suppliers_contactNumber2
epn_suppliers_description
epn_suppliers_emailAddress
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.
epn_daily_sales_report_Barcode
epn_daily_sales_report_Brand
epn_daily_sales_report_Description
epn_daily_sales_report_Discount
epn_daily_sales_report_FromDate
epn_daily_sales_report_Margin
epn_daily_sales_report_MarginPerc
epn_daily_sales_report_MeasuredQty
epn_daily_sales_report_Name
epn_daily_sales_report_OrderCode
epn_daily_sales_report_ProductID
epn_daily_sales_report_Qty
epn_daily_sales_report_ReferenceCode
epn_daily_sales_report_Size
epn_daily_sales_report_Sku
epn_daily_sales_report_ToDate
epn_daily_sales_report_TotCost
epn_daily_sales_report_Value
epn_daily_sales_report_ValueExcVAT
epn_daily_sales_report_ValueIncVAT
epn_products_buttonColourId
epn_products_containerFeeId
epn_products_costPriceTaxGroupId
epn_products_eatOutPriceTaxGroupId
epn_products_excludeFromLoyaltyPointsGain
epn_products_isCostPriceIncTax
epn_products_isEatOutPriceIncTax
epn_products_isMultipleChoiceProductOptional
epn_products_isSalePriceIncTax
epn_products_isTaxExemptable
epn_products_isVariablePrice
epn_products_measurementdetails_costPriceMeasurementUnitVolume
epn_products_measurementdetails_costPriceMeasurementSchemeItemId
epn_products_measurementdetails_salePriceMeasurementUnitVolume
epn_products_measurementdetails_salePriceMeasurementSchemeItemId
epn_products_multipleChoiceNoteId
epn_products_productdetails_DetailedDescription
epn_products_referenceCode
epn_products_salePriceTaxGroupId
epn_products_sortPosition
epn_suppliers_emailAddress
epn_suppliers_contactNumber2
epn_suppliers_contactNumber
epn_suppliers_addressLine2
epn_suppliers_addressLine1
epn_suppliers_description
epn_products_variantGroupId
epn_products_volumeOfSale