same color for recommend product

Question

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 Answer

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

david--garcia · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO