Articles on: Shopify

Markets - Price Field

Set up market-specific pricing in Stock Sync to update prices across different regions, manage currency markups, and format market prices automatically.

Available on: ✔️ Add | ✔️ Update | ✔️ Export

How to Set Up Markets Price

Navigation path: Go to App → Feed Settings → Step 2: Matching Column

Map Required Fields: Map Markets - Price alongside Markets - Compare at Price.
Configure Market Settings: Click on Smart Settings next to the mapped field to configure country codes and region rules.
Save Configuration: Review your field mappings and click Save to apply changes.

Ensure you have created the target market in your Shopify Admin before mapping market-specific prices.

Shopify requires that any update to Markets - Compare at Price must include a Markets - Price value in the same update.

Markets Price Smart Settings & Detailed Breakdown

1. Markets - Price Conditions

Markets Price conditions are used to add markups, margins, or markdowns (for sales) to a product's market-specific price.

The first condition in the list has the highest priority. Use the arrow icons beside each condition to reorder them.

Valid price keywords include: price (text comparison), price_f (numeric comparison), col#_f (numeric comparison), any, current_price (Shopify only), cost (Shopify only), and compare_at_price (Shopify only).

Condition (If)	Price / Formula (Then)	Result / Explanation
`any`	`*1.5`	Multiplies all prices by 1.5 (50% markup).
`any`	`*0 + current_quantity`	Sets the price equal to the store's `current_quantity`.
`any`	`0 + (col("price")+80)1.5`	Adds $80 delivery to column `price`, then applies a 50% markup (multiplies by 1.5).
`any`	`*0 + current_price(col("Option2")/100)`	Discounts store product price based on the value in column `Option2`.
`any`	`*0 + col("List_Price")`	Sets price to the value from column `List_Price`.
`any`	`+ col("InStock")`	Adds value from column `InStock` to the product price (supported based on XML nodes).
`any`	`*0 + 12.5`	Sets fixed price to 12.5. Do not use an equal sign (`=`) at the beginning.
`any`	`/0.2`	Divides all prices by 0.2.
`any`	`*0.90`	Multiplies all prices by 0.90 (10% markdown).
`current_price == 0`	`*0`	If store price equals 0, multiplies by 0 (no changes made).
`current_price < price`	`*0 + current_price`	Selects the lowest price when two feeds offer the same product identifier.
`col("sale price") == ""`	`*0 + col3`	Uses column `col3` as price if column `sale price` has no value.
`taxable == 1`	`*1.5`	Multiplies price by 1.5 (50% markup) if item is taxable (`1`: taxable, `0`: untaxable; Shopify only).
`col5 != ""`	`*0 + col5`	Uses column `col5` as price if column `col5` is not empty.
`col("price_special") <=0`	`*0 + col("price")`	Uses column `price` if column `price_special` is 0 or empty.
`col_string("Vendor")=="shoe"`	`*1.3 + col("shipping")`	Applies 30% markup and adds `shipping` column value if `Vendor` equals "shoe".
`contains ("pink", col_string("Description"))`	`*1.1`	Applies 10% markup if `Description` contains "pink".
`contains ("4", col("qty"))`	`*1.5`	Applies 50% markup if numeric column `qty` contains "4".
`price_f > 10 and price_f <= 15`	`*1.2`	Applies 20% markup if price is greater than 10 and less than or equal to 15.
`price_f == 11`	`*1.5`	Applies 50% markup if price equals 11.
`price > col1_f`	`*1 + col1 + col2`	Adds `col1` and `col2` to price if price is greater than column 1.
`col5 == "shoe"`	`*1.3`	Applies 30% markup if column 5 equals "shoe".
`price_f < 1`	`*0 + current_price`	Retains current in-store price if feed price is less than 1 (Shopify only).
`cost < 40`	`*1.2`	Multiplies price by 1.2 if store cost is less than 40 (Shopify only).
`compare_at_price > 10`	`*1.5`	Multiplies price by 1.5 if store compare-at price is greater than 10 (Shopify only).
`col4_date > now`	`*1.2`	Applies 20% markup if date in `col4_date` is after current timestamp (`now`).
`col4_date > today`	`*1.2`	Applies 20% markup if date in `col4_date` is after today's date (`today`).
`current_price > price_f`	`*0 + current_price`	Keeps store price unchanged when store price is higher than feed price.
`current_price > col8_f`	`*0 + current_price`	Keeps store price unchanged when store price is higher than column 8 value in feed file.

