Import Data
Videos
-
.01:56Data Import Webinar
Accessing Import Data
- Select Settings > Import & Export data
- Select Import data
- The Data Import screen will be displayed
Import Data Screen Overview
The Data Import screen is used to create, configure and manage the imports that are set up as well as checking logs of the import execution history
Buttons
- Add Scheduled Import - use this option to create a new scheduled import.
- Import Now - use this option to create a one-off import that is run on an ad-hoc basis.
The biggest difference between the Add Scheduled Import and Import Now are that a schedule can be defined when an import is set up via the Add Scheduled Import button. A schedule does not have to be defined and so it can mimic the behaviour of Import Now, with the added benefit that information about the file and column mapping is saved in the config. This allows the import to be run on an ad-hoc basis by clicking Run Now. Import Once type imports will only retain the type of import between runs, therefore a new file needs to be supplied and mapped each time the Reimport button is clicked.
Grid View
Column Name | Description |
---|---|
Name | The user-friendly name was given to the import to make to easily recognisable in the grid. |
Type | The Linnworks Import Type that is used to categorise the import. |
Enabled | Imports can only be executed when an Import is Enabled. To toggle the state simply click on the button. |
Last Import | The data and time in UTC the previous import was executed. |
Status of last import | The outcome of the most recent import
|
Next Import Date | The expected time the next import will be executed
|
Options | Use the buttons to manage the selected Import
|
CSV File Creation
Comma Separated Variable (CSV) files, also known as flat-files, are the format that all data imports and exports in Linnworks.net use. In order to make the import process as easy as possible, please consider the following when creating CSV files for data imports:
- The first row is reserved for column headings. Leaving a blank heading will mean the column is imported as Column #, where # is a number
- As these column headings are used in the mapping process, these should either match the name of an Available Column for the import you are mapping or be clearly identifiable
- Available Columns are listed on each data import type. A list of data import types can be found here
- If one or more columns have the same heading, the file will be rejected