Welcome to DG1 support.

GETTING STARTED GETTING STARTED
SETTINGS SETTINGS
SHOP SHOP
MARKETING MARKETING
WEB CMS WEB CMS
BOOKING BOOKING
THEMES THEMES

Products import

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.

When importing products to DG1 platform, you first have to prepare the following information:
  • 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

When importing products to DG1 platform, the most crucial information are the following:
  • Product group ID (Either select the one in the list - on the left, Key or Custom product group ID)
  • Name
  • Regular price

Find the example of a simple .csv spreadsheet here.

Advanced import

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.

Download examples of .csv spreadsheet:

Here are the instructions for each header (column) you select in your imported file and how/what to write in the .csv spreadsheet.

GENERAL
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
  • Maximum quantity for regular buyers
  • Maximum quantity in cart for company buyers
  • Minimum quantity in cart for regular buyers
  • Minimum quantity in cart for company buyers
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 RATES
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/EAN/BARCODE
Gtin 1 The barcode or EAN of the product.
Gtin 2 The barcode or EAN of the product.
CATEGORY
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.
SHIPPING
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)
VARIATIONS
Is main variation 1 - checked (YES), 0 - unchecked (NO)
  • Main variation product ID
  • Main variation product code
  • Main variation custom product ID
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).
IMAGES
  • Main image
  • Cover image
  • Gallery image
  • Bottom gallery image
Put in the location of image and name of the image with the file format (example: products/image.png or /products/image.png)
Note! If you realize that you have imported wrong information at the first import you can delete all products and start from the beginning or only import products with correct information. The products will be imported to the selected site. Selected site

Saving .csv file

Once you have prepared a spreadsheet you have to save it to your desktop as csv. file.

In your spreadsheet go to:
  • 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).
  • OK.

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.

4

1 5

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.

6

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.

copy 3

copy 1

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

  1. In your SHOP section go to Catalog and click Product import.

product import

  1. To add new product import click Add add.

add product import

  1. 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.

9

  1. When you wish to save the document, click Submit submit.

You are now back at the list of your imports. The status of your import document should now be Prepared.

  1. Once you are ready to import, click Actions and Import.

10

The system will start the import and this may take some time.

11

After refreshing the site, you will see the status being changed to Completed.

After the status is completed, you must View 10 your import and see if all products have been successfully imported. If the status is Failed, then click Show reason 14 and see what went wrong.

12

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.

13

IMPORTANT!
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.
We’re here for you
If you have any questions or concerns, our Help Center might have the answers you’re looking for.

Online support center

If you encounter any problems, submit a ticket through the online support center and our team will get back to you as quickly as possible. You will continue to be updated as we work toward a solution.

Submit your ticket

Live support

During business hours we can assist you through online chat. It’s built right into our website - no plugins or installs needed. Please click help button on the left side at the bottom of this page.

Remote desktop support

For members having specific technical issues, we also provide remote desktop support.

teamviewer

Browser upgrade Recommended
Our website has detected that you are using an outdated browser that will prevent you from accessing certain features.
Use the links below to upgrade your existing browser.