search

kowalczj / shop24

Web commerce application implemented in Flask
GNU General Public License v3.0
0 stars 0 forks source link

Display Inventory Purchase Metrics #8

Open kowalczj opened 4 years ago

kowalczj commented 4 years ago

As a marketing employee, I want to be able to see statistics on items purchased to gauge the popularity of various items. This will help the team decide which products to promote and which products to pull from our inventory.

crisischris commented 4 years ago

(estimation) 1 week. could be a DB column of #of_times_purchased? or we have to scrape through all customer records for the item? I'll go conservative.

kraynakr commented 4 years ago

this could be a query like: select customer.id, count(order.id) from order join customer on order.customer_id = customer.id group by customer.id