Last updated: Oct 25, 2023

Template Documentation

Shop Uploader is a tool for bulk uploading listings to Etsy.

This documentation is reference material for the upload templates.
Whenever you have a question about the template, you can find the answer here.

Looking for more in-depth info? See our Guides & Documentation.

Some terms need to be clarified before we jump into the meat of the page.

CategoryDescription
DescriptionDescribes what the column does
Allowed ValuesThe types of values you are allowed to enter into the field
RequiredYour input MUST satisfy these requirements
LimitationsYour input MUST obey these limitations
ExampleSome examples of valid field entries
column_set: ids
required

Description

The numeric ID for an Etsy listing. Generated by Etsy.

Leave the listing_id blank in your template to create new listings.

Provide a listing_id in your template to update an existing listing.

For existing listings, you can find listing_ids by clicking Start Export on the Exports page in the Download Listings section.

Allowed Values

Digits (0-9)

Requirements

Must be a whole number

Limitations

listing_id must match a listing in your Etsy shop

Examples

100000020346882686505
column_set: ids
required

Description

The numeric ID for an Etsy product variation. Generated by Etsy.

Required to partial_update variations.

Exports with variations will include your product_ids. Exports are found on the Exports page.

Etsy may change the product_id whenever you make changes to a listing's variations.

Allowed Values

Digits (0-9)

Requirements

Must be a whole number

Limitations

product_id must match a listing variation in your Etsy shop (you have to export them)

Examples

100000020346882686505
column_set: ids
related docs: variations
required

Description

The parent_sku is a string that combines rows together to create variations.

Any rows with the same parent_sku will be variations inside one listing.

The parent_sku is not actually uploaded to Etsy, it is just used to describe which rows in the template belong together.

Related documentation: Variations

Allowed Values

A-Z , 0-9 , - , _

Limitations

  • Max 32 characters

  • Cannot use spaces in your parent_sku

Examples

TOY-TRUKAP_00270012300

Details

Your parent_sku should be formatted similar to the SKU.

Sometimes Shop Uploader will need to create dummy products for your Etsy listings and it will use the parent_sku to generate the dummy SKU.

Important Note: You should not use spaces in your parent_sku. If you need something like spaces use _ or - as separators instead.

column_set: ids
required

Description

The stock-keeping unit for your item.

The SKU must be unique for each product.

Important Note: You should not use spaces in your SKUs. If you need something like spaces use _ or - as separators instead.

Allowed Values

A-Z , a-z , 0-9 , ( ) [ ] - _

Requirements

Min 1 character

Limitations

  • Max 32 characters

  • Cannot use ~ ` ! @ # $ % ^ & * = + \ | / ? . , > <

  • Cannot end with ( [ {

Examples

TOY-TRUK-50-REDAP_0027_SM_BLU0012345

Details

Your SKU should provide useful information about the item to make it easily identifiable. If you don't have a SKU and don't want to create one, you can instead just provide random valid characters.

column_set: sales_copy
required

Description

This is the title of your listing. A well crafted title will appear higher in search and entice shoppers to click on your listing.

There is only one title for a listing. Even if you provide a different title for each product variation, only the first title will be used.

Etsy's Title Requirements

Allowed Values

A-Z , a-z , 0-9 , ! @ # % & * ( ) - _ + / . , = | \ [ ] { } : ; " ' < > ? ~

Requirements

Limitations

  • Must start with a letter or number

  • Max 140 characters

  • Only one of each + : % &

  • Cannot use $ ^ `

  • Cannot have more than three words in all upper case

Examples

Red Rooster RunaroundPurple Platypus PinataGreen Guacamole Gym
column_set: sales_copy
required

Description

This tells the customers what they are buying in greater detail than the title. Here you can provide more details about the product, the services you offer, shipping, and return information.

Forum post with a list of usable special characters.

Allowed Values

