Identifier Column in Product-Level Spreadsheet

It is important to understand how Ablestar Bulk Product Editor handles the first column identifier on spreadsheet edits for Product-level data.

When you export or import any store data, we want to make sure we can easily identify if you are trying to update all products or all variants, or both.

Importing and exporting spreadsheets is simple if you keep in mind the Variant-level and Product-level identifiers:

1. Exports

From the export view, choose which column you would like as the "identifier" to be noted in the first column of your export. This helps as a reminder that when you are editing a product-level identifier, the edit will change only product (and product variants if included)

Each dropdown option is considered either product-level or variant-level (and sometimes both):

• Barcode: product level
• Product Handle: product level
• Product ID: product level
• Product Title: product level
• SKU: Both variant and product-level (as long as each SKU is unique)
• Variant ID: variant level only

When you choose a product-level option like 'Product Handle' or 'Product ID' to export, we configure the first-column identifier with that option, similar to this layout:

2. Configuring Spreadsheets

When you are bulk importing spreadsheet data for product detail, the identifier can be:

• Barcode
• Product Handle
• Product Title
• Product ID
• SKU

From the mapping view, click 'Advanced options' to change the Identifier option if needed:

3. Special Case Exception

There could be times when you want to update all products and product variants to the same value. In the example of changing all price (variant) fields to $19.99 you could use a product-level import as:

✅ Tips and Troubleshooting

• Get an overview of Variant-level and Product-level identifiers.
• Learn specific info on file formats

(04.118)