Price Field

Modified on Thu, 25 May 2023 at 12:20 PM






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




There are a few settings for this field which are:


1. Price Condition (Markup)

Price condition is used to add markup or margin to a product's price. The price condition can add a markdown if used for sales.

For more information on profit margin and markup, click here to learn the differences between profit margin and markup

Currency Conversion has the first priority compare to the Price Conditions.  



How to use Price Conditions according to the examples below:

Condition (If)

Price (Then)

Result Showing

current_price == 0

*0

If store price = 0

Then multiply by 0 (no changes made)

any

*1.5


All prices will be multiplied by 1.5 or 50%



col("Vendor") == "shoe"
*1.3 + col("shipping")
If column vendor has the value shoe, then multiply by 1.3 and add column shipping value to the price

It can be used for any column and is suitable for adding markup based on the conditions 

price_f > 10 and price_f <= 15

*1.2

If the price is more than 10 and equals or below 15, 


Then the price is multiplied by 1.2 or 20%  Use price_f when the comparison values are numeric


price_f ==11

*1.5

If the price is 11 

Then the price is multiplied by 1.5 or 50%


price > col1_f

*1 + col1 + col2

If the price is more than column 1, then add column 1 and column 2 to the price. 

Use col#_f when the comparison values are numeric                                                             

col5==“shoe”

*1.3

If column 5 has the value shoe, then multiply by 1.3

It can be used for any column and is suitable for adding markup based on collections

price_f < 1

*0 + current_price

If the price is less than 1


Then it will use the current price in-store (Shopify only).     

                                      

Use price_f when the comparison values are numeric

Price ==“high”

*1.2

If the price is equal to "high" 


Then multiply by 1.2         

                                                        

Use price when comparison values are text

any

*0.90

All the prices will be multiplied by 0.9 or 10% which means the price will be discounted by 10%

price ==“discount”

*0.50

If the price is equal to the "discount"


Then it will multiply by 0.50 0r 50% which markdown the price

cost < 40

*1.2

If the cost in the store is less than 40

Then multiply the price by 1.2

The cost value will be taken from the store. (Shopify only)

compare_at_price > 10

*1.5

If compare at price in the store is more than 10


Then multiply the price by 1.5

The compare at price value will be taken from the store. (Shopify only)


any

/0.2

All the prices will be divided by 0.2

col4_date > now

*1.2

If the col4 date is more than current_timestamp


Then multiply by 1.2                                      


Use col4_date when the comparison is a date 

Now refers to current_timestamp

col4_date > today

*1.2

If the col4 date is more than current_timestamp 


Then multiply by 1.2                                     


Use col4_date when the comparison is a date

Today refers to today’s date




There is little info regarding the price condition (markup) 

i. The Price Conditions take effect according to the arrangement. The first conditions have the highest priority. You can move it by using the arrow beside there according to your needs. 

ii. Stock Sync now supports Column Value.

iii. Valid price range keywords are:

  • price (Use it when the comparison value are text)
  • price_f (Use it when the comparison value are numeric)
  • col#_f (Use it when the comparison value are numeric)
  • any
  • current_price (Shopify only)
  • cost (Shopify only)
  • compare_at_price (Shopify only)

iv. The symbol that is used for the statement:

Symbol

Details

==

equal to

<=

less than or equal to

>=

more than or equal to

>

more than 

<

less than

and

only true when both statements are true

or

true when either statement is true



v. There is another method for pricing conditions that you can use:


    For example, col13 = 'ABCD'


Formulae

Explanation

contains('BC',col13)

If you want to select only 'BC' from the whole text 'ABCD'

contains('Large' , col13) != true


Don't update the price when it contains the word Large

!= (Not Equal)

left(col13, 2) == 'AB'


If you want to select only 2 letters from the left side of the whole text.

right(col13, 2) == 'CD'

If you want to select only 2 letters from the right side of the whole text.

mid(col13, 2, 2) == 'BC'

If you want to select only 2 letters in the middle of the whole text.

len(col13) == 4

If you want to select the whole text, the total number of letters must be indicated there. Example: 4 indicated the length of the letters.

find('BC', col13) == 2

If you want to find only 2 letters from the whole text.

substitute(col13, 'BC', 'XY') == 'AXYD'

If you want to substitute selected text from the whole text and replace it with another alphabet

max(price, col2, col3)

max(12,10,9) == 12

If you want to take the maximum value from the three-column you can use this method.

min(price, col2, col3)

max(12,10,9) == 9

If you want to take the minimum value from the three-column you can use this method.



2. Price Delimiter

The price delimiter provided in the price field has three options which are Comma, Decimal Point, and auto.  




3. Price Round

A price round is used to standardize the prices of the products in the store if a round number is used too often or the prices do not have a clear focus digit.

How to use Price Round according to the examples below:

Round off example

Result Showing

##.00 or ##.000

It will change it from 12.57 to 12.00 or 12.573 to 12.000

##.#0 or ##.#00

Change it from 12.57 to 12.50 or 12.573 to 12.500

##.## or ##.##0

Change it from 12.57 to 12.57 or 12.573 to 12.570

##.## or ##.###

Change it from 12.57 to 12.57 or 12.573 to 12.573 (Doesn't have any changes)

##.99

Change it from 12.570 to 12.599

##.95

Change it from 12.57 to 12.95

##.97

Change it from 12.57 to 12.97

##.#99

Change it from 12.570 to 12.599

##9.00

Change it from 121.57 to 129.00

##5.00

Change it from 123.57 to 125.00

##9.99

Change it from 127.57 to 129.99

##,000.00

Change it from 12,453.57 to 12,000.00

##,#00.00

Change it from 12,345.57 to 12,300.00

##,##0.00

Change it from 12,346.57 to 12,340.00

##,#99.00

Change it from 12,345.57 to 12,399.00

##9 (from #.#9 to ##9,000). eg. 129000, 12900, 1290, 129, 12.9...

Change it from 12.57 to 12.90 or 145.67 to 149.00


All the third digits of the number will change to 9 followed by 0.

nearest whole number (from #1.## to #2.00)

Change it from 12.57 to 13.00 or 135.33 to 136.00


Every whole number will be rounded up, its meant added by 1




4. Currency Converter

If the value of the prices provided in the feed is in a different currency than the currency that's in the store.

For example:

If the supplier feed currency = MYR
And the store currency = USD

Enable the Currency Converter and enter the currency in the fields above




5. Don't update the price when ...

Exclude certain products from updating the price using this option. It can be excluded by Vendor, Product Type (Custom), and Product Tags.


For example:

Dont update Price when Vendor = Adibas

All products price of Vendor Adibas will not be updated.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article