SQL Update for MS Access Database from ODBC Shopify Source

$250-750 AUD

Completed

Posted

almost 3 years ago

$250-750 AUD

Paid on delivery

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.

Project ID: 30958420

About the project

32 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

$0 AUD in 3 days

5.0

(34 reviews)

5.7

32 freelancers are bidding on average $411 AUD for this job

@fuentro

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 message if you would like to further discuss with me and we can start working! Best regards, Rodrigo

$550 AUD in 7 days

4.7

(29 reviews)

6.0

@crypthne

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 certified. I'm confidence I can help you to finish this project for you as requested.

$250 AUD in 3 days

4.9

(34 reviews)

4.5

@RomanRut

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 requirements carefully. Also, I have good experienced in ReactJS, AngularJS , javascript , HTML5, Bootstrap and SCSS, Nodejs, Expressjs, Laravel and Mysql/Mongodb/Redis. I can make the update query and link the mysql to Access I promise the best quality on time and 24/7 communication. Also, I will work on your timezone. I haven't ever made my employers angry who made a trust on me. Please contact me for further discussion. Thanks.

$750 AUD in 5 days

5.0

(8 reviews)

4.1

@niarfedevelop

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.

$250 AUD in 7 days

4.9

(13 reviews)

4.1

@nolk

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 how many records you have in shopify and how often the data is changed there. Also, where do you host your shopify and do you have full access to DB? cheers,

$400 AUD in 7 days

5.0

(7 reviews)

3.4

@daniyal3214

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, Tableau, Power Queries, SQL and MS Access. Lets discuss your project in detail and how I am highly suitable for this.

$300 AUD in 1 day

4.1

(3 reviews)

4.0

@NAUMANS2020

Hi I understand the requirements and confidently say that i can do your project. Please check my portfolio and i can show you some demo work on chat I will provide you 100% satisfaction work and full service. I done many projects related to database like MS Access, SQL server, MYSQL etc. I have command on ERD, Normalization, Queries and other different task related to database, I also have expertise in C#.net. I will do that with in your given budget and time frame. Thanks

$500 AUD in 7 days

5.0

(3 reviews)

2.3

@SPARKtechBD

Since 2000 I am working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I have created Point of Sales, Inventory, Accounting, Back Office, Hardware Controller System, etc. If you need a good delivery of job and move this project to successful then message me, please.

$750 AUD in 7 days

5.0

(3 reviews)

1.8

@uvtxyz1991

- previous experience in such topics; - eager to discuss a lot in such topics; - degree stats - maths;

$300 AUD in 1 day

0.0

(1 review)

0.0

@oviyarp17

Hi I am interested in your project. I have good knowledge of SQL Queries. I can able to update the query as needed in database. Please feel free to provide me more details on this project.

$300 AUD in 7 days