I need customer details & sales info from Sunshop intergrated into Frontrange Goldmine 6.5.
Sunshop uses a MySql Database which contains order information including customer details such as Name, Address, Phone email etc. This table also contains the infomation they purchased by means of a SKU and the option they selected (Size). I would like this information to be added to Goldmine once a day as a scheduled task or if this isnt possible then after every sale.
Goldmine has an email client. When the email is opened on Goldmine it updates Goldmine itself with the customer information and communicates with our stock control system to create a sales order, purchase order and adjust stock levels automatically. The latter part already works well with our other website but the site itself severely lacks any functionality.