A-Z , a-z , 0-9 , ` ~ ! @ # $ % ^ & * ( ) - _ = + [ ] { } | \ / ? < > , . , Emojis 👍

Requirements

Limitations

  • Min 1 character

  • Max 102,400 characters

  • Only shows the first 160 in the search results

Examples

A great runaround for your rooster. Colored in firetruck red. It is sure to please the man of the yard this holiday season!This great Platypus pinata will be a delight for any birthday party. Comes in regal purple and can hold up to five pounds of assorted candies!A great addition to your little tike's collection of play environments. Give them the authentic feel of a gym, without any of the hazards, with our green guacamole gym.
column_set: item
required

Description

This is the price you want to sell your product for.

Allowed Values

0-9 , .

Requirements

  • Must be a number

  • Min 0.20 USD equivalent (after conversion)

Limitations

Max 50,000.00 USD

Examples

15.285896.344

Details

Make sure you account for Etsy fees when setting your price.

Etsy charges a $0.20 listing fee

5% transaction fee of the price you charge

5% shipping fee of the total cost your customers pay

Payment processing fee of 3% + $0.25 per transaction

2.5% currency conversion fee.

Learn more about Etsy fees.

column_set: item
required

Description

How much of the item you have in your inventory. Enter the individual amounts for each variation.

Etsy shows the product's total quantity on its website. This is the sum of all your variation's quantities.

Allowed Values

Digits (0-9)

Requirements

  • Must be greater than or equal to 1

  • Must be a whole number

Limitations

  • Etsy will only display quantities up to 999.

  • You can enter any positive quantity in Shop Uploader, however, it will be capped at 999.

Examples

12867456
column_set: item
required

Description

Category defines what kind of product you're selling and where it should appear in Etsy searches.

Category is the most important product data and significantly impacts SEO.

You can add categories to your templates when creating them.

Allowed Values

Any of the categories you selected when generating your template.

Requirements

Cannot be left empty.

Limitations

Your options are limited to the categories you selected when generating the template.

Examples

Figurines & Knick Knacks
column_set: _underscore_columns

Description

These are additional properties/attributes you can add to your listing. The options available are based on the taxonomies/categories you chose when creating your template.

Allowed Values

Based on product category.

Requirements

You must be using a custom generated Shop Uploader template.

Limitations

If the property has a dropdown box, you must use one of the options provided.

Examples

_primary_color_holiday_fabric
column_set: variations
related docs: variations

Description

Options are the product properties that change for your variations. If your variations change in color or size, these are your option names.

Product options can be custom properties or Etsy's built-in properties.

'Dress size' is a custom property because there is no preceeding underscore.

'_primary_color' is an Etsy built-in property because there is a preceeding underscore.

To use an Etsy built-in option, you use the column name like '_primary_color'.

You can only use '_property_columns' that exist in your template. The templates only contain the columns that are allowed for your product category. If your template is missing columns, you may need to generate a new template for your category.

Related documentation: Variations

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Requirements

  • option1_name is required if option1_value is provided

  • You can only use the Etsy built-in columns '_like_these' if they are in your template

  • Min 1 character

  • option1_name cannot change per variation.

  • You must set at least option1_name and option1_value if your listing has variations

Limitations

  • Max 45 characters

  • Cannot use ` $ ^

Examples

Overall lengthDress size_primary_color_style
column_set: variations
related docs: variations

Description

This is the value of the option1_name that changes for product variations.

For instance, when option1_name = 'Background color', option1_value is the 'Background color' of this variation.

If you use an Etsy built-in (option1_name = '_primary_color') and you have already entered the values in that column, you can leave the option1_value column empty and it Shop Uploader will copy the values over for you.

Related documentation: Variations

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Requirements

Limitations

  • Max 255 characters

  • Cannot use ` $ ^

Examples

RedGreenBlue
column_set: variations
related docs: variations

Description

Options are the product properties that change for your variations. If your variations change in color or size, these are your option names.

Product options can be custom properties or Etsy's built-in properties.

'Dress size' is a custom property because there is no preceeding underscore.

'_primary_color' is an Etsy built-in property because there is a preceeding underscore.

To use an Etsy built-in option, you use the column name like '_primary_color'.

You can only use '_property_columns' that exist in your template. The templates only contain the columns that are allowed for your product category. If your template is missing columns, you may need to generate a new template for your category.

Related documentation: Variations

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Requirements

  • option2_name is required if option2_value is provided

  • You can only use the Etsy built-in columns '_like_these' if they are in your template

  • Min 1 character

  • option1_name cannot change per variation.

  • You must set at least option2_name and option2_value if your listing has variations

Limitations

  • Max 45 characters

  • Cannot use ` $ ^

