Objective
Bulk Adding Products via CSV / TSV
Applies To
- Jumper
- Bulk adding products
To upload multiple products at a time, we have built a simple CSV / TSV Bulk upload option and have provided you sample files to get started with immediately for the process.
Procedure
1. To start adding multiple products, go to Store in the menu option then select Product.
2. In the Products page click on Add/Import option, then select the Bulk add products option.
3. Here you will find 2 options for bulk upload, i.e. ‘Upload product data file’ & ‘Upload product variations data file’.
If your products have variations click on the ‘Upload product variations data file’ tab.
4. You will find a sample file link below the upload option, click on ‘here’ to download the sample file and know the format for product upload.
Important Notes : Before your start uploading your .CSV or .TSV files for your products or variations, follow the below instructions -
a. Make sure the column formatting matches the identifier type that Jumper accepts.
b. Make sure you have not, by mistake made any changes to the column headers including adding extra spaces, additional characters, or updated the sequence of the columns
c. Make sure your product information is entered using the correct format types detailed in the sections below.
This helps Jumper process the hashed column data to find matches during the upload and If you face any error during the upload, please make sure to verify your file is inline with the details mentioned here.
5. Formating Product Information
| Identifier type | Column header | Description & Formatting guidelines | Examples |
|
Product trigger / hashtag |
hashtag |
The product hashtag is an unique identifier for each product on Jumper. And can be used as a trigger keyword by the customer to start an automated purchase for the product. You can ideally choose any combination of numbers and alphabets for 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 products 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 add detailed descriptions about your products, eg composition, ingredients, specifications, etc. The details you add here will show in a web view when the customer clicks the "View details" button attached to your product cards. This information is optional. There are no character limits, however if you are uploading 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 Right link: - https://media.giphy.com/media/kDZyKwgD4ULeASnrof/giphy.gif
|
| 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 kilograms | 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 customizations 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 centimeter | height_in_cm |
The height of your product packaging is centimeters. You can skip this column if you don't have volume based shipping settings, or have variations.
|
10 |
| Product width in centimeter | width_in_cm |
The width of your product packaging is centimeters. You can skip this column if you don't have volume based shipping settings, or have variations.
|
5 |
| Product length in centimeter |
length_in_cm |
The length of your product packaging is centimeters. You can skip this column if you don't have volume based shipping settings, or have variations.
|
5 |
6. Once you have your .CSV file format with the following instruction mentioned above, upload your file by clicking on the upload option.
Once uploaded, you should see all your products that you just imported on your products page.
Articles in this section
- Creating Collections with Categories
- Creating Collections without Categories
- Bulk Update of Products
- Adding Products in Jumper (Bulk Add products via CSV) - Without Variation
- Adding Products in Jumper (Single Product Upload) - With Variation
- Adding Products in Jumper (Single Product Upload) - Without Variation