Restore Orders from Website Following Restoration of Sage Backup

If for any reason Sage is updated from a backup, you can restore orders from the website using the following procedure.

In the Woosage Control Centre go to Woosage>Utilities

1. Stop the Woosage Service 
   
2. Scroll down to Clear Database Tables and tick Orders
   
3. Click the red Clear Tables button
   
4. Go to Settings>Website and change the WooCommerce Order Window to cover the number of days you want to restore orders for, making a note of the previous setting
   
5. Click Save Settings

In the website go to WooCommerce>Orders

1. Using the checkbox in the first column, tick the all the orders you want to restore
   
2. Use the Bulk Actions dropdown at the top of the page and select Mark Not Exported To Sage
   
3. Click the Apply button next to the dropdown
   

In the Woosage Control Centre go to Woosage>Utilities

1. Start the Woosage Service 
   

The orders should then be re-imported to Sage.

When complete restore the WooCommerce Order Window to it previous setting

• Related Articles

• Bulk Import of Sage Users

  Assuming you have first installed the Woosage50 plugin on your website, you can import users from Sage including their Sage accounts code, price lists etc. using the details below. You can also use this method to add these details to to existing ...

• Woosage50 Orders Settings

  WooCommerce order are imported in to Sage according to the setting in Settings>Orders. The settings are shown below and this article provides additional information to supplement the tooltips. Order status options - select all the status conditions ...

• Order Information Posted to Sage

  Woosage posts information from the WooCommerce Orders into Sage Sales Orders or Invoices in the following sections (as per Sage Order tabs): Details Billing address details are posted unless the billing address override is off, using the settings ...

• How Sage Customer Account Codes are Applied

  All website orders must be created in Sage against a particular Customer Account as a Sales Order or Sales Invoice and Woosage provides a number of methods for determining which Customer Account an order is allocated to. Sage Customer Accounts are ...

• Dealing with Failed Orders in Woosage50

  Occasionally, orders fail to be imported to Sage and this is usually due to an incorrect or missing SKU code in an order line item. WooCommerce SKU codes must match the Sage Product Codes for each order line item, otherwise, the order will fail to ...