Inventory Import
Table of Contents
Videos
-
.02:50How To Import Your Inventory
Important!
Imports of the same type will not launch simultaneously even if they are scheduled to start at the same time. Instead, such imports will be launched one by one consecutively to improve the performance of the import process.
Available Columns
The available columns below have been grouped by similar fields for convenience. They may appear in a different order when exported. The order can be changed on the Column Mapping screen of the export configurations. For more information on this, please see out Column Mapping documentation.
Legend
Key | Description |
---|---|
![]() |
This field is a compulsory requirement for import. The data must exist as a column in the CSV and be mapped to the named field. |
![]() |
This field relies on dependent data that is a compulsory requirement for the import. If this field is included in the import then the dependent fields must also be mapped. |
![]() |
When the field is included in the import, the additional named field(s) are not permitted to be mapped and included in the import. Inclusion of both fields in the same import will prevent the import from executing. |
Columns - Stock Items
Key | Column | Description | Dependent fields | Forbidden fields |
---|---|---|---|---|
Archived | Enter YES or No to mark the Inventory item as Archived. An Archived Item can be hidden in the inventory screen | |||
Barcode Number | Unique identifier for the product, which could be EAN, MPN, UPC or ISBN | |||
Batch number scan required | If the item requires scanning batch number when processing add YES to this column | |||
Batch type |
Specify the Item's Batch type. Batch types options are: Sellby (Ordered by sell by date) or Priority (Ordered by priority sequence) Please Note! Use only with batched items. |
|||
![]() |
Bin Rack | The identifier for the physical location in the warehouse used to store the inventory item | Location | |
Category | The Linnworks Category this item is to be allocated to in the Linnworks Inventory. NOT to be confused with the Category on the Selling channel | |||
![]() |
Depth | A dimension of the item. Enter only a number, no measurement unit (m, cm, mm, inch, ") | ||
Description by Channel | Description to be used when listing. Will also require that SOURCE and SUBSOURCE be specified for the import, affecting any other import that is by Channel | Source SubSource |
||
Description by Channel (default) | Description to be used when listing. Will not require that SOURCE and SUBSOURCE be specified for the import, will be used by default if no other Description is specified | |||
Height | A dimension of the item. Enter only a number, no measurement unit (m, cm, mm, inch, ") | |||
Image URL |
The path to an image that should be imported into Linnworks for this SKU. If the files are stored on the same FTP/SFTP server or Dropbox account, they can be specified by starting the URL with [ftp], [SFTP] or [dropbox] respectively. eg [dropbox]/Images/Image32.png Image import order is determined by sequential line order of the file |
|||
![]() |
Is Variation Group | Enter Yes if the item is the Parent item in the Variation group and not the child item | Variation SKU | |
![]() |
Item extended property | Extended Properties can be used for a range of purposes in Linnworks. Takes the Extended Property Name from the Field description, but can be edited. Must select the Extended Property type. The type 'Attribute' will be picked by default, as it is the most commonly used type. | Property Type | |
Location | Linnworks Inventory location that stock level changes will be allocated against. Previous existing Location is needed | |||
![]() |
Minimum Level | Minimum number of items that should be held in inventory at the defined Location, normally used in conjunction with Purchase Ordering | Location | |
Price by Channel | Price to be used when listing. Will also require that SOURCE and SUBSOURCE be specified for the import along with subsource suffix when required (eBay), affecting any other import that is by Channel. For more information about Importing eBay Accept, Decline and Start Prices, please see this guide. For Amazon Bussines prices, click here. Walmart special prices, click here | Source SubSource |
||
Price by Channel (Default) | Price to be used when listing. Will not require that SOURCE and SUBSOURCE be specified for the import, will be used by default if no other Price is specified | |||
Primary Image | The path to an image that should be imported into Linnworks for this SKU as the Primary Image. If the files are stored on the same FTP/SFTP server or Dropbox account, they can be specified by starting the URL with [ftp], [sftp] or [dropbox] respectively. eg: [dropbox]/Images/Image32.png Please note! Existing primary images will remain associated with their respective SKUs, but images specified in the CSV file will become the primary images |
|||
Serial number scan required | Specify id the item requires scanning Serial number when processing. If the item requires, is marked YES | |||
Purchase Price | The indicated average price paid per item for this SKU | |||
Retail Price | Price to be charged to customers for this item | |||
Short Description | Brief description for your inventory item, saved in the Metadata field on the Edit Inventory Item screen | |||
![]() |
SKU | Unique identifier of the Linnworks inventory item that requires the additional KType data | ||
![]() ![]() |
Stock Level |
The physical amount of this SKU held at the location specified. Importing this value will replace the current stock level in Linnworks. If a Negative number is supplied, the stock level in Linnworks will be set to zero. An item in Linnworks cannot have a stock level less than 0. |
Location | Stock Level Adjust |
![]() ![]() |
Stock Level Adjust |
A number with a magnitude (-3, 0, 10) that will either increase or decrease the current stock level at the location specified. If a decrease would cause the stock level to drop below 0, the stock level would instead be set to 0. An item in Linnworks cannot have a stock level less than 0. |
Location | Stock Level |
![]() |
Stock Value |
The value of the stock held in this location. Importing this value will replace the existing stock value in Linnworks. When imported alongside stock level adjust, this value will adjust the current stock value in Linnworks; increasing or decreasing it instead of replacing it. |
Location | |
Tax Rate | The Sales Tax Rate for this item, if different to the System Default rate | |||
Title | The Name/Title of the Inventory item for use in Linnworks | |||
![]() |
Title by Channel | Title to be used when listing. Will also require that SOURCE and SUBSOURCE be specified for the import, affecting any other import that is by Channel | Source SubSource |
|
Title by Channel (Default) | Title to be used when listing. Will not require that SOURCE and SUBSOURCE be specified for the import, will be used by default if no other Title is specified | |||
![]() |
Variation Group Name | If the item is the parent SKU of a variation group, this is the name given to the group as a whole | Variation SKU Is Variation Group |
|
![]() |
Variation SKU | Specify the Item's Variation SKU if Variation Parent is marked YES | Variation SKU Variation Group Name |
|
Weight | A value defining the measured weight of the item, used when submitting shipping data to couriers. Enter only a number, no measurement unit, as this is specified in Linnworks.net (kg, g, oz, lb, ") | |||
Width | A dimension of the item. Enter only a number, no measurement unit (m, cm, mm, inch, ") |
Columns - Supplier Details
Key | Column | Description | Dependent fields | Forbidden fields |
---|---|---|---|---|
Supplier Name |
Name of Supplier, as setup in Linnworks to apply any specified Supplier-related changes in Linnworks NOTE : If the Supplier Name provided does not already exist in the Supplier Register a new record will be automatically inserted |
|||
![]() |
Default Supplier | Enter YES to make the Supplier specified in this file under Supplier Name the default supplier for this SKU | Supplier Name | |
![]() |
Lead Time Days | Specify the lead time for supported listings of this SKU. The max time between purchase and despatch | Supplier Name | |
![]() |
Supplier Barcode | Barcode/EAN used by supplier for this item if different from the Barcode set on the Linnworks SKU | Supplier Name | |
![]() |
Supplier Code | SKU used by the supplier to reference this item, if different. Used with Supplier feeds to ensure the correct items are updated with accurate stock levels | Supplier Name | |
![]() |
Supplier Min Order Qty | Minimum number of this item that can be ordered from this Supplier | Supplier Name | |
![]() |
Supplier Pack Size | Where an item is purchased from your supplier in packs or bundles, specify this amount here to ensure that Linnworks will recommend Purchase Orders in the correct multiples | Supplier Name | |
![]() |
Supplier Purchase Price | The current price for the specified SKU when ordered from the named Supplier | Supplier Name |
Columns - Shipping and Packaging
Key | Column | Description | Dependent fields | Forbidden fields |
---|---|---|---|---|
Packaging Group | Default Packing group for this item | |||
Postal Service | The default Postal service assigned to the stock item |
Inventory Import Guides
Due to the nature of the variety of data that can be imported for Linnworks Inventory, below are links to guides for specific scenarios
Example Files
-
..csvEmpty Template
-
..csvSample with Data (Using Single column to define Image URL)
-
..csvSample with Data (Using multiple columns to define Image URL)
- The images will not import as the DropBox account is not publicly available
- 3 columns (Location / Filename / Extension) are used in the file to define where the source image is. To make these into a single field for Primary Image the following Expression can be used
- concat[v{Image Location},v{Image Name},v{Image Extension}]
- The columns Brand /Range / Colour / Paint code are imported as Extended Properties