SQL Update for MS Access Database from ODBC Shopify Source

$250-750 AUD

已完成

已发布

超过 2 年前

$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.

项目 ID: 30958420

关于此项目

32提案

远程项目

活跃3 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@cgullapalli

$0 AUD 在3天之内

5.0

(34条评论)

5.7

32威客以平均价$411 AUD来参与此工作竞价

@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 在7天之内

4.7

(29条评论)

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 在3天之内

4.9

(34条评论)

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 在5天之内

5.0

(8条评论)

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 在7天之内

4.9

(13条评论)

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 在7天之内

5.0

(7条评论)

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 在1天之内

4.1

(3条评论)

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 在7天之内

5.0

(3条评论)

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 在7天之内

5.0

(3条评论)

1.8

@uvtxyz1991

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

$300 AUD 在1天之内

0.0

(1条评论)

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 在7天之内