Articles on: Matching Column

SKU Field

Configure and customize product SKUs when importing, updating, or exporting inventory. Use custom text formatting, prefixes, and suffixes to standardize SKU identifiers across your store and feed files.

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

To learn how to add extra text to the beginning or end of the SKU field, click here.

How to Set Up the SKU Field

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

Locate SKU Field: In the mapping list, find the SKU field row.
Select Feed Column: Map the SKU field to the corresponding column from your source feed, or leave it blank to generate custom SKUs.
Open Settings: Click the Settings (gear icon) next to the SKU field to configure custom text, prefixes, or formatting rules.

Always ensure the SKU format in your feed file strictly matches the identifier format used in your store.

SKU Field Setup

SKU Field Smart Settings / Detailed Breakdown

1. Custom Text and Formatting

Add static prefixes, suffixes, or dynamic column values to your SKUs even if your feed file lacks a dedicated SKU column.

Custom Text SKU Formatting

Example: Entering XYZ{{SKU}} prepends XYZ to each incoming SKU value.

Result with prefix: Source values 168, 163, 162 become XYZ168, XYZ163, and XYZ162.

Key Rules & Technical Details

Matching Exclusions: When SKU is selected as the Unique Product Identifier in Step 2, Stock Sync uses it only for matching existing products and will not overwrite or change the SKU in your store during an update.
Overwriting Existing SKUs: To update or overwrite existing SKUs in your store, temporarily switch your Unique Product Identifier to another attribute (such as Barcode or Product Title), map the new SKU column, and run the update feed.
Leading Characters: Ensure SKUs in your CSV feed do not contain unwanted leading characters like apostrophes (e.g., '1234), as these cause matching mismatches.
Prefix Consistency: If your store SKUs include prefixes that are missing from the CSV (e.g., store SKU is DS-123 but the CSV contains 123), configure the prefix under SKU field settings so Stock Sync can locate the match correctly.

Troubleshooting Steps

Issue: Products are skipped or not matching existing store items → Solution: Verify whether your store SKUs have prefixes (e.g., DS-) that are missing in the feed, and ensure no leading apostrophes exist in the CSV file.
Issue: SKU field in store is not updating to the new feed value → Solution: Change the Unique Product Identifier in Step 2 from SKU to Barcode or Product Title, map the new SKU column, and rerun the update.
Issue: Custom text placeholder is not generating the expected SKU → Solution: Ensure dynamic column names inside the placeholder match the feed column exactly and are enclosed in double curly brackets (e.g., {{SKU}}).

Good Articles to Continue

Custom Text Formatting in Description, Vendor, Title, and SKU Fields → Step-by-step guide to applying custom prefix, suffix, and static text formatting.
How to Set Up Unique Product Identifiers → Learn how to select and configure matching identifiers to prevent duplicate products.

Updated on: 28/10/2026

Was this article helpful?

Thank you!