File Loading (CSV)


Below are details on how to manually import a product file, please note that if this feature is used incorrectly it can severely affect your website and its contents. There are checks in place to try to prevent corruption of your data but this is not guaranteed, therefore only experienced users should import a database.


If you have any doubts over the setup of your automation, please contact the support department for guidance.


1. Prepare your file


The first step required is to create your file, this may be a download of the data. Within Excel (or a similar spreadsheet editing program) add / amend the required data you need to change. If creating new products from a fresh sheet make sure you add the required fields and relevant column headers. The file must be saved as a CSV.


2. Upload the file


Within the backoffice, navigate to Database Tools > Database Imports and click Upload CSV, select your CSV from the pop up window. Now click on the button Process CSV to proceed to the next step. You will then be prompted to map your file.


You will then be required to select the process type for your file.


Update or Replace


3. Map the template fields


On the left hand side of the screen you will see your column headers, on the right hand side will be dropdown menus with a list of all mappable fields. You will need to select the relevant fields on the right hand side to match your column headers, if your import will be for new products, be sure to include the price, categores and title aswell as the product code.


For category navigation, select 'category' for each level, first category column will the main top level category.

For images, select 'Product Images' for each, first image column will be the main image.

Note; you can't mix 'Product Images' and 'Product images Remote' in the same file.


Automated Loading (CSV)


Below are details on how to configure an automated product import, please note that if this feature is used incorrectly it can severely affect your website and its contents. There are checks in place to try to prevent corruption of your data but this is not guaranteed, therefore only experienced users should import a database


If you have any doubts over the setup of your automation, please contact the support department for guidance.


1. Prepare your template file


The first step required is to create your template file, this may be provided to you by the source of the data. Within Excel (or a similar spreadsheet editing program) you will need to enter your column headers. Please note that if the structure of the file changes, you will need to remap the file.


2. Upload the file


Within the backoffice, navigate to Database Tools > Automated Imports and click Configure An Import Database, select CSV. You will then be prompted to locate your template file to upload. Once the upload is complete, click Process CSV.


You will then need to complete the following fields.


Filename: This must be unique to each setup and also must include the extension '.csv'. Files posted must contain the setup name.
Upload Every: Select from 15 mins, 1 hour or daily
Import Type: Select either Update or Replace
Decription of Upload: This is for your reference only
Email Address: Enter the email address you would like the email confirmation sent to
CSV Attachment: Opt for the CSV results report attachment to the email confirmation

Disable unmodified products after processed: This will disable any item on the website which doesn't match the file, ideal for 3rd party systems that send full inventories.

Clear all images from FTP area after processed: This will remove all .jpg images from the FTP 'Root' directory at the end of the process.
Enable Now: Select either Yes or No


* File name setup can also include a 'Timestamp' or variable, if this is required then {VAR} is included within the name, ie; stock_{VAR}.csv 'Stock_' part remains constant.


3. Map the template fields


On the left hand side of the screen you will see your column headers, on the right hand side will be dropdown menus with a list of all mappable fields. You will need to select the relevant fields on the right hand side to match your column headers, if your import will be for new products, be sure to include the price, categores and title aswell as the product code.


For category navigation, select 'category' for each level, first category column will the main top level category.

For images, select 'Product Images' for each, first image column will be the main image.


Note: you can't mix 'Product Images' and 'Product images Remote' in the same file.


Update Method


Nearly all of your imports loads will be classified as an update, including new data. This is used to add to the data already assigned to a product, for example, if you import categories as an update, the product(s) will then be assigned to the categories in the spreadsheet in addition to any it was assigned to before the import.


If the field you are updating can contain only one value (text field, select dox or dropdown menu) then the field will be overwritten, for example when uploading Product Name, the field will be overwtiten with the new data.


Replace Method


The replace option will be used mainly for selecting a new set of categories or images for a product. Uploading to these fields as a replace will remove any categories/images assigned to the product in place of those defined in the spreadsheet.


When updating other fields that can only hold on value, such as the product name, description or price, this option will function in exactly the same way as the update option.