Comment on page

# Price calculation

Stockeo gives you a possibility to update product prices based on the supplier feed.

Add the Price field in the Data Mapping section, and specify which column/node contains prices in the supplier feed.

You can also calculate prices according to your needs. Click on the gear icon to define a price formula in Liquid.

The available variables are

`price`

- the feed price`sku`

- the feed SKU`quantity`

- the feed quantity, available if added to data mapping`cost`

- the product cost as in the feed, available if added to data mapping`variant.price`

- the current variant price in Shopify (before update)

You can use all the standard Liquid math filters to perform calculations.

Use the

`plus`

filter to add a number.{{ price | plus: 3 }}

Use the

`minus`

filter to subtract a number.{{ price | minus: 1 }}

Use the

`times`

filter to multiply price by a given number.{{ price | times: 1.2 }}

Use the

`divided_by`

filter to divide price by a given number.{{ price | divided_by: 1.2 }}

Use the

`round`

filter to round the price to the nearest integer or to the specified number of decimals.Formula | Feed Price | Result |
---|---|---|

`{{ price | round }}` | 4.32 | 4.00 |

`{{ price | round }}` | 4.56 | 5.00 |

`{{ price | round: 1 }}` | 4.44 | 4.40 |

`{{ price | round: 1 }}` | 4.68 | 4.70 |

Use the

`ceil`

filter to round the price up to the nearest integer.Formula | Feed Price | Result |
---|---|---|

`{{ price | ceil }}` | 4.32 | 5.00 |

`{{ price | ceil }}` | 4.56 | 5.00 |

Use the

`floor`

filter to round the price down to the nearest integer.Formula | Feed Price | Result |
---|---|---|

`{{ price | floor }}` | 4.32 | 4.00 |

`{{ price | floor }}` | 4.56 | 4.00 |

Use the

`at_least`

filter to limit prices to a minimum value.Formula | Feed Price | Result |
---|---|---|

`{{ price | at_least: 5}}` | 2.34 | 5.00 |

`{{ price | at_least: 5 }}` | 5.67 | 5.67 |

You can combine the standard math filters to achieve more price-specific rounding.

Use the following formula to round prices up to the nearest .99

{{ price | ceil | minus: 0.01 }}

If a price is already a whole number, then the formula will still subtract one cent. If you prefer to keep whole prices as they are, and only round up fractions to .99, then use the following formula.

{{ price | ceil | minus: 0.01 | at_least: price }}

Formula | Feed Price | Result |
---|---|---|

`{{ price | ceil | minus: 0.01 }}` | 12.34 | 12.99 |

`{{ price | ceil | minus: 0.01 }}` | 12.00 | 11.99 |

`{{ price | ceil | minus: 0.01 | at_least: price}}` | 12.34 | 12.99 |

`{{ price | ceil | minus: 0.01 | at_least: price}}` | 12.00 | 12.00 |

With Stockeo you can shape prices in your store based on the amounts from the feed and markup stored in the metafields for individual products.

In order to access to the metafield use one of the following pattern:

`product.metafields.namespace.key`

`variant.metafields.namespace.key`

For example, if you want to add a 50% markup to the product's price, you need to set the markup metafield to 50 and use the following price formula:

{% assign markup = product.metafields.custom.markup | default: 0 %}

{% assign markup_multiplier = markup | divided_by: 100 | plus: 1 %}

{{ price | times: markup_multiplier }}

The

**default**filter prevents error when the metafield with the markup is empty. In such a case the product price will be the same as the amount in the feed.Feed Price | Markup Metafield | Calculated Price |
---|---|---|

$100 | no set value | $100 |

$100 | 0 | $100 |

$100 | 50 | $150 |

$100 | 100 | $200 |

If you want the calculation of the price of a product in your store to change depending on the price in the feed, you can use the Liquid formula with

**if/elsif**statements.{% if price > 0 and price < 5 %}

{{ price | times: 3 }}

{% elsif price >= 5 and price < 10 %}

{{ price | times: 2 }}

{% elsif price >= 10 and price < 15 %}

{{ price | times: 1.5 }}

{% else %}

{{ price }}

{% endif %}

What price does the above code return?

If the price in the feed is between

**0**and**4.99**, it will be multiplied by**3**. If the feed price is between**5**and**9.99**, it will be multiplied by**2**. If the feed price is between**10**and 1**4.99**, it will be multiplied by**1.5**. In all other cases, the product price will be equal to the feed price.Assume you want to take a price from the column

**RRP**. When**RRP**is equal to**0**or**empty**, then get a value from the column**Price**. To handle this case, use the following Liquid code in the Price field:{% assign RRP = RRP | plus: 0 %}{% if RRP == 0 %}{{ Price }}{% else %}{{ RRP }}{% endif %}

**If**statemant in the price field of Stockeo automation

The code above is used to select from which column Stockeo should take the price. If you set a

**price formula**to calculate the final price, it will be executed on the value that Stockeo selected according to the above condition.

Last modified 6mo ago