Mapping Fields: SKU, Barcode, Price, and Inventory

Created by Stacey Kim, Modified on Tue, 17 Feb at 11:20 PM by Stacey Kim

Field mapping tells Alterify how your source file relates to your BigCommerce products. You set this up once

per profile — every future sync reuses the same mapping.

How Mapping Works

Mapping has two parts:

Matching — How Alterify identifies which row in your file corresponds to which product in your store.
Updating — Which product fields to overwrite with data from your file.

Step 1: Choose How to Match Products

In the Match products by dropdown, select the identifier that your file and BigCommerce store have in common:

Option	When to Use
SKU	Most common. Use this if your file and your BigCommerce products share the same SKU values.
UPC/EAN (Barcode)	Use this if your file contains barcode numbers that match the UPC/EAN field in BigCommerce.

In the Column name field, type the exact header from your file that contains the identifier. For example, if your CSV has a column called item_sku, type item_sku.

Important: The column name must match your file's header exactly, including capitalization and spacing.

Step 2: Add Fields to Update

Click + Add Field to add each product field you want Alterify to update. For each field, select the type and enter the matching column name from your file.

Field Type	What It Updates in BigCommerce	Example Column Name
Product Title	The product name displayed on your store	`product_name`
Quantity	Inventory / stock level	`qty_on_hand`
Price	Regular product price	`retail_price`
Sale Price	Discounted / promotional price	`sale_price`

You can add multiple fields to a single profile. For example, you might update both Quantity and Price from the same file.

Example

Say your supplier sends a CSV that looks like this:

sku	stock	wholesale_price
ABC-001	54	12.99
ABC-002	0	24.50

Your mapping would be:

Match products by: SKU — Column name: sku
Field 1: Quantity — Column name: stock
Field 2: Price — Column name: wholesale_price

Tips

You only need to map columns you want to update. If your file has 20 columns but you only need inventory, just add the Quantity field. Everything else is ignored.
Each field type can only be used once per profile. You can't map two different columns to Price in the same profile.
The identifier column is separate from update fields. The SKU or barcode column is only used for matching — it won't overwrite your BigCommerce SKU values.
If column names change, update the mapping. Click Edit Settings from the profile's actions dropdown and adjust the column names.