SQL Update for MS Access Database from ODBC Shopify Source

$250-750 AUD

완료함

게시됨

거의 3년 전

$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년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@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일에