DG1 allows you to import multiple products in the system. For a perfect import, one should prepare as much information as possible and make sure they prepare them according to these instructions.
- Product Groups and their IDs OR Custom product group IDs
- Brands and their custom IDs
- Categories and their custom IDs
- Tax rates
- Attributes (descriptions, specifications, sizes, colors etc.) – any descriptions can be also added as full sentences
On this page
- Simple import
- Advanced import
- Import products with images
- Table of all import fields
- Saving .csv file
- Start product import with .csv file
- Product group ID (Either select the one in the list - on the left, Key or Custom product group ID)
- Regular price
Find the example of a simple .csv spreadsheet here.
After the preparation of all necessary data in the system (product groups, categories, brands, taxes, shipping methods, payment methods, etc.), you have to prepare a .csv file.
The first line of your .csv spreadsheet needs to include the field headers described in the table - the headers can be the same or similar. Later you will connect each column to correct headers.
Later lines in the file should contain data for your product. To prepare a .csv file you can use excel or any other type of spreadsheet.
Each information about the product has to be in a separate column.
Import products with images
To import products with images, you first have to upload images to the File system. You should know which image will be displayed in which location. Example: image 0022.jpg will be displayed as product’s main image. To remember where each image will be displayed, you should prepare a list of image names and their locations, for your reference only.
Each image name has to be put in a separate column and after importing .csv you will have to choose between the following headers for each image: Main image, Cover image, Gallery image, and Bottom gallery image.
Here are the instructions for each header (column) you select in your imported file and how/what to write in the .csv spreadsheet.
|ID||The ID number is a unique number of the product. At the first import, the ID must NOT be written, but it must be added to your .csv when UPDATING the import. When updating import, you must use the same ID number in order to update the product successfully. Make sure you don’t use a different ID number so the product is not overridden with another one.|
|SKU||SKU is the product’s stock keeping unit of the product and usually connected to other tracking inventory services.|
|Custom product ID||Use any letters, numbers, or text symbols.|
|Product group ID||This is obligatory information. It is created when adding a product group. Find it in Catalog -> Product groups -> ID|
|Product group key||Optional. Use either product group ID or key. Key is written under Catalog -> Product groups -> Key|
|Name||One of the most important information that is required in each import. Name can contain letters, numbers, text symbols, and spaces.|
|Alias URL||It is created automatically. To customize it, it must be written in a URL version. (example: /product-alias-url)|
|Short description||It should not exceed 220 characters. Plain text without styling.|
|Brand ID||Find it in Catalog -> Product brands -> ID|
||Write the number of pieces, kilograms, meters, cubic meters or liters with a number. For decimals, use the separators from Formatting settings in Sites.|
|Net quantity||Enter the net quantity of the product which will be used to calculate the price per unit. Write it according to your decimal and number separators in Site settings.|
|External URL||When you wish to redirect a user to another site. Write it in the URL style.|
|Measurement unit||Write it according to your selected measurement units.|
|Add to cart unit||Write it according to your selected measurement units.|
|SITE SPECIFIC SETTINGS|
|Regular price||The price of the product. Don’t include any currency symbols. Write it according to your decimal and number separators in Site settings.|
|Can be bough||1 - checked (YES), 0 - unchecked (NO)|
|Display on content pages||1 - checked (YES), 0 - unchecked (NO)|
|Display in product grid||1 - checked (YES), 0 - unchecked (NO)|
|Is activated||1 - checked (YES), 0 - unchecked (NO)|
|Deactivated from||Write in format (YYYY-MM-DD HH:MM:SS)|
|Deactivated to||Write in format (YYYY-MM-DD HH:MM:SS)|
|Stock||The number of items you have in stock for this product.|
|Tax rate name 1||The Title of the Tax rate.|
|Tax rate value 1||The tax rate value (example: 22)|
|Tax rate name 2||The Title of the Tax rate.|
|Tax rate value 2||The tax rate value (example: 22)|
|SEARCH ENGINE OPTIMIZATIONS|
|Searchable||1 - checked (YES), 0 - unchecked (NO)|
|SEO descriptions||Plain text without styling.|
|SEO keywords||The keywords should be separated with a comma.|
|Include search words||The words must be separated with a comma.|
|Exclude search words||The words must be separated with a comma.|
|Gtin 1||The barcode or EAN of the product.|
|Gtin 2||The barcode or EAN of the product.|
|Category ID 1||It is the unique number given by the system. You find it in Catalog -> Categories -> Edit category|
|Custom category ID 1||It is the identifier given by you. Find it in Catalog -> Categories -> Edit category|
|Category name 1||The name of the category. Write it in the same way as the category name.
Note! For multiple categories, separate the ID value of each category or subcategory in a separate column. You can also assign the product to only one specific subcategory.
|Is tangible||1 - checked (YES), 0 - unchecked (NO)|
|Weight||Write it according to your decimal and number separators in Site settings.|
|Volume||Write it according to your decimal and number separators in Site settings.|
|Width||Write it according to your decimal and number separators in Site settings|
|Height||Write it according to your decimal and number separators in Site settings.|
|Length||Write it according to your decimal and number separators in Site settings.|
|Tobacco product||1 - checked (YES), 0 - unchecked (NO)|
|Alcoholic product||1 - checked (YES), 0 - unchecked (NO)|
|Additional shipping requirements - fragile||1 - checked (YES), 0 - unchecked (NO)|
|Additional shipping requirements - refrigerated||1 - checked (YES), 0 - unchecked (NO)|
|Is main variation||1 - checked (YES), 0 - unchecked (NO)|
||At the first import create your own Main variation custom product ID.
At the update use any of the three. Main variation product ID can be found at the Catalog -> Products
|ATTRIBUTE TYPES||Types of mapping in the .csv file|
|Checkbox||Obligatory information in Catalog -> Products -> Edit/Add product -> General settings and Site specific settings tabs and checkbox attributes): YES: 1 - checked, NO: 0 - unchecked|
|Select||Put in the title of the option (example: Color: red)|
|Select with image||Put in the title of the option (example: Color: red)|
|Multi select||Put each value in a separate column and in the preview of the file select exactly the same location (exactly the same attribute) of the value. (Example: Suitable for: outdoor and indoor)|
|Attribute Text||Write the whole text in one column.|
|Date time format||Write it according to your Date formatting selection in Site settings. Write either date only (20.05.2020) or date and time (20.05.2020 14:30:15).|
||Put in the location of image and name of the image with the file format (example: products/image.png or /products/image.png)|
Saving .csv file
Once you have prepared a spreadsheet you have to save it to your desktop as csv. file.
- Save as
- Select type: csv. or csv (comma delimiter)
- File name
- Keep current format
- Character set = UNICODE UTF-8
- Field delimiter is comma (or other)
- Text delimiter (example: “quote mark”) will be added automatically - quote all text cells (check).
WINDOWS USERS: If you are working with latest Excel, when clicking Save as, you will have to go to Tools, select Web options and choose Encoding (UNICODE UTF-8). Excel will choose field enclosure and text delimiter based on locale setting in the system. Different locales can have different settings.
To test what type of quotation mark your file will use, you can always just open your excel spreadsheet in Notepad and see what quotation was used. You do that by right mouse clicking on your csv. document. First you choose Open with, then Notepad.
MAC USERS: If you are using Numbers application, you can export to .csv file by clicking File -> Export to -> CSV. In the new window expand Advanced Options and select Unicode (UTF-8) text encoding. File will usually be exported with semicolon as separator. To check what type of quotation mark and separator is set, you can open the csv file in TextEdit application. You do that by right mouse clicking on your .csv document. First you choose Open With and then TextEdit.app.
If you have any other spreadsheet applications, please go online and find a tutorial or manuals on how to save a .csv file.
Start product import with .csv file
- In your SHOP section go to Catalog and click Product import.
- To add new product import click Add .
- Enter details about new product import:
- Name your Import.
- Add a description to your likings.
- Select a document to import (your previously saved csv. file).
- Check the Contains headers checkbox (only for spreadsheets with headers).
- Then choose exactly the same delimiters (Field separator and Field enclosure) as when you were saving the file.
- Once you import the document and see the preview, go thoroughly through every column and find the right location of the column. By clicking Skip all the available options will appear, you just have to make sure to locate the correct one.
- When you wish to save the document, click Submit .
You are now back at the list of your imports. The status of your import document should now be Prepared.
- Once you are ready to import, click Actions and Import.
The system will start the import and this may take some time.
After refreshing the site, you will see the status being changed to Completed.
After the status is completed, you must View your import and see if all products have been successfully imported. If the status is Failed, then click Show reason and see what went wrong.
After correcting csv, import products again. You have to repeat the whole process.
If the import was successful then the status of each product will be changed to Success.
Recommended maximum amount of imported products per session: maximum 1000 products per one import. If you can do it with less products, then do it with less. Estimated time to import 1000 products is one hour.
If importing for the first time, we would highly recommend you try to import up to 20 products so that you can see what additional info you need or would like to prepare.