Skip to content

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 the WebSalesAccount setting. Conversely, if WebSalesAccountOnly is set to 'False', Zynk will associate orders with users based on their email addresses, and only guest orders will be imported to the WebSalesAccount.

  • 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
Email Email 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
Email Email 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