Condition Comparison Operators	Details
`==`	Equal to
`<=`	Less than or equal to
`>=`	Greater than or equal to
`>`	Greater than
`<`	Less than
`and`	Only true when both statements are true
`or`	True when either statement is true

Formula Syntax	Explanation
`contains('BC',col13)`	Evaluates to true if column 13 text contains "BC" (e.g., inside "ABCD").
`contains('Large' , col13) != true`	Prevents price update when column 13 contains "Large" (`!=` means Not Equal).
`left(col13, 2) == 'AB'`	Selects the first 2 characters from the left side of column 13.
`right(col13, 2) == 'CD'`	Selects the last 2 characters from the right side of column 13.
`mid(col13, 2, 2) == 'BC'`	Selects 2 characters starting from position 2 of column 13.
`len(col13) == 4`	Checks if total character count of column 13 equals 4.
`find('BC', col13) == 2`	Checks if string "BC" starts at character position 2 in column 13.
`substitute(col13, 'BC', 'XY') == 'AXYD'`	Replaces "BC" with "XY" inside column 13.
`max(price, col2, col3)`	Evaluates to the maximum value among price, column 2, and column 3 (e.g., `max(12,10,9) == 12`).
`min(price, col2, col3)`	Evaluates to the minimum value among price, column 2, and column 3 (e.g., `min(12,10,9) == 9`).

2. Markets Price Delimiter

Format incoming delimiter structures from your feed file using options: Comma, Decimal Point, or Auto.

Example: If your feed file contains 42.39.20 and you need to convert it to a standard decimal comma representation, select the Comma delimiter option.

3. Markets Price Round

Standardize product prices across your store by rounding numbers to consistent decimals or psychological price points.

Rounding Example	Result Showing
`##.00` or `##.000`	Converts `12.57` to `12.00`, or `12.573` to `12.000`.
`##.#0` or `##.#00`	Converts `12.57` to `12.50`, or `12.573` to `12.500`.
`##.##` or `##.##0`	Converts `12.57` to `12.57`, or `12.573` to `12.570`.
`##.##` or `##.###`	Keeps `12.57` as `12.57`, or `12.573` as `12.573` (no change).
`##.99`	Converts `12.570` to `12.599`.
`##.95`	Converts `12.57` to `12.95`.
`##.97`	Converts `12.57` to `12.97`.
`##.#99`	Converts `12.570` to `12.599`.
`##9.00`	Converts `121.57` to `129.00`.
`##5.00`	Converts `123.57` to `125.00`.
`##9.99`	Converts `127.57` to `129.99`.
`##,000.00`	Converts `12,453.57` to `12,000.00`.
`##,#00.00`	Converts `12,345.57` to `12,300.00`.
`##,##0.00`	Converts `12,346.57` to `12,340.00`.
`##,#99.00`	Converts `12,345.57` to `12,399.00`.
`##9`	Converts `12.57` to `12.90`, or `145.67` to `149.00` (third digit changes to 9 followed by 0).
`nearest whole number`	Converts `12.57` to `13.00`, or `135.33` to `136.00` (rounds up to next whole number).
`##5.00` (`0 <= x <= 5`) AND `##9.00` (Other)	Converts price to nearest ending digit of 5 or 9 (e.g., `133` becomes `135`).

4. Don't Update the Markets Price When...

Exclude specific products from receiving market price updates based on defined store attributes.

Exclude market price updates by Vendor, Product Type (Custom), Product Tags, or Custom Data (Metafields).

Example: Setting Don't update Markets Price when Vendor = Adibas will skip market price updates for all products under the vendor "Adibas".

Key Rules & Technical Details

Priority sequence: Price Conversion → Price Condition → Price Rounding

Market Requirement: The target market must exist in Shopify Admin before Stock Sync can update prices for it.
Combined Mapping Rule: Shopify API mandates that Markets - Compare at Price updates MUST be accompanied by a Markets - Price value in the same request.
Numeric vs Text Types: Use price_f or col#_f for numeric price evaluation; use price or col# for standard text matching.

Troubleshooting Steps

Issue: Markets Compare-at Price is not updating → Solution: Verify that Markets - Price is mapped in the same feed setup. Shopify blocks isolated compare-at price updates for markets.
Issue: Price condition rule is not applying → Solution: Ensure correct variable syntax is used (price_f for numerical comparisons, price for string operations).
Issue: Target market prices are not reflecting in store → Solution: Confirm that the market name and country codes configured in Smart Settings match the active market setup in Shopify Admin.

Good Articles to Continue

How to create a market via Shopify Admin → Step-by-step guide on setting up international markets in Shopify.

Updated on: 15/10/2026

Was this article helpful?

Thank you!