Comparing Supplier's Inventory list to store's daily inventory list to find changes?

Hi! I am new to this forum and it looks like there are quite a number of very skilled participants. I am hoping to find the answer to the question below:

I am looking for a way to compare a number of different field values exported from my website's inventory list of a particular supplier's products. The supplier provides a daily update of their entire inventory list - approx. 10,000 items. Now my exported CSV file from the website of the inventory purchased from that supplier is approximately 1000 items. I buy only 1/10 of their available inventory.

I would like to remove all of the inventory (SKUs and their related fields) that I do not buy from the supplier's list and compare the changes in cost availability (discontinued for example) and quantity between the two lists. Would it be possible to produce a new sheet or file listing only the inventory from my site's list showing the changes for each inventory item between the two lists but removing the items that I do not buy from that supplier for the sake of comparison? I would like to then import only the updates / changes between the lists back into my database.

Is this possible and how can I accomplish this?
Does anyone have a template for this purpose? It would surely, be very appreciated!
My supplier sends an updated list daily of their complete inventory list in an excel file format but there are just too many items to compare and update manually.

Help!!
Thank you...
Regards,
Darrell

Yes, I have uploaded the two files that I am dealing with.

Thanks!
Darrell

Sorry ... This is what I want please:
I would like to remove all of the inventory (SKUs and their related fields) that I do not buy from the supplier's list and put onto a separate sheet. I need to compare wholesale cost changes (highlighted if possible)only for the SKU's that Have on site (Store List). I would like to have the field from the suppliers list Quantity on hand and Availability remain on the clean sheet (minus the SKUs that are not in the Store List). Would it be possible to produce a new sheet or file listing only the inventory from my store's list showing the changes for each inventory item between the two lists minus the items that I do not buy from that supplier. I would like to re-import only the updates / changes between the lists back into my database.

Thank you!
Darrell

I have uploaded the files. Can you provide assistance in this regard, please?

Yes, I have uploaded the two files that I am dealing with.

Thanks!
Darrell

Files Attached

File Type: csv Sample Inventory File My Store.csv‎ (19.0 KB, 4 views) Download
File Type: csv Suppliers Daily Update List.csv‎ (943.5 KB, 0 views) Download