SKU checker

Logic behind this application: After users used “Research Assistant” application they download results and filter ASINs in Excel file by criteria they want, deleting unneeded ASINs for the excel template. When users edit the template and saved it to their desktops next step would be to verify if this ASINs already have listings in our inventory for them. So, users upload edited results in the same template as they got “From Research Assistant” into “SKU Checker” and will get results whether SKUs exist for these ASINs.

So the logic would be Get SKU by provided ASIN.

Originally I want to have ASINs checked for both FBM and FBA existing SKUs (if it is possible) – Because they could be different. It is NOT given that FBA SKU = FBA SKU.

Please take a look at the file SKU Checker Result [url removed, login to view] to see the format I want results returned.

The User Interface should be the same as in “Research Assistant” with same functionality.

+ Add log generation for SKU Checker and place On/Off checkbox in settings. (All results you getting from API calls)

+ Ability to multi delete output files.

+ On Result template add column:

If FBA SKU = FBM SKU – column result “TRUE”

If FBA SKU doesn’t equal to FBM SKU – column result “FALSE”

If FBA sku exist only – column result “FBA Only”

If FBM sku exists only – column result “FBM Only”

The column “R” indicates if FBA SKu is Standard size or Oversize – This could be pulled from “Fee Preview Report” if makes sense otherwise calculated by cubic footage from item attribute. The column “R” is only valid for FBA Skus.

PHP Software Architecture

Project ID: #7828936

About the project