relationship betwwen order and products!!!

Frank Lampard asked on July 31, 2020 13:14

Hi there I need to what is the relationship between order and product to figure out how many product which sold? I've tried to use COM_SKU table but I cannot figure out which product how many has sold?

บอลสด

Recent Answers


Zach Perry answered on July 31, 2020 15:56 (last edited on July 31, 2020 15:57)

COM_order is the table with all the orders.

COM_OrderITem is the items that were on the order.

COM_Sku is the items available to sell.

1 votesVote for this answer Mark as a Correct answer

Kadir Ergün answered on July 31, 2020 17:01 (last edited on July 31, 2020 19:02)

Hi Frank,

You can see realtions between tables diagram below

Image Text

COM_Order -> COM_OrderItem (OrderItemOrderID = OrderID) COM_OrderItem -> COM_SKU (OrderItemSKUID = SKUID)

Image Text

I hope it helps,

You can generate custom report with SQL, but there are multiple reporting in "Store Reports" It might be the one "Top Products by number of purchases" what you are looking for.

Image Text

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.