Custom Gateway - Customer Support

Welcome to the Custom Gateway Support Portal

Here you can raise support tickets and read articles on common queries using the topic sections and search below

Importing products using Magnetic One


Magnetic One is a software which allows users to connect to a website and edit things which are on the website, e.g. Prices and Names of Products. In this article I am going to explain how to import products onto a website using this tool. 

First Stage is you will have to open Magnetic One, once it has been opened a screen like this will appear. (Picture 1). Once this screen appears you will need to connect to a website (store view), to do this you will need to go to settings at the top of the screen and then go down to connection wizard. Once connection wizard has been selected, it will bring up a box which asks you to select between three options these options are; simple mode, advanced mode and support.   Once you have selected between simple or advanced, it will then open another box which will give you two options; create a new store connection and configure a current connection. To connect to a new site press new store connection, Magnetic One will then ask you for the credentials to the website. Once the FTP details have been entered you should then connect to the website, when connected to the website through Magnetic One you will be able to see list of products and other things which are within the website build. 

Right now you are connected to the website, you are now able to import products onto that site, to do this you have to go to the store view at the top of the screen then to import/export, once import/export has been clicked it will then bring down a drop down menu where the user is able to choose what they wish to import. In this article I am going to talk through how to import products to a website using Magnetic One. 

After the user has selected the import products from the drop down menu a box will appear with two different options, (PICTURE) these options are; import and export. Click on the import button this will then take you to stage two of the import routine, the second stage is selecting a CSV file from your computer so that you can import your products. (Picture). After the user has selected the CSV file they wish to import onto the website it will then give the user a preview on the CSV file so they can check for abnormalities within the CSV, after the user has thoroughly check the CSV preview they can click next and continue with the import routine. 

The stage after the CSV preview is where users are able to import images with the products and set up field delimiters and quote characters (Picture). As standard we mainly have the follow options below;

Select delimiter character which will be used to separate field data:    ,  (Comma)

The quote string value with tick box is:    " (Speech Mark)

Select delimiter character which will be used to separate categories in category tree:   | (Line Break)

Select delimiter character which will be used to separate images in image gallery:   | (Line Break)

Select delimiter character which will be used to separate data in related fields:   , (Comma)

After you have filled out the field delimiters you can then select image folders so users can import images with the products they are wishing to import, the user can select the folder location by clicking on the little icon with three dots next to the local directory with images. Once the field delimiters and images have been selected you can progress to the next page. The next page is selecting which store view the products are going on, this only needs action if the site has multiple store views and you only want the products going on one of the views.

After these stages are done, it will be time to assign fields from the CSV to fields on the site.(Picture) To assign fields you will need to click the header of a field on the right hand side view, then find the field which it needs to be assigned to on the left hand side view the click the text. Once all fields have been assigned you can continue.

NOTE: Not all fields need to be assigned to be able to progress, it is recommended that you take unnecessary fields out of the CSV before importing to save time on import and to get rid of the risk of the unassigned data messing up the import.

Tip: In your CSV file you can name the headers of each column in a specific way so it auto assigns the field which I have just talked about above, this saves time and also the chance of wrong assigning. The way to do this is; 

For one word columns like SKU it would be <SKU>

And for two word columns like Tier Price it would be <Tier_Price>

Underscore goes in between words and they also must be in them characters. This is not necessary, but makes Magnetic One assign the fields automatically.

 After the fields have been assigned click continue, this will bring up a final import preview when checked hit next and import will begin.

Was this article helpful?
0 out of 0 found this helpful