sedang Berlangsung

Project for robnicholson -- 4

New add on for UNFI

Building on what you have done with UNFI and SP Richards SQL code.

Goal is to add new products to a UNFI client DB by looping though the "Customer_Datafeed" table as is done now to update the inventory numbers for UNFI but instead of updating inventory add/update new products.

The process should be separate from the UNFI Inventory update because it does not need to run as often.

You have a process now in SP Richards you built for me to add products ( and all the related tables for a single DB) but now the database we need to pull the data from ("Store_2_Master" with a given VendorID in a related table to the "Product" Table, "Product_Cost") is on a different server and the client database could be on a number of different SQL servers.

We would only select products that have a given vendor/supplier ID (VendorID).

I think you still have access to the SQL server [url removed, login to view]

Let me know if this is something you want to do. I also have two items to do as soon as the above is done.

1. Diagnose and fix if possible a SQL server 2008 keep rebooting more often than is normal.

2. Design, build a new process to import data from a number of sources in to a master database and then move that data to client data bases. Not all data will be updated or added but data based on vendors/suppliers. I laid out a basic overview of this below. I want to hit this as soon as we can as well.


This is an overview of what I am doing here so you can get a good picture.

I own a small ecommerce software company that sells ecommerce software(shopping cart) I wrote the code. Our big selling point is product and inventory integration with suppliers/distributors.

Some suppliers we have to clean and manage their data because of the quality of data we get from them before we push it to our clients (web site owner). Others the data comes in very nice with all the data we need like an sp richards you did for us.

Right now we put some data in a master database some in different databases pulling inventory and products from all other the place.

Goal and what I want to work toward is:

All supplier products in a single master database with their cost and inventory updated there. Many products have more than one supplier like a can of Coke we would have one product and 5 or 6 suppliers with each ones inventory and costs(multiple price levels or client specific pricing).

We want to push this data to a given client database based on the supplier they use like UNFI or S.P. Richards some will only have one supplier other lots.

Keahlian: Azure, Administrasi Basis Data, Pemrograman Database, Microsoft SQL Server, SQL

Lihat lebih lanjut: unfi, s. p. richards, code of shopping cart in db design, access vendor database, shopping portal small project, project assignment small company, project plan mall shopping cart, online shopping project cart, project working capital small company, small company network project, project report demo small company, project plan website shopping cart, project cart system shopping dreamweaver, accounting system project small company, project small company, network project design documentation small company, zen cart modify shopping cart, small company web page, drupal small company

Tentang Pemberi kerja:
( 5 ulasan ) Alpharetta, United States

ID Proyek: #11184645

Diberikan kepada:


I have had a lot of experience in coming into companies and getting data from various sources to centralize and clean up their current data. Please review my resume in my profile. Thank you for your time. Sincerely, Lebih banyak

$55 USD / jam
(0 Ulasan)

3 freelancer menawar dengan rata-rata $53/jam untuk pekerjaan ini


Dear Sir/Madam, We can start immediately RK Websoft Technologies is a software designing and development Team. We are having very experience, enthusiastic and talented team with more than 5 years of experience on .N Lebih banyak

$50 USD / jam
(2 Ulasan)

Hello, I propose the following steps to implement the action plan of the project: 1. Any questions, contact me. 2. Design of the solution. 3. Development of the solution. 4. Testing and implementation of the s Lebih banyak

$55 USD / jam
(0 Ulasan)