This release fixes a couple of bugs, adds a new column, and enables filtering and scoring on custom columns.
Bugs fixed
Custom formulas are now compatible with Google Sheets. They used to produce a double equals sign ('==') at the front, making them not render in Google Sheets. This is no longer the case so that they work properly.
The “AMZ Price to Break Even” and “Max Cost to BE + X%” columns now trigger the download of fees. Someone without any fee columns at all in their output would have seen these columns as always blank.
ASIN Scores could in some circumstances be evaluated when the respective data wasn’t available yet.
The “Number of Images” column may have shown an inflated figure without historical data, due to incorrectly counting multiple resolutions of the same image, or a blank.
New Image List column
The “Image List” column has been added (ID 1132), which will produce a list of all available* images on this product, in their largest known resolution.
* Subject to the API limit, which at time of writing is 8.
Filtering and Scoring on custom columns
Filtering and scoring have just become even more powerful: You can now use them with your custom Excel formula based columns!
Previously it wasn’t possible to select a custom column for creating a filter or scoring rule. In this update we have worked to add this functionality, enabling the following new use cases:
Combining criteria
You can now use Excel’s AND() and OR() to create arbitrarily complex conditions under which a product should be discarded or receive a certain score.
Filtering on input columns
To create a custom column that references an input column, recall that we use the notation =@{A} to output the value of input column A.
You can now use this in a filter, so if you name this column “Input column A”, a filter such as “Discard if Input column A is equal to ‘No’” becomes possible.
A concrete use case is where your supplier has a “Quantity on Hand” column that you may wish to filter out. Let’s assume for this example that this “QoH” column is column C. In that case we would define our custom column like this:
And this would become our custom filter:
Your custom column does not need to be part of the output in order to be evaluated, but it may help you with debugging.
We also recommend adding the Discard Reason column when creating a new custom formula based filter. Adding this column has the effect that discarded items remain in the output, and this column will tell you which filter would cause it to be discarded. This allows you to refine your filters. You can also quickly remove these rows based on “Discard Reason” having a value.
Items that are discarded in this manner are treated the same as if they were actually discarded - they will not have all data populated depending on the stage at which they were filtered out.
If you work with files in different formats, do remember to disable these filters, or it could lead to unexpected results. For example and following the QoH example above, if your next file has a blank column for C, it could result in all items being discarded right at the start.