Find Jobs
Hire Freelancers

SQL Update for MS Access Database from ODBC Shopify Source

$250-750 AUD

I përfunduar
Postuar over 2 years ago

$250-750 AUD

Paguhet në dorëzim
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 e Projektit: 30958420

Rreth projektit

32 propozime
Projekt në distancë
Aktive 3 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
$0 AUD në 3 ditë
5,0 (34 përshtypje)
5,7
5,7
32 freelancers are bidding on average $411 AUD for this job
Avatari i Përdoruesit
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 në 7 ditë
4,7 (29 përshtypje)
6,0
6,0
Avatari i Përdoruesit
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 në 3 ditë
4,9 (34 përshtypje)
4,5
4,5
Avatari i Përdoruesit
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 në 5 ditë
5,0 (8 përshtypje)
4,1
4,1
Avatari i Përdoruesit
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 në 7 ditë
4,9 (13 përshtypje)
4,1
4,1
Avatari i Përdoruesit
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 në 7 ditë
5,0 (7 përshtypje)
3,4
3,4
Avatari i Përdoruesit
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 në 1 ditë
4,1 (3 përshtypje)
4,0
4,0
Avatari i Përdoruesit
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 në 7 ditë
5,0 (3 përshtypje)
2,3
2,3
Avatari i Përdoruesit
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 në 7 ditë
5,0 (3 përshtypje)
1,8
1,8
Avatari i Përdoruesit
- previous experience in such topics; - eager to discuss a lot in such topics; - degree stats - maths;
$300 AUD në 1 ditë
0,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
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 në 7 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i AUSTRALIA
TOWNSVILLE CITY, Australia
0,0
0
Mënyra e pagesës u verifikua
Anëtar që nga korr 27, 2021

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.