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 pricesku- the feed SKUquantity- the feed quantity, available if added to data mappingcost- the product cost as in the feed, available if added to data mappingvariant.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 |
Last modified 3mo ago