Examples

Overall lengthDress size_primary_color_style
column_set: variations
related docs: variations

Description

This is the value of the option2_name that changes for product variations.

For instance, when option2_name = '_material', this is the 'Material' value for this variation. If the variation is made of cotton you would enter cotton for the value, if suede enter suede.

Related documentation: Variations

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Requirements

Limitations

  • Max 255 characters

  • Cannot use ` $ ^

Examples

SmallMediumLarge
column_set: variations_advanced
related docs: variations

This column was previously called `is_enabled`

Description

This is a variation control determines whether a variation should be enabled and purchaseable by customers.

By default all variations are enabled except dummy variations, which are disabled by default.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means sku can change when option1_value changes.

For instance, when option1_value = 'RED', the SKU could be 'MY-SKU-RED' and then when option1_value = 'BLUE', the SKU could change to 'MY-SKU-BLU'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option1_values to have the same SKU.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means price can change when option1_value changes.

For instance, when option1_value = 'RED', the price could be '12' and then when option1_value = 'BLUE', the price could change to '10'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option1_values to have the same price.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means quantity can change when option1_value changes.

For instance, when option1_value = 'RED', the quantity could be '100' and then when option1_value = 'BLUE', the SKU could change to '26'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option1_values to have the same quantity.

If one sale uses up the inventory quantity of the whole listing (because options share assembly materials), you probably want this option to be FALSE.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means sku can change when option2_value changes.

For instance, when option2_value = 'RED', the SKU could be 'MY-SKU-RED' and then when option2_value = 'BLUE', the SKU could change to 'MY-SKU-BLU'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option2_values to have the same SKU.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means price can change when option2_value changes.

For instance, when option2_value = 'RED', the price could be '12' and then when option2_value = 'BLUE', the price could change to '10'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option2_values to have the same price.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: variations_advanced
related docs: variations

Description

This is a variation control that means quantity can change when option2_value changes.

For instance, when option2_value = 'RED', the quantity could be '100' and then when option2_value = 'BLUE', the SKU could change to '26'.

This setting controls the checkboxes that you see on Etsy when creating variation options.

The main reason to use this option is when you want all your option2_values to have the same quantity.

If one sale uses up the inventory quantity of the whole listing (because options share assembly materials), you probably want this option to be FALSE.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: linked_images
related docs: variations

Description

This is the URL for the image you want to link to a variation.

A linked image is linked to a variation option (ex: Color) and when the customer selects that option, Etsy will display the linked image.

The image is linked by using this column and image_for_option

Many option values can be linked to the same image, for example all Sizes linked to a size chart.

Only one image can be linked to each option value. Example: Customer selects Red, only one image will appear.

Learn more about linking images to variations.

Allowed Values

Any safe url characters

Requirements

  • Min 1 character

  • Min size 50x50 pixels

  • Recommended size 3000x3000 pixels

Limitations

Only applies if you add images

Examples

https://api.onedrive.com/v1.0/shares/s!At6jwhBQLy7NhxAzDT7etaao3X8V/root/contenthttps://dl.dropbox.com/s/3ob1ye6qbol3cx9/bouncy-ball-blue.pnghttps://drive.google.com/uc?export=download&id=1EStG-dmxicbTdkVgFYGamsiC7Hsgrm3Nhttps://i.imgur.com/YobcUsr.jpg

Details

You can either put all of your image's url links in this section or place the main one here and the rest into the images section.

Note images cannot be larger than 10MB.

Images are drawn from this category first for the Etsy slideshow based on image_position

For image requirements visit Requirements and Best Practices for Images in Your Etsy Shop.

For more information about images visit Etsy's Listing Image Requirements page.

Another useful source if information is Etsy's Intellectual Property Policy page.

column_set: linked_images
related docs: variations

Description

This is the position of the linked image in the Etsy image set.

Positions will be automatically corrected, and can be used to set relative position:

If you want the image to be first, use 1.

If you want the image to be last, use 10.

Learn more about linking images to variations.

Allowed Values

1-10

Limitations

Must be a whole number

Examples

159

Details

This column is optional. Shop Uploader will use ascending order (1,2,3) by default.

column_set: linked_images
related docs: variations

Description

This is the variation option name for the linked image.

For instance, to link the image to this variation's Size, the linked_image_for_option would be Size.

Enter the value from option1_name or option2_name into this column.

Learn more about linking images to variations.

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Limitations

Cannot use ` $ ^

