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.
32 freelances font une offre moyenne de 411 $ pour ce travail
[login to view URL] I have gone through your project requirements. I will develop access application for you. It will connect with Cdata via ODBC and will write queries to update the dates and contacts in your access database I Plus
Hi, I’ve read your project description and is a lot like projects I’ve done in the past both with customers from this site as well as personal projects. I feel confident that I can work on it with you. Send me a messag Plus
Hello, We have seasoned Full stack developers for mobile and web developments, We have developed many solutions in Object C, Swift, Java, Kotlin, React Native, Flutter, Xamarin, etc. and in Shopify, Woo Commerce, Reac Plus
I'm an experience MS Access and vba developer, have been in this field for more than 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access c Plus
Hello, I have been working as a professional angular developer for 8 years and I've gained rich experience with it in other companies. Please review my portfolio if you have one sec. Basically, I've investigated your r Plus
Hello, I would like to help you, I have more than 10 years of experience working with MYSQL, POSTGRESQL, SQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL.
Hi guys, I believe I can help you with the task. Do you want the sync to be done as a full export/import or you want just a delta to be pushed from shopify to access? both variants can do the job, the important bit is Plus
Hi, I have gone through your requirement and I am able to help you with it. 8+ years of professional experience with DB designing and management for global tech companies. Well versed in DB administration, designing an Plus
Hello, I will be glad to assist you with that. I am an experienced Data Scientist and Data Visualization expert holding years of experience in performing Data Visualization, Data Analytics and Automation using Power BI Plus