SQL Update for MS Access Database from ODBC Shopify Source
Budget: $250 – $750 AUD
We are a small non-profit art gallery, and we have a gallery shop in Shopify. We also have an MS Access Database with contacts that are linked to... Artwork sales, event booking, donations, exhibitions, creators of artworks in database, etc. So we need to keep these MS Access Database contacts updated when people update their details in their shopify account. We also have membership dates stored in MS Access: join date, renew date, and expiry date (can be 1, 2, or 3 years from renewal/join date). People can buy a membership in Shopify, and we would like to update the MS access contacts with their new dates.
We have been able to get the shopify tables into MS Access via linked table manager using ODBC. (We use a driver from CData, you can get a free trial to assist with development).
Experience with the shopify tables would be preferred but not necessary. The main work is writing the SQL Update Query. The info required seems to be across 4 tables in Shopify: Customers, Customer Addresses, Orders, Order Items.
We have been able to get the shopify tables into MS Access via linked table manager using ODBC. (We use a driver from CData, you can get a free trial to assist with development).
Experience with the shopify tables would be preferred but not necessary. The main work is writing the SQL Update Query. The info required seems to be across 4 tables in Shopify: Customers, Customer Addresses, Orders, Order Items.