Products - 1.0.0

API Endpoints

Products
- Description: Get normalized products across all merchants.
- Example Request: https://s3.fmtc.co/api/1/products?api_token=API_KEY

Products API

Using the Products endpoint will result in the fields listed below. You are welcome to use as much or as little of this information as you like when displaying the Products on your website. We encourage our subscribers to monitor created_at, updated_at, and processed_at. Because our database is updated daily, we suggest you pull incremental data every 24 hours.

What’s New?

Updated parameter names for consistency across our APIs.

Request Parameters

Name	Value(s)	Description	Required	Default
api_token	APIKEY	API key for authentication, available on the API Keys & Calls page.(https://account.fmtc.co/cp/api_keys)	Yes	N/A, must always be provided
format	String XML, JSON, CSV, TAB, or PIPE	Choose the feed format you would like returned.	No	json
latest	0, 1	Limits Products based on how long ago the process was processed	No	1
latest_days	Number	How many days old a Product can be before it is returned	No	1
only_on_sale	0, 1	Limit the products to only those on sale.	No	0
only_has_image_link	0, 1	Limit the products to only those with an image_link value.	No	0
only_freshreach	0, 1	Limit the products to only those related to merchants within FreshReach®.	No	0
cross_merchant_id	String	The Cross Merchant ID (CMID) of the Product to return.	No	null
currency_code	String (###) USD, EUR, GBP	Return only Products from a particular Currency Code.	No	null
network_id	Number	Return only Products from a particular network. Use Networks - 3.0.0 endpoint for available networks.	No	null
merchant_ids	Number(s)	Return only Products from a particular merchant ID or merchant IDs separated by commas. If you do not specify a merchant_ids value, Products will be returned from all of your selected merchants.	No	null
category_ids	Number(s)	Return only Products from a particular category ID or category IDs separated by commas. Use the Categories - 3.0.0 endpoint for available categories. Only top level Categories are assigned to Products	No	null
brand_ids	Number(s)	Return only Products from a particular brand ID or brand IDs separated by commas. Use the Brand API endpoint for available brands.	No	null
subid	String	A custom Sub ID to add to the affiliate URLs for the Products returned.	No	null

Implementation

Response Elements

Name	Description
id	Our proprietary product ID
cross_merchant_id	A generated ID that holds a mix of FMTC IDs and Merchant IDs. This can be used to identify a product across multiple Merchants.
product_id	An ID given by the Merchant can be an SKU, MPN, etc.
merchant_id	The ID assigned to the merchant by FMTC.
merchant_object	A multi-dimensional object that holds the FMTC ID and name of the Merchant.
network_id	An FMTC assigned ID for the affiliate network associated with this merchant. Use https://fmtc.atlassian.net/wiki/spaces/FKB/pages/1519452184 endpoint for available networks.
brand_id	The FMTC ID of the closest matching Brand. Look up the Brand via our Brand API.
raw_brand_name	The string the Program assigned for the Brand.
brand_object	The results from looking up the Brand in the Brand API.
primary_category_id	The ID assigned to the top-level category by FMTC.
raw_categories	The string of categories that is provided by the merchant.
label	The basic description of the product being sold.
available	This will determine if the product is available in the merchant, and will be a 0 or 1.
price	Original price of the product.
sale_price	Discounted price of the product.
currency_code	The currency of the price of the product. Normalized to a ISO 4217 Currency Code.
raw_currency_string	The string provided by the merchant that generated the currency_code.
affiliate_url	The affiliate link containing your own affiliate ID that is used to go to the product’s landing page and set the appropriate network cookie. It requires that you have inserted your affiliate IDs on the Manage Affiliate IDs page.
freshreach_url	Link that lands on the page associated with the product and is monetized by FreshReach®. You must have a FreshReach® account to activate this field.
image_link	The link to the Product’s image.
shipping_details	The shipping information for the product. Can include: Country, Price,
gtin	The GTIN of the product provided by the merchant.
description	A short description of the product provided by the merchant.
additional_details	All other fields provided by the merchant.
created_at	When the product was first inserted into our system.
updated_at	When the product was last updated by the merchant.
processed_at	When we last confirm the product is still in the merchant's Data Feed.

Error Responses

Parameter Key	Error String	Possible Solutions
format	The requested format is invalid or not supported.	The format you requested is not supported by our system or is not recognized as a valid format. Make sure you pass in one of our valid formats (json, xml, csv, pipe, tab)
page_size	The page size field must be an integer.	The page_size passed in must be a numeric integer that consists only of numbers.
page_size	The page size field must not be greater than 2000.	The page_size cannot be larger than 2,000 Products per page.
latest	The latest field must be true or false.	The value passed for the latest parameter must be a Boolean value. We recommend using 0 or 1 to avoid errors.
latest_days	The latest days field must be an integer.	The latest_days passed in must be a numeric integer that consists only of numbers.
latest_days	The latest days field must not be greater than 30.	We limit the time latest_days looks back to 30 days. For older products, we recommend passing in a false with the latest field.
only_on_sale	The only on sale field must be true or false.	The value passed for the only_on_sale field must be a Boolean value. We recommend using 0 or 1 to avoid errors.
only_has_image_link	The latest field must be true or false.	The value passed for the only_has_image_link field must be a Boolean value. We recommend using 0 or 1 to avoid errors.
only_freshreach	The latest field must be true or false.	The value passed for the only_freshreach field must be a Boolean value. We recommend using 0 or 1 to avoid errors.
currency_code	The currency code field must be 3 characters.	We limit the currency_code field to 3 characters as that is as many as are needed for a standard ISO 4217 Currency Code.
network_id	The network id field must be an integer.	The network_id passed in must be a numeric integer that consists only of numbers.
merhcant_ids.X	All merchant ids must be integers.	The merchant_ids passed in must be a numeric integer that consists only of numbers. X indicates which ID is invalid.
category_ids.X	All category ids must be integers.	The category_ids passed in must be a numeric integer that consists only of numbers. X indicates which ID is invalid.
brand_ids.X	All brand ids must be integers.	The brand_ids passed in must be a numeric integer that consists only of numbers. X indicates which ID is invalid.

Example Response - JSON

Here is an example of a JSON Response from the Products endpoint.

CODE

{
  "data": [
    {
      "id": 3,
      "cross_merchant_id": "id-10103-5812-14",
      "product_id": "36705974375",
      "merchant_id": 5812,
      "merchant_object": {
        "id": 5812,
        "name": "Buyagift.co.uk"
      },
      "network_id": 14,
      "brand_id": null,
      "raw_brand_name": null,
      "brand_object": null,
      "primary_category_id": 2,
      "raw_categories": "short breaks",
      "label": "One Night Memorable Break for Two",
      "available": 1,
      "price": 99.99,
      "sale_price": 99.99,
      "currency_code": "GBP",
      "raw_currency_string": "GBP",
      "affiliate_url": "https://www.awin1.com/pclick.php?p=36705974375&a=ACTID&m=273",
      "freshreach_url": "https://freshreach.co/click.php?m=5812&cid=FMTC&uid=9107",
      "shipping_details":  {
        "price": "0.00"
      },
      "gtin": null,
      "description": "This great flexible hotel voucher gives you access to a range of quality, great value hotel breaks across the UK and Europe.",
      "additional_details": {
        "aw_product_id": "36705974375",
        "merchant_image_url": "https://images.buyagift.co.uk/common/client/Images/Product/HighRes/en-GB/10913507-ShendishManor.jpg",
        "merchant_name": "Buyagift.co.uk",
        "category_name": "Short Breaks",
        "category_id": "641",
        "aw_image_url": "https://images2.productserve.com/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31",
        "merchant_deep_link": "https://www.buyagift.co.uk/p/short-breaks/one-night-memorable-break-for-two-br-10913507.aspx",
        "display_price": "GBP99.99",
        "large_image": "https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10913507-ShendishManor.jpg",
        "aw_thumb_url": "https://images2.productserve.com/?w=70&h=70&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31",
        "cross_1": "AB15 6TW,AB43 8ZS,AB42 1TY,AB39 2BU,PA23 7QJ,PA23 7NE,PA23 7HU,PA23 8HJ,PA23 7LG,MK45 2NG,RG41 5TS,RG1 2HE,RG1 1DP,SL3 6AP,SL4 2QY,BS16 1RY,HP18 9RT,MK18 5JE,HP16 0DG,HP14 3XX,MK17 9PX,MK16 8DS,CB6 2BD,PE7 1BH,PE14 0DQ,SA32 8AY,SA33 4SE,SA15 2TH,SA34 0NL,SA44 6JD,JE2 7PD,SK8 3FS,CH2 3NL,CH1 2DD,CW2 6DN,SY14 7HU,CW8 2ES,WA8 3UJ,LL24 0SR,LL30 2YY,PL30 5LU,PL13 1PJ,PL22 0AG,TR19 6DN,PL25 5AG,V95 FE81,BT33 0QB,BT34 3AD,BT34 3EU,DL12 0SL,DL12 9SE,DL12 8PH,DH8 9NL,DL1 3NL,SR7 7HD,CA16 6UN,LA14 4QW,CA8 7HN,CA8 1LE,CA23 3DT,LA15 8HB,CA17 4LL,CA17 4JP,CA10 3QU,CA11 0AP,CA20 1NP,CA7 8LS,LL22 8RY,DE55 2EH,DE6 2HS,DE45 1JE,SK17 0AL,DE74 2DF,EX31 4PZ,EX39 6HB,EX17 3BU,EX17 5AD,TQ1 1HF,EX34 9EE,EX34 8DR,EX20 4PQ,EX35 6DQ,TQ13 7QY,EX20 4LR,TQ4 6AX,TQ4 6HA,PL7 5HP,EX10 0SD,EX16 8BP,EX16 4LA,TQ2 5BZ,TQ2 5JP,TQ2 6QT,TQ2 5UE,PL20 6DR,BH16 6JB,BH19 3DS,BH20 5LR,DT4 7HD,DT4 7NP,DG6 4NT,DG11 2DA,DG3 5LU,DD1 4DU,KA5 5PR,YO43 4AD,TN33 0EA,BN2 1PB,BN21 4BJ,TN34 1EN,CO16 0EF,CO12 3EA,SS1 3AA,CM24 8EY,KY15 7EY,CH6 5QG,CH7 6RQ,G2 1DS,G1 1TY,GL13 9BA,GL55 6AT,GL2 8DR,GL15 5RF,CR5 2LL,HA6 2PQ,E10 5EL,SW12 9HJ,BL0 9DS,M16 0PE,WN8 9QD,LL57 2SR,LL40 1RF,LL65 4UH,LL72 8HB,LL49 9NY,PO16 8SB,GU51 4NE,SO43 7NF,SO14 2HN,HR4 9BG,HR9 6JL,HP3 0AA,HP4 3HL,HP4 1AH,CM22 7SP,AL10 9RH,AL3 7AF,SG8 7BZ,CM21 0JU,SG1 1EJ,IV17 0XN,KW12 6YN,PA37 1PB,IV26 2SX,PO33 1AB,PO36 8BN,PO36 9BW,PO37 6BD,PO37 6RL,PO37 6RG,TN25 5NB,CT2 8JZ,CT20 2EA,CT20 2EL,TN29 0LN,FY1 2LD,FY1 6BP,FY4 1HJ,FY1 6BJ,FY1 2EY,FY1 2JA,FY1 4BY,FY1 4PR,FY4 1HE,BB12 9PA,BB12 7QW,BB10 2LF,BB12 8HG,BB7 2BX,BB3 2JU,LA2 7HF,LA2 9LA,FY8 5JP,FY8 1LS,FY6 0NW,PR3 1YE,PR3 2NB,PR1 2YF,FY8 1HN,NG33 4LL,DN41 8BU,L1 1JP,L17 4JE,CH43 7RY,CH66 8PF,PR9 9EX,PR8 1JR,NP7 7LW,NP16 5EX,NP25 3SZ,AB37 9ET,AB56 4SD,AB55 4AD,NR27 9QH,NR20 5QS,NR21 0DX,NR30 3JL,NR30 2DQ,NR30 2DG,PE36 5HW,PE30 4NB,NR14 6SF,TS4 2EZ,DL8 1PY,HG1 5JR,HG5 0AD,DL8 4NP,YO18 8SE,HG4 4NF,YO11 2AY,YO12 7PE,YO11 2QF,BD23 5QX,YO22 4QH,YO21 1XE,YO31 8JX,YO61 4AS,NN17 3AT,NN6 9JA,NN6 7TU,TD15 2TA,NE47 6NQ,NE47 0AH,NE47 6JQ,NE65 9TP,NE65 7TE,NG23 5SG,NG1 3BP,KW17 2DB,OX26 6NB,OX18 4TN,OX25 5QQ,OX12 0EJ,OX28 6BH,SA62 3LW,SA35 0AW,LD1 5UA,LD6 5LL,LD6 5NG,PA4 9EJ,CF44 9SX,LE15 9HU,TD12 4AS,TF11 8HG,SY2 5HG,SY4 5UA,SY4 5RG,TF8 7NH,TA7 0QR,TA6 6QA,TA20 3TA,TA20 2HW,BA11 5DP,TA9 3PU,TA24 6JS,BA16 0EF,TA3 6SG,BA9 9JF,KA26 9HE,KA10 6BQ,S66 9JA,S7 1NQ,S21 3WF,DE13 7BB,ST21 6JQ,ST15 0BQ,CO10 1BD,IP31 1AW,IP30 9AB,GU23 6BB,NE1 4SD,NE6 1LD,B49 6NR,CV21 1HU,CV23 9LF,CV37 9DP,CV34 4DP,G83 7AU,CV5 9BA,CV1 1GU,DY1 4RN,WV6 0BQ,WF17 7HR,BD1 5SH,BD22 8DU,OL14 5NJ,LS22 5HS,SN10 5TH,SN8 2DU,SP5 2AS,BA13 4PT,LL12 0DE",
        "cross_2": "Aberdeenshire,Argyll and Bute,Bedfordshire,Berkshire,Bristol,Buckinghamshire,Cambridgeshire,Carmarthenshire,Ceredigion,Channel Islands,Cheshire,Conwy,Cornwall,County Clare,County Down,County Durham,Cumbria,Denbighshire,Derbyshire,Devon,Dorset,Dumfriesshire,Dundee,East Ayrshire,East Riding of Yorkshire,East Sussex,Essex,Fife,Flintshire,France,Glasgow,Gloucestershire,Greater London,Greater Manchester,Gwynedd,Hampshire,Herefordshire,Hertfordshire,Highland,Isle of Wight,Italy,Kent,Lancashire,Lincolnshire,Merseyside,Monmouthshire,Moray,Norfolk,North Yorkshire,Northamptonshire,Northumberland,Nottinghamshire,Orkney Islands,Oxfordshire,Pembrokeshire,Powys,Renfrewshire,Rhondda Cynon Taf,Rutland,Scottish Borders,Shropshire,Somerset,South Ayrshire,South Yorkshire,Staffordshire,Suffolk,Surrey,Tyne and Wear,Warwickshire,West Dunbartonshire,West Midlands,West Yorkshire,Wiltshire,Wrexham",
        "cross_3": "1",
        "cross_5": "https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10976824_(6)_lionandkey.jpg",
        "cross_6": "https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10913507-PolraenCounty.jpg"
      },
      "created_at": "2025-01-02T15:05:13+00:00",
      "updated_at": "2025-01-02T15:05:13+00:00",
      "processed_at": "2025-01-23T19:33:25+00:00"
    },
    {
      "id": 317,
      "cross_merchant_id": "gtin-000887276124391",
      "product_id": "sku7760401",
      "merchant_id": 37023,
      "merchant_object": {
        "id": 37023,
        "name": "AT&T Mobility"
      }
      "network_id": 3,
      "brand_id": 154,
      "raw_brand_name": "Samsung",
      "brand_object": {
        "id": 154,
        "name": "Samsung",
        "parent_id": 0
      },
      "primary_category_id": 99,
      "raw_categories": "electronics,communications,telephony,mobile phones",
      "label": "Samsung Gear S2 - Silver",
      "available": 1,
      "price": 99.99,
      "sale_price": 0,
      "currency_code": "USD",
      "raw_currency_string": "USD",
      "affiliate_url": "https://www.tkqlhce.com/click-ACTID-13664766?url=http%3A%2F%2Ftracking.searchmarketing.com%2Fclick.asp%3Faid%3D330002190000016701",
      "freshreach_url": "https://freshreach.co/click?m=37023&cid=FMTC&uid=9107&cpid=289",
      "image_link": "https://www.att.com/catalog/en/skus/images/samsung-gear%20s2-silver-100x160.jpg",
      "shipping_details": null,
      "gtin": "000887276124391",
      "description": "With elegant curves and premium finishes, the Samsung Gear S2 will turn heads. The intuitive circular face and bezel let you navigate effortlessly to get to what you need. Get more out of the moments in your day with Samsung Gear S2 and AT&T network. cell phones and smart phones on the AT&T 4G network.",
      "additional_details": {
        "program_url": "https://www.att.com/wireless/",
        "catalog_name": "AT&T Mobility Product Feed",
        "last_updated": "2025-03-18T09:10:24.081-07:00",
        "impression_url": "https://www.awltovhc.com/image-AFFILIATEID-13664766",
        "mobile_link": "https://m.att.com/shopmobile/devices/samsung/gear-s2.html#sku=sku7760401",
        "expiration_date": "2025-04-16T01:00:00.000-07:00",
        "google_product_category": "267",
        "product_type": "Electronics > Communications > Telephony > Mobile Phones",
        "identifier_exists": "yes",
        "condition": "new",
        "color": "Silver",
        "custom_label_0": "Everything Else",
        "custom_label_1": "Samsung",
        "custom_label_2": "Samsung Gear S2",
        "custom_label_3": "Catch All",
        "custom_label_4": "Catch All_spanish",
        "product_highlight": "[]"
      },
      "created_at": "2025-03-18T10:15:00+00:00",
      "updated_at": "2025-03-18T10:15:00+00:00",
      "processed_at": "2025-03-20T00:00:00+00:00"
    }
  ],
  "links": {
    "prev": null,
    "next": "http://s3.fmtc.co/api/3/products?api_token=042bc55c836344e30c1e07cf890e67af&format=json&latest=0&cursor=eyJpZCI6MTcsIl9wb2ludHNUb05leHRJdGVtcyI6dHJ1ZX0"
  },
    "meta": {
    "path": "http://s3.fmtc.co/api/3/products",
    "per_page": 15,
    "total_on_page": 15,
    "version": "3.0.0"
  }
}

Example Response - XML

Here is an example of an XML Response from the Products endpoint.

CODE

<results>
  <data>
    <product>
      <id>3</id>
      <cross_merchant_id>id-10103-5812-14</cross_merchant_id>
      <product_id>36705974375</product_id>
      <merchant_id>5812</merchant_id>
      <merchant_object>
        <id>5812</id>
        <name>Buyagift.co.uk</name>
      </merchant_object>
      <network_id>14</network_id>
      <brand_id/>
      <raw_brand_name/>
      <brand_object/>
      <primary_category_id>2</primary_category_id>
      <raw_categories>short breaks</raw_categories>
      <label>One Night Memorable Break for Two</label>
      <available>1</available>
      <price>99.99</price>
      <sale_price>99.99</sale_price>
      <currency_code>GBP</currency_code>
      <raw_currency_string>GBP</raw_currency_string>
      <affiliate_url>https://www.awin1.com/pclick.php?p=36705974375&a=ACTID&m=273</affiliate_url>
      <freshreach_url>https://freshreach.co/click.php?m=5812&cid=FMTC&uid=9107</freshreach_url>
      <shipping_details>
        <price>0.00</price>
      </shipping_details>
      <gtin/>
      <description>This great flexible hotel voucher gives you access to a range of quality, great value hotel breaks across the UK and Europe.</description>
      <additional_details>
        <aw_product_id>36705974375</aw_product_id>
        <merchant_image_url>https://images.buyagift.co.uk/common/client/Images/Product/HighRes/en-GB/10913507-ShendishManor.jpg</merchant_image_url>
        <merchant_name>Buyagift.co.uk</merchant_name>
        <category_name>Short Breaks</category_name>
        <category_id>641</category_id>
        <aw_image_url>https://images2.productserve.com/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31</aw_image_url>
        <merchant_deep_link>https://www.buyagift.co.uk/p/short-breaks/one-night-memorable-break-for-two-br-10913507.aspx</merchant_deep_link>
        <display_price>GBP99.99</display_price>
        <large_image>https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10913507-ShendishManor.jpg</large_image>
        <aw_thumb_url>https://images2.productserve.com/?w=70&h=70&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31</aw_thumb_url>
        <cross_1>AB15 6TW,AB43 8ZS,AB42 1TY,AB39 2BU,PA23 7QJ,PA23 7NE,PA23 7HU,PA23 8HJ,PA23 7LG,MK45 2NG,RG41 5TS,RG1 2HE,RG1 1DP,SL3 6AP,SL4 2QY,BS16 1RY,HP18 9RT,MK18 5JE,HP16 0DG,HP14 3XX,MK17 9PX,MK16 8DS,CB6 2BD,PE7 1BH,PE14 0DQ,SA32 8AY,SA33 4SE,SA15 2TH,SA34 0NL,SA44 6JD,JE2 7PD,SK8 3FS,CH2 3NL,CH1 2DD,CW2 6DN,SY14 7HU,CW8 2ES,WA8 3UJ,LL24 0SR,LL30 2YY,PL30 5LU,PL13 1PJ,PL22 0AG,TR19 6DN,PL25 5AG,V95 FE81,BT33 0QB,BT34 3AD,BT34 3EU,DL12 0SL,DL12 9SE,DL12 8PH,DH8 9NL,DL1 3NL,SR7 7HD,CA16 6UN,LA14 4QW,CA8 7HN,CA8 1LE,CA23 3DT,LA15 8HB,CA17 4LL,CA17 4JP,CA10 3QU,CA11 0AP,CA20 1NP,CA7 8LS,LL22 8RY,DE55 2EH,DE6 2HS,DE45 1JE,SK17 0AL,DE74 2DF,EX31 4PZ,EX39 6HB,EX17 3BU,EX17 5AD,TQ1 1HF,EX34 9EE,EX34 8DR,EX20 4PQ,EX35 6DQ,TQ13 7QY,EX20 4LR,TQ4 6AX,TQ4 6HA,PL7 5HP,EX10 0SD,EX16 8BP,EX16 4LA,TQ2 5BZ,TQ2 5JP,TQ2 6QT,TQ2 5UE,PL20 6DR,BH16 6JB,BH19 3DS,BH20 5LR,DT4 7HD,DT4 7NP,DG6 4NT,DG11 2DA,DG3 5LU,DD1 4DU,KA5 5PR,YO43 4AD,TN33 0EA,BN2 1PB,BN21 4BJ,TN34 1EN,CO16 0EF,CO12 3EA,SS1 3AA,CM24 8EY,KY15 7EY,CH6 5QG,CH7 6RQ,G2 1DS,G1 1TY,GL13 9BA,GL55 6AT,GL2 8DR,GL15 5RF,CR5 2LL,HA6 2PQ,E10 5EL,SW12 9HJ,BL0 9DS,M16 0PE,WN8 9QD,LL57 2SR,LL40 1RF,LL65 4UH,LL72 8HB,LL49 9NY,PO16 8SB,GU51 4NE,SO43 7NF,SO14 2HN,HR4 9BG,HR9 6JL,HP3 0AA,HP4 3HL,HP4 1AH,CM22 7SP,AL10 9RH,AL3 7AF,SG8 7BZ,CM21 0JU,SG1 1EJ,IV17 0XN,KW12 6YN,PA37 1PB,IV26 2SX,PO33 1AB,PO36 8BN,PO36 9BW,PO37 6BD,PO37 6RL,PO37 6RG,TN25 5NB,CT2 8JZ,CT20 2EA,CT20 2EL,TN29 0LN,FY1 2LD,FY1 6BP,FY4 1HJ,FY1 6BJ,FY1 2EY,FY1 2JA,FY1 4BY,FY1 4PR,FY4 1HE,BB12 9PA,BB12 7QW,BB10 2LF,BB12 8HG,BB7 2BX,BB3 2JU,LA2 7HF,LA2 9LA,FY8 5JP,FY8 1LS,FY6 0NW,PR3 1YE,PR3 2NB,PR1 2YF,FY8 1HN,NG33 4LL,DN41 8BU,L1 1JP,L17 4JE,CH43 7RY,CH66 8PF,PR9 9EX,PR8 1JR,NP7 7LW,NP16 5EX,NP25 3SZ,AB37 9ET,AB56 4SD,AB55 4AD,NR27 9QH,NR20 5QS,NR21 0DX,NR30 3JL,NR30 2DQ,NR30 2DG,PE36 5HW,PE30 4NB,NR14 6SF,TS4 2EZ,DL8 1PY,HG1 5JR,HG5 0AD,DL8 4NP,YO18 8SE,HG4 4NF,YO11 2AY,YO12 7PE,YO11 2QF,BD23 5QX,YO22 4QH,YO21 1XE,YO31 8JX,YO61 4AS,NN17 3AT,NN6 9JA,NN6 7TU,TD15 2TA,NE47 6NQ,NE47 0AH,NE47 6JQ,NE65 9TP,NE65 7TE,NG23 5SG,NG1 3BP,KW17 2DB,OX26 6NB,OX18 4TN,OX25 5QQ,OX12 0EJ,OX28 6BH,SA62 3LW,SA35 0AW,LD1 5UA,LD6 5LL,LD6 5NG,PA4 9EJ,CF44 9SX,LE15 9HU,TD12 4AS,TF11 8HG,SY2 5HG,SY4 5UA,SY4 5RG,TF8 7NH,TA7 0QR,TA6 6QA,TA20 3TA,TA20 2HW,BA11 5DP,TA9 3PU,TA24 6JS,BA16 0EF,TA3 6SG,BA9 9JF,KA26 9HE,KA10 6BQ,S66 9JA,S7 1NQ,S21 3WF,DE13 7BB,ST21 6JQ,ST15 0BQ,CO10 1BD,IP31 1AW,IP30 9AB,GU23 6BB,NE1 4SD,NE6 1LD,B49 6NR,CV21 1HU,CV23 9LF,CV37 9DP,CV34 4DP,G83 7AU,CV5 9BA,CV1 1GU,DY1 4RN,WV6 0BQ,WF17 7HR,BD1 5SH,BD22 8DU,OL14 5NJ,LS22 5HS,SN10 5TH,SN8 2DU,SP5 2AS,BA13 4PT,LL12 0DE</cross_1>
        <cross_2>Aberdeenshire,Argyll and Bute,Bedfordshire,Berkshire,Bristol,Buckinghamshire,Cambridgeshire,Carmarthenshire,Ceredigion,Channel Islands,Cheshire,Conwy,Cornwall,County Clare,County Down,County Durham,Cumbria,Denbighshire,Derbyshire,Devon,Dorset,Dumfriesshire,Dundee,East Ayrshire,East Riding of Yorkshire,East Sussex,Essex,Fife,Flintshire,France,Glasgow,Gloucestershire,Greater London,Greater Manchester,Gwynedd,Hampshire,Herefordshire,Hertfordshire,Highland,Isle of Wight,Italy,Kent,Lancashire,Lincolnshire,Merseyside,Monmouthshire,Moray,Norfolk,North Yorkshire,Northamptonshire,Northumberland,Nottinghamshire,Orkney Islands,Oxfordshire,Pembrokeshire,Powys,Renfrewshire,Rhondda Cynon Taf,Rutland,Scottish Borders,Shropshire,Somerset,South Ayrshire,South Yorkshire,Staffordshire,Suffolk,Surrey,Tyne and Wear,Warwickshire,West Dunbartonshire,West Midlands,West Yorkshire,Wiltshire,Wrexham</cross_2>
        <cross_3>1</cross_3>
        <cross_5>https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10976824_(6)_lionandkey.jpg</cross_5>
        <cross_6>https://images.buyagift.co.uk/common/client/Images/Product/Large/en-GB/10913507-PolraenCounty.jpg</cross_6>
      </additional_details>
      <created_at>2025-01-02T15:05:13+00:00</created_at>
      <updated_at>2025-01-02T15:05:13+00:00</updated_at>
      <processed_at>2025-01-23T19:33:25+00:00</processed_at>
    </product>
    <product>
      <id>317</id>
      <cross_merchant_id>gtin-000887276124391</cross_merchant_id>
      <product_id>sku7760401</product_id>
      <merchant_id>37023</merchant_id>
      <merchant_object>
        <id>37023</id>
        <name>AT&T Mobility</name>
      </merchant_object>
      <network_id>3</network_id>
      <brand_id>154</brand_id>
      <raw_brand_name>Samsung</raw_brand_name>
      <brand_object>
        <id>154</id>
        <name>Samsung</name>
        <parent_id/>
      </brand_object>
      <primary_category_id>99</primary_category_id>
      <raw_categories>electronics,communications,telephony,mobile phones</raw_categories>
      <label>Samsung Gear S2 - Silver</label>
      <available>1</available>
      <price>99.99</price>
      <sale_price/>
      <currency_code>USD</currency_code>
      <raw_currency_string>USD</raw_currency_string>
      <affiliate_url>https://www.tkqlhce.com/click-ACTID-13664766?url=http%3A%2F%2Ftracking.searchmarketing.com%2Fclick.asp%3Faid%3D330002190000016701</affiliate_url>
      <freshreach_url>https://freshreach.co/click?m=37023&cid=FMTC&uid=9107&cpid=289</freshreach_url>
      <image_link>https://www.att.com/catalog/en/skus/images/samsung-gear%20s2-silver-100x160.jpg</image_link>
      <shipping_details/>
      <gtin>000887276124391</gtin>
      <description>With elegant curves and premium finishes, the Samsung Gear S2 will turn heads. The intuitive circular face and bezel let you navigate effortlessly to get to what you need. Get more out of the moments in your day with Samsung Gear S2 and AT&T network. cell phones and smart phones on the AT&T 4G network.</description>
      <additional_details>
        <program_url>https://www.att.com/wireless/</program_url>
        <catalog_name>AT&T Mobility Product Feed</catalog_name>
        <last_updated>2025-03-18T09:10:24.081-07:00</last_updated>
        <impression_url>https://www.awltovhc.com/image-AFFILIATEID-13664766</impression_url>
        <mobile_link>https://m.att.com/shopmobile/devices/samsung/gear-s2.html#sku=sku7760401</mobile_link>
        <expiration_date>2025-04-16T01:00:00.000-07:00</expiration_date>
        <google_product_category>267</google_product_category>
        <product_type>Electronics > Communications > Telephony > Mobile Phones</product_type>
        <identifier_exists>yes</identifier_exists>
        <condition>new</condition>
        <color>Silver</color>
        <custom_label_0>Everything Else</custom_label_0>
        <custom_label_1>Samsung</custom_label_1>
        <custom_label_2>Samsung Gear S2</custom_label_2>
        <custom_label_3>Catch All</custom_label_3>
        <custom_label_4>Catch All_spanish</custom_label_4>
        <product_highlight>[]</product_highlight>
      </additional_details>
      <created_at>2025-03-18T10:15:00+00:00</created_at>
      <updated_at>2025-03-18T10:15:00+00:00</updated_at>
      <processed_at>2025-03-20T00:00:00+00:00</processed_at>
    </product>
  </data>
  <links>
    <prev/>
    <next>http://s3.fmtc.co/api/3/products?api_token=042bc55c836344e30c1e07cf890e67af&format=xml&latest=0&cursor=eyJpZCI6MTcsIl9wb2ludHNUb05leHRJdGVtcyI6dHJ1ZX0</next>
  </links>
  <meta>
    <path>http://s3.fmtc.co/api/3/products</path>
    <per_page>15</per_page>
    <total_on_page>15</total_on_page>
    <version>3.0.0</version>
  </meta>
</results>

Example Response - CSV

Here is an example of a CSV Response from the Products endpoint.

CODE

id,cross_merchant_id,product_id,merchant_id,merchant_object,network_id,brand_id,raw_brand_name,brand_object,primary_category_id,raw_categories,label,available,price,sale_price,currency_code,raw_currency_string,affiliate_url,freshreach_url,image_link,shipping_details,gtin,description,additional_details,created_at,updated_at,processed_at
3,id-10103-5812-14,36705974375,5812,"{""id"":5812,""name"":""Buyagift.co.uk""}",14,,,,2,"short breaks","One Night Memorable Break for Two",1,99.99,99.99,GBP,GBP,https://www.awin1.com/pclick.php?p=36705974375&a=ACTID&m=273,https://freshreach.co/click.php?m=5812&cid=FMTC&uid=9107,"{""price"":""0.00""}",,"This great flexible hotel voucher gives you access to a range of quality, great value hotel breaks across the UK and Europe.","{""aw_product_id"":""36705974375"",""merchant_image_url"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/HighRes\/en-GB\/10913507-ShendishManor.jpg"",""merchant_name"":""Buyagift.co.uk"",""category_name"":""Short Breaks"",""category_id"":""641"",""aw_image_url"":""https:\/\/images2.productserve.com\/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""merchant_deep_link"":""https:\/\/www.buyagift.co.uk\/p\/short-breaks\/one-night-memorable-break-for-two-br-10913507.aspx"",""display_price"":""GBP99.99"",""large_image"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-ShendishManor.jpg"",""aw_thumb_url"":""https:\/\/images2.productserve.com\/?w=70&h=70&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""cross_1"":""AB15 6TW,AB43 8ZS,AB42 1TY,AB39 2BU,PA23 7QJ,PA23 7NE,PA23 7HU,PA23 8HJ,PA23 7LG,MK45 2NG,RG41 5TS,RG1 2HE,RG1 1DP,SL3 6AP,SL4 2QY,BS16 1RY,HP18 9RT,MK18 5JE,HP16 0DG,HP14 3XX,MK17 9PX,MK16 8DS,CB6 2BD,PE7 1BH,PE14 0DQ,SA32 8AY,SA33 4SE,SA15 2TH,SA34 0NL,SA44 6JD,JE2 7PD,SK8 3FS,CH2 3NL,CH1 2DD,CW2 6DN,SY14 7HU,CW8 2ES,WA8 3UJ,LL24 0SR,LL30 2YY,PL30 5LU,PL13 1PJ,PL22 0AG,TR19 6DN,PL25 5AG,V95 FE81,BT33 0QB,BT34 3AD,BT34 3EU,DL12 0SL,DL12 9SE,DL12 8PH,DH8 9NL,DL1 3NL,SR7 7HD,CA16 6UN,LA14 4QW,CA8 7HN,CA8 1LE,CA23 3DT,LA15 8HB,CA17 4LL,CA17 4JP,CA10 3QU,CA11 0AP,CA20 1NP,CA7 8LS,LL22 8RY,DE55 2EH,DE6 2HS,DE45 1JE,SK17 0AL,DE74 2DF,EX31 4PZ,EX39 6HB,EX17 3BU,EX17 5AD,TQ1 1HF,EX34 9EE,EX34 8DR,EX20 4PQ,EX35 6DQ,TQ13 7QY,EX20 4LR,TQ4 6AX,TQ4 6HA,PL7 5HP,EX10 0SD,EX16 8BP,EX16 4LA,TQ2 5BZ,TQ2 5JP,TQ2 6QT,TQ2 5UE,PL20 6DR,BH16 6JB,BH19 3DS,BH20 5LR,DT4 7HD,DT4 7NP,DG6 4NT,DG11 2DA,DG3 5LU,DD1 4DU,KA5 5PR,YO43 4AD,TN33 0EA,BN2 1PB,BN21 4BJ,TN34 1EN,CO16 0EF,CO12 3EA,SS1 3AA,CM24 8EY,KY15 7EY,CH6 5QG,CH7 6RQ,G2 1DS,G1 1TY,GL13 9BA,GL55 6AT,GL2 8DR,GL15 5RF,CR5 2LL,HA6 2PQ,E10 5EL,SW12 9HJ,BL0 9DS,M16 0PE,WN8 9QD,LL57 2SR,LL40 1RF,LL65 4UH,LL72 8HB,LL49 9NY,PO16 8SB,GU51 4NE,SO43 7NF,SO14 2HN,HR4 9BG,HR9 6JL,HP3 0AA,HP4 3HL,HP4 1AH,CM22 7SP,AL10 9RH,AL3 7AF,SG8 7BZ,CM21 0JU,SG1 1EJ,IV17 0XN,KW12 6YN,PA37 1PB,IV26 2SX,PO33 1AB,PO36 8BN,PO36 9BW,PO37 6BD,PO37 6RL,PO37 6RG,TN25 5NB,CT2 8JZ,CT20 2EA,CT20 2EL,TN29 0LN,FY1 2LD,FY1 6BP,FY4 1HJ,FY1 6BJ,FY1 2EY,FY1 2JA,FY1 4BY,FY1 4PR,FY4 1HE,BB12 9PA,BB12 7QW,BB10 2LF,BB12 8HG,BB7 2BX,BB3 2JU,LA2 7HF,LA2 9LA,FY8 5JP,FY8 1LS,FY6 0NW,PR3 1YE,PR3 2NB,PR1 2YF,FY8 1HN,NG33 4LL,DN41 8BU,L1 1JP,L17 4JE,CH43 7RY,CH66 8PF,PR9 9EX,PR8 1JR,NP7 7LW,NP16 5EX,NP25 3SZ,AB37 9ET,AB56 4SD,AB55 4AD,NR27 9QH,NR20 5QS,NR21 0DX,NR30 3JL,NR30 2DQ,NR30 2DG,PE36 5HW,PE30 4NB,NR14 6SF,TS4 2EZ,DL8 1PY,HG1 5JR,HG5 0AD,DL8 4NP,YO18 8SE,HG4 4NF,YO11 2AY,YO12 7PE,YO11 2QF,BD23 5QX,YO22 4QH,YO21 1XE,YO31 8JX,YO61 4AS,NN17 3AT,NN6 9JA,NN6 7TU,TD15 2TA,NE47 6NQ,NE47 0AH,NE47 6JQ,NE65 9TP,NE65 7TE,NG23 5SG,NG1 3BP,KW17 2DB,OX26 6NB,OX18 4TN,OX25 5QQ,OX12 0EJ,OX28 6BH,SA62 3LW,SA35 0AW,LD1 5UA,LD6 5LL,LD6 5NG,PA4 9EJ,CF44 9SX,LE15 9HU,TD12 4AS,TF11 8HG,SY2 5HG,SY4 5UA,SY4 5RG,TF8 7NH,TA7 0QR,TA6 6QA,TA20 3TA,TA20 2HW,BA11 5DP,TA9 3PU,TA24 6JS,BA16 0EF,TA3 6SG,BA9 9JF,KA26 9HE,KA10 6BQ,S66 9JA,S7 1NQ,S21 3WF,DE13 7BB,ST21 6JQ,ST15 0BQ,CO10 1BD,IP31 1AW,IP30 9AB,GU23 6BB,NE1 4SD,NE6 1LD,B49 6NR,CV21 1HU,CV23 9LF,CV37 9DP,CV34 4DP,G83 7AU,CV5 9BA,CV1 1GU,DY1 4RN,WV6 0BQ,WF17 7HR,BD1 5SH,BD22 8DU,OL14 5NJ,LS22 5HS,SN10 5TH,SN8 2DU,SP5 2AS,BA13 4PT,LL12 0DE"",""cross_2"":""Aberdeenshire,Argyll and Bute,Bedfordshire,Berkshire,Bristol,Buckinghamshire,Cambridgeshire,Carmarthenshire,Ceredigion,Channel Islands,Cheshire,Conwy,Cornwall,County Clare,County Down,County Durham,Cumbria,Denbighshire,Derbyshire,Devon,Dorset,Dumfriesshire,Dundee,East Ayrshire,East Riding of Yorkshire,East Sussex,Essex,Fife,Flintshire,France,Glasgow,Gloucestershire,Greater London,Greater Manchester,Gwynedd,Hampshire,Herefordshire,Hertfordshire,Highland,Isle of Wight,Italy,Kent,Lancashire,Lincolnshire,Merseyside,Monmouthshire,Moray,Norfolk,North Yorkshire,Northamptonshire,Northumberland,Nottinghamshire,Orkney Islands,Oxfordshire,Pembrokeshire,Powys,Renfrewshire,Rhondda Cynon Taf,Rutland,Scottish Borders,Shropshire,Somerset,South Ayrshire,South Yorkshire,Staffordshire,Suffolk,Surrey,Tyne and Wear,Warwickshire,West Dunbartonshire,West Midlands,West Yorkshire,Wiltshire,Wrexham"",""cross_3"":""1"",""cross_5"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10976824_(6)_lionandkey.jpg"",""cross_6"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-PolraenCounty.jpg""}",2025-01-02T15:05:13+00:00,2025-01-02T15:05:13+00:00,2025-01-23T19:33:25+00:00
317,gtin-000887276124391,sku7760401,37023,"{""id"":37023,""name"":""AT&T Mobility""}",3,154,Samsung,"{""id"":154,""name"":""Samsung"",""parent_id"":0}",99,"electronics,communications,telephony,mobile phones","Samsung Gear S2 - Silver",1,99.99,0,USD,USD,https://www.tkqlhce.com/click-ACTID-13664766?url=http%3A%2F%2Ftracking.searchmarketing.com%2Fclick.asp%3Faid%3D330002190000016701,https://freshreach.co/click?m=37023&cid=FMTC&uid=9107&cpid=289,https://www.att.com/catalog/en/skus/images/samsung-gear%20s2-silver-100x160.jpg,,000887276124391,"With elegant curves and premium finishes, the Samsung Gear S2 will turn heads. The intuitive circular face and bezel let you navigate effortlessly to get to what you need. Get more out of the moments in your day with Samsung Gear S2 and AT&T network. cell phones and smart phones on the AT&T 4G network.","{""program_url"":""https:\/\/www.att.com\/wireless\/"",""catalog_name"":""AT&T Mobility Product Feed"",""last_updated"":""2025-03-18T09:10:24.081-07:00"",""impression_url"":""https:\/\/www.awltovhc.com\/image-AFFILIATEID-13664766"",""mobile_link"":""https:\/\/m.att.com\/shopmobile\/devices\/samsung\/gear-s2.html#sku=sku7760401"",""expiration_date"":""2025-04-16T01:00:00.000-07:00"",""google_product_category"":""267"",""product_type"":""Electronics > Communications > Telephony > Mobile Phones"",""identifier_exists"":""yes"",""condition"":""new"",""color"":""Silver"",""custom_label_0"":""Everything Else"",""custom_label_1"":""Samsung"",""custom_label_2"":""Samsung Gear S2"",""custom_label_3"":""Catch All"",""custom_label_4"":""Catch All_spanish"",""product_highlight"":""[]""}",2025-03-18T10:15:00+00:00,2025-03-18T10:15:00+00:00,2025-03-20T00:00:00+00:00

Example Response - TAB

Here is an example of a TAB Response from the Products endpoint.

CODE

id	cross_merchant_id	product_id	merchant_id	merchant_object	network_id	brand_id	raw_brand_name	brand_object	primary_category_id	raw_categories	label	available	price	sale_price	currency_code	raw_currency_string	affiliate_url	freshreach_url	image_link	shipping_details	gtin	description	additional_details	created_at	updated_at	processed_at
3	id-10103-5812-14	36705974375	5812	"{""id"":5812,""name"":""Buyagift.co.uk""}"	14				2	"short breaks"	"One Night Memorable Break for Two"	1	99.99	99.99	GBP	GBP	https://www.awin1.com/pclick.php?p=36705974375&a=ACTID&m=273	https://freshreach.co/click.php?m=5812&cid=FMTC&uid=9107	"{""price"":""0.00""}"		"This great flexible hotel voucher gives you access to a range of quality, great value hotel breaks across the UK and Europe."	"{""aw_product_id"":""36705974375"",""merchant_image_url"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/HighRes\/en-GB\/10913507-ShendishManor.jpg"",""merchant_name"":""Buyagift.co.uk"",""category_name"":""Short Breaks"",""category_id"":""641"",""aw_image_url"":""https:\/\/images2.productserve.com\/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""merchant_deep_link"":""https:\/\/www.buyagift.co.uk\/p\/short-breaks\/one-night-memorable-break-for-two-br-10913507.aspx"",""display_price"":""GBP99.99"",""large_image"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-ShendishManor.jpg"",""aw_thumb_url"":""https:\/\/images2.productserve.com\/?w=70&h=70&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""cross_1"":""AB15 6TW,AB43 8ZS,AB42 1TY,AB39 2BU,PA23 7QJ,PA23 7NE,PA23 7HU,PA23 8HJ,PA23 7LG,MK45 2NG,RG41 5TS,RG1 2HE,RG1 1DP,SL3 6AP,SL4 2QY,BS16 1RY,HP18 9RT,MK18 5JE,HP16 0DG,HP14 3XX,MK17 9PX,MK16 8DS,CB6 2BD,PE7 1BH,PE14 0DQ,SA32 8AY,SA33 4SE,SA15 2TH,SA34 0NL,SA44 6JD,JE2 7PD,SK8 3FS,CH2 3NL,CH1 2DD,CW2 6DN,SY14 7HU,CW8 2ES,WA8 3UJ,LL24 0SR,LL30 2YY,PL30 5LU,PL13 1PJ,PL22 0AG,TR19 6DN,PL25 5AG,V95 FE81,BT33 0QB,BT34 3AD,BT34 3EU,DL12 0SL,DL12 9SE,DL12 8PH,DH8 9NL,DL1 3NL,SR7 7HD,CA16 6UN,LA14 4QW,CA8 7HN,CA8 1LE,CA23 3DT,LA15 8HB,CA17 4LL,CA17 4JP,CA10 3QU,CA11 0AP,CA20 1NP,CA7 8LS,LL22 8RY,DE55 2EH,DE6 2HS,DE45 1JE,SK17 0AL,DE74 2DF,EX31 4PZ,EX39 6HB,EX17 3BU,EX17 5AD,TQ1 1HF,EX34 9EE,EX34 8DR,EX20 4PQ,EX35 6DQ,TQ13 7QY,EX20 4LR,TQ4 6AX,TQ4 6HA,PL7 5HP,EX10 0SD,EX16 8BP,EX16 4LA,TQ2 5BZ,TQ2 5JP,TQ2 6QT,TQ2 5UE,PL20 6DR,BH16 6JB,BH19 3DS,BH20 5LR,DT4 7HD,DT4 7NP,DG6 4NT,DG11 2DA,DG3 5LU,DD1 4DU,KA5 5PR,YO43 4AD,TN33 0EA,BN2 1PB,BN21 4BJ,TN34 1EN,CO16 0EF,CO12 3EA,SS1 3AA,CM24 8EY,KY15 7EY,CH6 5QG,CH7 6RQ,G2 1DS,G1 1TY,GL13 9BA,GL55 6AT,GL2 8DR,GL15 5RF,CR5 2LL,HA6 2PQ,E10 5EL,SW12 9HJ,BL0 9DS,M16 0PE,WN8 9QD,LL57 2SR,LL40 1RF,LL65 4UH,LL72 8HB,LL49 9NY,PO16 8SB,GU51 4NE,SO43 7NF,SO14 2HN,HR4 9BG,HR9 6JL,HP3 0AA,HP4 3HL,HP4 1AH,CM22 7SP,AL10 9RH,AL3 7AF,SG8 7BZ,CM21 0JU,SG1 1EJ,IV17 0XN,KW12 6YN,PA37 1PB,IV26 2SX,PO33 1AB,PO36 8BN,PO36 9BW,PO37 6BD,PO37 6RL,PO37 6RG,TN25 5NB,CT2 8JZ,CT20 2EA,CT20 2EL,TN29 0LN,FY1 2LD,FY1 6BP,FY4 1HJ,FY1 6BJ,FY1 2EY,FY1 2JA,FY1 4BY,FY1 4PR,FY4 1HE,BB12 9PA,BB12 7QW,BB10 2LF,BB12 8HG,BB7 2BX,BB3 2JU,LA2 7HF,LA2 9LA,FY8 5JP,FY8 1LS,FY6 0NW,PR3 1YE,PR3 2NB,PR1 2YF,FY8 1HN,NG33 4LL,DN41 8BU,L1 1JP,L17 4JE,CH43 7RY,CH66 8PF,PR9 9EX,PR8 1JR,NP7 7LW,NP16 5EX,NP25 3SZ,AB37 9ET,AB56 4SD,AB55 4AD,NR27 9QH,NR20 5QS,NR21 0DX,NR30 3JL,NR30 2DQ,NR30 2DG,PE36 5HW,PE30 4NB,NR14 6SF,TS4 2EZ,DL8 1PY,HG1 5JR,HG5 0AD,DL8 4NP,YO18 8SE,HG4 4NF,YO11 2AY,YO12 7PE,YO11 2QF,BD23 5QX,YO22 4QH,YO21 1XE,YO31 8JX,YO61 4AS,NN17 3AT,NN6 9JA,NN6 7TU,TD15 2TA,NE47 6NQ,NE47 0AH,NE47 6JQ,NE65 9TP,NE65 7TE,NG23 5SG,NG1 3BP,KW17 2DB,OX26 6NB,OX18 4TN,OX25 5QQ,OX12 0EJ,OX28 6BH,SA62 3LW,SA35 0AW,LD1 5UA,LD6 5LL,LD6 5NG,PA4 9EJ,CF44 9SX,LE15 9HU,TD12 4AS,TF11 8HG,SY2 5HG,SY4 5UA,SY4 5RG,TF8 7NH,TA7 0QR,TA6 6QA,TA20 3TA,TA20 2HW,BA11 5DP,TA9 3PU,TA24 6JS,BA16 0EF,TA3 6SG,BA9 9JF,KA26 9HE,KA10 6BQ,S66 9JA,S7 1NQ,S21 3WF,DE13 7BB,ST21 6JQ,ST15 0BQ,CO10 1BD,IP31 1AW,IP30 9AB,GU23 6BB,NE1 4SD,NE6 1LD,B49 6NR,CV21 1HU,CV23 9LF,CV37 9DP,CV34 4DP,G83 7AU,CV5 9BA,CV1 1GU,DY1 4RN,WV6 0BQ,WF17 7HR,BD1 5SH,BD22 8DU,OL14 5NJ,LS22 5HS,SN10 5TH,SN8 2DU,SP5 2AS,BA13 4PT,LL12 0DE"",""cross_2"":""Aberdeenshire,Argyll and Bute,Bedfordshire,Berkshire,Bristol,Buckinghamshire,Cambridgeshire,Carmarthenshire,Ceredigion,Channel Islands,Cheshire,Conwy,Cornwall,County Clare,County Down,County Durham,Cumbria,Denbighshire,Derbyshire,Devon,Dorset,Dumfriesshire,Dundee,East Ayrshire,East Riding of Yorkshire,East Sussex,Essex,Fife,Flintshire,France,Glasgow,Gloucestershire,Greater London,Greater Manchester,Gwynedd,Hampshire,Herefordshire,Hertfordshire,Highland,Isle of Wight,Italy,Kent,Lancashire,Lincolnshire,Merseyside,Monmouthshire,Moray,Norfolk,North Yorkshire,Northamptonshire,Northumberland,Nottinghamshire,Orkney Islands,Oxfordshire,Pembrokeshire,Powys,Renfrewshire,Rhondda Cynon Taf,Rutland,Scottish Borders,Shropshire,Somerset,South Ayrshire,South Yorkshire,Staffordshire,Suffolk,Surrey,Tyne and Wear,Warwickshire,West Dunbartonshire,West Midlands,West Yorkshire,Wiltshire,Wrexham"",""cross_3"":""1"",""cross_5"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10976824_(6)_lionandkey.jpg"",""cross_6"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-PolraenCounty.jpg""}"	2025-01-02T15:05:13+00:00	2025-01-02T15:05:13+00:00	2025-01-23T19:33:25+00:00
317	gtin-000887276124391	sku7760401	37023	"{""id"":37023,""name"":""AT&T Mobility""}"	3	154	Samsung	"{""id"":154,""name"":""Samsung"",""parent_id"":0}"	99	"electronics,communications,telephony,mobile phones"	"Samsung Gear S2 - Silver"	1	99.99	0	USD	USD	https://www.tkqlhce.com/click-ACTID-13664766?url=http%3A%2F%2Ftracking.searchmarketing.com%2Fclick.asp%3Faid%3D330002190000016701	https://freshreach.co/click?m=37023&cid=FMTC&uid=9107&cpid=289	https://www.att.com/catalog/en/skus/images/samsung-gear%20s2-silver-100x160.jpg		000887276124391	"With elegant curves and premium finishes, the Samsung Gear S2 will turn heads. The intuitive circular face and bezel let you navigate effortlessly to get to what you need. Get more out of the moments in your day with Samsung Gear S2 and AT&T network. cell phones and smart phones on the AT&T 4G network."	"{""program_url"":""https:\/\/www.att.com\/wireless\/"",""catalog_name"":""AT&T Mobility Product Feed"",""last_updated"":""2025-03-18T09:10:24.081-07:00"",""impression_url"":""https:\/\/www.awltovhc.com\/image-AFFILIATEID-13664766"",""mobile_link"":""https:\/\/m.att.com\/shopmobile\/devices\/samsung\/gear-s2.html#sku=sku7760401"",""expiration_date"":""2025-04-16T01:00:00.000-07:00"",""google_product_category"":""267"",""product_type"":""Electronics > Communications > Telephony > Mobile Phones"",""identifier_exists"":""yes"",""condition"":""new"",""color"":""Silver"",""custom_label_0"":""Everything Else"",""custom_label_1"":""Samsung"",""custom_label_2"":""Samsung Gear S2"",""custom_label_3"":""Catch All"",""custom_label_4"":""Catch All_spanish"",""product_highlight"":""[]""}"	2025-03-18T10:15:00+00:00	2025-03-18T10:15:00+00:00	2025-03-20T00:00:00+00:00

Example Response - PIPE

Here is an example of a PIPE Response from the Products endpoint.

CODE

id|cross_merchant_id|product_id|merchant_id|merchant_object|network_id|brand_id|raw_brand_name|brand_object|primary_category_id|raw_categories|label|available|price|sale_price|currency_code|raw_currency_string|affiliate_url|freshreach_url|image_link|shipping_details|gtin|description|additional_details|created_at|updated_at|processed_at
3|id-10103-5812-14|36705974375|5812|"{""id"":5812,""name"":""Buyagift.co.uk""}"|14||||2|"short breaks"|"One Night Memorable Break for Two"|1|99.99|99.99|GBP|GBP|https://www.awin1.com/pclick.php?p=36705974375&a=ACTID&m=273|https://freshreach.co/click.php?m=5812&cid=FMTC&uid=9107|"{""price"":""0.00""}"||"This great flexible hotel voucher gives you access to a range of quality, great value hotel breaks across the UK and Europe."|"{""aw_product_id"":""36705974375"",""merchant_image_url"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/HighRes\/en-GB\/10913507-ShendishManor.jpg"",""merchant_name"":""Buyagift.co.uk"",""category_name"":""Short Breaks"",""category_id"":""641"",""aw_image_url"":""https:\/\/images2.productserve.com\/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""merchant_deep_link"":""https:\/\/www.buyagift.co.uk\/p\/short-breaks\/one-night-memorable-break-for-two-br-10913507.aspx"",""display_price"":""GBP99.99"",""large_image"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-ShendishManor.jpg"",""aw_thumb_url"":""https:\/\/images2.productserve.com\/?w=70&h=70&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.buyagift.co.uk%2Fcommon%2Fclient%2FImages%2FProduct%2FHighRes%2Fen-GB%2F10913507-ShendishManor.jpg&feedId=273&k=1af809409be70ed20785bc4d0f5a5e5e4b71cb31"",""cross_1"":""AB15 6TW,AB43 8ZS,AB42 1TY,AB39 2BU,PA23 7QJ,PA23 7NE,PA23 7HU,PA23 8HJ,PA23 7LG,MK45 2NG,RG41 5TS,RG1 2HE,RG1 1DP,SL3 6AP,SL4 2QY,BS16 1RY,HP18 9RT,MK18 5JE,HP16 0DG,HP14 3XX,MK17 9PX,MK16 8DS,CB6 2BD,PE7 1BH,PE14 0DQ,SA32 8AY,SA33 4SE,SA15 2TH,SA34 0NL,SA44 6JD,JE2 7PD,SK8 3FS,CH2 3NL,CH1 2DD,CW2 6DN,SY14 7HU,CW8 2ES,WA8 3UJ,LL24 0SR,LL30 2YY,PL30 5LU,PL13 1PJ,PL22 0AG,TR19 6DN,PL25 5AG,V95 FE81,BT33 0QB,BT34 3AD,BT34 3EU,DL12 0SL,DL12 9SE,DL12 8PH,DH8 9NL,DL1 3NL,SR7 7HD,CA16 6UN,LA14 4QW,CA8 7HN,CA8 1LE,CA23 3DT,LA15 8HB,CA17 4LL,CA17 4JP,CA10 3QU,CA11 0AP,CA20 1NP,CA7 8LS,LL22 8RY,DE55 2EH,DE6 2HS,DE45 1JE,SK17 0AL,DE74 2DF,EX31 4PZ,EX39 6HB,EX17 3BU,EX17 5AD,TQ1 1HF,EX34 9EE,EX34 8DR,EX20 4PQ,EX35 6DQ,TQ13 7QY,EX20 4LR,TQ4 6AX,TQ4 6HA,PL7 5HP,EX10 0SD,EX16 8BP,EX16 4LA,TQ2 5BZ,TQ2 5JP,TQ2 6QT,TQ2 5UE,PL20 6DR,BH16 6JB,BH19 3DS,BH20 5LR,DT4 7HD,DT4 7NP,DG6 4NT,DG11 2DA,DG3 5LU,DD1 4DU,KA5 5PR,YO43 4AD,TN33 0EA,BN2 1PB,BN21 4BJ,TN34 1EN,CO16 0EF,CO12 3EA,SS1 3AA,CM24 8EY,KY15 7EY,CH6 5QG,CH7 6RQ,G2 1DS,G1 1TY,GL13 9BA,GL55 6AT,GL2 8DR,GL15 5RF,CR5 2LL,HA6 2PQ,E10 5EL,SW12 9HJ,BL0 9DS,M16 0PE,WN8 9QD,LL57 2SR,LL40 1RF,LL65 4UH,LL72 8HB,LL49 9NY,PO16 8SB,GU51 4NE,SO43 7NF,SO14 2HN,HR4 9BG,HR9 6JL,HP3 0AA,HP4 3HL,HP4 1AH,CM22 7SP,AL10 9RH,AL3 7AF,SG8 7BZ,CM21 0JU,SG1 1EJ,IV17 0XN,KW12 6YN,PA37 1PB,IV26 2SX,PO33 1AB,PO36 8BN,PO36 9BW,PO37 6BD,PO37 6RL,PO37 6RG,TN25 5NB,CT2 8JZ,CT20 2EA,CT20 2EL,TN29 0LN,FY1 2LD,FY1 6BP,FY4 1HJ,FY1 6BJ,FY1 2EY,FY1 2JA,FY1 4BY,FY1 4PR,FY4 1HE,BB12 9PA,BB12 7QW,BB10 2LF,BB12 8HG,BB7 2BX,BB3 2JU,LA2 7HF,LA2 9LA,FY8 5JP,FY8 1LS,FY6 0NW,PR3 1YE,PR3 2NB,PR1 2YF,FY8 1HN,NG33 4LL,DN41 8BU,L1 1JP,L17 4JE,CH43 7RY,CH66 8PF,PR9 9EX,PR8 1JR,NP7 7LW,NP16 5EX,NP25 3SZ,AB37 9ET,AB56 4SD,AB55 4AD,NR27 9QH,NR20 5QS,NR21 0DX,NR30 3JL,NR30 2DQ,NR30 2DG,PE36 5HW,PE30 4NB,NR14 6SF,TS4 2EZ,DL8 1PY,HG1 5JR,HG5 0AD,DL8 4NP,YO18 8SE,HG4 4NF,YO11 2AY,YO12 7PE,YO11 2QF,BD23 5QX,YO22 4QH,YO21 1XE,YO31 8JX,YO61 4AS,NN17 3AT,NN6 9JA,NN6 7TU,TD15 2TA,NE47 6NQ,NE47 0AH,NE47 6JQ,NE65 9TP,NE65 7TE,NG23 5SG,NG1 3BP,KW17 2DB,OX26 6NB,OX18 4TN,OX25 5QQ,OX12 0EJ,OX28 6BH,SA62 3LW,SA35 0AW,LD1 5UA,LD6 5LL,LD6 5NG,PA4 9EJ,CF44 9SX,LE15 9HU,TD12 4AS,TF11 8HG,SY2 5HG,SY4 5UA,SY4 5RG,TF8 7NH,TA7 0QR,TA6 6QA,TA20 3TA,TA20 2HW,BA11 5DP,TA9 3PU,TA24 6JS,BA16 0EF,TA3 6SG,BA9 9JF,KA26 9HE,KA10 6BQ,S66 9JA,S7 1NQ,S21 3WF,DE13 7BB,ST21 6JQ,ST15 0BQ,CO10 1BD,IP31 1AW,IP30 9AB,GU23 6BB,NE1 4SD,NE6 1LD,B49 6NR,CV21 1HU,CV23 9LF,CV37 9DP,CV34 4DP,G83 7AU,CV5 9BA,CV1 1GU,DY1 4RN,WV6 0BQ,WF17 7HR,BD1 5SH,BD22 8DU,OL14 5NJ,LS22 5HS,SN10 5TH,SN8 2DU,SP5 2AS,BA13 4PT,LL12 0DE"",""cross_2"":""Aberdeenshire,Argyll and Bute,Bedfordshire,Berkshire,Bristol,Buckinghamshire,Cambridgeshire,Carmarthenshire,Ceredigion,Channel Islands,Cheshire,Conwy,Cornwall,County Clare,County Down,County Durham,Cumbria,Denbighshire,Derbyshire,Devon,Dorset,Dumfriesshire,Dundee,East Ayrshire,East Riding of Yorkshire,East Sussex,Essex,Fife,Flintshire,France,Glasgow,Gloucestershire,Greater London,Greater Manchester,Gwynedd,Hampshire,Herefordshire,Hertfordshire,Highland,Isle of Wight,Italy,Kent,Lancashire,Lincolnshire,Merseyside,Monmouthshire,Moray,Norfolk,North Yorkshire,Northamptonshire,Northumberland,Nottinghamshire,Orkney Islands,Oxfordshire,Pembrokeshire,Powys,Renfrewshire,Rhondda Cynon Taf,Rutland,Scottish Borders,Shropshire,Somerset,South Ayrshire,South Yorkshire,Staffordshire,Suffolk,Surrey,Tyne and Wear,Warwickshire,West Dunbartonshire,West Midlands,West Yorkshire,Wiltshire,Wrexham"",""cross_3"":""1"",""cross_5"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10976824_(6)_lionandkey.jpg"",""cross_6"":""https:\/\/images.buyagift.co.uk\/common\/client\/Images\/Product\/Large\/en-GB\/10913507-PolraenCounty.jpg""}"|2025-01-02T15:05:13+00:00|2025-01-02T15:05:13+00:00|2025-01-23T19:33:25+00:00
317|gtin-000887276124391|sku7760401|37023|"{""id"":37023,""name"":""AT&T Mobility""}"|3|154|Samsung|"{""id"":154,""name"":""Samsung"",""parent_id"":0}"|99|"electronics,communications,telephony,mobile phones"|"Samsung Gear S2 - Silver"|1|99.99|0|USD|USD|https://www.tkqlhce.com/click-ACTID-13664766?url=http%3A%2F%2Ftracking.searchmarketing.com%2Fclick.asp%3Faid%3D330002190000016701|https://freshreach.co/click?m=37023&cid=FMTC&uid=9107&cpid=289|https://www.att.com/catalog/en/skus/images/samsung-gear%20s2-silver-100x160.jpg||000887276124391|"With elegant curves and premium finishes, the Samsung Gear S2 will turn heads. The intuitive circular face and bezel let you navigate effortlessly to get to what you need. Get more out of the moments in your day with Samsung Gear S2 and AT&T network. cell phones and smart phones on the AT&T 4G network."|"{""program_url"":""https:\/\/www.att.com\/wireless\/"",""catalog_name"":""AT&T Mobility Product Feed"",""last_updated"":""2025-03-18T09:10:24.081-07:00"",""impression_url"":""https:\/\/www.awltovhc.com\/image-AFFILIATEID-13664766"",""mobile_link"":""https:\/\/m.att.com\/shopmobile\/devices\/samsung\/gear-s2.html#sku=sku7760401"",""expiration_date"":""2025-04-16T01:00:00.000-07:00"",""google_product_category"":""267"",""product_type"":""Electronics > Communications > Telephony > Mobile Phones"",""identifier_exists"":""yes"",""condition"":""new"",""color"":""Silver"",""custom_label_0"":""Everything Else"",""custom_label_1"":""Samsung"",""custom_label_2"":""Samsung Gear S2"",""custom_label_3"":""Catch All"",""custom_label_4"":""Catch All_spanish"",""product_highlight"":""[]""}"|2025-03-18T10:15:00+00:00|2025-03-18T10:15:00+00:00|2025-03-20T00:00:00+00:00