Orders

The solution will download 'Open Orders' with a status of 'paid' from Linnworks and import them into Sage as Sales Orders

Requirements & Assumptions/Assertions

• Orders will be downloaded from Linnworks once. Modifications and deletions will not be handled.
• A tax mapping must be created
• Orders will be automatically allocated when imported into Sage
• If accounts are being created in Sage for each customer, each customer can only order in a single currency
• Payment methods must be set up in Sage to refelct the payment methods in Linnworks
• It is assumed that all orders marked as 'paid' are fully paid and not partially paid
• Composite Products: It is assumed that composite products in Linnworks have been manually set as BOM products in Sage
• All payments will be made using the method set in the PaymentMethod setting

Zynk Process

• Export open orders from Linnworks
• Convert orders into the Sage Sales Order format
• Import the Sales Orders into Sage
• Customer matching:
  • If WebSalesAccountOnly is set to True, all orders will be imported with the Account Reference set in WebSalesAccount
  • If UseSourceAccount is set to True, the orders will be imported with the Account Reference set to the Linnworks 'source'.
  • If the customer has an email address it will be used to match to an existing customer in Sage. If no matching customer is found a new one will be created
  • If no email is present the order will be imported with the Account Reference set in WebSalesAccount
• If UseLinnworksOrderNumber is set to True the order number in Sage will be set to the Linnworks order number

Tax Mappings

To accurately represent the tax on orders in Sage, it is necessary to create a mapping between the Linnworks tax rates and the Sage tax codes. This requires the creation of a mapping titled 'Linnworks Tax Rates to Sage Tax Codes'. In this mapping, each tax rate in Linnworks should be listed in the 'From' column, and its corresponding Sage tax code should be placed in the 'To' column. For further details on setting up mappings in Zynk, please refer to the Mapping Documentation.

Note

Orders cannot be processed without this mapping in place

Field Mappings

Order

Linnworks field	Sage field	Notes
-	Customer Code	Determined based on the settings outlined above
Order number	Order no.	Sage order number will be set to the Linnworks order number if UseLinnworksOrderNumber is set to 'True'
Reference Number	Customer order no.
Recieved Date	Document Date
Despatch By Date	Date promised
Currency	Currency	Order currency must match the currency of the customer account
-	Payment Method	Set using the PaymentMethod setting
Total	Payment

Order Line

Linnworks field	Sage field	Notes
SKU	Item Code
Quantity	Quantity
Retail price	Unit price
Tax (rate)	Tax Code	Converted using the mapping that must be in place