4 Replies Latest reply on Jan 31, 2019 1:02 PM by Tiag Guimarães de Freitas

    Combo products

    Tiag Guimarães de Freitas

       

       

       

       

      490/5000

       

       

       

       

      Hello guys.

      I have a question, I have a list that contains several different product codes and several different orders.

      I would like to know ...

      In how many different orders an item X was sold with a second item that can be any one, and which item is.

      I would like to know the item, and which was the second most came out on different orders with this item.

      In short, I wanted to know what are the possible combos I can create based on a product and order history.

       

        • 1. Re: Combo products
          Jim Dehner

          Hi

          Sounds like you want to do a market basket analysis

           

          if you are on 2018.3 you can use set actions to do that

           

          you can reverse engineer the attached

          you just create a set on the

           

          you create a set on the lower level (sub cat)

           

          then create a set on that set

           

          and add a set action to the worksheet

           

           

          it returns this

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Combo products
            Tiag Guimarães de Freitas

             

             

             

            595/5000

             

             

             

            Hello jim

            Thank you for the return.

            But actually what I need this...

            Example

            I have the television item that had 30 orders, of these three I

            would like the quantity of orders that came with an additional item to come to me, but I do not know what item it is, the tableau that has to make the account identifying the first, second and third item that most came out along with the first.

            In the table below shows 30 orders with television, 30, 28 contained Desktops, 22 with servers and 19 Notebooks.

            Soon I know that every time I sell a television I can offer one of three items as a complement.


             

            • 3. Re: Combo products
              Jim Dehner

              that is what this shows with the 814 phones there were 199 binders etc

               

               

              Jim

              • 4. Re: Combo products
                Tiag Guimarães de Freitas

                Thanks for the help, but still not clear the information.

                In the table below for example, the data is exactly as it is in my database.

                 

                I just want him to bring along with each item what else was sold with it, I'll send the file together for you to see.

                That's all I need, in a tabulated form, it may even be conformed to this table below, which is actually the vision I have to do.

                The table below shows the first, second, and third best-selling items, and the percentage of times the additional item was part of the key item.

                Example.

                They had 8 requests for television, of the 8 five had a desktop, so there are 63% of the television applications that have desktops.

                 

                 

                  

                OrderItem
                0423Television
                0423Desktop
                0424Television
                0425Television
                0425Server
                0426Server
                0427Television
                0427Desktop
                0428Television
                0428Desktop
                0428Mouse
                0429Desktop
                0429Server
                0430Notebook
                0431Mouse
                0431Keypad
                0432Television
                0432Desktop
                0433Television
                0433Notebook
                0434Television
                0434Desktop
                0435Desktop
                0435Mouse
                0436Desktop
                0436Keypad
                0437Desktop
                0437Keypad
                0438Desktop
                0438Keypad