Refunds
Zynk will export refunded orders from WooCommerce and import them into Sage 200 as Sales Order returns.
Requirements & Assumptions/Assertions
-
Refunds can be either imported into a single account or associated with Sage users through their email addresses. If you set
WebSalesAccountOnly
to 'True', all orders will be imported to the account specified in theWebSalesAccount
setting. Conversely, ifWebSalesAccountOnly
is set to 'False', Zynk will associate orders with users based on their email addresses, and only guest orders will be imported to theWebSalesAccount
. -
Customer settings need to be configured to enable Refunds to be imported, see the Customers page for details
-
Refunds will only be imported into Sage once; modifications and deletions will not be handled
-
The workflow will process all item lines exported from WooCommerce. Should there be any additional fees, these will be imported into Sage 200 as a FreeTextLine.
Zynk Process
- Export Refunded Orders from WooCommerce
- Convert WooCommerce Refunds to Sage 200 Sales returns.
- Import Sales returns into Sage 200.
Field Mappings
Refund Details
WooCommerce Field | Sage Field | Field Length | Notes |
---|---|---|---|
N/A | Account Reference | 60 | Account reference is optionally specified at the Import Task level, if not it will be auto-generated or automatically determined by the email address on the customer. |
Number | Customer Order Number | 30 | |
Date Created | Sales Order Date | - |
Sales Order Address
WooCommerce Field | Sage Field | Field Length | Notes |
---|---|---|---|
Billing/Company | Company | 60 | If there is no Billing/Company present, then First Name and Second name will be used instead |
Date Created | Sales Order Date | - | |
Address 1 | Address 1 | 60 | |
Address 2 | Address 2 | 60 | |
City | Town | 60 | |
Postcode | Postcode | 10 | |
State | County | 60 | |
Country | Country | 2 | |
Phone | Telephone | 30 | |
255 |
Sales Order Delivery Address
WooCommerce Field | Sage Field | Field Length | Notes |
---|---|---|---|
Shipping/Company | Company | 60 | If there is no Shipping/Company present, then First Name and Second name will be used instead |
Date Created | Sales Order Date | - | |
Address 1 | Address 1 | 60 | |
Address 2 | Address 2 | 60 | |
City | Town | 60 | |
Postcode | Postcode | 10 | |
State | County | 60 | |
Country | Country | 2 | |
Phone | Telephone | 30 | |
255 |
Sales Order Items
WooCommerce Field | Sage Field | Field Length | Notes |
---|---|---|---|
SKU | SKU | 30 | |
Name | Name | 60 | |
Quantity | QtyOrdered | - | |
Price | UnitPrice | - | |
Total Tax | Total Tax | - | |
N/A | Nominal Code | - | Nominal Code is optionally chosen at the task level |
N/A | TaxCode | - | TaxCode is optionally chosen at the task level |