Using the ODBC Capability
There is now a facility to create the ODBC DSN from the Utilities tab of the Woosage Control Centre, so the information below this blue box is mainly for troubleshooting or making changes to the ODBC DSN directly.
To create or update the ODBC DSN use the Create DSN button in the Utilities tab.
If updating ODBC due to an update of Sage version, then ensure Sage is updated first.
data path is on a server the UNC format should be used (e.g. \\ServerName\FolderName\FileName)
as opposed to the drive letter form.
Carry out the following steps to create a new ODBC Data Source for Woosage.
Windows PC where Woosage is installed open the ODBC Data Source
Administrator (32-bit) in Windows Administrative Tools, which displays the
Note: if you are using the 64-bit version of Sage you must run the 64-bit ODBC Data Source Administrator.
Select the System
DSN tab and click the Add… button, which opens the following window:
Line 50 vXX (where XX is the version of Sage you are using, 26 in this
example) and click the Finish button and the following window is
displayed (with empty fields).
Enter the name
for the data source as WoosageToSage, then enter the path to your Sage
data, which MUST match the path name in the Woosage settings (copy from teh settings and paste in to the Data Path field). Then click the OK button and your new ODBC data source should appear in the list as shown below.
ODBC DSN Creation & Update
The first time the Woosage50Service is run it will create the ODBC DSN if it doesn't exist. This code is in the service itself not the installer, because in a future release it will handle Sage updates and data path changes without having to re-run ...
Using the Vizulate Simple Role Based Pricing Plugin
Purpose Simple Role Based Pricing is a plugin provided by Vizulate to facilitate the mapping of Sage Price Lists & Special Pricing to website roles. It does not provide any other functionality, but may be used with other plugins that include RBP ...
Adding New Price List Customers (when using Barn2 Plugin)
Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers with a role using a 3rd ...
Adding New Price List Customers (when using Elex Plugin)
Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers using a 3rd party Role Based ...
Using a Price List for website Regular Prices
We have added a feature to Woosage to allow you to use a Sage Price List to populate the Regular Prices on your website. This is useful for clients that use Sage Sales Prices for their trade/wholesale customers and want to create a Price List for ...