New: Automatically create variation image rows

Click the button and copy this Google Sheet to your own Google Drive:


Mapping variation images requires a few column headers and values. For quick reference, these are the basic variation image column headers:

  • VariationImageOption

  • VariationImageValue1

  • VariationImage1_1


Getting Started

We are going to walk through a real-world example.

  • The table below shows the Variation CSV we need to assign images to:

SKU

Parent SKU

Color

CustomSpecific Size

skuPARENT

sku-red-2

skuPARENT

red

2 cm

sku-red-3

skuPARENT

red

3 cm

sku-blue-2

skuPARENT

blue

2 cm

sku-blue-3

skuPARENT

blue

3 cm

To map the variation images, we need:

  • Variation Options: The variation Item Specifics names (Color and Size)

  • Variation Values: The value for the Item Specifics (red, blue, and 2 cm, 3 cm)


Step 1 - Choose a Variation Option for Images

Important: Variation image data must be placed in the Parent SKU row.

  • Use the column VariationImageOption to enter the Item Specific Name as the Variation Option. (eBay only allows one variation option for variation images)

Color

CustomSpecific Size

VariationImageOption

Color

red

2 cm

red

3 cm

blue

2 cm

blue

3 cm


Step 2 - Set Images for a Variation Value

  • Use the column VariationImageValue1 to enter an Item Specific value.

Color

VariationImageOption

VariationImageValue1

Color

red

red

red

blue

blue

Each variation image value will progress in the order:

  • VariationImageValue1,

  • VariationImageValue2,

  • VariationImageValue3,

  • VariationImageValue4, etc.


  • Use column headers progressing like: VariationImage1_1 , VariationImage1_2 to enter up to 12 image URLs:

Color

VariationImageOption

VariationImageValue1

VariationImage1_1

VariationImage1_2

Color

red

example.com/red.jpg

example.com/rd.jpg

red

red

blue

blue


Step 3 - Set Variation Images for Other Variation Values

Repeat step 2 for other variation values, progressing the numbers like: VariationImageValue2, VariationImage2_x.

Color

VariationImageOption

VariationImageValue1

VariationImage1_1

VariationImage1_2

VariationImageValue2

VariationImage2_1

VariationImage2_2

Color

red

example.com/red.jpg

example.com/rd2.jpg

blue

example.com/blue.jpg

example.com/blu.jpg

red

red

blue

blue


Step 4 - Import and Turn On Variation Photos

If you edit the imported Draft directly, enable the variation option,

Your photos will be uploaded and ready to publish:

Did this answer your question?