Build a utility to compare two inventory files and present the output

We use a physical point of sale (ERPLY) and an ecommerce platform (SHOPIFY). We need the ability to take the product table exports from each system and then compare them on 4-5 different fields, then output the results for each of those scenarios. Here are the scenarios: Products that should be online but are not: ERPLY Show In Webshop = Yes AND SHOPIFY visible online = No Products that are online but should not be: ERPLY Show In Webshop = No AND SHOPIFY visible online = Yes Products that are have inaccurate sale pricing on Shopify Shopify Price <> ERPLY Web Price List OR Shopify Compare at Price <> ERPLY Net sales price Products Out Of Stock Online That Are In Stock In Store Shopify On Hand <= 0 AND ERPLY > 0 on hand The output would display a table with the following fields (field from ERPLY unless noted as SH- which is Shopify field): Code UPC Code Name Product Group Net Sales Price SH - Compare At Price Web Price SH - Shopify Price Brand Show in webshop SH - Visible online In Stock SH - On Hand The user can filter on: UPC - text box entry, live search Name - text box entry, live search Product Group (ERPLY Field) - drop down, alphabetical ascending order Brand (ERPLY Field) - drop down, alphabetical ascending order The user can select the different scenarios to reduce the output list down. *We are requesting a basic mockup of the app before we select a freelancer. This can be done in Paint/drawn on paper, as long as we know you have an idea of what we are trying to create.*