Project for Hsottany

1. A table will be created. This table is the basic list of asins. a. ASIN b. SKU(Serial Number) c. Asin status (LIVE/Discontinued/Merged) (E) d. Restrictions (Y/N)(E) e. Restrictions Code(E) f. Restriction Note(E) g. Title h. Image1 link i. Image2 link j. Description k. Shipping size l. Shipping weight Option to add additional columns as needed. There should be an option to add sku and asins to this list by uploading a csv file. When the file is uploaded it should automatically check if the asins or skus are already present and add only new asins/sku. Once the new asins are uploaded, it should pull the columns g to I from amazon. There should be an option to download the above information in csv based on filters e.g. Restriction code =Y or based on specific list by uploading csv 2. A second table is required for the price part. This table should automatically pull new asins from first table and add new asins a. ASIN b. Sku c. Lowest FBA price (new condition) d. Last checked date and time stamp e. Additional coulmns for last 3 checks and their date and time stamp Where ASin status = ‘Live’ AND Restricions = ‘N’, the script should run in the background and keep updating these skus/asins. The script is required to update these skus/asins atleast once a day. There should also be an option to stop the above background update and prioritize a list of skus/asin for price check by uploading a csv file or scheduling update jobs based on multiple csv files uploaded. Options to download the above data in csv based on filters like a specific list of skus/asins or price range or date range etc.