Product trigger / hashtag

hashtag

The product hashtag is a unique identifier for each product on Jumper. 

This can be used as a trigger keyword by customer to start an automated purchase for the product. 

You can ideally choose any combination of numbers and alphabets for as the hashtag. 

The hashtag should not contain any special or non-english, or accent characters. 

This value should be unique for each row/product. 

RedDress

H13045

Product name

name

Add a name for your product in a way that is understandable for your customer, much like you'd add on your website or promote on social media

Lily of the Valley Cologne, 100ML

Product short description

short_description

Add a short description about your product which can be shared as a message to the customer for a quick product overview. 

The short description should not exceed 1000 characters.

Lily of the Valley Cologne is a luminous, airy composition. It is a pure floral composed around four flowers: exotic and intense lily, radiant and fruity ylang-ylang, fresh and sparkling orange blossom, and creamy, highly feminine Grasse tuberose.

Product long description

description

Here you can added detail descriptions about your products, eg composition, ingredients, specifications, etc. 

The details you add here will show in a web view when the customer clicks "View details" button attached to your product cards. 

This information is optional. 

There are no character limits, however if you are uploading the loading the long description via .csv you can't add images or tables in your long descriptions. 

Direct image update link

image_url

The link from where we can upload the image. 

The link should be an open link and not require login (Eg No Google drive links)

The link should also end with the supported file extensions. ie .png , .jpg , .gif

Wrong Formats

• https://giphy.com/gifs/kDZyKwgD4ULeASnrof

• https://share.getcloudapp.com/7KumZvd5

Correct Formats

• https://media.giphy.com/media/kDZyKwgD4ULeASnrof/giphy.gif

• https://p83.f1.n0.cdn.getcloudapp.com/items/7KumZvd5/Image%202020-07-10%20at%2012.15.48%20AM.png?v=49fb538ab7a2e9f3030722b005bc276a

Product price

price

The selling price of your product. 

If you have variations you can skip this column. 

USD 100

Product SKU ID

sku

Your product SKU ID, in your system

Q019181877GH

Product stock

stock

The number of product units you want to sell. 

If you have variations you can skip this column. 

100

Product weight in Kgs

weight_in_Kgs

Weight of your product and packaging in Kilograms. 

You can skip this column if you don't have weight based shipping options, or have variations. 

0.15

Option to add custom notes to order

accept_custom_notes_from_buyer

If you want to give the option to customers to add notes or request customisations for their order, fill TRUE. 

Otherwise, fill FALSE.

FALSE

Product visibility on shop

visible_on_shop_page

If you want the product to be shown on your web store front and in your Live chat Actions panel, please fill in TRUE. 

Otherwise fill FALSE. 

TRUE

Enable > 1 quantity per order

allow_the_shopper_to_buy_more_than_one_quantity

If shoppers can buy more than 1 SKU per order, fill TRUE. 

If you want to restrict each customer to buy only 1 unit per order, then fill FALSE

TRUE

Limit maximum order quantity

max_quantity_buyer_can_order

If you want to restrict the maximum quantity a customer can buy per order, fill the maximum number of product SKU's can be added per order.

3

Product height in centimetre

height_in_cm

The height of your product packaging in centimetres.  

You can skip this column if you don't have volume based shipping settings, or have variations. 

10

Product width in centimetre

width_in_cm

The width of your product packaging in centimetres.

You can skip this column if you don't have volume based shipping settings, or have variations.  

5

Product length in centimetre

length_in_cm

The length of your product packaging in centimetres.

You can skip this column if you don't have volume based shipping settings, or have variations. 

5

Product trigger / hashtag

hashtag

Fill the same hashtag name as your added for the product, this variation is associated with. 

If your product has multiple variations, eg 3 size variations and 2 color variations, then you should fill all the 6 rows with the product variation combinations, with the same hashtag. 

You must enter minimum 2 rows for hashtag, ie a minimum of 2 variations for each product. 

If some of your products don't have variations, you can simply skip those product's hashtags while preparing this file. 

You must ensure that the product and hashtag are already created before you add and update the same using this file. 

RedDress

The name of your 1st variation type. 

variant_1_name

Fill the name using which your customers can understand the type of the variation, eg size, color, weight. 

The variation you add here will be shown as the first variation type to select from when they are purchasing the product. 

If you have multiple selections available under the variation type. Eg you have 3 size variations (S, M, L), then you should fill the same variation name for all 3 rows

If you have, 2nd and 3rd variant type, then you should repeat the name, till you have all the combinations, listed uniquely in each row.

You must add at least 2 rows if your products have variations. 

size

The selection options available for your variant type

variant_1_value

Enter the options you have available for the variation type. 

Eg if you have 3 size variations, then enter S, M and L in each row. 

If you have, 2nd and 3rd variant type, then you should repeat the values, till you have all the combinations, listed uniquely in each row.

You must add at least 2 rows if your products have variations.

S

The image for the specific variation combination

variant_1_image_url

If your variant doesn't have an image, you can leave this blank. Eg. Size. 

If your variant value's do have images, eg print, then add a direct link from where we can upload the image for the same. 

