Price rules
A price rule turns the supplier’s price into your selling price:
your price = supplier price × Multiply the supplier price by + Then add
- Multiply the supplier price by: 1 keeps the price, 1.5 adds 50%, 2 doubles it. Any number from 0.01 to 100.
- Then add: a fixed amount in your shop’s currency, after multiplying. Use a negative number to subtract. The price never goes below 0.
- End prices in .99: the result becomes the whole number plus .99, for example 12.40 becomes 12.99.
The form shows an example as you type: “a supplier price of 10.00 becomes …”. The rule applies to the price and to the compare-at price; a compare-at price that is not above your price is left out.
The supplier’s own price is saved as each variant’s Cost per item, so Shopify’s margin and profit reports show what you earn per sale. The daily sync updates the cost when the supplier changes their price.
Suppliers in another currency
When the supplier’s store shows prices in another currency than your store, Columna: Product Import & Sync converts them into your store’s currency with the European Central Bank’s daily reference rates before your price rule runs, so the rule, the price and the cost per item are all in your currency. The daily sync uses the day’s rate. A currency the ECB does not publish a rate for (about 30 currencies are covered) cannot be imported; the daily sync then keeps your prices and still updates stock.
The default: 50 % markup, ending in .99
Until you change it, every supplier starts with Multiply the supplier price by 1.5 and End prices in .99: a supplier price of 10.00 becomes 15.99. A rule that adds nothing (multiply by 1 or less and add nothing) would sell at the supplier’s price, so you earn nothing: the app warns you and saves or imports with it only after you tick “Sell at the supplier’s price anyway” (or, on the import screen, “Import at the supplier’s price”).
Where to set it
- Settings > Default price rule is the rule each new supplier starts with.
- Each supplier has its own rule: Suppliers > the supplier > Price rule. It applies to the next products you import from that supplier and, with the daily sync on, to every price change the supplier makes.
Changing a rule does not change products you already imported until the daily sync next updates their price. Lock a product’s price (see Daily sync and locks) to keep a price you set by hand.