Batch Group Related/Variant Items

Available on the Newegg.com, Neweggbusiness.com, and Newegg.ca platforms.

NOTE:
Starting from July 21, 2025, if the old template is used to submit products, only individual item creation will be supported. Variant grouping will no longer be processed using the legacy group-by property.

For updated variant grouping information click here.

To make sure customers can find all your products easily, you should group the same product with multiple variations together, such as a chair with different color options. Doing this can show customers all the product variations you have on one page so customers do not have to find the different product variations on multiple product pages.

In order to create product variations, follow these steps.

Click here to download a list of the subcategories where grouping is possible.

How-To Batch Create Product Variants:

This section is ONLY for creating variations when creating new items using Batch Item Creation.

1. Download the “group-by” enabled subcategory-specific template:
   1. Go to Seller Portal and hover your mouse pointer over the list icon (upper left corner) then select Items > Batch Item Creation/Update.
   2. Click Download File Template tab.
   3. Select Batch Item Creation.
   4. Select Template File Type (Recommend Excel).
   5. Pick an Industry and Category.
   6. Click DOWNLOAD FILE TEMPLATE.
2. Input each variant item in the template:
   1. Open file, refer to instructions and basic item info sheets for additional information.
   2. Input each variant on a separate row under the datafeed sheet.
   3. You must assign unique values for the seller part #, manufacturer part #, and UPC.
   4. All required header names in red font must be entered to complete.
3. Set up the variant item’s relationship:
   1. Enter the parent SKU seller part # into the child SKU Related Seller Part # field.
   2. Leave the parent SKU Related Seller Part # field BLANK.
4. Fill in ALL “group-by” properties:
   • A  group-by property is a variant attribute option.
   • Each subcategory has its own set of group-by properties.
   • The Data Feed Template in the MS Excel format will mark all of the subcategory group-by properties with header names in blue font.
   • The cell will provide a dropdown menu with all available “group-by” property values. Select the appropriate value for the “group-by” property.  If the value does not exist, please contact our Newegg Content team to request that it can be added.
5. Uploading the template:
   1. Save file.
   2. Click Upload File tab.
   3. Click Select files… to upload the file from local drive.
   4. Click UPLOAD FILES.
6. Check if the template uploaded successfully or failed under Uploaded File Status and History:
   1. Click Upload File tab.
   2. By default, the Date field, Newegg provides the last 3 days of upload.  Adjust the filter accordingly.
   3. Click REFRESH LIST to check the Status of upload.
   4. Click View Details if there are any errors when the upload has been completed.
7. On the product page, the items will show variation options.  Note: After successfully creating the variation, allow at least 24 hours for it to reflect.

How-To use Batch Item Grouping:

This section is ONLY for creating variations from items that already exist in your account that are active and that allow for grouping.

1. Navigate to the SP > Items > Batch Item Grouping
   
2. Download the Batch_Group_Items template
   
3. Add your pre-existing active items to the template
   Please note that you do not have to group the item with itself
   (Ex.  MyBrush-BLK / MyBrush-BLK   will be ignored)
   
4. Click Select files… to upload the file from local drive.
5. Click UPLOAD FILES.
6. Click REFRESH LIST to check the Status of upload.
7. Click View Details if there are any errors when the upload has been completed.

For additional assistance contact our Content team at Mktp.content@newegg.com