Find Jobs
Hire Freelancers

update an Excel spreadsheet with an sql query of a database

$10-30 USD

Completed
Posted almost 9 years ago

$10-30 USD

Paid on delivery
I am trying to compare two sets of data and update one from the other. My main database has approx 10000 items and their prices change constantly. It is an sql database. My website has about 500 products and I want to update those prices once a week using the prices contained in our master database. Ideally: I would export a list of the products on the website to a .csv file and import into Excel, with only the following fields: SKU, price and quantity. Then I'd have Excel query the SQL database for matches on each of those SKU's, with a return of price and quantity. I would then upload the updated list back to the website. What I need done is to have someone write the query that would check each record in my list of web products against my main database and update the price and quantity fields for each SKU that had a change. And secondarily, to then flag each changed record so we could then upload only those that were changed back to our website. We would then need instructions on how to set it up at our end and what commands our staff would need to execute to run this process each week.
Project ID: 7737806

About the project

5 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

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:
User Avatar
There has GOT to be a better way. Why are you using 2 databases? That (from what i understand ) is the issue. In your scenario below it is unclear what each database is? Do you know you can access the SQL database on the web with Excel? Make your changes and be done with it . Or have a little app that connects to the web database and use it to make the changes. Anytime you have data in more than one place it is a sign of a design issue.
$25 USD in 1 day
5.0 (3 reviews)
5.2
5.2
5 freelancers are bidding on average $31 USD for this job
User Avatar
Hello, I am very much interested to do this work by .Net as i have similar experience by it. It will have a simple form where you will browse your data file and it will do the required task and export the required data. I think i can do this work efficiently and quickly. Looking forward to have a positive response from you. Thanks
$24 USD in 1 day
5.0 (60 reviews)
5.6
5.6
User Avatar
Hello there. Let me ask you something: 1) are both database SQL server? (your local and your web databases? If so, you can avoid Excel 2) will be the SKUs in your local database updated entirely with their related SKUs on the web?. If so, You only need a "Query" in Sql Server Managment to update the web table according with the info in the local table. (both databases will be visible in your Sql Server management) let me know... I use TeamViewer to connect myself into your network.
$55 USD in 1 day
5.0 (24 reviews)
4.6
4.6
User Avatar
La propuesta todavía no ha sido proveída
$25 USD in 3 days
5.0 (1 review)
3.3
3.3
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
1
Payment method verified
Member since May 25, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.