I am having trouble mapping my source file columns. What are the column headers/index? What do the various attributes do?
The Source Mapping Column section tells Stock Sync which column of your source file to read for each field. You can enter either the column header or the column number (index), so it is important to get this right when mapping your file.
How Column Headers and Indexes Work
- Column header: The header is the text in the first (topmost) row of your source file. It must match the header in your file exactly.
- Column index: The leftmost column is index 1, the next column is index 2, and so on.
We recommend using the column index rather than the column header, because it is safer. Headers can change or contain small differences that stop the match.
Source Mapping Column Settings
1. Prefix & Store Prefix
This removes the leading product identifier from the source file value, using the characters you enter.
Example: If the SKU in your source file is ABC1001121 and you enter ABC, then 1001121 is matched against the SKUs in your store.
2. Product Key, Quantity Key, Selling Price Key, and Barcode Key
Enter the column header or column index of each field in your source file.
Example: The header SKU for the product key, and the header Qty for the quantity key.
Key Rules & Technical Details
- Exact match: A column header must match your source file exactly, including spelling and capitalization.
- Index first: Use the column index whenever possible, as it is the safer option.
Troubleshooting Steps
- Issue: The column is not found → Solution: Check that the header matches the first row of your file exactly, or switch to the column index.
- Issue: Values are read from the wrong column → Solution: Check the column number. The leftmost column is index 1.
- Issue: SKUs do not match your store after the prefix is applied → Solution: Check the characters you entered in the prefix field against the start of the source SKU.
Good Articles to Continue
- Product Identifier Field → Learn how to set the identifier used to match products in your feeds.
- Quantity Field → See the quantity options, including how stock is updated.
- What is the difference between Add feed and Update feed in Stock Sync? → Choose the right feed type for new or existing products.
Updated on: 16/11/2026
Thank you!