Examples

ColorTextureSize
column_set: linked_images
related docs: variations

Description

Alt text for the linked image. Providing alt text can improve the SEO of your listings.

Learn more about linking images to variations.

Allowed Values

Any valid string

Examples

Sticker sheet with happy-looking cartoon fish characters.
column_set: images
required

Description

This section refers to columns: image_1 -> image_10.
Each column contains a URL to an image you want to upload to your listing. These numbered images cannot be linked to variations. They are uploaded in addition to the linked_image_url.

Learn more about images.

Allowed Values

Any valid URL

Requirements

  • Must be a URL

  • Min size 50x50 pixels

  • Recommended size 3000x3000 pixels

Examples

https://api.onedrive.com/v1.0/shares/s!At6jwhBQLy7NhxAzDT7etaao3X8V/root/contenthttps://dl.dropbox.com/s/3ob1ye6qbol3cx9/bouncy-ball-blue.pnghttps://drive.google.com/uc?export=download&id=1EStG-dmxicbTdkVgFYGamsiC7Hsgrm3Nhttps://i.imgur.com/YobcUsr.jpg

Details

This section covers the image_1 to image_10 columns.

These images are processed and added to the Etsy slideshow after the ones from linked_image_url have been added. Shop Uploader takes the images from image_1 from top to bottom first, then moves on to image_2 all the way to image_10.

For image requirements visit Requirements and Best Practices for Images in Your Etsy Shop.

For more information about images visit Etsy's Listing Image Requirements page.

Another useful source if information is Etsy's Intellectual Property Policy page.

column_set: image_alt_text

Description

This section refers to columns: image_alt_text_1 -> image_alt_text_10.
Each column contains the alt text for the corresponding numbered image column (example: image_1 & image_alt_text_1). Providing alt text can improve the SEO of your listings.

Learn more about images.

Allowed Values

Any valid string

Examples

Sticker sheet with happy-looking cartoon fish characters.
column_set: videos

Description

This is the URL to the video you want to post for your listing. It follows the same URL requirements as images or digital files.

Allowed Values

Any valid url

Requirements

  • Must be a url

  • Over 5 seconds, under 1 minute

  • Up to 100MB filesize

Examples

https://api.onedrive.com/v1.0/shares/s!At6jwhBQLy7NhxAzDT7etaao3X8V/root/contenthttps://dl.dropbox.com/s/3ob1ye6qbol3cx9/bouncy-ball-blue.mp4https://drive.google.com/uc?export=download&id=1EStG-dmxicbTdkVgFYGamsiC7Hsgrm3Nhttps://your-website.com/files/product-video.mp4

Details

Videos will be cropped to a square and sound will be removed by Etsy

For video requirements view our Etsy video guide

column_set: shipping
required: physical

Description

The numeric ID of the shipping profile associated with the listing.

You can find this on your Shop page.

Limitations

shipping_profile_id must match a shipping profile in your Etsy shop

Examples

100000020346882686505
column_set: shipping
required: physical

Description

The numeric ID of the return policy associated with the listing.

Return policies are mandatory for most Etsy listings as of Jan 31, 2023 (does not apply to EU-based shops).

You can find this on your Shop page.

Limitations

return_policy_id must match a return policy in your Etsy shop

Examples

100000020346882686505
column_set: shipping_calculated

Description

Calculated shipping only.

The length of the package, ready to ship. Units are specified in dimensions_unit. The length applies to all product variations in the listing.

Allowed Values

0-9 , .

Requirements

  • Must be a number

  • L >= W >= H

Examples

126.50.75

Details

You must use the units that appear in the listing editor in your Etsy shop

