Products Sync Master service for Shopify allows you to create the fields you need with special formulas when importing products into Shopify. Using the already available fields and their values in the imported file, you can create a new field or field with your formula:

How does it work? Suppose, when importing from your file, you need to increase the price of all products in the "T-Shirts" collection by +10%. Also, you want to increase the price of products from the "Sunglasses" Collection by +20%, and reduce the price of the "Shorts" collection by -5%. It would be very boring and time will leave consuming to change the price manually. Especially if the assortment of goods in each collection totals several hundred thousand products. But with the new functionality of our app, it is enough to simply use simple formulas and the script will do everything for you.

Let's get started. Choose our file to import and move on by clicking «Next»:

Now open the «Additional Settings» tab. Important note! To save product prices in other collections, you must definitely indicate this in the "fields". Otherwise, the app imports goods from other collections at zero price. Let's indicate that the prices of products in other collections remain the same as in our file:

Next, we create a similar condition for the «Sunglasses» collection:

 

 

and condition for the «Shorts» collection:

 

 

 

Don't forget to save changes!

 

 

Now go to the «Pricing» tab and select the value of the field "Price" created by us a custom field "new_price":

 

Done! Now we can start importing. Let's look at the data in our file for a start:

 

 

Compare the data with the import result on our website. Our formulas worked successfully. In the same way, we can fully control the data when importing. Thus, you can change the quantity, change the name, custom fields, and more.