same color for recommend product

[mukeshpurushothaman]

scenario : If the customer buys red products, we want to recommend red items.
So how to set recommend product color as same as recipient product color in adobe campaign client console ??

[Parvesh_Parmar · Accepted solution]

Hello @mukeshpurushothaman ,

There can be many way to implement it. It depends on your data and use case.

For e.g. you can try the following steps: 

1. Create a new attribute "lastPurchasedItemColor" in recipient table.

2. In the product table, create a filed filed "colorOfProduct".

3. Create a workflow which may run every day, there your query order table to  get the last purchased product, from there you can insert the last purchased product color value in recipient field "lastPurchasedItemColor".

4. Create your business workflow in campaign where you can setup a link between recipient and product table based on lastPurchasedColor and other criteria ( for e.g. number of product/ Propensity to buy) and it will give you list of recommended product of same color. 

Thanks, 

Parvesh

[mukeshpurushothaman]

Hello @Parvesh_Parmar, 

May I how to link Recipient and product table ?

[Parvesh_Parmar]

Hello @mukeshpurushothaman , 

You can use enrichment activity to setup a link between recipient and productTable based on color. 

You need to setup 1 to N link, then you would get all product of same color. 

Note: You need to exclude the product which already purchased, If  you do not want to show this product.  otherwise you would get the same product again, because it has the same color.  

1. Add a enrichment activity and setup a link: 

2.  Select the product scheme: 

3. In the next screen, you can add condition based on color. 

You can use the enumeration for Product table as mentioned by @david--garcia in last comment. 

Thanks, 

Parvesh

[david--garcia]

Create an enumeration in your product's schema

  <enumeration basetype="byte" name="cusColorProfile">
    <value label="White" name="white" value="0"/>
    <value label="Yellow" name="yellow" value="1"/>
    <value label="Red" name="red" value="2"/>
    <value label="Blue" name="blue" value="3"/>
    <value label="Brown" name="brown" value="4"/>
    <value label="Purple" name="purple" value="5"/>
  </enumeration>

And a new attribute to assign enum.

    <attribute enum="<namespace>:<yourschema>:cusColorProfile" label="Color Profile" name="colorProfile" sqlDefault="0" type="byte"/>

 Each product must be assigned a color, however, by default they will be assigned White or 0, you can name it "Unassigned" or "Neutral"

In theory your orders/purchases will inherit/reference the product purchase colorProfile, hence, you could recommend products belonging to the same colorProfile, you may want to include additional conditions such as price range based on historical product purchases data.

I don't think you need to assign a color to your profile, but rather go through the order history / purchases to get the colorProfile of products purchased in the past. anyways, to learn how to create a link visit the following documentation video.

https://helpx.adobe.com/campaign/classic/how-to/links-between-tables-in-acv6.html