Data Mapping

Table of contents

1. Custom XML Data Mapping
   1. Producer (Mandatory)
   2. Wine Name (Mandatory)
   3. Vintage (Mandatory)
   4. ExternalId (Mandatory)
   5. Bottle Size (Optional)
   6. Stock (Mandatory)
   7. Off-Trade Price (Mandatory*)
   8. Title (Mandatory*)
2. Additional Custom XML Data Mapping
   1. Product Link (Optional*)
   2. SKU (optional)
   3. GTIN (optional)
   4. On-Trade Price (Optional*)
   5. Purchase Price (Optional)
   6. Wine Data Fields

Custom XML Data Mapping

Below you find ways you can map your product feed data to the Wineally format.

Producer, Wine Name, Vintage - these data fields in combination provide the best option for automatically identification of new wines in your data feed.

Producer (Mandatory)

Datatype: string

This field should be the wine producers name, without any additional information.

d'Arenberg, Chateau Latour, Winegut Wittman

Wine Name (Mandatory)

Datatype: string

Wine name should be without any additional information added (e.g vintage, appelation, producer name etc).

Air de Vieux Robin, Alix de Château Plaisance and Zédé de Labégorce are valid examples of wine names.

Vintage (Mandatory)

Datatype: integer

Vintage is provided in format NNNN, non-vintage wines are marked as NV

2014, 1976, 2021 and NV are all valid examples.

ExternalId (Mandatory)

Datatype: string

Unique identifier in the source system that will later be used to identify a wine in the data feed and a wine cellar wine. This identifier must be unique the wine cellar, otherwise a wine will update the wrong.

Examples of unique ExternalId may be productid.

Bottle Size (Optional)

Datatype: decimal

Default: 75

Bottle size is provided in centilitre (cl) as a single number.

Valid bottle sizes include 18.75, 37.5, 75, 150 and 300

Stock (Mandatory)

Datatype: integer

Stock level should be provided to ensure wines in stock are presented to your Wine & Food Matcher users. Wines with stock level 1 or more will be visible in the Wine & Food Matcher.

If you don’t want to update Wineally with correct stock level, just set it to 1 as long as it is in stock and to 0 if it is out of stock (or omit wine from feed when out of stock, as described here).

Off-Trade Price (Mandatory*)

Datatype: decimal

Your off-trade (retail) sales price including sales tax in your local currency.

Off-Trade price must be provided for the wine to be available in the Wine & Food Matcher.

Use dot notation for decimals (e.g. 10.50). Comma notation is not supported.

Do not use thousands separators.

Don’t use currency symbols. Wineally will use the currency you have configured in account information.

*Used by Wine Merchant accounts only.

Title (Mandatory*)

Datatype: string

The title must be in the following format. This is commonly also known as the display name.

{producer-name} {wine-name} {vintage} {colour}

Non-vintage wines are marked as NV in the title.

Bollinger Special Cuvée NV White

Title can be used on its own to identify wines but is optional if the other identifying data fields are provided (producer, wine name and vintage). For best result, provide *wine name instead.

Additional Custom XML Data Mapping

These fields are optional, however, providing them will increase the chances of correctly identifying your new wines automatically and add them to your wine cellar.

Product Link (Optional*)

Datatype: string

URL to the product page where the Wine & Food Matcher users are able to purchase your wine. As a wine merchant it is strongly recommended that you add this information. The product link should not contain any additional utm-tags.

https://wine-merchant.com/wines/sparkling/bollinger-007-spectre-millesime-2010-75

*Only for wine merchant accounts.

SKU (optional)

Datatype: string

Stock Keeping Unit or SKU. Optiona value in Wineally which may be valuable when exporting wine cellar data or otherwise integrating with Wineally in the future.

GTIN (optional)

Datatype: string

Global Trade Identification Number or GTIN. Use this field to save GTIN such as EAN to Wineally.

On-Trade Price (Optional*)

Datatype: decimal

decimal value for your on-trade sales price excluding sales tax. For wine merchants it is strongly recommended that you add this information.

Use dot notation for decimals (e.g. 10.50). Comma notation is not supported.

Do not use thousands separators.

Don’t use currency symbols. Wineally will use the currency you have configured in account information.

*Used by Wine Merchant accounts only.

Purchase Price (Optional)

Datatype: decimal

The purchase price of the wine excluding sales tax. When added Wineally can correctly show gross margin and the value of your wine cellar.

Use dot notation for decimals (e.g. 10.50). Comma notation is not supported.

Do not use thousands separators.

Don’t use currency symbols. Wineally will use the currency you have configured in account information.

Used by Wine Merchant accounts only.

Wine Data Fields

Providing more data allows our Wine Data Team to add wines to the wine database quicker, in case our large wine data base is missing one or more of your wines.

Values such as country, colour and region are always in English.

---