In Progress

Design an Access Database

I use [url removed, login to view] to manage inventory across multiple marketplaces. I currently use microsoft excel to manage the listings on solidcommerce.

I need an access database that will simplify this process.

It needs to be compatible with solidcommerce's excel addin tool.

The database needs to be able to download all the data I require from solidcommerce; compare it to the current data in case there were changes (such as if I moved an item From one warehouse to another, or a price has changed, etc). Update the records that changed. While maintaining formulas for such fields as:

sale price, warehouse location, etc.

It should also let me find entries that need certain data (ie entries that are missing images, or descriptions or whatever I want to search for).

Data should be easily accessible via forms. And be extensible. IE I currently sell on [url removed, login to view], [url removed, login to view], volusion. If I add Ebay in the future, I need to be able to add that in with little outside effort.

Database should also let me match categories across the various platforms, assign my products to those categories. I will maintain a volusion oriented category structure. If a product, for example, is in "car parts" in my store, I need to be able to map "car parts" to the ebay/amazon/etc equivalent for easy uploading. I want to allow any item to exist in up to 5 categories.

I can provide the current excel structure as a template of how things should work.

Any data I change needs to be exportable to excel for uploading to solidcommerce. Any unchanged entries, of course, would not be uploaded.

In short, I want it to:

1) download all current data from solid commerce.

2) compare that data to current records

3) make changes to the current data (maybe allow me to accept/decline those changes)

4) allow me to make changes to data and reupload the changed data.

5) categorize items based upon a structure I provide and map that structure to other versions (I'd do a one time map for each, and it'd remember that)

6) create feeds (a la solid commerce specs) to various marketplaces

7) allow the use of custom variables a la solid commerce specs

8) create shopping engine data feeds (csv format), that could be uploaded to various shopping portals

9) add products and then upload to solidcommerce and the various marketplaces

Maybe more...we can talk about it.

Attached is the generic start up template. Mine is a bit more complex, using formulas to define various fields.

Also, there can be up to 100 custom variables as well (I use about 10 of them right now).

Skills: Excel, Microsoft Access, Volusion

See more: access volusion database, access database volusion, volusion database access, want to buy a car, use case tool download, use case map, use case amazon, time map template, template tool price, search for product design, price structure template, parts inventory database, parts database example, parts database access, microsoft excel formulas, microsoft access parts database, la design, i want to buy a car, i need an access database, how to make an ebay store template

About the Employer:
( 12 reviews ) Riverview, United States

Project ID: #4540059

25 freelancers are bidding on average $1808 for this job


#1 Database, volusion, ecommerce expert on freelancer

$1578 USD in 3 days
(257 Reviews)

Consider it done. Check your PM for my bid details.

$1578 USD in 15 days
(321 Reviews)

I HAVE 15 years exp access I can build your database

$1666 USD in 3 days
(41 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$1578 USD in 9 days
(42 Reviews)

Hi, I have experience with this project, I happily if work with you in this project. Best Regards winnet21

$1578 USD in 30 days
(16 Reviews)

Please see PMB for details in relevant field. Thanks,

$2500 USD in 14 days
(18 Reviews)

I am ready to start this project... thanks

$1500 USD in 3 days
(11 Reviews)

This is an exciting project which is hard to come by in this place - I have 15 years of corporate and freelance experience with Access, Excel, SQL and data which may come useful.

$1500 USD in 10 days
(11 Reviews)

I'm a Microsoft certified MS Access developer, +12 years of experience as well as a Database/MySQL Web programmer. I did a similar project for a client not long ago; I'm ready to get started with your project.

$1500 USD in 5 days
(13 Reviews)

Please check private message.

$1500 USD in 15 days
(1 Review)

I have nearly 10 years of programming experience.

$2500 USD in 30 days
(3 Reviews)

I would like to offer my services for this job. Check PM for details

$1777 USD in 20 days
(3 Reviews)

Hello, see PM

$1500 USD in 10 days
(2 Reviews)

Hello, i can do it. In fact, i have allready done something similar. See PM please.

$1777 USD in 15 days
(1 Review)

Hi, Greetings from Sanskar Technologies. We have gone through your project requirement clearly and are confident that we have all resource & expertises to execute this project in line to your [login to view URL] assure the More

$1777 USD in 15 days
(1 Review)

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

$1894 USD in 30 days
(0 Reviews)

Hello, Let me do this project for you. Please see your inbox for more details. Thank you.

$1500 USD in 10 days
(0 Reviews)

Hi, I'm ready to start this job. Thanks.

$2500 USD in 10 days
(0 Reviews)

See Private Message.

$1500 USD in 3 days
(0 Reviews)

I have over 12 years experience working with Excel/access and building databases to meet clients needs.

$1666 USD in 7 days
(0 Reviews)