What is the requirements:
Provide a script that I can run daily to create a database and update it daily that contains a summary record for each unique Sales Order ID & SKU combination.
The records will primarily contain summary Price, Sales Tax, Shipping Fees Paid, Shipping cost, Product Cost and Profit for each record. This will allow me to sort and analyze data in the manner that I require.
Because the sales information that i have is detailed information, I am looking for a very simple Solution to provide Summary Data for each Sales Order ID and SKU. While the detailed information is very useful, Most of what I want to do requires the data to be summarized. Unless you have a very easy and simple solution that is easier than creating a summary database, I am asking for a simple script that creates a summary database that contains 1 summary record for each unique Sales Order Id and SKU. What does this mean. Sales Orders may have multiple SKU’s on each order. I would want a database that has summarized records based on the Sales Order ID and SKU. So the database could and will have multiple records with the Same Sales Order ID but not with the same Sales
Order ID and SKU combination.
You must comment the script sharing the detail of how the script works so that in the future i can understand it and possibly make minor changes.
I will provide existing two database structures and files already created. I have attached the relationship diagram. I also already have a layout that works correctly that has all the summary data on it if that is helpful.
Only Sales, SalesTranx, and salestranxsummary databases involved.
Please look at the new Database structure design document and the PDF that tells the details.
5 freelancers are bidding on average $96 for this job
Hi...Can you please share up the ER Diagram as the attachment is shown getting shown. Will revert back to you in case of any doubts that would arise. I would try completing your project in minimal time.