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

In this article we describe, what type of feed format and which 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 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

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.

This should be excluded Amazon fees and advertising cost.

If you as a seller decide to set the shipping cost to zero (for FBM products) then cost_of_goods_solds should be included in 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 manage, 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?