Bulk Assigning Standard Products to Variant Products

Product Assignment Overview

What is Product Assignment?

Product assignment allows you to convert existing Standard Products (standalone products with no variations) into Variant Products (specific configurations of a parent product). When you assign a standard product to a variant product:

1. The standard product is converted into a variant of the parent variant product
2. The variant receives the selected option values (e.g., Length=8', Grade=SPF)
3. The original standard product is marked as deleted
4. The variant becomes part of the parent product's variant list

CSV File Format

Required Headers

When creating your CSV file for bulk product assignment, include the following headers:

• SKU (required): The SKU of the standard product that you want to assign to a variant product. This product must exist in your catalog and be a standard product. If the product has variants, it is a parent product and cannot be assigned.
• Parent SKU (required): The SKU of the parent variant product that the standard product will be assigned to. This must be a variant product that already has variant options defined.
• Option 1, Value 1 (required): First variant option name and value
• Option 2, Value 2 (required if parent has 2+ options): Second variant option name and value
• Continue with Option N, Value N for as many variant options as the parent product has

Example: Assigning Products to Variants

You can download the above CSV template here.

Uploading Products

Assigning Standard Products to Variants

To assign standard products to variant products via bulk upload:

1. Navigate to Catalog > Products > Bulk Upload
2. Select Assign Products to Variants from the upload type dropdown
3. Upload your CSV file with the required headers
4. Review the result file to see successfully assigned products and any errors

Note: Product assignment is catalog-specific, meaning the assignment affects the product structure across all stores. Once assigned, the variant will be available at all store locations. Store-specific attributes (like pricing and availability) are preserved during assignment.

Error Handling & Validation

When uploading products via CSV for assignment, the system performs automatic checks to ensure the data is valid. If any issues are found, an error log will be generated for you to review and correct. Here are the common error types and how to resolve them:

1. Required Fields

Issue: Required fields such as SKU or Parent SKU are missing from your CSV file.

Fields: SKU, Parent SKU

Resolution: Ensure all required fields are populated in your CSV file. Each row must have both a SKU and Parent SKU value.

Example Errors:

• "SKU cannot be empty"
• "Parent SKU cannot be empty"

2. Product Not Found

Issue: The SKU or Parent SKU specified does not exist in your catalog, or the Parent SKU is not a variant product.

Fields: SKU, Parent SKU

Resolution: Verify that both SKUs exist in your catalog. The Parent SKU must be a variant product with variant options defined. You can use the Bulk Download feature to get a list of all product SKUs.

Example Errors:

• "Product not found with SKU: [SKU]"
• "Parent product not found with SKU: [Parent SKU]"

3. Invalid Product Structure

Issue: The product is a parent product (it has variants), or the SKU and Parent SKU are the same.

Field: SKU

Resolution: Only standard products can be assigned. If a product has variants, it is a parent product and cannot be assigned. Also ensure that SKU and Parent SKU are different values.

Example Errors:

• "Product must be a standard product to be assigned"
• "SKU and Parent SKU cannot be the same"

4. Invalid Option Names or Values

Issue: Option names don't match the parent product's variant options, option values are invalid, or required options are missing.

Fields: Option 1, Value 1, Option 2, Value 2, etc.

Resolution: You must provide all variant options that the parent product has. Option names must exactly match the variant option names defined on the parent product (case-sensitive). Option values must be valid values that exist for each option. Verify the exact option names and valid values using the Bulk Download feature or by viewing the parent product in the Products tab.

Example Errors:

• "Missing required variant options. Parent product requires [number] options"
• "Option name 'Length' does not match parent product options"
• "Value '20'' is not valid for option 'Length (ft)'"

5. Duplicate Options or Combinations

Issue: The same option name appears multiple times in a row, or the combination of option values already exists.

Fields: Option 1, Option 2, Value 1, Value 2, etc.

Resolution: Each option name must be unique within a row. Each combination of option values must be unique - you cannot assign two products to the same variant combination. Check if the combination already exists as a variant on the parent product or appears in another row of your CSV file.

Example Errors:

• "Duplicate option name: [Option Name]"
• "Variant combination already exists for parent product"

Error Logs and Troubleshooting

After uploading your CSV file, you can access error logs and results:

1. Go to Dealer Admin > Reports > Bulk Upload History
2. Find your upload job in the list
3. Click Download to get the result file

The error log file contains all rows from your original CSV file, plus a Message column indicating the status (Success, Error, or Skipped) and a Message Detail column with specific error messages.

Example Error Log:

You can download the above CSV template here

Limitations and Considerations