I was wondering if, on top of being able to call functions on inputs when syncing between services, is there any option to run calculations on data and push a calculated value to one service/endpoint using Dsync?
Yes you can do basic mathematical calculations using the ‘Add Custom Field’ option when mapping a field. The destination field you are mapping must be of type ‘number’.
As an example the below calculation is adding 10% to the price and then mapping to another system
What sort of function calculations can I make on my data synchronization? The following can be used to make data calculations between your systems +-*/ and brackets ()
Brackets () can be used to create different calculations example 3*5+7*2 different to 3*(5+7)*2
Custom Field Calculations
Can I run formulas on my data synchronization? Yes, you can add, subtract, multiply and divide number formats from one system to another.
Where in the DSYNC dashboard can I set formulas and calculations? Data formulas can be set at an endpoint to endpoint level within the mapping section. To access the mapping section, click on the line between your two systems then edit your map. To set a calculation you will need to “Add a custom field”. Enter your desired formula in the section indicating “Add a string constant”.
Can I add a percentage % to my data sync? Yes, to add a percentage to your integration please create a custom field. This is a common formula that is applied to sales mark ups and to currency exchange rates.
In the mapping section how do I create a formula calculation for my data? When adding a field to map under the search button you can select “Add a custom field” Enter the formula where it says add a string constant.
Can I add a buffer calculation to my stock levels so that I don’t run out of stock? Yes, if you are synchronizing stock quantities you can add a formula to subtract a given quantity from the inventory being synchronized this will act as a buffer.