To make entry of new information fast and easy Linnworks has various import types that allow managing large amount of inventory more efficiently. It is possible to add, delete or modify the entire group of inventory using a single spreadsheet. There are extensive imports that can add a wide range of details in one go and more specific ones for a single job. Linnworks allows importing files from your computer, Dropbox, FTP/SFTP or HTTP.


Import Types:


Inventory related Imports


The Inventory Import brings information into Linnworks for creating and updating stock items. This is used to build the Linnworks inventory with information about the item, available levels, images, prices, suppliers, other listing information and etc.

This import allows you to update or set the Linnworks SKUs that make up a Linnworks Composite Item. Composite Item is "Virtual" item that is a collection of multiple SKUs. This could either be a multipack of the same SKU or bundle consisting of multiple different SKUs.


Import allows changing the item number (SKU) for an existing Linnworks inventory item. All existing links to listings will be maintained.


Whilst it is possible to update stock level using an Inventory Import, it may be more convenient to update stock level with the specific stock level import. This import type will not create stock items if they do not already exist in the Linnworks.


Whilst it is possible to update stock level for batches manually in the Inventory Item screen, it may be more convenient to update them with the specific stock level import for batches. This import routine lets you import stock levels for newly created inventory items or overwrite the existing stock level for items that are using the batching feature.


This import allows the import of inventory linking information into the Linnworks database. This is done per Selling Channel (Source/SubSource). It is possible to link more than one listing per channel to a single item in the Linnworks Inventory. This is done by including multiple rows for the SKU (Linnworks Inventory Item), Source and SubSource, but with a different Linked SKU Custom Label.

Items linked via the Stock Linking import will also be linked within orders that are downloaded.



Manipulations with orders


The Open Order Import is used to add orders to Linnworks in bulk from a sales channel or a source that is unavailable through a direct Channel Integration.


Import triggers Open Orders in Linnworks to be marked as processed in bulk. This can be used where historical orders have been downloaded from a newly integrated selling channel mistakenly to 'tidy up' the Open Orders screen.



Delete Import


 

This import has several subtypes that allow the automated deletion of various records from the Linnworks database. Inventory deletions will still be reflected in historical reports covering the period prior to deletion.





Fulfillment Center


Fulfillment centers - a warehouse operated by a 3rd party where your stock is despatched on your behalf. Below are imports required for the FC:


This import can only be created using FC Automation functionality. However, it can be configured and deleted from the Import Data screen.


This import can only be created using FC Automation functionality. However, it can be configured and deleted from the Import Data screen. It is used to import the status of orders that have been assigned to a fulfillment center.



Suppliers

 

Linnworks allows you to keep a register of supplier data and it is possible to have multiple suppliers for the same inventory item. There are 2 imports that allow updating information related to suppliers.


When using the Linnworks Purchase Order functionality, it's good to be able to assess the cost of a recommended order. As such, This import allows supplier pricing to be imported against a Linnworks Inventory Items, and because it's relative to a particular supplier, this feature allows the relative cost of an item to be compared between suppliers


Linnworks recognizes that not all sellers will use the same SKU as their suppliers. As such, when using the Linnworks Purchase Order functionality and importing information on stock levels from their suppliers, a useful option is for the ability to use the Supplier Stock Code instead of the SKU. The Supplier Code can be imported as part of the Inventory import.

Remember that, because this is a stock level import to reflect stock held by your supplier, the import should specify the correct location so as not to overwrite the local/default stock for the seller.



eBay Imports


This Import breaks the connection permanently between a Linnworks inventory item and an active eBay listing. Once a listing has been stricken off through this method Linnworks will not make any attempts to pass information to the listing or update it.


Linnworks integrates with eBay's K-Type functionality, allowing sellers to show which makes and models of a car given Automotive Accessory is compatible with as part of the listing. At it's most basic, this import requires the SKU for the inventory item and a K-Type Value, also known as MVL (Master Vehicle List) codes. You can also Include or Exclude specific years from the make and model covered by that K-Type value. Where multiple K-Types are associated with the same SKU, multiple rows will be needed in the file.


This import can be also used as a Delete Import for K-Types. If a Delete column is included in the file (and mapped), including YES for a given SKU and K-Type value, will trigger it to be removed.


Linnworks integrates with eBay's Motorcycle parts compatibility functionality, allowing sellers to show which makes and models of motorcycle a given Automotive Accessory is compatible with as part of the listing. At it's most basic, this import requires the SKU for the inventory item and an ePID code from the MML (Master Motorcycle List) file provided by eBay. Where multiple ePID are associated with the same Linnworks SKU, multiple rows will be needed in the file.


This import can be also used as a Delete Import for ePid. If a Delete column is included in the file (and mapped), including YES for a given SKU and ePID value this will trigger the ePID to be removed from the specified Linnworks SKU.



Customers database


Import allows the import of customer details into the Linnworks database. These Customers will then be available for lookup when creating new Direct Orders.



Articles that might be useful:


CSV file, Tips & Hints

Data Import - using the same column more than once

Data Import - complex expressions

Data Import - direct links to files on Dropbox, Google Drive or a Private FTP Server

Data Import - importing a file from your computer

Data Import - setting a default location for an import