Support

Import Products via a CSV file

Importing products is useful when you need to update a large number of products in your store, when you have thousands of products to load or when you need to import your products from an existing store to your new Jumpseller store.

Contents

  1. The Import File
  2. Import Products from Another Platform
  3. Update Existing Products in your Store
  4. Upload New Products
  5. Frequently Asked Questions

The Import File

The import file must be in CSV format. We recommended and support UTF-8 to import CSV files, so that special characters can be handled: á u or, which are displayed in specific encoded formats.

Microsoft Office does not handle UTF-8 characters very well, so we recommend using Google Sheets or LibreOffice since they do it correctly. This will avoid errors in your import process.

You can be sure about how your CSV should look, cheking our template that contains: all fields + 2 product options and 2 product variants. We recommend checking that your import file is arranged exactly like the template before doing the import process.

Important: The file has columns and each column must contain a field. The columns of the CSV file must be exactly in the order of the sample template and in the table presented here.

Fields

Name Description and Important Observations
Permalink Unique identifier of a product. Must be blank when creating a new product.</br>
Name Name of a product.</br>
Description Description of a product.</br>
Meta Title Product title to be shown in Google search results.
Meta Description Product description to be shown in Google search results.
Width Product Width (for packaging and shipping purposes).
Length Product Length (for packaging and shipping purposes).
Height Product Height (for packaging and shipping purposes).
Brand Brand of a product.</br>
Barcode Barcode information of the product (e.g. GTIN, UPC)</br>
Categories One or more categories’ permalink (e.g: winter-2014 ) or one or more category’s name (e.g. Winter 2014).</br>
Images One or more images’ URL . Links to many images per product should be separated by a comma and these links are required to be publicly accessible. Example: “http://domain.com/images/a.jpg”,”http://domain.com/images/b.jpg”</br>
Digital Defined as “YES” if the product is digital or “NO” if not. By default, if you don’t import the column, the product will be non-Digital.</br>
Featured Defined as “YES” if you want the product to be featured or “NO” if not. By default, if you don’t import the column, the product will not be featured.</br>
Status The status of the product in the store. Can be one of three values - available, not-available, disabled.</br>
SKU Stock-keeping unit identification.</br>
Weight Weight or volumetric weight of a product.</br>
Stock Stock number of a product.</br>
Stock Unlimited Defined as “NO” if inventory is tracked or “YES”.</br>
Price Price of a product.</br>
Variant 1 Option Name Option Name of the first variant of a product, eg: Color.</br>
Variant 1 Option Type Option Type of the first variant of a product. By default this type is “option” for a selection.</br>
Variant 1 Option Value Option Value of the first variant of a product, eg: Yellow, Blue or Red.</br>
Variant N Option Name Option Name of the Nth variant of a product. N should be a sequential number, eg: 1, 2, 3, 4.</br>
Variant N Option Type Option Type of Variant N of a product. Accepted values: ‘option’,’input’,’text’ or ‘file’.</br>
Variant N Option Value Option Value of the Nth variant of a product. N should be a sequential number, eg: 1, 2, 3, 4.</br>
Custom Field 1 Label Label of custom field 1 that was previously created.</br>
Custom Field 1 Value Value to be added to custom field 1.</br>
Custom Field N Label Label of Nth custom field that was previously created.</br>
Custom Field N Value Value to be added to Nth custom field.</br>
Google Product Category The category for Google Shopping (if you use this tool) must be written exactly the same as seen in the list that appears on the product page when you create it.</br> For example: Apparel & Accessories > Clothing > Suits > Tuxedos. You must leave a blank space between each category and the > symbol.

If you have more questions about how to import/export a Google Product Category, please consult the support page from Google.

  • The permalink is the unique identifier for each product.
  • Jumpseller searches for a product by its permalink.
  • You can find the permalink of each product at its URL. For example, the permakink “yellow-tennis” is associated with the Product named “Yellow Tennis” . Hence, the URL: www.mystore.com/yellow-tennis.
  • Permalinks are composed with lower case letters or numbers and containing no spaces.

When you upload a file, there may be several scenarios regarding permalink:

1. If you are updating existing only product data:

In this case you DO NOT modify the permalink column. Only the rest of the data.

2. If you are uploading only new products:

