Match lowest landed price

This script will change your price to MATCH the lowest LANDED PRICE offer (item price + shipping) with a % positive rating AT OR ABOVE 90% in ANY CONDITION on Amazon.com, while ignoring your own price. If there isn’t competition, the script will use your Base Price. This script applies a price floor of Cost or $1, whichever is greater.

The script will use shipping amount defaults based on item type, if there is no default the shipping amount will be $0.00. For example, if the lowest landed price of a competitive seller on Amazon.com was $15 ($10 item price and $5 shipping price) and your shipping amount was $2.98, the script will set the price of your item to $12.02.

You can change the price floor from 1.00 and the % rating from 90 in the script below, if desired.

var item = FILLZ.ITEM.v1;
var f = FILLZ.FILTERS.v1;
var util = FILLZ.UTIL.v1;

// default price
var price = item.base_price;
// price floor
var floor = Math.max(item.cost, 1.00);

// competition filters
var filters = [];
// ignore offers made by me
filters.push(f.seller_id.excludes(FILLZ.SETTINGS.v1.seller_id_for_venue('amazon')));
// consider only offers with rating >= 90%
filters.push(f.rating.greater_than_or_equal(90));
// filter offers from amazon.com
var offers = FILLZ.SOURCE.AMAZONUS.v2.offers(filters);

//determine my shipping amount (use zero if unknown)
var shipping = util.shipping_by_type(item.type, 0);
if (item.is_fba) shipping = 0;

// match if competitors exist after filtering (landed price)
var lowest = offers.lowest_total_offer();
if (lowest) {
  debug('matching lowest landed price: '+lowest);
  price = lowest.total - shipping;
}

//apply price floor
if (price < floor) price = floor;
return price;