Update products selling price based on category
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 products
The flow will fetch all products from your Epos Now account ready for filtering
Target the products that match your filters
Select the categories for which the product prices should be changed. Only products that are assigned to the categories in your filter will be updated.
Update the product selling price
The product selling price can be updated by increasing/decreasing by an absolute value or a percentage. For example, add 10, or increase by 10%. These can be chained together to perform more complex price changes, for example add 5 and then add 3%.
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.
Product Id
Product Name
Product ArticleCode
Product Barcode
Product Brand
Product ButtonColour
Product Category
Product Colour
Product CostPrice
Product CostPriceTaxGroup
Product Description
Product EatOutPrice
Product EatOutPriceTaxGroup
Product ExcludeFromLoyaltyPointsGain
Product IsArchived
Product IsCostPriceIncTax
Product IsEatOutPriceIncTax
Product IsMultipleChoiceProductOptional
Product IsSalePriceIncTax
Product IsTaxExemptable
Product IsVariablePrice
Product MultipleChoiceNote
Product OrderCode
Product PopupNote
Product ProductType
Product RrPrice
Product SalePrice
Product SalePriceTaxGroup
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product Supplier
Product SortPosition
Product TareWeight
Product UnitOfSale
Product VolumeOfSale
Product MeasurementDetails SalePriceMeasurementSchemeItemId
Product MeasurementDetails SalePriceMeasurementUnitVolume
Product MeasurementDetails CostPriceMeasurementSchemeItemId
Product MeasurementDetails CostPriceMeasurementUnitVolume
Product Detailed Description
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.
Product Id
Product Name
Product ArticleCode
Product Barcode
Product Brand
Product ButtonColour
Product Category
Product Colour
Product CostPrice
Product CostPriceTaxGroup
Product Description
Product EatOutPrice
Product EatOutPriceTaxGroup
Product ExcludeFromLoyaltyPointsGain
Product IsArchived
Product IsCostPriceIncTax
Product IsEatOutPriceIncTax
Product IsMultipleChoiceProductOptional
Product IsSalePriceIncTax
Product IsTaxExemptable
Product IsVariablePrice
Product MultipleChoiceNote
Product OrderCode
Product PopupNote
Product ProductType
Product RrPrice
Product SalePrice
Product SalePriceTaxGroup
Product SellOnTill
Product SellOnWeb
Product Size
Product Sku
Product Supplier
Product SortPosition
Product TareWeight
Product UnitOfSale
Product VolumeOfSale
Product MeasurementDetails SalePriceMeasurementSchemeItemId
Product MeasurementDetails SalePriceMeasurementUnitVolume
Product MeasurementDetails CostPriceMeasurementSchemeItemId
Product MeasurementDetails CostPriceMeasurementUnitVolume
Product Detailed Description