Skip to main content

Move invalid and unsellable product

Zoltán Mikolás
  • Updated

This Action Map moves invalid and unsellable products to a Perfion Category called _Inactive.

This example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.

Action Map

  • All lines containing a Command are created as virtuals. This is a recommended best practice
  • The "." in the first and third From field means "current Perfion database"
  • Two SELECT.PERFION queries are executed and then joined to one dataset (Productlist 2 is joined to Productlist 1)
  • The SELECT command builds a dataset for import. It sets Category to Inactive

Sample data for building Action Map

NOTE: Line breaks are omitted if you paste scripts from the table below directly to an action. In stead, paste script to Notepad++ and then copy from there. That will preserve line breaks when you paste into an action.

Action Map - FromToCommandActionScriptNote
.Productlist1SELECT.PERFION <Query>
<Select languages='EN'>
<Feature id='ProductValidUntil' />
</Select>
<From id ='100'/>
<Where>
<Clause id='ProductValidUntil' operator="&lt;" value="@@DATENOW" />
</Where>
</Query>		Not valid products
Table@FORMAT    
.Productlist2SELECT.PERFION <Query>
<Select languages='EN'>
<Feature id='Sellable' />
</Select>
<From id ='100'/>
<Where>
<Clause id='Sellable' operator='=' value='No' />
</Where>
</Query>		Not sellable products
Table@FORMAT    
Productlist2Productlist1JOIN   
Productlist1ProductlistSELECT   
_Value_Value    
ProductValidUntil#ProductValidUntil    
Sellable_EN#Sellable    
 Category_EN  Value="_Inactive"; 
ProductlistProductIMPORT   

Related articles

Comments

0 comments

Please sign in to leave a comment.