We recommend using the smallest unit allowed by your Etsy shop and using it across your entire product catalog.

If your product length does not show up on Etsy it probably means Etsy does not like your selected dimensions_unit.

column_set: shipping_calculated

Description

Calculated shipping only.

The width of the package, ready to ship. Units are specified in dimensions_unit. The width applies to all product variations in the listing.

Allowed Values

0-9 , .

Requirements

  • Must be a number

  • L >= W >= H

Examples

126.50.75

Details

You must use the units that appear in the listing editor in your Etsy shop

We recommend using the smallest unit allowed by your Etsy shop and using it across your entire product catalog.

If your product width does not show up on Etsy it probably means Etsy does not like your selected dimensions_unit.

column_set: shipping_calculated

Description

Calculated shipping only.

The height of the package, ready to ship. Units are specified in dimensions_unit. The height applies to all product variations in the listing.

Allowed Values

0-9 , .

Requirements

  • Must be a number

  • L >= W >= H

Examples

126.50.75

Details

You must use the units that appear in the listing editor in your Etsy shop.

We recommend using the smallest unit allowed by your Etsy shop and using it across your entire product catalog.

If your product height does not show up on Etsy it probably means Etsy does not like your selected dimensions_unit.

column_set: shipping_calculated

Description

Calculated shipping only.

Defines the unit for the length, width, and height. Each measurement must use the same unit.

You may need test different units. Different units are supported depending on your shop's location.

Allowed Values

in , ft , mm , cm , m , yd , inches

Examples

mminft
column_set: shipping_calculated

Description

Calculated shipping only.

The weight of the package, ready to ship. Units are specified in weight_unit. The weight applies to all product variations in the listing.

Allowed Values

0-9 , .

Requirements

Must be a number

Limitations

Certain accounts cannot ship domestic packages over 70 pounds.

Examples

150500

Details

You must use the units that appear in the listing editor in your Etsy shop

We recommend using the smallest unit allowed by your Etsy shop and using it across your entire product catalog.

Enter 2000 oz if the item weights 125 lbs or 2000 g if the item weights 2 kg.

If your product weight does not show up on Etsy it probably means Etsy does not like your selected weight_unit.

column_set: shipping_calculated

Description

Calculated shipping only.

Defines the unit for the weight.

You may need test different units. Different units are supported depending on your shop's location.

Allowed Values

lb , kg , g , oz

Examples

kgoz
column_set: digital_files
required: digital

Description

This section refers to columns: digital_file_1 -> digital_file_5

This is the url link(s) to the digital file(s) you want to post for your listing.

Etsy allows 5 digital files per listing, if you need more than this, you can use ZIP folders.

Learn more about digital listings.

Allowed Values

Any valid url

Requirements

  • type must be set to digital

  • Must be a url

  • File size cannot be greater than 20MB

  • File name must be between 3 and 70 characters long

Examples

https://api.onedrive.com/v1.0/shares/s!At6jwhBQLy7NhxAzDT7etaao3X8V/root/contenthttps://dl.dropbox.com/s/3ob1ye6qbol3cx9/bouncy-ball-blue.pnghttps://drive.google.com/uc?export=download&id=1EStG-dmxicbTdkVgFYGamsiC7Hsgrm3N
column_set: digital_files
required: digital

Description

This section refers to columns: digital_file_name_1 -> digital_file_name_5

This is where you add your digital file's name.

This is needed since some urls do not provide this information. Without this information, your customer have to add the file extension themselves after purchaing your products.

Learn more about digital listings.

Allowed Values

A-Z , a-z , 0-9 , - . _

Requirements

  • type must be set to digital

  • digital_file must have an entry

  • File name must be between 3 and 70 characters long

Examples

bouncy-ball-blue.pngbouncy-ball-red.png
column_set: core_details
required

Description

This indicates if the product is a physical or digital product.

Allowed Values

physical , digital

Examples

physicaldigital

Details

You will need to indicate what type of items you are selling. This is a mandatory field when listing a product on Etsy.

column_set: shop_details

Description

The numeric ID of the shop section for this listing.

You can find this on your Shop page.

Examples

100000020346882686505
column_set: core_details
required

Description

