Pricing Profiles

Pricing profiles can be linked to listings and a dynamic price will be calculated. Anytime that a token changes the price will be recalculated. This could come in useful for example if you have supplier feeds which update the cost price of a product if this is used within a formula then this will be automatically updated.

Channels can also have a default pricing profile set. This will be selected automatically when creating new listings. eBay default values can also be set up to have a pricing profile selected.

Example Tokens:

• Price
• AverageCost
• RRP
• Margin
• Sold Last 7 Days
• Weight
• PackagingCosts

Example Formulas:

• [AverageCost] + [Margin] + [PackagingCosts]
• ([PrioritySupplierCost] + [PackagingCosts]) * (1 + ([Margin] / 100))
• [RRP] + [Margin] + [PackagingCosts]
• [AverageCost] + [Margin] + [PackagingCosts] + if([Inventory]<10, 5,0)

User Interaction Points

Edit Pricing Profiles Page

Pricing profiles can be edited by going to Settings > Integrations > Pricing Profiles. From here new pricing profiles can be created and existing ones edited. The edit page allows you to amend the formula and set the price ends.

It also allows you to enter example data and see what the pricing profile would of calculated it as.

Channel Details

For each channel you can set up a default pricing profile. This is used when creating new listings. It can be found in the misc section of channel settings.

Listing Pages

A new listing price box control has been added to all pages. When the pricing profiles feature is enabled there is a chain link on the right hand side of the price box. Clicking this will bring up a lightbox where the pricing profile can be amended.

When a creating a new listing if the channel has a default pricing profile this will be automatically filled in.

When listing a variant it is the same process there is a chain link in the price box that can be clicked and edited. Pricing profiles can also be amended in bulk for variants by hovering over the price header and selecting the bulk actions link.

eBay Default Values

A default pricing profile for the ebay default value can be selected.

Listing Import Export

Pricing profiles can be updated in bulk via the listing import export. It works based on the name that the user set for it.

Operators

Logical

or, ||, and, &&

Relational

=, ==, !=, <>,<, <=, >, >=

Additive

+, -

Multiplicative

*, /, %

Bitwise

& (bitwise and), | (bitwise or), ^(bitwise xor), << (left shift), >>(right shift)

Unary

!, not, -, ~ (bitwise not)

Maths Functions

Abs(x)

Get the absolute value of a number. For instance Abs(-1.5) will result in 1.5, Abs(1.5) will result in 1.5

Ceiling(x)

Returns the smallest integer greater than or equal to the specified number. Ceiling(1) = 1, Ceiling(1.5) = 2

Floor(x)

Returns the smallest integer less than or equal to the specified number. Floor(1) = 1, Floor(1.5) = 1

Max(x,y)

Returns the larger of two specified numbers.

Min(x,y)

Returns the smaller of two numbers.

Pow(x,y)

Returns a specified number raised to the specified power.

Round(x)

Rounds a decimal value to the nearest integral value.

Round(x,y)

Rounds a decimal value to a specified number of fractional digits.

Sqrt(x)

Returns the square root of a specified number.

Truncate(x)

Calculates the integral part of a number. Truncate(1) = 1, Truncate(1.5) = 1

Other Functions

in(valueToCheck, x,y,z)

Checks whether a value is in a list of values. For instance In(5, 0 ,5,10,15) this will check if 5 is in the list of values (0,5,10,15) and will equal true.

if(condtion, trueResult, falseResult)

Checks whether a condition is true or false and then returns either the true value or false value.

Price Ends

Price Ends (sometimes called physiological or charm pricing) lets users decide what decimal value they would like their prices to come out at. This is because customers prefer prices like £1.00 £1.50 £1.99 over prices like £1.37, £1.77 etc.

For each pricing profile the user can input a list of price ends that they would like so instance: 0, 25, 50, 99.

They can then choose a rounding strategy that they would like:

• Round Down
• Round Up
• Mid Point Rounding

Round Down

If using Round Down and the following price ends: 25, 50, 99. When the price is calculated as:

• 1.67 it will round to 1.50
• 1.99 will round to 1.99
• 2.00 will round to 1.99
• 1.33 will round to to 1.25

Round(x,y)

If using Round Up and the following price ends: 25, 50, 99. When the price is calculated as:

• 1.67 it will round to 1.99
• 1.99 will round to 1.99
• 2.00 will round to 2.25
• 1.33 will round to to 1.50

Midpoint

Midpoint will round to the closest value. So if using Midpoint and the following price ends: 25, 50, 99. When the price is calculated as:

• 1.67 it will round to 1.50
• 1.99 will round to 1.99
• 2.00 will round to 1.99
• 1.43 will round to to 1.50