1. Home
  2. Docs
  3. Calculate your price
  4. Usage
  5. Calculation rules

Calculation rules

How does the table calculations work?

  • Purchase price: This is your purchase price and do no calculations but could be important to find cost of goods
  • Other cost: Typically this is handling, shipping and other costs you may have after purchase on a product. It is the difference between purchase price and cost of goods. If you have set cost of goods and purchase price the extension set the difference in this field.
  • Shipping: If you want to separate shipping cost this field can be added in settings and will be calculated together with other cost to make the sum of cost of goods.
  • Cost of goods: This is purchase price + other cost (+ shipping cost) per product. This field does no calculations but is essential for further calculations of the price.
  • Markup: This is the percentage markup on your product. Cost of goods + markup = new price (sales price).  If you want 20% markup on your product you need to enter 120 in the markup field. If you know what the new price will be and set it direct, the markup will adjust according to your new price.
  • Price: This is the current sale price on you product and is mostly there to show you what your current price on the product is. Does not do any calculations.
  • New price: This is the sum of cost of goods + markup. If this field has a yellow background it is different than the current price. If you want to use it as the current price, make sure the row is checked and save.
  • Stock: This field show current stock on the product and is used for calculation of value at cost, retail value and profit.
  • Value at cost: Is the sum of cost of goods * stock.
  • Retail value: Is the sum of current price * stock.
  • Profit: Is the sum of retail value – value at cost. If negative profit the numbers are shown in red.
  • Table footer fields with values: Show the totals of the current column, updates if you do updates in the table or search in rows.
Was this article helpful to you? Yes No

How can we help?