---
title: Bulk Assigning Standard Products to Variant Products
description: Convert existing standard products into variant products using CSV file uploads. The bulk assign feature allows you to quickly reorganize your product catalog by assigning standalone products to parent variant products, creating a more organized and scalable catalog structure.
---
[Skip to content](https://support.toolbx.com/bulk-assigning-standard-products-to-variant-products#main-content)
English
Show submenu for translations
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Contact us](mailto:support@toolbx.com)
[Contact us](mailto:support@toolbx.com)
How can we help you?
- There are no suggestions because the search field is empty.
1. [TOOLBX Help Center](https://support.toolbx.com/)
2. [Products & catalog management](https://support.toolbx.com/products-catalog-management)
3. [Catalog management](https://support.toolbx.com/products-catalog-management#catalog-management)
March 19, 2026
# Bulk Assigning Standard Products to Variant Products
## Convert existing standard products into variant products using CSV file uploads. The bulk assign feature allows you to quickly reorganize your product catalog by assigning standalone products to parent variant products, creating a more organized and scalable catalog structure.
### **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
**Important**: You must provide all variant options that the parent product has. Option and values need to be created on the target product before doing any assignments. Option names must exactly match the parent product's variant option names (case-sensitive), and option values must be valid values that exist for each option.
#### **Example: Assigning Products to Variants**
| **SKU** | **Parent SKU** | **Option 1** | **Value 1** | **Option 2** | **Value 2** |
| --- | --- | --- | --- | --- | --- |
| 2x4x8-spf | 24SPF | Length (ft) | 8' | Grade | SPF |
| 2x4x10-spf | 24SPF | Length (ft) | 10' | Grade | SPF |
| 2x4x12-spf | 24SPF | Length (ft) | 12' | Grade | SPF |
| 2x4x16-spf | 24SPF | Length (ft) | 16' | Grade | SPF |
| 2x4x8-2btr | 24SPF | Length (ft) | 8' | Grade | #2&BTR |
| 2x4x10-2btr | 24SPF | Length (ft) | 10' | Grade | #2&BTR |
You can download the above CSV template [here.](https://docs.google.com/spreadsheets/d/1LDO5Rkir4KIAYdXC7aNlHBI6pxpaZWVaBTDL8XqHjss/edit?usp=sharing)
### **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**:
| **SKU** | **Parent SKU** | **Option 1** | **Value 1** | **Option 2** | **Value 2** | **Message** | **Message Detail** |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 2x4x8-spf | 24SPF | Length (ft) | 8' | Grade | SPF | Success | |
| invalid-sku | 24SPF | Length (ft) | 10' | Grade | SPF | Error | Product not found with SKU: invalid-sku |
| 2x4x12-spf | 24SPF | Length (ft) | 12' | Grade | SPF | Error | Variant combination already exists for parent product |
You can download the above CSV template here
#### **Limitations and Considerations**
**Important Notes**:
- **Permanent Action**: Assigning a product is a permanent action. The original standard product is marked as deleted.
- **Product Requirements**: Only standard products can be assigned. If a product has variants, it is a parent product and cannot be assigned.
- **Store Impact**: Assignments affect all stores. The variant will be available across all locations.
- **Cannot Reverse**: Once a product is assigned, the original standard product is deleted and cannot be easily restored.
- [Getting started](https://support.toolbx.com/getting-started)
- [Release notes](https://support.toolbx.com/release-notes)
- [Toolbx Admin](https://support.toolbx.com/toolbx-admin)
- [Storefront](https://support.toolbx.com/storefront)
- [Quotes](https://support.toolbx.com/quotes)
- [Payments](https://support.toolbx.com/payments)
- [Products & catalog management](https://support.toolbx.com/products-catalog-management#main-content)
- [Product setup & details](https://support.toolbx.com/products-catalog-management#product-setup-details)
- [Catalog management](https://support.toolbx.com/products-catalog-management#catalog-management)
- [Google Shopping & Local Listings](https://support.toolbx.com/products-catalog-management#google-shopping-local-listings)
- [Customers](https://support.toolbx.com/customers)
- [Documents](https://support.toolbx.com/documents)
- [Fraud & risk management](https://support.toolbx.com/fraud-risk-management)
- [Dispute management](https://support.toolbx.com/dispute-management)
- [Taxes](https://support.toolbx.com/taxes)
- [ACH](https://support.toolbx.com/ach)
[](https://www.toolbx.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, Toolbx