Import

If you have the Plus, PRO or Enterprise subscription you will have access to the Import app that will help you import all the products and all their details.

It is recommended to have and to use this app when you switch from a different platform to Gomag, because it will allow you to import in your new online shop all the products that you had in the old one, with all their details.

Once this app is activated, entering the Products section from the main menu you will find the Import button in the top-right corner of the screen, button that will open a new page. Here you will see the imports you did throughout the time and you can add a new one anytime by clicking the Import Products button.

Import products in your shop

In order to import correctly you have to follow a few steps:

(click on the step you want to jump to)

• Step 1: Choose the prodcuts file
• Step 2: Color the columns
• Step 3: Configure the import options
• Step 4: Finish and track the import
• Extra: Tips for creating the import file  + file example

Step 1:  Choose the products file

Click on the Select File button and upload from your computer a file with the XLS or TSV extension.

The products file that you send for the import does not have to contain text with style (colored column. Bolded text, italic text, underlines and other text or table styling).

You can download an import file example at the end of this (click HERE to jump to this example).

Step 2: Color the columns

Before coloring, make sure that you have created in your shop the attributes related to the columns from the import file.  The options for the attributes will be added automatically from the file, so you don’t have to add them manually.

In case you will use an import file with options. It is necessary to create the list kind of attributes that will be used in the options configuration.

Establish exactly how you are going to use the imported information from the import file in your shop and under which form will they be found in the products details.

• One by one, click on the Choose text related to each column to establish how the link (coloring) between the information from the file and the ones from the shop will be done.

• In the window that will open, choose the product property that can be found in that specific column from the file. For example, the “brand” column will be linked to the “brand” property.

• After you follow these steps for all columns, you will be able to see in the table how the link is done.

• If you don’t want the values from a certain column to be taken into consideration when the import is done, uncheck the box related to that column.
• Optional, you can save the link that you have done in case you will import files with the same columns in the future.
• Choose the first row from the imported table to be ignored if this contains the name of the columns (as it is the case for the example above).

Step 3: Configure the import options

Open the Import Options tab and finish the import settings as it follows:

• Choose how you want the new products to be managed. In case the file contains products that you don’t currently have in your shop, they can be added or not.

• Choose whether the images and other import files to be taken over or not, selecting one of the options:
  
  • Yes – The images from the file will be taken over and will be added to the existing ones.
  • No – The import will be done without taking the images over.
  • Replace – The images from the file will be taken over and they will replace the existing ones.

• In the file that you uploaded, the row linked to the products’ images can be filled up with two types of values: the complete URL ( example: http://domeniu.ro/ftp/bb12.jpg) or just the name of the image ( ex:bb12.jpg).
• If the file contains complete URL, you don’t have to fill in the Prefix Images URL

• If the file only contains the names, it is necessary to fill in the Prefix Images URL field with a prefix in order for their complete URL to be automatically built.

• Optionally, after introducing the prefix, you can test it by adding in the Test the iamges’ prefix field the name of an image from the file.

You don’t have to take the images URL for import from cPanel.

Find out how to add images from FTP from HERE .

• You can choose for only the information about the price and stock to be imported from the file, and the rest of the rows to be ignored. ( Once this option is selected, the following options from this page will disappear because they are no longer needed.)

• Use the options Reset Categories and Reset Attributes to replace all these values with the ones from the file.

• Specify the used symbols as Categories Separator and Multiple Values Separator in the file that you wish to import.

Step 4: Finnish and follow the import

Once you are done configuring the options for the import, click on the Start Import button from the right top corner of the page.

A page will be displayed with all the imports done till present, where you can follow the status of the import done now.

Extra: Tips for creating the import file + file example

Fill in the “ Active in the shop “ column with “ yes “ or “ no “ depending on how you want the products to be displayed in the shop; thus, the products are inactive so they are not visible in the shop.

Fill in the “Manage the products’ stock” column with “yes” or “no” depending on how you want the stock for each product to be managed; thus, after the import, the products’ stock is not managed.

It is necessary to fill in the “VAT Rate “column in case the “Price includes VAT” column is filled in with the “no “value; otherwise, the VAT rate for that product will be the one set for the entire shop. 

Here you can download one of the two examples for your import files: