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.
See screen shot of flowchart basic design.