Follow

Linnworks set up

Currently Scurri uses the following Linnworks Configuration to set up an FTP export from Linnworks. 

 

To set up the export, please follow the steps as below.

Log into Linnworks

Go to Settings

Click Import and Export Data

Click "Export Data"

Setting up an export from Linnworks to Scurri

An export is created in the customer's Linnworks account:

Export Configuration:

Name: Scurri
Type: Custom

 
DECLARE @folder nVarchar(255) = 'SCURRI'
DECLARE @harmonisationParam nvarchar(255) = 'Harmonisation code'
DECLARE @countryOfOrigin nvarchar(255) = 'United Kingdom'
SELECT
'OrderID' = oo.nOrderId, -- Linnworks Order Number
'Order Value' = oo.fTotalCharge, -- Order Total Charge
'Order Date' = oo.dReceievedDate, -- Date Order was placed on the Sales Channel
'Order Notes' =
CASE WHEN notes.notes IS NULL THEN '' ELSE notes.notes END , -- Linnworks order Notes
'Order Currency' = oo.cCurrency, -- Currency used when placing Order
'Order Reference' = oo.ReferenceNum, -- Sales Channel Order Number
'Order Shipment Method' = ps.PostalServiceName, -- Name od Postal Service Method assigned in Linnworks
'Shipper Warehouse Name' = sLoc.Location, -- Linnworks Location for Order
--Shipper Warehouse Code -- *** This is not defined within Linnworks ***
'Buyer Name' = oo.cFullName, -- Buyer Full Name
--Recipient First Name -- *** This is not defined within Linnworks ***
--Recipient Last Name -- *** This is not defined within Linnworks ***
'Buyer Email Address' = oo.cEmailAddress, -- Buyer email address
'Buyer Phone Number' = oo.BuyerPhoneNumber, -- Buyer Phone Number
'Buyer Company Name' = oo.Company,
'Buyer Address 1' = oo.Address1,
'Buyer Address 2' = oo.Address2,
'Buyer Address 3' = oo.Address3,
'Buyer Town' = oo.Town,
'Buyer Region' = oo.Region,
'Buyer Postcode' = oo.cPostCode,
'Buyer Country' = c.cCountry,
--Package Number -- *** This is not defined within Linnworks unless Split Packaging is used ***
'Package Item Length' = si.DimDepth, -- Linnworks Stock Item Depth Dimension
'Package Item Width' = si.DimWidth, -- Linnworks Stock Item Width Dimension
'Package Item Height' = si.DimHeight, -- Linnworks Stock Item Height Dimension
'Package Length' = pt.Depth, -- Linnworks Packaging Type Depth Dimension
'Package Width' = pt.Width, -- Linnworks Packaging Type Width Dimension
'Package Height' = pt.Height, -- Linnworks Packaging Type Height Dimension
'Package Type' = pg.PackageCategory, -- The assigned Linnworks Packaging Group
'Package Description' = pt.PackageTitle, -- The assigned Linnworks Packaging Type (Based on weight)
'Package Item SKU' = si.ItemNumber, -- Linnworks Stock Item SKU
'Description' = si.ItemTitle, -- Linnworks Stock Item Title
'Package Item Quantity' = oi.nQty, -- Order Item Quantity
'Value' = oi.CostIncTax, -- Order Item Cost Including Tax
'Weight' = si.Weight, -- Linnworks Stock Item Weight
'Weight Unit' =
CASE WHEN s.settingname = 'WEIGHT' THEN s.settingValue ELSE '' END, -- Unit of measure for weight
'Package Item Harmonisation Code' =
CASE WHEN h.fkStockItemId IS NULL THEN '' ELSE h.ProperyValue END, -- Use Extended Property on Stock Item
'Package Item Country of Origin' = @countryOfOrigin -- Use a parameter defined by query
FROM
[Open_Order] oo
INNER JOIN [Open_Order_Folder] oFol
ON oo.pkOrderID = oFol.fkOrderId AND oFol.FolderName = @folder
INNER JOIN [StockLocation] sLoc
on oo.FulfillmentLocationId = sLoc.pkStockLocationId
INNER JOIN ListCountries c WITH (NOLOCK)
ON c.pkCountryId = oo.fkCountryId AND c.blogicalDelete = 0
INNER JOIN [Open_OrderItem] oi WITH (NOLOCK)
ON oo.pkOrderID = oi.fkOrderID
INNER JOIN [StockItem] si WITH (NOLOCK)
ON oi.fkStockItemId = si.pkStockItemID
LEFT JOIN StockItem_ExtendedProperties h WITH (NOLOCK)
ON si.PKStockItemID = h.FKStockItemID AND h.ProperyName = @harmonisationParam
INNER JOIN [AppSettings] s
ON s.settingname = 'WEIGHT'
LEFT OUTER JOIN (SELECT
oo.pkOrderID,
STUFF(
(SELECT ' ,' + oon.Note
FROM [Open_Order_Notes] oon WITH (NOLOCK)
WHERE oon.fkOrderId = oo.pkOrderID
ORDER BY oon.NoteEntryDate
FOR XML PATH(''), TYPE
).value('.' , 'nvarchar(max)'),1,2, ''
) AS notes
FROM
Open_Order oo
LEFT OUTER JOIN Open_Order_Notes oon WITH (NOLOCK)
ON oo.pkOrderID = oon.fkOrderId --AND oon.Internal = 0
GROUP BY oo.pkOrderID
) AS notes ON oo.pkOrderID = notes.pkOrderID
INNER JOIN [PostalServices] ps WITH (NOLOCK)
ON oo.fkPostalServiceId = ps.pkPostalServiceId
LEFT OUTER JOIN [PackageGroups] pg WITH (NOLOCK)
ON oo.fkPackagingGroupId = pg.PackageCategoryID
LEFT OUTER JOIN [Open_Order_Packaging] oop WITH (NOLOCK)
ON oo.pkOrderID = oop.fkOrderId
LEFT OUTER JOIN [PackageTypes] pt WITH (NOLOCK)
ON oop.fkPackagingTypeId = pt.PackageTypeId

 

*You will need to create a folder in "Open Orders" to use this. 

  1. Go to Open Orders
  2. Right click on any order
  3. Click "Folder Manager"
  4. Create a new folder called "Scurri" (To match config below)

SFTP Configuration 

 

Column Mapping

Schedule - It appears you would need to create multiple schedules to have the export go more often than every hour. 

Done! Here is the line in Linnworks when complete, you can manually run the export from this line for testing, you can also review logs of failed exports. 

 

At this point, you will need to contact Scurri with the details you've created to make sure the configuration has been saved. 

 

Import Configuration 

Log into Linnworks

Go to Settings

Click Import and Export Data

Click "Import Data"

See configuration below:


Set up SFTP import information. Make sure this has all been created from the create SFTP step. 

 

Map the columns

Potential issue - No carrier identified

 

Set schedule - Manifested shipments get imported every x minutes. 

Done! You can manually run and check logs from here

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk