Restore Orders from Website Following Restoration of Sage Backup

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

    • Failed Orders

      WooCommerce SKU codes must match the Sage Product Codes for each order line item, otherwise, the order will fail to import to Sage, even if there are correct order line items within the order.   Orders will also fail if the Sage Account Code is not ...
    • Bulk Import of Sage Account Codes from Sage to Wordpress

      Introduction Assuming you have first installed the Woosage plugin on your website, you can add Sage Accounts Code to User Profiles. Warning. If you are making changes to a live website we strongly advise you to take a database backup prior to ...
    • Creation of new website products from Sage

      Woosage has a feature that allows you to create new product in WooCommerce from Sage. However, as WooCommerce has comprehensive product presentation features that are not present on Sage, such as short & long descriptions, attributes and variations, ...
    • 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 ...