Adding many products manually can be a time consuming task. A faster method is to import your products.
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.
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.
Most problems arise because of an import file of poor quality. Always check the file before importing.
You can import in 3 ways:
Use the verification code DOIMPORT (uppercase) to confirm the upload.
You will now see a list of the imported data. These data are in a temporary database and have not been imported yet.
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.
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.
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.
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.
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.
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.