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
• It is assumed that all orders marked as 'paid' are fully paid and not partially paid

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

Nominal Mapping

The mapping process utilises the OrderDefaultNominal setting to determine the nominal code to be used. If this is not specified, Zynk will default to using the nominal code associated with the product. Alternatively, Zynk will use the default nominal code associated with the product, or the default nominal code associated with the customer if the 'Use Default Nominal Code for Sales' option is enabled on the customer record.

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
-	A/C	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	Sales Order Date
Despatch By Date	Due Date
Currency	Currency	Order currency must match the currency of the customer account
Payment Method	Method	Names must match between Linnworks and Sage
Payment Method ID	Reference
Total	Payment

Invoice Address

Linnworks field	Sage field	Notes
Address1	Address1
Address2	Address2
Town	Town
PostCode	Postcode
Region	County
Country	Country
PhoneNumber	Telephone
EmailAddress	Email

Order Line

Linnworks field	Sage field	Notes
Sku	Product Code
Title	Description
Quantity	Quantity
Retail price	Unit Price
N/A	Nominal Code	Uses the Setting OrderDefaultNominal
Tax (rate)	Tax Code	Converted using the mapping that must be in place