Who made the product.

Allowed Values

i_did , someone_else , collective

Examples

i_didsomeone_elsecollective
column_set: core_details
required

Description

Is the product made to order?

If TRUE it is made to order. If FALSE it is not made to order.

Allowed Values

TRUE , FALSE

Requirements

Must be True or False

Examples

TRUEFALSE
column_set: core_details
required

Description

This is the year in which the product was produced.

Allowed Values

Digits (0-9)

Requirements

  • Must be a whole number

  • year_made <= Current Year

  • If from BC/BCE, use negative numbers

Examples

184614922021
column_set: core_details
required

Description

Is the product considered vintage (20+ years old).

If TRUE the produce is >=20 years old. If FALSE the product is <20 years old.

Allowed Values

TRUE , FALSE

Requirements

  • Item must be at least 20 years old

  • Item age is based on year_made value

Examples

TRUEFALSE
column_set: core_details
required

Description

When TRUE, tags the listing as a supply product. False indicates that it is a finished product. Helps buyers locate the listing under the Supplies heading.

Allowed Values

TRUE , FALSE

Requirements

Examples

TRUEFALSE

Details

TRUE indicates that the item is a supply or tool used to make things.

False indicates that the item is a finished product.

column_set: core_details
required

Description

This indicates whether or not a customer will be taxed at checkout when purchasing the item.

When TRUE, applicable shop tax rates apply to this listing at checkout.

Allowed Values

TRUE , FALSE

Requirements

Value must be TRUE or FALSE

Examples

TRUEFALSE
column_set: core_details
required

Description

NOTE: All listing fees are levied by Etsy. Shop Uploader has no control over fees levied by Etsy.

This indicates whether or not you want your listings to be automatically renewed.

When TRUE, renews a listing for four months upon expiration.

If TRUE when previously FALSE, Etsy renews the listing before it expires, but the renewal period starts immediately rather than extending the listing's expiration date.

Any unused time remaining on the listing is lost. Renewals result in charges to a user's bill.

Allowed Values

TRUE , FALSE

Requirements

Value must be TRUE or FALSE

Examples

TRUEFALSE
column_set: personalization

Description

When TRUE, a buyer may contact the seller for a customized order.

Most sellers use personalization instead.

Allowed Values

TRUE , FALSE

Examples

TRUEFALSE
column_set: personalization

Description

When TRUE, this listing is personalizable.

Allowed Values

TRUE , FALSE

Requirements

Value must be TRUE or FALSE

Examples

TRUEFALSE
column_set: personalization

Description

When TRUE, this listing requires personalization.

Allowed Values

TRUE , FALSE

Requirements

Examples

TRUEFALSE
column_set: personalization

Description

Instructions telling the buyer on what to put in the personalization text box.

Allowed Values

A-Z , a-z , 0-9 , ~ ! @ # % & * ( ) _ - + = [ ] { } \ | / ? > < . ,

Requirements

When TRUE, is_personalizable must also be TRUE

Limitations

  • Cannot use ` $ ^

  • Max characters 256

Examples

What do you want the necklace to say?Describe the order you want the colors. Example: Red, Blue, Red.Please enter the year established.
column_set: personalization

Description

The maximum length for the personalization message entered by the buyer.

Allowed Values

1-1024

Requirements

  • is_personalizable must also be TRUE

  • Minimum character amount is 1

  • Value must be a whole number

Limitations

  • Max 1024 characters

  • Cannot have ,

Examples

154831023
column_set: styles

Description

This defines the style of the product you are selling.

Etsy seems to be moving away from styles in favor of category-specific attributes.

Allowed Values

A-Z , a-z , 0-9 , Spaces

Limitations

  • Cannot be more that 45 characters long

  • Max 2 per listing

  • Cannot use ~ ` ! @ # $ % ^ & * ( ) _ + = [ ] { } \ | / ? > < . ,

  • Cannot contain emoji

Examples

FormalCasualSummer Wear
column_set: tags
required

Description

This section refers to columns: tag_1 -> tag_13

A tag is a word or short phrase that describes your item.

Allowed Values

A-Z , a-z , 0-9 , Spaces , -, ', trademark symbol, copyright symbol, and reserved symbol

