Delete transactions and/or related data

By /

Delete transactions and/or related data

transactions Available
Delete transactions and/or related data such as customers and staff within a given date range. Set the schedule to run daily automatically or run manually when needed.

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 transactions

The flow will fetch all transactions from your Epos Now account ready for filtering

Fetch
Apply filters…
Target the transactions that match your filters

Filter so that this is only applied to transactions that match your filters

Filter
Then do this…
Delete the transactions and/or related data

Delete the transactions and/or related data such as customers, staff, tables.

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.

Trigger
Manual Run

Run your flow manually using our dashboard. This is useful for testing your flow or running it on demand.

Trigger

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_transactions_adjustStock

Filter

epn_transactions_barcode

Filter

epn_transactions_containerfee_amountIncTax

Filter

epn_transactions_containerfee_amount

Filter

epn_transactions_containerfee_rate

Filter

epn_transactions_containerfee_name

Filter

epn_transactions_containerfee_containerFeeId

Filter

epn_transactions_customerId

Filter

epn_transactions_dateTime

Filter

epn_transactions_device

Filter

epn_transactions_deviceId

Filter

epn_transactions_discountReasonId

Filter

epn_transactions_discountValue

Filter

epn_transactions_endDate

Filter

epn_transactions_gratuity

Filter

epn_transactions_id

Filter

epn_transactions_isTransactionIncTax

Filter

epn_transactions_miscproductitem_quantity

Filter

epn_transactions_miscproductitem_taxGroupId

Filter

epn_transactions_miscproductitem_taxAmount

Filter

epn_transactions_miscproductitem_refundReasonId

Filter

epn_transactions_miscproductitem_printOnOrder

Filter

epn_transactions_miscproductitem_unitPriceTax

Filter

epn_transactions_miscproductitem_unitPrice

Filter

epn_transactions_miscproductitem_name

Filter

epn_transactions_miscproductitem_Id

Filter

epn_transactions_nonDiscountable

Filter

epn_transactions_nonTax

Filter

epn_transactions_otherItems_Amount

Filter

epn_transactions_otherItems_ItemType

Filter

epn_transactions_otherItems_ItemTypeId

Filter

epn_transactions_otherTenders_ItemType

Filter

epn_transactions_otherTenders_Amount

Filter

epn_transactions_otherTenders_ItemTypeId

Filter

epn_transactions_referenceCode

Filter

epn_transactions_serviceCharge

Filter

epn_transactions_serviceType

Filter

epn_transactions_staffId

Filter

epn_transactions_startDate

Filter

epn_transactions_statusId

Filter

epn_transactions_tableId

Filter

epn_transactions_tax_amount

Filter

epn_transactions_tax_rate

Filter

epn_transactions_tax_name

Filter

epn_transactions_tax_taxRateId

Filter

epn_transactions_tenders_platformFees

Filter

epn_transactions_tenders_type

Filter

epn_transactions_tenders_isCashback

Filter

epn_transactions_tenders_changeGiven

Filter

epn_transactions_tenders_amount

Filter

epn_transactions_tenders_tenderTypeId

Filter

epn_transactions_totalAmount

Filter

epn_transactions_transactiondetail_printOnReceipt

Filter

epn_transactions_transactiondetail_printOnOrder

Filter

epn_transactions_transactiondetail_showOnTill

Filter

epn_transactions_transactiondetail_value

Filter

epn_transactions_transactiondetail_name

Filter

epn_transactions_item_endDate

Filter

epn_transactions_item_startDate

Filter

epn_transactions_item_isTaxExempt

Filter

epn_transactions_item_parentId

Filter

epn_transactions_item_multipleChoiceProductId

Filter

epn_transactions_item_printOnOrder

Filter

epn_transactions_item_notes

Filter

epn_transactions_item_refundReasonId

Filter

epn_transactions_item_discountReasonId

Filter

epn_transactions_item_discountAmount

Filter

epn_transactions_item_quantity

Filter

epn_transactions_item_taxAmount

Filter

epn_transactions_item_taxGroupId

Filter

epn_transactions_item_costPrice

Filter

epn_transactions_item_unitPriceExcTax

Filter

epn_transactions_item_unitPrice

Filter

epn_transactions_item_productId

Filter

epn_transactions_item_transactionId

Filter

epn_transactions_item_id

Filter

epn_customers_businessName

Filter

epn_customers_cardNumber

Filter

epn_customers_contactNumber

Filter

epn_customers_contactNumber2

Filter

epn_customers_currentBalance

Filter

epn_customers_currentPoints

Filter

epn_customers_customerAddressId

Filter

epn_customers_dateOfBirth

Filter

epn_customers_emailAddress

Filter

epn_customers_expiryDate

Filter

epn_customers_forename

Filter

epn_customers_id

Filter

epn_customers_id_name

Filter

epn_customers_maxCredit

Filter

epn_customers_notes

Filter

epn_customers_referenceCode

Filter

epn_customers_signUpDate

Filter

epn_customers_signUpLocationId

Filter

epn_customers_surname

Filter

epn_customers_title

Filter

epn_customers_type

Filter

epn_device_description

Filter

epn_device_id

Filter

epn_device_locationId

Filter

epn_device_name

Filter

epn_discountreason_defaultpercentage

Filter

epn_discountreason_id

Filter

epn_discountreason_name

Filter

