If you want to import Amazon products to WordPress and only import those products that are on sale, this is already possible using WordPress Automatic Plugin

1- Setup your campaign to import from Amazon normally

2- set this criterion for the plugin to only import the product if the list price is greater than the product price

[list_price_numeric]

[price_numeric]