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:
|
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)