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.
Sir, I went through your requirement and understood it properly, I need more information from your end, regarding the project. If you want to see my expertise kindly go through my profile reviews https://www.freelancer.in/u/pulakesh90.html , or my website www.infyact.com.
Thanks & Regards
Pulakesh
Hi,
Greeting from Vying Software!
I have gone through the requirement carefully and feel confident to do you project well. We are highly qualified and experienced team and we always believe in client satisfaction.
Skills: PHP/MYSQL, ecommerce, social networking open sources.
Let me know when we can discuss the project.
Thanks a lot!!