Using Wine Matcher to get Commodity Codes and ABVs
Commodity codes and ABV values are available to Liv-ex members on the Gold and Black packages via API, and through Wine Matcher. This short article explains the key steps to retrieving this data via Wine Matcher.
If you are on the Bronze or Silver package and would like more information about gaining access to this feature, please contact your Account Manager.
What are commodity codes?
Commodity codes (sometimes called HS codes) offer a standardised numerical method of categorising goods. They are typically required when moving products between territories, for example for calculating taxes.
Obtaining the correct code for a wine, fortified wine, or spirit requires detailed knowledge of the product type, origin (designation), colour, and alcohol level. If the wrong code is provided, there is a risk of fines or delays at customs. This article provides further information.
These codes are different in markets around the world. Wine Matcher provides access to codes for the UK, Europe, and Singapore (ASEAN).
How to get them using Wine Matcher
Getting ABVs and Commodity Codes from Wine Matcher is easy. Follow the same steps that you would take to get price data.
1. Log in to Wine Matcher
2. Select ‘Get LWINs + prices’
3. Select the data points you want to receive. ABVs and commodity codes are at the bottom of the screen.
4. Upload your Excel list of wines and hit ‘start’
5. Next you’ll be asked to select column headers. If you have your own ABV values and want to use them to generate commodity codes, make sure to allocate a header to this data (see below). If you don’t do this, your ABV values will still appear in the final spreadsheet but will not be used for commodity code calculation. Liv-ex values will be used instead.
6. You’ll then be asked to validate some matches. If you need a refresher on this, our help videos explain this screen in detail.
7. On the final screen, you can review your selection of data points and complete the journey. If you’ve selected ABVs or any commodity codes, all data will be emailed to you as a single Excel attachment. This typically takes around 15 minutes.
Understanding the file you receive
The file that you receive via email will show the various data points that you uploaded and requested through Wine Matcher. The example below shows a simple file. Key elements relating to ABVs and commodity codes are highlighted and explained below.
A – You have the option of using your own ABV data to generate commodity codes. If you selected the ABV header when uploading your list (step 5, above), your own ABVs will be used to generate commodity codes. Liv-ex data will be used to supplement your own ABV data where there are gaps.
If you do not have your own ABV values, or you did not select the ABV header when uploading your file, only Liv-ex values will be used to generate commodity codes.
B – ABV values from Liv-ex are shown where available. In the “ABV verified” column, we indicate whether these values have been individually verified by our team (“true”), or not (“false”).
C – Any commodity codes that you have requested will be shown here. Where verified ABV values are available, a full code is shown. Where ABV values are not available, a shortened code based on origin information is shown. You will need to add additional digits to the code after validating the ABV value of the wine. Full UK and EU codes are ten digits long. Full ASEAN codes are eight digits long.