Database For B2B: Suppliers for Dropship Company

I am CFO of a dropship company. We need a relational database created or adapted to our business model, which I will now explain briefly...

We sell inventory we have in stock through major online etailers, ebay, and we intend to have our own shopping cart someday.

We are constantly requesting manufacturers, but primarily wholesalers, to submit new product offerings (we call them sku's) for our consideration. We constantly get lists of product items that a company wants us to either buy, sell on consignment, or flip to an online seller for a slight mark-up.

Once we receive a product submissions, we have to shop the price. We have to see if it is really being offered low enough so we have a decent profit margin, etc. If it is a good price and is an item we want to carry, then we have to upload the product, with some of the fields of information, to our retail seller where it goes live for sale to the public.

We would like to streamline this process using a database. Here is what we envision:

A wholesaler or manufacturer logs into a database using their username and password. New wholesalers should be able to easily set up an account. Once logged in, they can upload the products. We will define the fields they need to fill in. They should have the ability to import their data at least as a CSV (comma separated value) file, and maybe our database could accept other forms. They should also be able to manually upload each offering, with out a bulk upload.

After we receive the uploads, we need to be able to review all of the inputs, sort it by date, or by any other field (sku, manufacturer, product model, name of manufacturer, name of wholesaler, etc.).

We then research the product to see if it is viable to sell. This usually includes copying and pasting the brand name and model number and searching the web for matches to see what street price is. We are open to new ideas as to how the database can streamline the current copy and paste method...

Once we have reviewed the project, we want to track if we accept or reject the offer. If we accept it, we then need to track the way in which the product is to be carried (bought and stored, dropshipped by manufacturer/wholesaler, consigned, etc.)

We then want to avoid having to manually input our selections into our retailer's databases. This means the database has to be able to export a CSV file for the fields we want it to export that match up for input into our retailer's software program.

The number of fields per item we would need to create would probably be well under 50.

Currently, our serve accepts MySQL databases, but we can migrate to another ISP if necessary.

Currently we are shipping out 100 orders a day. We expect that number to grow 10 times to 1,000 in the next year.

I know how to use Filemaker Pro, so I am familiar the what relational databases can and cannot do, and I can give clear explanations of what we want this database to do.

There are many off-the-self databases that will manage orders, inventory, labels and shipments. We are looking at [url removed, login to view] for this one. It would be nice if these databases could work together, but that is for another time! Right now we just need an easy way to manage product buys that, once accepted, we can turn around and submit to the Etailers.

We also want our suppliers to be able to go in and update the information submitted as they acquire more information.

Habilidades: Adobe Flash, Cold Fusion, Delphi, J2EE, Perl

Ver mais: work for ebay online, wholesalers online, wholesalers com, wholesalers c&a, what can i buy and sell for a profit, want to create new brand name, that web company, suppliers products, suppliers online, suppliers for business, some online business ideas, shopping cart filemaker, seller which have shipping, sell business ideas online, self-review, self pro, review matches, review for company, review a company, retail online business, pro ebay, products offering, products manufacturers, own business ideas, online suppliers

Acerca do Empregador:
( 2 comentários ) Las Vegas, United States

ID do Projeto: #163943

16 freelancers are bidding on average $1113 for this job


Hi, we have understood the concept and can develop RDBMS,we are ready to start,thanx

$1000 USD in 30 dias
(13 Comentários)

Very experienced in ASP, PHP and all databases and very complex administrative back end systems.

$1000 USD in 20 dias
(13 Comentários)

Hi, We would like to introduce ourselves as a company of professionals who are driven by the philosophy of customer satisfaction through QUALITY and INNOVATION. We specialize in web-related technologies and soft Mais

$1000 USD in 27 dias
(29 Comentários)

hey..chk out PMB.

$1200 USD in 20 dias
(12 Comentários)

BPowerHouse is an international premier specialist IT solutions and services company, that combines core technical expertise with a global business perspective. The company's key offerings include product development, Mais

$1500 USD in 30 dias
(1 Comentário)

Good day Sir, I am software engineer experienced with enterprise systems. I have a strong experience using Java/J2EE, PHP, Flash (ActionScript 2.0 and Flex) and relational databases (MySql, Oracle). I am working usi Mais

$1000 USD in 30 dias
(0 Comentários)

Hi Sir, I used to be a GM for a small trading company for inductrial gadgets. So I am very familiar with the backend flows as we also have a kind of system running (not to my standard, though). Now I started SOH Mais

$1000 USD in 15 dias
(0 Comentários)

Hi, Pl ref pm for details. Thanks VVN

$1500 USD in 90 dias
(0 Comentários)

Our Proposition We have extensive experience in designing and implementing the online store of Vodafone Co Uk and the Inventory management of Indian Railways. Both of these software systems incorporate all the require Mais

$1500 USD in 45 dias
(0 Comentários)

Hi there, In all honesty you're looking for a pretty basic system that ties together a few of your standard procedures, and can potentially hook into additional procedures down the track. I can develop a system that is Mais

$1250 USD in 20 dias
(0 Comentários)

IT Solutions is Software Solutions Company with a global presence. We are a technology based service provider in the area of eBusiness, eCRM, and IT Service Management, Specializing in the field of systems integration. Mais

$1500 USD in 30 dias
(0 Comentários)

hi as i i have seen you requirement and fortunately i am having good hand on on sales and inventory +ebay system (I am a developer member of ebay). i am presently working for a US based company who deal is ahving simla Mais

$800 USD em 1 dia
(0 Comentários)

10 yrs in delphi and 4 yrs in mysql, high experienced in optimized coding in huge databases

$900 USD in 30 dias
(0 Comentários)

Dear sir, We are Prognosyz Technologies we are one of the leading service provider in the areas of web technologies such as web designing webhosting email solution, and other web based application such as crm, and erp Mais

$1100 USD in 35 dias
(0 Comentários)

Hi We are group of programmers from India willing to submit our proposal based on your requirements. We would also like to discuss few technical specifications based on specification set given in PM.

$1250 USD in 45 dias
(0 Comentários)

We have a turnkey solution that does exactly what you have described, including automated daily push to your own database with updated SKU and inventory information, including detailed descriptions, images, categories, Mais

$300 USD em 1 dia
(0 Comentários)