When you download transactions from Opayo, it matches the stock code from the basket contents you submit in the web shop. NOTE: The stock code shouldn't include any special characters, e.g. £.
The items submitted from the basket must be in this format to match the stock codes in Sage 50 Accounts: - Number of item lines:[stock code]stock code:quantity:Net value:VAT value:Gross value:Gross value
EXAMPLE: The stock code is product code BOARD001 with description Whiteboard - Drywipe. The quantity is 1. The net value is 100.00 and VAT value 20.00.
This should appear as follows: - 1:[BOARD001]Whiteboard - Drywipe:1:100.00:20.00:120.00:120.00
The stock code in square brackets must match the stock code in Sage 50 Accounts. If the stock code's different, or there's no stock code in square brackets, when you download transactions into Sage 50 Accounts, they import as an S1 item line if VAT is included, or an S2 item line if no VAT is included. If you're not sure how to check what's submitted to the basket contents on the web shop, Opayo support can help you with this. |