Limitations

  • Max 20 characters

  • Max 13 per listing

  • Cannot use ~ ` ! @ # $ % ^ & * ( ) _ + = [ ] { } \ | / ? > < . ,

Examples

SkirtShirtPants
column_set: materials

Description

This section refers to columns: material_1 -> material_13

Materials are what your products are made out of.

Allowed Values

A-Z , a-z , 0-9 , Spaces

Limitations

  • Emojis 👎

  • Cannot use ~ ` ! @ # $ % ^ & * ( ) _ - + = { } [ ] | \ / , . < >

  • Max 13 per listing

  • Max 45 characters

Examples

CottonSilkBurlap
column_set: production_partners

Description

This section refers to columns: production_partner_1 -> production_partner_5

These are the IDs of your Etsy production partners. Etsy automatically generates the IDs but you have to create the production partners.

You can create your production partners by going to Shop Manager > Settings > Production Partners on Etsy.

You can access these on your Shop page (must be logged in).

For additional information please visit the Working With Production Partners on Etsy page.

Examples

21571772113481
column_set: translations

Description

Translations are available for all Etsy-supported languages.

If you want to provide your own translation you must provide the entire translation.

That means title, description, and tags must be translated.

Translations in the template will be look like this: {lang}_{column}.

For example the es_description = Spanish description.

Supported language codes: [nl, fr, de, it, ja, pl, pt, ru, es].

Examples

es_titlees_descriptiones_tag_1
column_set: controls
required

Description

Action controls how Shop Uploader will process your upload. This is the most important column in your template.

create/update creates a new listing or updates an existing listing (overwrites everything). If you provide a listing_id, it will overwrite all information in your listing. Without a listing_id, the update action will create a new listing. Both create and update perform the same actions, different names, same result.

inventory will ONLY change inventory quantity (but it's very fast). You must provide listing_id, sku, and quantity.

delete will delete the ENTIRE listing. You need to also provide listing_id.

state_change ONLY change the listing_state, for instance changing a draft listing into an active listing. You must provide listing_id.

partial_update will ONLY update the columns you provide. You must provide listing_id (and product_id to update variations).

Allowed Values

create , update , inventory , delete , state_change , partial_update

Examples

createupdateinventorydeletestate_changepartial_update
column_set: controls
required

Description

This describes the listing state of your listings. The two options for this category are draft and published.

When set to draft you will upload draft listings. A draft listing is free to make and is not seen by customers.

When set to publish you will upload published listings or change your draft listings into published listings. Published listings are public and can be seen by customers. You have to pay Etsy's listing fee ($0.20) to post a published listing.

You cannot take a listing from active to draft.

Allowed Values

draft , published

Examples

draftpublished
column_set: controls
required

Description

If TRUE and you already have 10 images existing images will be overwritten.

If overwrite is FALSE, the new images will be added after the existing images. This is until you hit the max image limit for the listing. Once hit additional images will be ignored.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: controls_advanced

Description

If TRUE, Shop Uploader will deactivate a listing when the listing and all its variations have 0 quantity.

This solves the 'EtsyError: listing quantity cannot be 0' when trying to set the inventory to 0 (sold out) for a listing.

Listings cannot be changed to the state 'sold_out' via the API. So, we must instead change listings to 'inactive'.

Re-activating a listing may incur Etsy listing fees, so this is FALSE by default.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: controls_advanced

Description

If TRUE, delete all images from the listing before adding any images.

This is useful when you are uploading new images, but fewer than are currently online, and you don't want any of the old images.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: controls_advanced

Description

If TRUE, delete all variations from the listing before adding any variations.

This can be used with the `partial_update` action to simply remove all variations.

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: controls_advanced

Description

If TRUE, delete all digital files from the listing before adding any digital files.

A digital listing must always have at least 1 digital file

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE
column_set: deprecated

This column is no longer in use. See `category` instead (Template v1.00+)

Description

A unique Etsy defined code that helps categorize listings on Etsy

Use the category column instead.

Allowed Values

Digits (0-9)

Requirements

Must be greater than or equal to 1

Examples

150500

The most powerful
tool for Etsy sellers