Move invalid and unsellable product

Owned by Morten Lindequist Køhler
Feb 14, 2024
1 min read

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 - From

To

Command

Action

Script

Note

.

Productlist1

SELECT.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

 

 

 

 

.

Productlist2

SELECT.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

 

 

 

 

Productlist2

Productlist1

JOIN

 

 

 

Productlist1

Productlist

SELECT

 

 

 

_Value

_Value

 

 

 

 

ProductValidUntil

#ProductValidUntil

 

 

 

 

Sellable_EN

#Sellable

 

 

 

 

 

Category_EN

 

 

Value="_Inactive";

 

Productlist

Product

IMPORT