In this case the permalink column must be empty, since the system will assign that value automatically.

3. If you are uploading a file with new products and existing products to which you had modified some data:

The permalink of new products must be blank. The existing products must NOT be modified.

Product Variants

Each product variant uses a row, shares the same Product Permalink and with the following blank columns: Name, Description, Brand, Categories, Images. Look at this example:

This variant of a product:

Import Variants

It is reflected in the CSV file like this:

Import Variants

Variants are compared with their Name / Value option (e.g. Color: Blue) and the properties of the Variant, such as SKU, Weight and Stock are updated.

If we cannot find a Name/Values combination, they will be added as new product options.

Images

  • When you import new or existing products on another platform, the images must be uploaded to the internet first. You can only use URLs for your images.
  • Tip: use an external FTP to upload images and get your URL.
  • Multiple images can be added per product and must be separated by commas and double quotes, for example: “http://myimage1.jpg,http://myimage2.jpg”.
  • There is a maximum download time of 5 seconds per image. File size images should not exceed 1.5Mb
  • Gdrive, Gphotos & Dropbox Share or Viewer links will not work for the Images column when importing CSV files. The import function needs a “direct link” to download. As a free alternative, try ImgBB

Why were some images not imported?

In some cases, the images may not have been imported yet, as the process may take some time. This may be because you imported a large number of images, the CSV file is too large or the image servers are slow.

There may be many reasons to block the import of images, such as:

  • Image size may be too large.
  • Blocked by the image server.
  • Incorrect coding.
  • Spaces in URL.
  • Incorrect URL (Jumpseller can download images only from direct image URLs).

Import Products from Another Platform

The first thing you should do is modify the CSV file you obtained from the other platform, so that it contains each and every one of the fields described in the section on the import file.

  1. Keep the “permalink” field empty (you will create products that are not in your Jumpseller store).
  2. Make sure the rest of the fields contain the correct information.
  3. Make sure the fields are in the exact order described above.
  4. Make sure the URLs of the images are spelled correctly as indicated here
  5. Save your file in CSV format.
  6. Go to your Administration Panel > Products and select “Import File”.
  7. Upload your CSV file by selecting it from your computer.
  8. Check the boxes in the header of each field on the import screen.
  9. Click on “Import” and check the import results in your email.

Update of Existing Products in your store

To update information on existing products:

  1. Export current products to a CSV file.
  2. Keep the permalink link unchanged.
  3. Edit product details, such as name, sku or stock.
  4. Save your file again in CSV format.
  5. Check the boxes in the heading of each field on the import screen.
  6. Click on “Import” and check the import results in your email.

Upload New Products

If you have many new products and want to make a massive load of them, follow these steps:

  1. Download our sample template
  2. You must fill in the data in the corresponding fields.
  3. Keep the “permalink” field empty (you will create products that are not in your Jumpseller store).
  4. Make sure you don’t change the order of the preset fields in the template.
  5. Make sure the URLs of the images are spelled correctly as indicated here
  6. Save your file in CSV format.
  7. Go to your Administration Panel > Products and select “Import File”.
  8. Upload your CSV file by selecting it from your computer.
  9. Check the boxes in the header of each field on the import screen.
  10. Click on “Import” and check the import results in your email.

Important: Do not forget to check the boxes in the header of each field on the import screen.

Import Screen

Submit a question to our Support Team if you need it (don’t forget to attach your CSV file).

Frequently Asked Questions

Is it possible to import products without custom fields?

Yes, you can import products without custom fields. Also, custom fields are not deleted when importing for protection.

Is it possible to delete custom fields for my products?

It is recommended to NOT delete custom fields via the CSV.

My import file does not work. What can I do?

  • Reduce the products in the CSV file to only one.
  • Confirm that the problem still exists in that single product.
  • Import that CSV into Google Sheets.
  • Confirm that the problem still exists in that single product on Google Sheets.
  • Send the Google Sheets link (with the edit permissions) to support@jumpseller.com

How do I synchronize an inventory system to load and update products?

It is possible to do that through our API and it is necessary to develop an integration, if you have a developer who supports you with the technical part you can contact us or we can recommend one of our list of professionals so you can achieve it.

If you have additional questions you can write to our support channel.