Exporting out of MYOB RetailManager POS into Woocommerce for Free – Part 2 Allowing access to the MYOB RetailManager Database via ODBC
Welcome back to part 2 in our series on how to export stock information out of MYOB RetailManager into a website like Woocommerce. In part 1 we gave a bit of an overview of the approach we are taking. In this part we will start to get our hands dirty by performing our first step of allowing access to the MYOB RetailManager Database via ODBC.
To put together this tutorial we are using RetailManager 12 on Windows 8.1 with a WordPress 4.4 site and Woocommerce 2.4. If your not running this exact environment, don’t stress, everything should be basically the same on any version of RetailManager, Windows, WordPress or Woocommerce.
Allowing access to the MYOB RetailManager Database via ODBC
As you may know RetailManager stores its data in a Microsoft Access database. Yep old, unstable, awful Access! We didn’t have a copy of Microsoft Access, got rid of that years ago once I met Mr mySQL and Mr PostgreSQL. So to get into the RetailManager database do the following:
- Install the 2010 Microsoft Access Runtime from here (
pick the right one for your system, I went with 32-bitCorrection, according to this forum 32-bit is the only option with MYOB RetailManager databases). Don’t get the 2013 Runtime as this doesn’t work with the RetailManager mdb database.
- Once installed open up the “ODBC Data Sources (32-bit)” program under Control Panel->Administrative Tools.
If you downloaded the 64 big Runtime in step one launch the “ODBC Data Sources (64-bitOnly possible to use 32-bit, see correction in step ).
- Click the Add button to setup a new ODBC connection to the MYOB database.
- Select the Microsoft Access Driver from the list.
- Enter a name that you will use to refer to the Data Source. I prefer not to use spaces in my names…I’ve been rolled with spaces in names on Windows a million times, so I entered “RetailManager”. Once you’ve entered a name click the “Select…” button in the Database section.
- From the popup window browse to where you MYOB RetailManager database is. If you don’t know where this is you can figure it out by clicking File->Configuration, click Yes then look at the path of your shopfront. Normally this is something like C:RetailMrecent.mdb. Once you’ve found it click OK.
- This should bring you back to Data Source settings page. The ODBC connect your creating has the ability for it to be used to update data in MYOB. This is generally a bad idea so to prevent anything nasty like this happening to your MYOB Retails Manager database I suggest you click the “Options>>” button and check the “Read Only” box. Then click “OK”.
- At this point you should now have a working ODBC connection to your MYOB RetailManager database
Next step..Using the MYOB RetailManager ODBC Connection
Well done! Your part way to getting your stock information updated on your website. I know at this point you don’t have much to show for your efforts but in Part 3 you’ll start to see some results for your work when we create an Openoffice Base connection to the MYOB RetailManager database via the ODBC connection and then start to import the stock information via Base into an Openoffice Calc document. Check back soon.