How to bulk upload to Etsy (With Variations)

Updated Sep 26, 2022

3 min read

How to Bulk Upload Product Variations to Etsy

Shop Uploader lets you bulk upload listings to Etsy with a simple spreadsheet.

This tutorial will show you how to upload a product with variations. Etsy product variations can have 2 options and a different SKU, inventory quantity, and price. We're going to focus on the changes you need to make when working with variations. Visit the full guide for a deep dive into bulk uploading products to Etsy.

These sections are:

  • Title
  • Description
  • SKU and Parent SKU
  • Styles, Tags, and Materials

Let’s get started.

Title and Description

To begin, fill out the title and description of your listings. Remember, your title needs to follow Etsy’s Title Requirements.

You NEED to have the SAME title for all variations of the same product. If you have different titles for your variations, you will make a new listing for each.

Referring back to our ship example, we had 4 variations. This means we need to have the same title for 4 rows in the excel document.

Example of Etsy title infromation entered into a Shop Uploader template

You need to follow Etsy’s Seller Policy to avoid getting into trouble with your description. When dealing with variations, you have two options for posting your description. The first is to post the same description in all rows. The second is to place it in the first row and leave the other rows blank. Remember, Etsy only shows the first 160 characters in its search results.

For this example, here is our description:

Example of Etsy description entered into a Shop Uploader template

SKU and Parent SKU

SKUs help differentiate between variations of the same product. They are mandatory and are limited to a max of 32 characters.

Your listing Needs to have a Parent SKU. They are mandatory and are limited to a max of 32 characters. Your Parent SKU must be the same for each variation of a product. If it is different, you will be creating a new listing for each variation.

For this example, here is our SKU setup:

Example of Etsy SKU and parent SKU entered into a Shop Uploader template

Styles, Tags, and Materials

Style_# gives the overarching broad art category your product falls into. Etsy has various predefined styles you can choose from, but you can also import your own. The predefined options differ slightly depending on what you are listing. We recommend going to Etsy, selecting your category, then taking a style option from there.

Tag_# is a word or short phrase that describes your item. Tags can be up to 20 characters long, and you can have up to 13 per listing.

Material_# is what materials make up the product. Each number will be for one material.

These are our style, tags, and materials:

Example of Etsy tags and materials entered into a Shop Uploader template

Production Partner(s)

Production_partner_# is generated by Etsy. You can access these on the Shop Page (must be logged in).

Uploading Your File

Now that you've completed your template, head on over to the Uploads Page (must be logged in) to complete your first bulk upload.

The most powerful
tool for Etsy sellers