Adspert needs to receive a feed with details to calculate and the profit per product to start profit optimisation.

In this article, we describe what type of feed format and parameters we need to start profit optimisation.

Feed Format

You can either send us a CSV or XML or GSheet with that data or supply us with an URL where we can download the data automatically every day (preferred!).

Feed Parameter

Name

Description

URL

Where to get the feed from. Supported file formats:

  • CSV (including variants like semicolon and tab-separated)

  • XML Atom or RSS feed

  • Google Sheet

vat_price

The default VAT rate for product prices.

This refers to prices from MWS.

To fetch product values from a GSheet, it must be publicly accessible or access granted to the userinspector@adspert-inspector.iam.gserviceaccount.com.

The URL in table product_value_feed must follow the pattern gsheet:<DOC-ID>[/<SPREADSHEET-ID>].

Feed Columns

Column

Description

Required

amz_sku

Product SKU.

Yes

cost_of_goods_sold

Seller’s buying and handling cost for a product, excluding Amazon fees and advertising cost. Without vat.

If a seller decides to set the shipping cost in Amazon to zero (for FBM products), this value should include the shipping cost.

Yes

vat_price

Rate of VAT included in price (e.g 0.19 for 19%)

No (feed parameter vat_price is the default).

Example of how it should look like

amz_sku

cost_of_goods_sold

vat_price

AB1233r

10

0.19

Please make sure to provide information to your client success manager, about the number format for monetary values and rates:

  • Is comma or point used as decimal separator?

  • Is VAT provided as a rate (e.g. 0.19) or as a factor (e.g. 1.19)

Did this answer your question?