FOR RETURNS ONLY. Contains the data on all the goods that are being sold by the retailer.
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) | Field Name (XML, XLSX) | Example Data | Obligatory | Obligatory for Live Exchanges | Restrictions |
|---|---|---|---|---|---|
| SKU | <SKU> | 30D24LRED | Yes | Yes | String, max length 50 |
| Master SKU | <MasterSKU> | 33057 | No | Yes | String, max length 50 |
| Brand | <Brand> | ZigZag | No | No | String, max length 200 |
| Google Product Category | <GoogleProductCategory> | Apparel & Accessories > Clothing > Dresses | No | Yes | String, max length 250 |
| GTIN | <GTIN> | 5019808762341 | Yes | Yes | String, max length 50 |
| MPN | <Mpn> | 28047996 | No | No | String, max length 50 |
| Availability | <Availability> | Available | No | No | String, max length 250 |
| Sale Price Effective Date | <SalePriceEffectiveDate> | 2017-05-01 00:00:00 | No | No | DateFormat, yyyy-MM-ddTHH:mm:ss |
| Condition | <Condition> | New | No | No | String, max length 50 |
| URL Image 1 | <ImageLink> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 2 | <AdditionalImages> <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 3 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 4 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 5 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 6 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 7 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| URL Image 8 | <String> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| Tag (Colour) | <Color> | BRIGHT RED | No | No | String, max length 20 |
| Description | <ProductDescription> | Prepare yourself for SS17 by injecting a pop of colour into your wardrobe... | No | No | String, max length 500 |
| Item Title | <ItemTitle> | TALL ring wrap dress | Yes | Yes | String, max length 500 |
| Attribute (Size) | <Size> | 10 | No | No | String, max length 50 |
| Tag (Gender) | <Gender> | Female | No | No | String, max length 50 |
| Link | <Link> | https://zigzag.global/direct_download_link | No | No | String, max length 250 |
| Age | <Age> | 18, Teenage | No | No | String, max length 50 |
| Weight | <Weight> | 0.5 | No | Yes | Decimal |
| Width | <Width> | 20 | No | No | Decimal |
| Height | <Height> | 5 | No | No | Decimal |
| Length | <Length> | 20 | No | No | Decimal |
| Season | <Season> | Summer | No | No | String, max length 50 |
| Fit | <Fit> | Slim | No | No | String, max length 50 |
| Country of Origin ISO2 Code | <CountryofOriginISO2Code> | 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
}
]
}