Prerequisites

The minimum percent of price drop must be configured.

Logic

Condition checked during product row being added to "product catalog":

(stockTotalFromFile > 0) && (newPriceFromFile < (wishlistOrAbandonedCartPrice * (100 - minimumPercentPriceDrop)%))

Here's what each component means:

  • stockTotalFromFile - the "stockTotal" field value from the current import.
  • newPriceFromFile - the "productPrice" field value from the current import.
  • wishlistOrAbandonedCartPrice - the price saved in the contact's Wishlist or Abandoned Cart.
  • minimumPercentPriceDrop - the price drop percentage value configured in the trigger.

Example

Trigger settings:


Imported data:

Product price saved in the contact's Wishlist or Abandoned CartproductSKUstockTotalproductPriceResult
10aaa-aaa-aaa05Doesn't meet the "Price drop" trigger condition because the imported "stockTotal" field is not higher than 0.
bbb-bbb-bbb38Doesn't meet the "Price drop" trigger condition because the imported "productPrice" is not lower than the configured 20% price drop.
ccc-ccc-ccc27This meets the "Price drop" trigger condition because the imported "stockTotal" is higher than 0, and the imported "productPrice" is lower than the configured 20% price drop.
ddd-ddd-ddd412Doesn't meet the "Price drop" trigger condition because the imported "stock total" is not lower than the configured 20% price drop.