Upload Products to your Online Store
The most essential part to get your online store started is adding your products. With this tutorial, we want to give you a brief overview of how y...
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.
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.
|Name||Description and Important Observations|
|Permalink||Unique identifier of a product. Must be blank when creating a new product.|
|Name||Name of a product.|
|Description||Description of a product.|
|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.|
|Barcode||Barcode information of the product (e.g. GTIN, UPC)|
|Categories||One or more categories’ permalink (e.g: winter-2014 ) or one or more category’s name (e.g. Winter 2014).|
|Images||One or more image URLs. 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”|
|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.|
|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.|
|Status||The status of the product in the store. Can be one of three values - available, not-available, disabled.|
|SKU||Stock-keeping unit identification.|
|Weight||Weight or volumetric weight of a product.|
|Stock||Stock number of a product.|
|Stock Unlimited||Defined as “NO” if inventory is tracked or “YES”.|
|Price||Price of a product.|
|Variant 1 Option Name||Option Name of the first variant of a product, eg: Color.|
|Variant 1 Option Type||Option Type of the first variant of a product. By default this type is “option” for a selection.|
|Variant 1 Option Value||Option Value of the first variant of a product, eg: Yellow, Blue or Red.|
|Variant N Option Name||Option Name of the Nth variant of a product. N should be a sequential number, eg: 1, 2, 3, 4.|
|Variant N Option Type||Option Type of Variant N of a product. Accepted values: ‘option’,’input’,’text’ or ‘file’.|
|Variant N Option Value||Option Value of the Nth variant of a product. N should be a sequential number, eg: 1, 2, 3, 4.|
|Custom Field 1 Label||Label of custom field 1 that was previously created.|
|Custom Field 1 Value||Value to be added to custom field 1.|
|Custom Field N Label||Label of Nth custom field that was previously created.|
|Custom Field N Value||Value to be added to Nth custom field.|
|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. 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.
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.
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:
It is reflected in the CSV file like this:
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.
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:
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.
To update information on existing products:
If you have many new products and want to make a massive load of them, follow these steps:
Important: Do not forget to check the boxes in the header of each field on the import screen.
Submit a question to our Support Team if you need it (don’t forget to attach your CSV file).
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?
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.