How to prepare a product variant feed for automation

For products and variants

The field is  mandatory.

SKU

SKU-01-WFW - SKU for the Product

SKU-01-WFW-SB - SKU for the Variant(see the example below)

For products and variants

The field is mandatory.

The SKU should be unique for each product or variant.

Only for variants

The field is mandatory.

It should have the parent product’s SKU. Otherwise, the connection can’t be made between the product and its variant.

Women Fine Watch

Only for products

If the information is added to the variant, it will be ignored, as the name will always be taken from the parent product.

Only for products

If the information is added to the variant, it will be ignored, as the description will always be taken from the parent product.

For products

You can add up to 15 images in the same row,  but you have to separate them with a semicolon (;) 

The image link must end in either .jpg or .png, otherwise it will not work

If you have trouble finding a correct URL, you can use the link from Design Studio. 

The product image link will automatically apply for variants as well. You can overwrite variant images by filling in the Variant.ImageURL field.

35

35.5

Only for products

The price will automatically apply to variants as well. You can overwrite variant prices by filling in the Variant.Price field.

If you use a decimal separator, please use a decimal point, not a decimal comma.

Do not use dollar signs ($); prices will not display if a dollar sign is included. We have a separate column for currency.

Only for products

You can add a single currency for the entire flipbook, but you can modify the currency when editing the flipbook. 

If you change the currency, it will be applied to all products/variants. 

If you need to change the currency, we recommend doing so in the feed and then updating the feed in Flipsnack. If the sheet contains more than one currency, the first currency added will be applied to the entire flipbook.

Only for products

Same rules apply as for Price (only numbers and period)

Only for variants

You can choose between TRUE or FALSE 

If FALSE, the variant will be unavailable for purchase.

If you leave the field blank, it will be set as TRUE by default, but set this field to FALSE if the variant is out of stock or if you do not want buyers to be able to purchase it.

Only for products

When set to TRUE, users will be able to adjust the quantity of a product using a control like the one below: 
     
When set to FALSE, the quantity field becomes unavailable, and users can only add one product at a time.

The minimum quantity available for purchase for the same product/variant.

2

For Products

It will also apply to the variants.

If you have set a minimum quantity, you must also add a maximum one, otherwise, it will not work.

For Products

It will also apply to the variants.

TRUE → enables quantity steps (multiples).

FALSE → buyers can choose any number between the min and max 

E.g., if you have MIN.Purchasable.Quantity 2 and MAX.Purchasable.Quantity 10, and MOQ TRUE, the buyers can add only 2,4,6,8, or 10 items to the cart (multiples of 2, until they reach the maximum value, 10)

The product attribute name.

Color

For Products

You can add a maximum of 3 attributes. If your product does not contain variants, you can leave the field blank.

The options available for Attribute.Name1.

Product options: Silver;Black;Gold;Brown

Variant options: 

Silver

Black

Gold

For Products and Variants

Each option should be added on separate rows for each variant.

The product attribute name.

Size

For Products

Same as Attribute.Name1.

The options available for Attribute.Name2.

Product options: Small, Medium; Large

Variant options: 

Small

Medium

Large

For Products and Variants

Same as Attribute.Options1.

The product attribute name.

Material

For Products

Same as Attribute.Name1.

The options available for Attribute.Name3.

Product options: 

Cotton;Polyester

Variant options:

Cotton

Polyester

For Products and Variants

Same as Attribute.Options1

Only for products

You need to choose a single attribute (if you have more than one) for which you want to add the images.  

E.g. if you’re selling T-shirts with the attributes Color and Size, the obvious choice would be to choose Color for the image attribute. This way, when someone selects the T-shirt in a different color, they will see a picture of the T-shirt in that particular color. Using different images for each size would not make too much sense since, visually, they all look the same.

For variants

You can add up to 15 images in one field, separated by semicolons(;).

The field should be located in the same row as the attribute option to which you want to add images.

E.g. If “Color” is your Image.Attribute and the options are red, green, or white, do this:

Add a variant row for each color.

For example:

Product.Type → Variant

Attribute.Options1 → green

Variant.ImageURL → add the image links for the green product.

Repeat for each color (e.g., a “white” row with its own image links).

Flipsnack will automatically show the correct images when a buyer selects that color.

For Variants

You can add a different price for each variant. If you leave the field blank, the product's price (Price column) will be applied to the variant.

For Variants

You can add a different discount price for each variant. If you leave the field blank, the product's discount price (Discount.price column) will be applied to the variant.

Only for products

The field is mandatory.

You can choose between AREA and BUTTON.

The Area element is an overlay.

The Button element is a call to action button.

If you leave the field blank, AREA will be selected by default. 

For Products

Applicable only if you have selected AREA.

If the field is blank, “Click to view this product” will be displayed.

Area.Element.Color

The color of the Area element.

#7BC2FF

For Products

You must add a HEX Code.

Area.Element.Opacity

The opacity of the Area element. 

20

For Products

You can select a value between 0 and 100.

0 = completely transparent.

100 = completely visible.

Shop.Button

The add to cart shop button. 

TRUE

If you set it to FALSE, the add to cart/shop this item button will be hidden. 

For products

We recommend using the Hex Code.

If left empty, the default color will be black.

For Products

If the field is blank, “Shop this item” will be displayed.

For products

By default, the color is set to white.

For Products

Visible when you click on the area or button element.

You can choose between TRUE or FALSE.

If the field is blank, FALSE will be used.

For Products

It can be used if Website.Button is set to TRUE.

If the field is blank, “View more” will be displayed.

For Products

If you don’t add a link, the button will not be displayed, even if you set its value to TRUE.

Set this field to TRUE if the product allows personalization (e.g., “Add your name”). 

This is a short message or guide for buyers, for example:  “Write your message or initials below.”

It appears inside the personalization box in the shopping modal.

A fixed extra cost for personalization.

Example: If you charge $2.50 for engraving, enter 2.5.

Charges a price per character typed by the buyer (e.g., $0.10 per letter).

If you fill in both Flat.Fee and Per.Character, Per. Character takes priority.

Numbers only. Sets the maximum number of characters a buyer can type (e.g., 20).

Set to TRUE if personalization is required (the buyer must fill it out to purchase).

Leave FALSE if it’s optional.