Returns - product feed

Used when integrating with our partner ZigZag to manage returns.

The product feed contains the data on all the goods that are being sold by the retailer. Is needed for the Inventory Grid and in order to grab product's data on the received order files. Is also used to apply category, product type and brand pricing settings. Can be provided in several languages.

It can be integrated via FTP, or via API.

Integration via FTP

Naming convention: ProductsDE{timestamp}.csv; ProductsGB{timestamp}.csv etc. Timestamps supplied in ISO 8601 format. e.g. 2013-10-31T000000Z

Upload frequency: once per day

Directory: sftp/feeds/Inventory/Country ISO2Code

Column Name (csv)	Example Data	Obligator y	Obligator y for Live Exchange s	Restrictions
SKU	30D24LRED	Yes	Yes	String, max length 50
Master SKU	33057	No	Yes	String, max length 50
Brand	ZigZag	No	No	String, max length 200
Google Product Category	Apparel & Accessories > Clothing > Dresses	No	Yes	String, max length 250
GTIN	5019808762341	Yes	Yes	String, max length 50
MPN	28047996	No	No	String, max length 50
Availabilit y	Available	No	No	String, max length 250
Sale Price Effective Date	2017-05-01 00:00:00	No	No	DateFormat, yyyy-MM- ddTHH:mm:s s
Condition	New	No	No	String, max length 50
URL Image 1	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 2	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 3	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 4	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 5	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 6	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 7	https://zigzag.global/direct_download _ link	No	No	String, max length 250
URL Image 8	https://zigzag.global/direct_download _ link	No	No	String, max length 250
Tag (Colour)	BRIGHT RED	No	No	String, max length 20
Descriptio n	Prepare yourself for SS17 by injecting a pop of colour into your wardrobe...	No	No	String, max length 500
Item Title	TALL ring wrap dress	Yes	Yes	String, max length 500
Attribute (Size)	10	No	No	String, max length 50
Tag (Gender)	Female	No	No	String, max length 50
Link	https://zigzag.global/direct_download _ link	No	No	String, max length 250
Age	18, Teenage	No	No	String, max length 50
Weight	0.5	No	Yes	Decimal
Width	20	No	No	Decimal
Height	5	No	No	Decimal
Length	20	No	No	Decimal
Season	Summer	No	No	String, max length 50
Fit	Slim	No	No	String, max length 50
Country of Origin ISO2 Code	GB	No	Yes	ISO 2 Country Code

Integration via API

This endpoint is designed to create new products or update existing products. Products failing validation will not be processed.

PUT: https://api.returns.international/Return/api/v1/products/{SKU}

Example payload:

{
  "retailerCode": "GL123",
  "masterSku": "Monogrammed",
  "brand": "string",
  "googleProductCategory": "Accessories",
  "gtin": "Monogrammed",
  "mpn": "string",
  "condition": "string",
  "availability": "string",
  "salePriceEffectiveDate": "2019-08-24T14:15:22Z",
  "defaultProductHsCode": "string",
  "productInformation": [
    {
      "name": "MONOGRAMMED",
      "description": "string",
      "gender": "string",
      "link": "https://image.spreadshirtmedia.net/image-server/v1/mp/products/T6A7MPA4289PT17X0Y330D168795764FS2014/views/1,width=800,height=800,appearanceId=7,backgroundColor=F2F2F2,modelId=1405,crop=list/yellow-shirt-with-black-zigzag-mens-t-shirt.jpg",
      "color": "Black",
      "size": "string",
      "imageLink": "https://image.spreadshirtmedia.net/image-server/v1/mp/products/T6A7MPA4289PT17X0Y330D168795764FS2014/views/1,width=800,height=800,appearanceId=7,backgroundColor=F2F2F2,modelId=1405,crop=list/yellow-shirt-with-black-zigzag-mens-t-shirt.jpg",
      "age": "string",
      "weight": 10,
      "width": 10,
      "height": 10,
      "length": 10,
      "countryCode": "GB",
      "countryOfOriginIso2Code": "GB",
      "fit": "string",
      "season": "string"
    }
  ],
  "prices": [
    {
      "countryCode": "GB",
      "rrp": 0,
      "sellingPrice": 10,
      "shippingCost": 10,
      "costPrice": 10
    }
  ]
}