Average landed price

This script will change your price to the AVERAGE LANDED PRICE (item price + shipping) of all available offers 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 average landed price of a competitive seller on Amazon.com was $10 ($7 item price and $3 shipping price) and your shipping amount was $2.98, the script will set the price of your item to $7.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
var shipping = util.shipping_by_type(item.type, 0);
if (item.is_fba) shipping = 0;

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

//apply price floor
if (price < floor) price = floor;
return price;
Have more questions? Submit a request