MySQL Forums
Forum List  »  MySQL Query Browser

product loyalty query
Posted by: Henk-Jan van der Kamp
Date: December 23, 2016 04:26AM

i am facing the task to evaluate Shopware (online Shop, mysql DB) data.

Most have not been too complicated (using Power Query and Excel ..).

However, one issue is not that trivial. We need to know if customers stick to a product or, through time and multiple orders, make a lot of changes to their product scope.

Shopware has 3 Tables required for the analysis :

s_user : user data (id)
s_order : order data (userid as key to s_user, its own id, ordertime, status (only status 1 are fullfilled orders))
s_order_details : breakdown of order to article(s) (orderid as key to s_order), article

So basically I need
- for every user, for every order, for every article
count orders per user
count articles per order

Sounds like a PL SQL Loop with which I have not enough experience.

Any experts out there wanting to help me with that ?

Options: ReplyQuote

Written By
product loyalty query
December 23, 2016 04:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.