Batch Group Related/Variant Items

This function is available on the Newegg.com, Neweggbusiness.com and Newegg.ca platforms.

This guide is ONLY for creating variations while creating a new item at the same time. To group existing items together, please email: Newegg Marketplace Content Team at mktp.content@newegg.com.

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 our enabled group-by subcategories.

How-To Batch Create Product Variants:

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.