The link should be an open link and not require login (Eg No Google drive links)

The link should also end with the supported file extensions. ie .png , .jpg , .gif

You must add at least 2 rows if your products have variations. 

Wrong Formats

• https://giphy.com/gifs/kDZyKwgD4ULeASnrof

• https://share.getcloudapp.com/7KumZvd5

Correct Formats

• https://media.giphy.com/media/kDZyKwgD4ULeASnrof/giphy.gif

• https://p83.f1.n0.cdn.getcloudapp.com/items/7KumZvd5/Image%202020-07-10%20at%2012.15.48%20AM.png?v=49fb538ab7a2e9f3030722b005bc276a

The name of your 2nd variation type.

variant_2_name

Fill the name using which your customers can understand the type of the variation, eg size, color, weight. 

The variation you add here will be shown as the second variation type to select from when they are purchasing the product.

Same as above, if you have multiple selections available under the variation type. Eg you have 2 color variations (Green, blue). Then you should fill the same variation name for 2 rows

If you have 3rd variant type, then you should repeat the name, till you have all the combinations, listed uniquely in each row. 

If you don't have more than 1 type of variations, you can leave this blank. 

color

The selection options available for your variatant type

variant_2_value

Enter the options you have available for the variation type. 

Eg if you have 2 color variations, then enter Green, and White in each row.

If you have 3rd variant type, then you should repeat the values, till you have all the combinations, listed uniquely in each row. 

If you don't have more than 1 type of variations, you can leave this blank. 

Green

The image for this specific variation combination

variant_2_image_url

If your variant doesn't have an image, you can leave this blank. Eg. Size. 

If your variant value's do have images, eg print, then add a direct link from where we can upload the image for the same. 

The link should be an open link and not require login (Eg No Google drive links)

The link should also end with the supported file extensions. ie .png , .jpg , .gif

If you don't have more than 1 type of variations, you can leave this blank. 

Wrong Formats

• https://giphy.com/gifs/kDZyKwgD4ULeASnrof

• https://share.getcloudapp.com/7KumZvd5

Correct Formats

• https://media.giphy.com/media/kDZyKwgD4ULeASnrof/giphy.gif

• https://p83.f1.n0.cdn.getcloudapp.com/items/7KumZvd5/Image%202020-07-10%20at%2012.15.48%20AM.png?v=49fb538ab7a2e9f3030722b005bc276a

The name of your 3rd variation type

variant_3_name

Fill the name using which your customers can understand the type of the sub variation.

The variation you add here will be shown as the last variation type to select from when they are purchasing the product.

Same as above, if you have multiple selections available under the variation type. Eg you have 5 print variations Then you should fill the same variation name for 5 rows

If your other variations have more selections available, then follow the same guidelines as mentioned for other variant names.

If you don't have 3 types of variations, you can leave this blank. 

print

The selection options available for your variant type

variant_3_value

Enter the options you have available for the variation type. 

Eg if you have 5 print variations, then enter a different print name in each row.

If you don't have 3 types of variations, you can leave this blank.

Floral

The image for the specific variation combination

variant_3_image_url

If your variant doesn't have an image, you can leave this blank. Eg. Size. 

If your variant value's do have images, eg print, then add a direct link from where we can upload the image for the same. 

The link should be an open link and not require login (Eg No Google drive links)

The link should also end with the supported file extensions. ie .png , .jpg , .gif

If you don't have 3 types of variations, you can leave this blank. 

Wrong Formats

• https://giphy.com/gifs/kDZyKwgD4ULeASnrof

• https://share.getcloudapp.com/7KumZvd5

Correct Formats

• https://media.giphy.com/media/kDZyKwgD4ULeASnrof/giphy.gif

• https://p83.f1.n0.cdn.getcloudapp.com/items/7KumZvd5/Image%202020-07-10%20at%2012.15.48%20AM.png?v=49fb538ab7a2e9f3030722b005bc276a

The price for the specific variation combination

price

Enter the price, for the variation combination you have entered in this row. 

Eg based on the our above examples you should enter the price if the user buys S size, Green Color, Floral Print in the first row and then similarly add the price for each row you have created for the main product. 

THB 500

The SKU ID for the specific variation combination

sku

Enter the SKU ID, for the variation combination you have entered in this row.

H00010202020DL

The stock for the specific variation combination

stock

Enter the available stock, for the variation combination you have entered in this row. 

1000

The weight for the specific variation combination

weight_in_Kgs

Enter the weight in kilograms, for the variation combination you have entered in this row. 

If you don't charge shipping rates based on weight of the order then you can skip this. 

0.5

The height for the specific variation combination

height_in_cm

Enter the height in centimetres, for the variation combination you have entered in this row. 

If you don't charge shipping rates based on volume of the package then you can skip this.

10

The width for the specific variation combination

width_in_cm

Enter the width in centimetres, for the variation combination you have entered in this row. 

If you don't charge shipping rates based on volume of the package then you can skip this.

10

The length for the specific variation combination

length_in_cm

Enter the length in centimetres, for the variation combination you have entered in this row. 

If you don't charge shipping rates based on volume of the package then you can skip this.

10