search

spooky-oysters / Bangazon-Command-Line-Application

0 stars 1 forks source link

User should be able to view stale products #9

Open stevebrownlee opened 6 years ago

stevebrownlee commented 6 years ago

Given a user wants to see products that aren't selling When the user selects the option to view stale products Then the user should be presented with a list of all products that meet any of the following criteria

  1. Has never been added to an order, and has been in the system for more than 180 days
  2. Has been added to an order, but the order hasn't been completed, and the order was created more than 90 days ago
  3. Has been added to one, or more orders, and the order were completed, but there is remaining quantity for the product, and the product has been in the system for more than 180 days

Pro tip: Investigate the SQL Union operation to fulfill these requirements

DreRandaci commented 6 years ago