Bulk Import of Sage Account Codes from Sage to Wordpress

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 carrying out the Import stage of this process.

If you want to apply Sage Account Codes to existing website users (customers) you can use the following plugin to export and import users:


The Woosage plugin should be installed and we recommend you take a WordPress database backup before you start.  Then follow these steps:

Use the plugin to extract all the user details to a CSV file (see detailed instructions below). The plugin settings and usage is at Tools>Import and export users and customers. 

Modify the CSV file to remove all data except the username email address and Sage account fields as shown below. Add the Sage codes by matching on the email address or username (user_login), which are unique among WP users. Do not change the order of the field (column) headings.

username
email
sage_account
auser
ABC123

If you only need to import users (i.e. you already have a list of email addresses and Sage account codes) you can modify the field headings to match those shown above.

Use the plugin to import the CSV file containing the email addresses and Sage account codes (see detailed instructions below).

Exporting

Go to Tools>Import and export users and customers in the website back-end and select the Export tab. 

Then select the Customers from the drop-down list of roles.

Ignore the date and time fields and leave the delimiter as Comma then click the Download button.

The file will be downloaded as export-users.

Importing

Go to Tools>Import and export users and customers in the website back-end and select the Import tab. 

Click Choose File and browse for the CSV file you wish to import.

In Default role tick Customer (this will not be used) and select Leave the old value for this metadata

Leave the 2 email options unticked if you don't want to notify the users.

Select:

Yes for Update Existing users,
No, skip this user for Update Emails and
No for Update roles for existing users

In the Never update password dropdown Select Never Update Passwords when updating user

Under the section  Users not present… section leave both options unticked

Click Start Importing

The users will be updated with the Sage account codes and a summary of the changes will be shown when complete.


    • Related Articles

    • Setting Sage Customer Account Codes via the Woosage Plugin

      The Woosage plugin adds a field to the website user account details (shown below) to allow the Sage Account Code to be added to order generated by the user (when logged on), so that the order is imported to the relevant Sage account.    Add a Sage ...
    • 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 ...
    • 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 ...
    • Product Codes (AKA SKU or Stock Codes)

      Sage Code Restrictions. A requirement of Woosage is that the SKU codes in WooCommerce must match the Product (Stock) codes on Sage in order to process orders and update website products. While WooCommerce can have SKU codes up to 255 characters in ...
    • Setting up Tax Codes

      Under normal circumstances WooCommerce uses tax classes to determine how the add tax to orders and shipping by using table of rates based on the billing or shipping address in the order (or shop base address). Each product and the shipping classes ...