EasyWebshop

Importing products and categories

Orders Adding many products manually can be a time consuming task. A faster method is to import your products.

Possibilities

Important

The import module is an expert module. It's a powerful module with a lot of features that allow you to add and update lots of products in a short time span.

With a lot of features comes extra responsibility. Please read these tips before importing on a large scale:

  • Read this documentation page thoroughly before using the module
  • Make sure you have unique article codes for your products and product variations. If not, you cannot update your products afterwards
  • To be able to use spreadsheets and CSV files a basic knowledge of office is required
  • Start with a few products, so you can undo a faulty import easily
  • Prepare yourself with a small amount of products: this prevents situations where you have to manually delete or update thousands of products manually

You can find this module at Settings > Modules > Import products.

If Import products is not displayed in the menu, first adjust the user level to Expert, at Settings > User experience level.

This is an expert module. It can take a while before you have mastered this part.

Office knowledge is required. Please don't use this module without the necessary knowledge.

Start with a small file, so a failed import can be undone easily.

Step 1: Provide a good source file

You need to have a file which contains the products you want to import. This can be a spreadsheet file, an export from your supplier or a POS export. You can import up to 1000 products at a time. If you want to import more products, you can split the file into several blocks.

.csv
This is a comma-separated values file where each product is put on a separate line and the fields are separated by commas. (See an example)
Do not use semicolons.

.ods
This is a spreadsheet file in the OpenDocument standard. (See an example)

The following office applications are suitable to work with OpenDocument Spreadsheet files:

.xml
You can also use the XML standard for importing. Provide a root element below the product elements. (See an example)
.xls, .xlsx
Non standard formats can be converted. You can use LibreOffice or youconvertit.

Most problems arise because of an import file of poor quality. Always check the file before importing.

Step 2: Choose an import method

You can import in 3 ways:

Use the verification code DOIMPORT (uppercase) to confirm the upload.

Step 3: Check your import

You will now see a list of the imported data. These data are in a temporary database and have not been imported yet.

Import

At the top you can select the column title.

Make sure the columns correspond to the data, otherwise all the data will be scrambled and you will have to remove all the products.

All data can still be modified at this stage. Click on the table cell you wish to change. The cell will be displayed as a pop-up so you don't need to modify everything in the tiny cell. Click anywhere outside the pop-up to save. If you have more than 15 products, you can use the navigation below to view the following pages.

Delete Sometimes when you are converting files, extra rows (products) are added. Remove these products before you start importing.

If you don't want a column to be imported, select the column titel Delete.

Importing categories and photos

You can also import categories. If the category name you enter, doesn't exist, a new category will be created. If your shop is multilingual, fill out the translations of the new category afterwards.

You can import photos by pasting the URL of the photo. Placing a picture in a spreadsheet file is not possible: this would make the file too large for an upload. The photos must therefore be located at an internet address. The images are automatically retrieved, scaled proportionally (in combination with the High Quality Photos module) and a thumbnail is created. Provide an image < 1MB in the .jpg, .gif or .png format.

Editing products or variations

When you enter a product with an article name that already exists, the product will be updated with the new data. The names have to be identical, otherwise a new product will be added.

Make sure to set the column titles of the fields that don't have to be adjusted to "Delete". Otherwise all the current data of your product will be replaced by empty fields.

Step 4: Import

Check the data thoroughly.

If you are sure that everything is correct, click Import. It may take a while before the next page is loaded: please wait patiently and don't leave the page.

Possible product statusses

Copying products from another shop

You can import up to 1000 products at a time. If you want to copy more products, just select categories until you reach 1000 products. Then repeat this procedure for the remaining categories.

Products and product photos are copied automatically.

Automation

Possible problems

I get a white screen after uploading my file
The file is too large. Split the file into smaller files and upload the files separately.
When an order is made, the price is zero
The price column should always be numeric. Never fill in a currency sign.
I want to add or update more than 1000 products at once
An upload of more than 1000 products via a web interface is not the appropriate method.
- You can split the file and import several times.
- You can perform an import or update automatically by using the API.

Next page: Shop configuration >>>

Overview

Info

Documentation