Last updated: May 23, 2023

Template Documentation

Shop Uploader lets you bulk upload your listings and inventory to Etsy.

This documentation serves as reference material for the upload template.
Think of it as the dictionary for Shop Uploader.
When you need to figure something out you can look it up here.

Looking for more in-depth info? See our Tutorials and Guides for step-by-step guides.

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

listing_id

This column is ready for active use. (Template v0.25+)

Description

The numeric ID for the 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

product_id

This column is ready for active use. (March 2023+)

Description

The numeric ID for each variant. Generated by Etsy.

Required to partial_update variants.

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

Allowed Values

Digits (0-9)

Requirements

Must be a whole number

Limitations

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

Examples

100000020346882686505

parent_sku

Product Identification

This column is ready for active use. (Template v0.25+)

Description

The parent_sku groups multiple SKUs together into a single listing.

You can think of the parent_sku as the product SKU without the variant information. For instance our example: 'TOY-TRUK-50-RED' becomes 'TOY-TRUK' after removing the size (50) and the color (RED).

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.

sku

Product Identification

This column is ready for active use. (Template v0.25+)

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.

title

Product Identification
SEO

This column is ready for active use. (Template v0.25+)

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 variant, 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

description

SEO

This column is ready for active use. (Template v0.25+)

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.

price

This column is ready for active use. (Template v0.25+)

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.

quantity

This column is ready for active use. (Template v0.25+)

Description

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

Etsy shows the product's total quantity on its website. This is the sum of all your variant'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

category

This column is ready for active use. (Template v1.00+)

Description

This column is availiable on custom made Shop Uploader templates

Category replaces the taxonomy_id column.

You add categories to your template through the Templates page. Once your desired categories are selected generate a new template.

You can either use your category's name or continue to enter the taxonomy ids.

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

category properties

This column is ready for active use. (Template v1.00+)

Description

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

Allowed Values

Based on selected taxonomies.

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

option1_name

Product Variants

This column is ready for active use. (Template v0.25+)

Description

Options are the product properties that change for your variants. If your variants 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.

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 variant.

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

Limitations

  • Max 45 characters

  • Cannot use ` $ ^

Examples

Overall lengthDress size_primary_color_style

option1_value

Product Variants

This column is ready for active use. (Template v0.25+)

Description

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

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

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.

Allowed Values

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

Requirements

Limitations

  • Max 255 characters

  • Cannot use ` $ ^

Examples

RedGreenBlue

option2_name

Product Variants

This column is ready for active use. (Template v0.25+)

Description

Options are the product properties that change for your variants. If your variants 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.

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 variant.

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

Limitations

  • Max 45 characters

  • Cannot use ` $ ^

Examples

Overall lengthDress size_primary_color_style

option2_value

Product Variants

This column is ready for active use. (Template v0.25+)

Description

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

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

Allowed Values

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

Requirements

Limitations

  • Max 255 characters

  • Cannot use ` $ ^

Examples

SmallMediumLarge

is_enabled

Product Variants

This column is ready for active use. (Template v0.25+)

Description

This is a variation control determines whether a variant 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

option1_changes_sku

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

option1_changes_price

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

option1_changes_quantity

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

option2_changes_sku

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

option2_changes_price

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

option2_changes_quantity

Product Variants

This column is ready for active use. (Template v0.25+)

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 variant 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

image_url

This column is ready for active use. (Template v0.25+)

Description

This is the url link to the image you want to post for your listing. This is the image you can link with image_for_option.

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.

image_position

This column is ready for active use. (Template v0.25+)

Description

This is the position you want your photo to show up in, in the Etsy slideshow. If you set the value to 1 it will show up first, if you set the value to 10 it will be last.

Allowed Values

1-10

Limitations

Must be a whole number

Examples

159

Details

This section is optional. If you leave this blank your images will be listed in the order Shop Uploader finds them.

image_for_option

This column is ready for active use. (Template v0.25+)

Description

This is the item option the image will show up for. You need to enter the value you entered for either option1_name or option2_name into this column.

Allowed Values

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

Limitations

