How to Use Custom Formulas When Importing Products in Sync Master

Products Sync Master for Shopify allows you to create custom fields with formulas when importing products. Using existing fields and their values from your import file, you can easily generate new fields or modify existing ones with simple formula logic.

How It Works

Suppose you want to adjust product prices during import based on their collections:

• Increase the price of all products in the “T-Shirts” collection by +10%.
• Increase the price of products in the “Sunglasses” collection by +20%.
• Reduce the price of products in the “Shorts” collection by –5%.

Normally, this would require manual edits across thousands of products. With formulas, Sync Master can do this automatically in just a few clicks.

Step 1: Upload Your File

Choose your import file and click «Next»:

Step 2: Open the “Custom Fields” Tab

Go to the «Custom fields» tab. Important: to keep existing prices for all other collections, you must specify this in your formulas. Otherwise, products not included in the formulas will be imported with a zero price.

Set a rule to preserve prices for products not included in the modified collections:

Step 3: Create a Formula for Each Condition

Increase “T-Shirts” Prices by 10%

Add a new condition and define your formula to increase the price:

Increase “Sunglasses” Prices by 20%

Create another condition for the “Sunglasses” collection:

Reduce “Shorts” Prices by 5%

Finally, add a condition for the “Shorts” collection:

Step 4: Map the Custom Field

Now go to the «Pricing» tab and select the custom field you created (for example, new_price) as the value for the Price field:

Step 5: Review and Import

Check your source file data:

Compare it with the imported result — your formulas should apply automatically, updating product prices according to your defined rules.

That’s it! You can use formulas not only for prices but also to modify quantities, product names, or other custom fields — giving you full control over the import process.