In Progress

Create/maintain reference database of SKU's and specs

I need a relational Database initially created and then updated/maintained (this will be an ongoing job). I don’t care how it is done, whether it’s with Microsoft Access, Open Office, or a web based / cloud service.

I just need to have you help me query the database to compile the required information from the appropriate columns so I can create CSV files to upload to my eCommerce store.

The initial database will have 20,000 rows of SKU’s. I will provide spreadsheets of information that can be uploaded by you or by myself. I will create the columns for all the tables and designate what the primary keys need to be to link tables together.

In the updating/maintenance part, you will generate reports of what information is missing from certain rows so we can fill it in. Also, you will be comparing a list of maybe 1,000 parts to the existing 20,000 or so existing SKU’s to match with what we have in the database already and what we need to create new data for.

Future work will also involve creating other databases similar to this for different product categories. Please let me know if you have any questions.

Skills: Data Processing, Excel, Microsoft Access, PHP, SQL

See more: maintain sku database, work reference, what's data processing, service database access, parts database access, need a cloud for web service, microsoft access web database, microsoft access parts database, microsoft access job, future care, ecommerce product upload service, care cloud, access parts database, sku product columns database maintain sku, microsoft spreadsheets, how to create product, updating product information, sku, service database , relational, reference , product sku, database ecommerce, create similar access, create questions

About the Employer:
( 7 reviews ) Cincinnati, United States

Project ID: #1081643

Awarded to:

shuiwatermizu

please see pm

$750 USD in 10 days
(91 Reviews)
6.4

47 freelancers are bidding on average $899 for this job

funnyfox

Dear Sir/Madam, we can do this job. Best regards.

$1500 USD in 20 days
(94 Reviews)
8.5
ambar

Dear Sir/Madam, Please check my private message. Thanks Shome.

$750 USD in 30 days
(83 Reviews)
7.3
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$900 USD in 20 days
(154 Reviews)
6.9
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$750 USD in 10 days
(42 Reviews)
6.8
rhomeu

Advanced MS Access developer with VBA here. Let's take advantage of the features of MS Access that it offers - Please check private message box.

$750 USD in 5 days
(41 Reviews)
6.5
bharanisrihari

Hi, Please check PM for details. Thanks!

$750 USD in 7 days
(60 Reviews)
6.3
kulhanekd

I would like to bid on this project. Donna

$750 USD in 30 days
(36 Reviews)
5.8
Krusche

We would offer an MS Office solution with MS Access. In terms of the needed expertise we have ready code solutions for almost every point of your project description, as we have really a lot of experiences in terms of More

$750 USD in 3 days
(28 Reviews)
5.7
digidreamstech

Please look into the PMB.

$750 USD in 10 days
(14 Reviews)
5.4
instech

Kindly see the PM for bid details and comments.

$751 USD in 14 days
(8 Reviews)
4.8
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$750 USD in 5 days
(20 Reviews)
4.6
florinserban

Hi. Please check PM for details. Thanks!

$750 USD in 7 days
(17 Reviews)
4.4
realYuR

Hello, I can do it, just send me a details.

$750 USD in 5 days
(7 Reviews)
4.2
AccuPro

Can do. Please check details in PM.

$750 USD in 2 days
(7 Reviews)
4.1
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

$900 USD in 30 days
(3 Reviews)
4.1
albariconsulting

please see pmb for details

$1499 USD in 29 days
(3 Reviews)
4.0
cnut17

that's clearly a job for an access database as you don't need to share it with many users, but only manage your sku list and export csv. I've made dozens of simple databases like this one, can be done very fast.

$750 USD in 1 day
(4 Reviews)
4.0
pranotor

ready to start sir.. please check your PM

$750 USD in 3 days
(3 Reviews)
3.3
amsak

Placing bid

$750 USD in 60 days
(6 Reviews)
3.4
ConsultOne

See my PM to you regarding the details of my bid

$1300 USD in 11 days
(1 Review)
2.8