Cannot use ` $ ^

Examples

ColorTextureSize

images

This column is ready for active use. (Template v0.25+)

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 are not linked to variants but they are uploaded in addition to the linked_image_url.

Allowed Values

Any valid URL

Requirements

  • Needs to 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 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.

video_1

This column is ready for active use. (Template v0.25+)

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

  • Needs to 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

length

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

The length of the product, when packaged, in the units specified in dimensions_unit.

The length applies to all product variants 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.

width

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

The width of the product, when packaged, in the units specified in dimensions_unit.

The width applies to all product variants 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.

height

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

The height of the product, when packaged, in the units specified in dimensions_unit.

The height applies to all product variants 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.

dimensions_unit

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

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

You may need to do some testing with the different options to determine which works for your shop.

Allowed Values

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

Examples

mminft

weight

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

The weight of the item and packaging (applies to the entire 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.

weight_unit

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

Description

Defines the unit for the weight.

You may need to do some testing with the different options to determine which works for your shop.

Allowed Values

lb , kg , g , oz

Examples

kg oz lb

shipping_profile_id

Physical Products
Dimensions

This column is ready for active use. (Template v0.25+)

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

return_policy_id

Physical Products

This column is ready for active use. (Template v0.25+)

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

digital files

Digital Files
Product Type

This column is ready for active use. (Template v0.25+)

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.

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

file name

This column is ready for active use. (Template v1.00+)

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.

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

type

This column is ready for active use. (Template v0.25+)

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.

shop_section_id

This column is ready for active use. (Template v0.25+)

Description

The numeric ID of the shop section for this listing.

You can find this on your Shop page.

Examples

100000020346882686505

taxonomy_id

This column is no longer in use. (Template v1.00+)

Description

A unique Etsy defined code that helps categorize listings on Etsy

You can find these on the Templates page.

If you are using a Shop Uploader custom template, taxonomy_id is covered by the category column.

Allowed Values

Digits (0-9)

Requirements

Must be greater than or equal to 1

Examples

150500

who_made

This column is ready for active use. (Template v0.25+)

Description

Who made the product.

Allowed Values

i_did , someone_else , collective

Examples

i_didsomeone_elsecollective

is_made_to_order

This column is ready for active use. (Template v0.25+)

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

is_vintage

This column is ready for active use. (Template v0.25+)

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

year_made

This column is ready for active use. (Template v0.25+)

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

auto_renew

This column is ready for active use. (Template v0.25+)

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

is_taxable

This column is ready for active use. (Template v0.25+)

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

is_supply

This column is ready for active use. (Template v0.25+)

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.

is_customizable

This column is ready for active use. (Template v0.25+)

Description

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

Allowed Values

TRUE , FALSE

Examples

TRUEFALSE

is_personalizable

This column is ready for active use. (Template v0.25+)

Description

When TRUE, this listing is personalizable.

Allowed Values

TRUE , FALSE

Requirements

Value must be TRUE or FALSE

Examples

TRUEFALSE

personalization_is_required

This column is ready for active use. (Template v0.25+)

Description

When TRUE, this listing requires personalization.

Allowed Values

TRUE , FALSE

Requirements

Examples

TRUEFALSE

personalization_instructions

This column is ready for active use. (Template v0.25+)

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.

personalization_char_count_max

This column is ready for active use. (Template v0.25+)

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

styles

This column is ready for active use. (Template v0.25+)

Description

This defines the style of the product you are selling.

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

tags

This column is ready for active use. (Template v0.25+)

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

materials

This column is ready for active use. (Template v0.25+)

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

production_partners

This column is ready for active use. (Template v0.25+)

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

action

This column is ready for active use. (Template v0.25+)

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 deletes the 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 variants).

Allowed Values

create , update , inventory , delete , state_change , partial_update

Examples

createupdateinventorydeletestate_changepartial_update

listing_state

This column is ready for active use. (Template v0.25+)

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

overwrite_images

This column is ready for active use. (Template v0.25+)

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

can_be_sold_out

This column is ready for active use. (Template v0.25+)

Description

If TRUE, Shop Uploader will deactivate a listing when the listing and all its variants 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

delete_all_images

This column is ready for active use. (Template v0.25+)

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

delete_all_variants

This column is ready for active use. (Template v0.25+)

Description

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

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

Allowed Values

TRUE , FALSE

Requirements

Value must be True or False

Examples

TRUEFALSE

The most powerful
tool for Etsy sellers