Find Jobs
Hire Freelancers

SQL Update for MS Access Database from ODBC Shopify Source

$250-750 AUD

Terminado
Publicado hace más de 2 años

$250-750 AUD

Pagado a la entrega
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 del proyecto: 30958420

Información sobre el proyecto

32 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
$0 AUD en 3 días
5,0 (34 comentarios)
5,7
5,7
32 freelancers están ofertando un promedio de $411 AUD por este trabajo
Avatar del usuario
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 en 7 días
4,7 (29 comentarios)
6,0
6,0
Avatar del usuario
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 en 3 días
4,9 (34 comentarios)
4,5
4,5
Avatar del usuario
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 en 5 días
5,0 (8 comentarios)
4,1
4,1
Avatar del usuario
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 en 7 días
4,9 (13 comentarios)
4,1
4,1
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
3,4
3,4
Avatar del usuario
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 en 1 día
4,1 (3 comentarios)
4,0
4,0
Avatar del usuario
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 en 7 días
5,0 (3 comentarios)
2,3
2,3
Avatar del usuario
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 en 7 días
5,0 (3 comentarios)
1,8
1,8
Avatar del usuario
- previous experience in such topics; - eager to discuss a lot in such topics; - degree stats - maths;
$300 AUD en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
TOWNSVILLE CITY, Australia
0,0
0
Forma de pago verificada
Miembro desde jul 27, 2021

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.