Archives: FAQs

On the SalesData sheet the Referral % field calculates the referral percentage from column R, selling fees / column M, product sales. The FP Ref % is the referral percentage calculated from the FeePreview data. This is simply a reference to see if the referral percentages are different between the two. This will only happen when the item was moved to a product group where the referral fees are different. Keep in mind that the percentage can be higher than the product group referral percentage when there is a minimum referral fee (usually $1). Ref. Dif? will say “Yes” when the difference between the two if greater than 5%.  This result is not reported on the Order Summary report.

To calculate what belongs on Fee Check Summary, we take the standard deviation of all length + girth and weights fields for all items. These calculations are displayed on the far right of FeePreview. Any items that have greater than 3 times (3z) the standard deviation of both of these goes into the Fee Check Summary.

These items should be physically measured and weighed to check the accuracy of what Amazon has listed. Take a picture or two to prove to Amazon seller support if, in fact, your measurements or weight are different.

Recoverable Fees are calculated based on the total difference between FBA fees and FeePreview when Problem = Yes.  This could actually be considerably more if you were charged incorrect fees, but the item was not in the FeePreview data to verify the fees against our Threshold calculations.

Problem = Yes: FBA fees were more than both the Threshold and FeePreview. There was definitely something different with orders marked yes, and they should be investivated.

Problem = Maybe: FBA fees for this order were more than the Threshold OR FeePreview. This may be because of an incorrect fee, and we didn’t have a whole lot of data to go on, or because of a FBA fee change. There isn’t necessarily an issue, but you should check to be sure.

Problem = Decreased: FBA fees were less than what is listed in FeePreview. This is probably because the fees were recently adjusted for that item due to a weight or dimension change. That means the fees could currently be incorrect and this tool did not pick up on it because it thinks those fees are normal.  Orders with a quantity more than 1 are filtered. Regardless, you should investigate why the FBA fees are less.

This is the “adjusted FBA fees”. Column S ‘fba fees’ contains shipping and gift wrap totals. These are subtracted from the adjusted fba fee. Multi-channel fulfillment orders are also excluded since the fees are not consistent with regular fba fees. These orders have an Order-ID beginning with ‘S’. We account for orders that received a promotional discount as well. In other words if you gave out a coupon code, that amount is subtracted from the fee total.

Also, we’ve tried to take into account orders with multiple quantities. The adjusted fee divides by the quantity as to make the fee per item rather by order. Any change in fees will have to be greater than the calculated threshold to trigger an issue regardless of how many items are in an order.

The threshold figure you see on the Order Summary and Sales Summary is calculated by taking the average of all FBA fees for an item + the standard deviation of those fees. If there the standard deviation on the Sales Summary sheet is $0.00 for an item, that means the fees were always the same in the sales data (they didn’t deviate). You can see a summary of the averages and standard deviations for each item on the Sales Summary sheet.