Articles on: Frequently Asked Questions (FAQ)

Can we add a prefix or postfix during the add process?

Yes, you can automatically add a prefix or postfix to your product SKUs during the Add Feed process. This can be configured by applying dynamic custom text formatting in your field mapping or by using the Prefix Smart Setting in your matching column.

Available on: ✔️ Add | ✔️ Update

How to Set Up a Prefix or Postfix

Go to App → Feed Settings → Step 2: Matching Column → Product Identifier

Locate SKU Field: Find the SKU field in your field mapping list.
Select Custom Format: Choose the Custom Format option from the column mapping dropdown.
Enter Format Syntax: Wrap your feed file column name inside double curly brackets {{...}} and type your prefix before it or postfix after it.
Save Settings: Click Save Settings to apply your custom SKU structure to all imported products.

Always wrap your source column name in double curly brackets (e.g., {{SKU}}) so Stock Sync dynamically pulls each item's SKU value.

SKU Prefix and Postfix Methods Breakdown

1. Custom Text Formatting (Field Mapping)

Custom text formatting allows you to insert static text, vendor codes, or symbols directly before (prefix), after (postfix), or on both sides of your SKU value.

To add a prefix, enter your custom text immediately before the column placeholder (e.g., ABC{{SKU}}).

To add a postfix, enter your custom text immediately after the column placeholder (e.g., {{SKU}}PART).

Add Prefix Custom Format

Add Postfix Custom Format

Formatting Type	Source Feed Value	Custom Format Syntax	Resulting Shopify SKU
Prefix	`1234`	`ABC{{SKU}}`	`ABC1234`
Postfix	`1234`	`{{SKU}}PART`	`1234PART`
Prefix & Postfix	`1234`	`ABC-{{SKU}}-PART`	`ABC-1234-PART`

2. Prefix Smart Setting (Step 2: Matching Column)

Alternatively, you can add a prefix directly from the matching configuration step using the built-in Smart Setting.

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

Select Identifier: Choose your source SKU column in the matching column dropdown.
Open Smart Settings: Click the Smart Setting (gear icon) next to the selected SKU column.
Enter Prefix: Locate the Prefix field and enter your static prefix characters.

The Smart Setting option in Step 2 only supports prefixes; use Custom Formatting in Step 4 if you need a postfix.

Key Rules & Technical Details

Case Sensitivity: The column name inside {{...}} must match your feed file header exactly (e.g., if your feed header is sku_number, enter {{sku_number}}).
Subsequent Update Feeds: If you add a prefix or postfix in an Add Feed, the product will be created in Shopify with that modified SKU. Any subsequent Update Feeds must use matching identifier logic to locate and update the item.

Priority rule: If you apply a prefix in Step 2: Matching Column, Stock Sync searches Shopify for the SKU after the prefix has been attached.

Troubleshooting Steps

Issue: The imported product displays literal text {{SKU}} in Shopify. → Solution: Ensure your feed column name inside the double brackets matches the source file column header exactly.
Issue: Update Feeds fail to update products created with a prefix/postfix. → Solution: Configure the same prefix or postfix rules in your Update Feed so the identifier matches the modified Shopify SKU.

Good Articles to Continue

[Custom Text Formatting in Description, Vendor, Title, and SKU Fields] → Learn how to apply custom text formulas and concatenate multiple columns across other product fields.

Updated on: 03/11/2026

Was this article helpful?

Thank you!