First, review the Product CSV Template in Sellbrite

To do this, click Settings > Export Data > Products - Template Only

Open the Product CSV Template in Excel or any spreadsheet application. Review the Variation Product in the file to see how it looks.

You'll see an example of the variation with the Parent SKU SBTSHIRT.

Key Points:

  • Parent SKU is assigned in the second column. This SKU is NOT used for the actual Parent row, only the variation rows, in order to group the variations with the Parent.
  • Variation names (Size, Color) will live on the Parent row, and variation values (Small, Blue) will live on the Variant rows.

Add your Parent & Variation SKUs

Go back to Settings > Export Data, but this time select Products - All Data. Filter by a specific Product Category if desired.

Delete everything except for the top 3 header rows, and the products you want to group together.

Find the row that you wish to use as your Parent, then add subsequent Variation rows beneath it. Make sure to enter the Parent SKU for each variation row. Leave the Parent SKU column blank for the Parent.

Update the variation column for each of the rows. For the Parent, enter the variation option (Size,Color). For the Variations, enter the actual variation value (Small, Blue). Be consistent with your formatting and capitalization, and only enter one value in each cell.

Products can vary on up to 5 different things.

 
Save the Spreadsheet as a new CSV file. You may want to rename it.

To import the data back into Sellbrite, Click Settings > Import Data > Products - CSV File

Select the saved file you created. When the file finishes uploading, your Variation Product will be built properly, with a Parent Product, and any Variations all together as a grouped family.

Did this answer your question?