epn_staff_hourlyRate

Filter

epn_staff_id

Filter

epn_staff_id_name

Filter

epn_staff_mainLocationId

Filter

epn_staff_name

Filter

epn_staff_referenceCode

Filter

epn_staff_roleId

Filter

epn_staff_showAtAllLocations

Filter

epn_table_height

Filter

epn_table_id

Filter

epn_table_name

Filter

epn_table_pos_x

Filter

epn_table_pos_y

Filter

epn_table_seating_area_id

Filter

epn_table_seats

Filter

epn_table_width

Filter

epn_transaction_service_type_name

Filter

epn_transaction_service_type_value

Filter

epn_transaction_status_name

Filter

epn_transaction_status_value

Filter

epn_customer_addresses_addressLine1

Filter

epn_customer_addresses_addressLine2

Filter

epn_customer_addresses_county

Filter

epn_customer_addresses_customerId

Filter

epn_customer_addresses_id

Filter

epn_customer_addresses_id_name

Filter

epn_customer_addresses_isMainAddress

Filter

epn_customer_addresses_name

Filter

epn_customer_addresses_postCode

Filter

epn_customer_addresses_town

Filter

epn_customer_titles_name

Filter

epn_customer_titles_value

Filter

epn_customer_types_defaultExpiryLength

Filter

epn_customer_types_defaultMaxCredit

Filter

epn_customer_types_description

Filter

epn_customer_types_discount

Filter

epn_customer_types_id

Filter

epn_customer_types_id_name

Filter

epn_customer_types_name

Filter

epn_location_areas_description

Filter

epn_location_areas_emailAddress

Filter

epn_location_areas_locationAreaId

Filter

epn_location_areas_locationAreaId_name

Filter

epn_location_areas_name

Filter

epn_location_areas_parentId

Filter

epn_locations_address1

Filter

epn_locations_address2

Filter

epn_locations_barTabSpendLimit

Filter

epn_locations_countryName

Filter

epn_locations_county

Filter

epn_locations_currencyId

Filter

epn_locations_dateFormat

Filter

epn_locations_decimalSeparator

Filter

epn_locations_description

Filter

epn_locations_emailAddress

Filter

epn_locations_groupSeparator

Filter

epn_locations_id

Filter

epn_locations_id_name

Filter

epn_locations_isWarehouse

Filter

epn_locations_languageId

Filter

epn_locations_locationAreaId

Filter

epn_locations_longTimeFormat

Filter

epn_locations_name

Filter

epn_locations_noOfTopSellers

Filter

epn_locations_numberOfBarTabs

Filter

epn_locations_phoneNumber

Filter

epn_locations_postCode

Filter

epn_locations_predefinedLocaleSettingsId

Filter

epn_locations_shortTimeFormat

Filter

epn_locations_showBarTabs

Filter

epn_locations_timeZoneId

Filter

epn_locations_town

Filter

epn_role_CanAccessBackOffice

Filter

epn_role_CanAccessMiscProducts

Filter

epn_role_CanAccesssCustomers

Filter

epn_role_CanAccessTablePlan

Filter

epn_role_CanAccessTill

Filter

epn_role_CanAccessTillAdminOptions

Filter

epn_role_CanAdjustFloat

Filter

epn_role_CanApplyBasketDiscounts

Filter

epn_role_CanApplyItemDiscounts

Filter

epn_role_CanChangeTabSpendAmount

Filter

epn_role_CanClearTransaction

Filter

epn_role_CanDeleteUnorderedItems

Filter

epn_role_CanDisableServiceCharge

Filter

epn_role_CanEditCustomerPoints

Filter

epn_role_CanHoldTransaction

Filter

epn_role_CanManuallySelectCustomer

Filter

epn_role_CanOrderAllocationServer

Filter

epn_role_CanOrderAllocationTableManager

Filter

epn_role_CanOrderAllocationTeamServer

Filter

epn_role_CanReceiveStock

Filter

epn_role_CanRefundItems

Filter

epn_role_CanRemoveFromTable

Filter

epn_role_CanRunEndOfDay

Filter

epn_role_CanSeeEndOfDayReport

Filter

epn_role_CanSendStock

Filter

epn_role_CanServerBaking

Filter

epn_role_CanStockTake

Filter

epn_role_CanTipOutOthers

Filter

epn_role_CanTipOutSelf

Filter

epn_role_CanUnlockDeviceViaPin

Filter

epn_role_CanUnrestrictedStockTake

Filter

epn_role_CanUseNoSale

Filter

epn_role_CanUsePayouts

Filter

epn_role_CanUsePettyCash

Filter

epn_role_CanVoidItems

Filter

epn_role_Description

Filter

epn_role_id

Filter

epn_role_id_name

Filter

epn_role_IsAdminOnTill

Filter

epn_role_MaxBasketDiscountAmount

Filter

epn_role_MaxBasketDiscountPercentage

Filter

epn_role_MaxCustomerCreditLimit

Filter

epn_role_MaxItemDiscountAmount

Filter

epn_role_MaxItemDiscountPercentage

Filter

epn_role_MaxRefundAmount

Filter

epn_role_name

Filter

epn_seating_areas_description

Filter

epn_seating_areas_id

Filter

epn_seating_areas_locationId

Filter

epn_seating_areas_name

Filter

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_transactions_id

Action
Scroll to Top