XML and CSV Data Files

What's a data file? A data file is a list of your products. When you import a data file to Snooth, we automatically do two things:

  • First we examine every product in your data file to see if it matches one of the millions of products that already exist on Snooth. For every match, that wine is added to your account.
  • For products we can't match, we assume it's a product that we don't know about. In those cases we create new product listings and add those products to your account.

XML Data Files

Sample XML Data File for Retailers

This template is good for stores with an E-Commerce website.

Show example Download file

<?xml version="1.0" encoding="UTF-8" ?>
<document>
    <wine>
        <sku>5112453345</sku>
        <name>Alderbrook Reserve Zinfandel Dry Creek Valley</name>
        <vintage>2010</vintage>
        <product_url>http://your-site.com/this-wine.html</product_url>
        <release_status>Current</product_url>
        <price>32.99</price>
        <in_stock>1</in_stock>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Alderbrook Winery</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>USA</country>
        <appellation>Upper Dry Creek</appellation>
        <varietal>Zinfandel; Carignane</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>Rich, dark rose color. The nose is bursting with brambly blackberry fruit. Anise, blueberry and black cherry notes flow through on the palate. Enjoy now or hold for the future, this is a wine with aging potential.</winery_notes>
        <reviews>
            <review>
                <rating>92 Points</rating>
                <source>Wine Enthusiast</source>
            </review>
            <review>
                <rating>90 Points</rating>
                <source>Jay Miller, The Wine Advocate</source>
                <date>February 2009</date>
                <body>This wine exhibits...</body>
            </review>
        </reviews>
    </wine>
    <wine>
        <sku>5112453346</sku>
        <name>Baglio di Pianetto Piana dei Cembali Nero d'Avola </name>
        <vintage>2002</vintage>
        <product_url>http://your-site.com/this-wine.html</product_url>
        <release_status>Prior</product_url>
        <price>32.99</price>
        <in_stock>1</in_stock>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Baglio di Pianetto</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>Italy</country>
        <appellation>Sicily</appellation>
        <varietal>Nero d'Avola</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>100% Nero d'Avola - robust, warm, pleasing to the palette. Sicilian sunshine in a bottle.</winery_notes>
        <reviews>
            <review>
                <rating>92</rating>
                <source>John Smith, Wine Lover's Magazine</source>
                <date>January, 2009</date>
                <body>It is very dark ruby and opens with a fragrant black cherry bouquet with notes of chocolate and a hint of blueberry. On the palate, this wine is full bodied, nicely balanced, very smooth and almost velvety.</body>
            </review>
            <review>
                <rating>90</rating>
                <source>Jay Miller, The Wine Advocate</source>
                <date>February 2009</date>
                <body>This wine exhibits...</body>
            </review>
        </reviews>
    </wine>
    <wine>
        <sku>5112453347</sku>
        <name>Baglio di Pianetto Ramione Red Blend </name>
        <vintage>2004</vintage>
        <release_status>Prior</product_url>
        <product_url>http://your-site.com/this-wine.html</product_url>
        <price>21.99</price>
        <in_stock>1</in_stock>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Baglio di Pianetto</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>Italy</country>
        <appellation>Sicily</appellation>
        <varietal>Merlot; Nero d'Avola</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>Deep ruby red color. Intense, pronounced nose of refined quality. Aromas of jam and red berries precede spicy notes of vanilla, licorice and nutmeg. A soft and balanced wine, of good intensity and lasting persistence. The wine is well-structured and harmonious with medium body, expressing the diverse characteristics of the terroir. </winery_notes>
    </wine>
</document>

Sample XML Data File for Wineries

This template is good for wineries that want to make sure their products are well-represented on Snooth.

Show example Download file

<?xml version="1.0" encoding="UTF-8" ?>
<document>
    <wine>
        <name>Alderbrook Reserve Zinfandel Dry Creek Valley</name>
        <vintage>2002</vintage>
        <release_status>Prior</product_url>
        <msrp>35.00</msrp>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Alderbrook Winery</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>USA</country>
        <appellation>Upper Dry Creek</appellation>
        <varietal>Zinfandel; Carignane</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>Rich, dark rose color. The nose is bursting with brambly blackberry fruit. Anise, blueberry and black cherry notes flow through on the palate. Enjoy now or hold for the future, this is a wine with aging potential.</winery_notes>
        <reviews>
            <review>
                <rating>92 Points</rating>
                <source>Wine Enthusiast</source>
            </review>
            <review>
                <rating>90 Points</rating>
                <source>Jay Miller, The Wine Advocate</source>
                <date>February 2009</date>
                <body>This wine exhibits...</body>
            </review>
        </reviews>
    </wine>
    <wine>
        <name>Baglio di Pianetto Piana dei Cembali Nero d'Avola </name>
        <vintage>2002</vintage>
        <release_status>Prior</product_url>
        <msrp>45.00</msrp>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Baglio di Pianetto</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>Italy</country>
        <appellation>Sicily</appellation>
        <varietal>Nero d'Avola</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>100% Nero d'Avola - robust, warm, pleasing to the palette. Sicilian sunshine in a bottle.</winery_notes>
        <reviews>
            <review>
                <rating>92</rating>
                <source>John Smith, Wine Lover's Magazine</source>
                <date>January, 2009</date>
                <body>It is very dark ruby and opens with a fragrant black cherry bouquet with notes of chocolate and a hint of blueberry. On the palate, this wine is full bodied, nicely balanced, very smooth and almost velvety.</body>
            </review>
            <review>
                <rating>90</rating>
                <source>Jay Miller, The Wine Advocate</source>
                <date>February 2009</date>
                <body>This wine exhibits...</body>
            </review>
        </reviews>
    </wine>
    <wine>
        <name>Baglio di Pianetto Ramione Red Blend </name>
        <vintage>2004</vintage>
        <msrp>21.99</msrp>
        <in_stock>1</in_stock>
        <bottle_size>750</bottle_size>    
        <image_url>http://your-site.com/this-wine.jpg</image_url>
        <winery>Baglio di Pianetto</winery>
        <color>Red</color>
        <type>Table Wine</type>
        <country>Italy</country>
        <appellation>Sicily</appellation>
        <varietal>Merlot; Nero d'Avola</varietal>
        <percentage>15.1%</percentage>
        <acidity>15.1%</acidity>
        <winery_notes>Deep ruby red color. Intense, pronounced nose of refined quality. Aromas of jam and red berries precede spicy notes of vanilla, licorice and nutmeg. A soft and balanced wine, of good intensity and lasting persistence. The wine is well-structured and harmonious with medium body, expressing the diverse characteristics of the terroir. </winery_notes>
    </wine>
</document>

Tips for better XML data files

  • You can create and edit an XML file using a basic text editor such as Notepad (although you can't use Microsoft Word).
  • All the information inside each <wine> tag must represent a unique product.
  • Tags you add to some products don't have to be in all your products. Just include as much information as you have for each product.
  • Price information from E-Commerce data files automatically expire every 30 days (90 days for wineries). This helps insure the information on Snooth always is up-to-date and accurate. The best way to ensure your prices never expire is to set up a dynamic data file.

XML Tag Reference

All the possible data you can include in your data file.

XML Tag Description Examples

Basic Tags

* Required for all wines

Include as many of these tags as possible in your data file to reduce duplicate listings and consumer confusion.
name* A detailed description of the wine's name <name>Two Hands Wines Gnarly Dudes Shiraz 2006</name>
vintage The wine's vintage <vintage>1997</vintage>
<vintage>2005</vintage>
<vintage>NV</vintage>
release_status The wine's release status <release_status>Current</release_status>
<release_status>Prior</release_status>
color The wine's color (red, white, or rose only) <color>Red</color>
<color>White</color>
<color>Rose</color>
type The wine's type (Typically "Table Wine") <type>Table Wine</type>
<type>Sparkling</type>
<type>Madeira</type>
varietal The wine's varietal, including blend composition separated by semicolons <varietal>Cabernet Sauvignon (50%); Merlot (50%)</varietal>
<varietal>Grenache</varietal>
<varietal>Syrah (82%); Viognier (18%)</varietal>
winery The wine's winery <winery>Dog Point Vineyard</winery>
<winery>Larkmead Vineyards</winery>
<winery>Dalla Terra</winery>
country The wine's country of origin <country>Spain</country>
<country>USA</country>
<country>France</country>
appellation The appellation/district of origin (most specific level) <appellation>Ribera Del Duero</appellation>
<appellation>Alexander Valley</appellation>
<appellation>Sauternes</appellation>

Tags for E-Commerce:

* Required for E-Commerce

These tags are most commonly used by retailers who want Snooth to link to their E-Commerce website.
sku* Your unique id for the wine <sku>0000001</sku>
<sku>MB_4552331</sku>
<sku>Wine_ID_144336</sku>
product_url* Your URL for the wine. This is the page on your website that Snooth sends people who click the "Buy" buttons on Snooth. If you're interested in boosting clicks and tracking conversions, consider installing our tracking code. <product_url>http://www.your-site.com/this-wine.html</product_url>
image_url The main image for the wine <image_url>http://your-site.com/this-wine.jpg</image_url>
price* The wine's retail price as listed on your E-Commerce website - decimals only <price>9.99</price>
<price>13.59</price>
<price>45</price>
currency* The wine price's 3-letter currency code - required for non-USD prices <currency>USD</currency>
<currency>GBP</currency>
<currency>EUR</currency>
in_stock* 1 or 0, indicating whether the wine is in stock at your E-Commerce website. (1="in stock", 0="out of stock") <in_stock>1</in_stock>
<in_stock>0</in_stock>
sale_price The wine's discounted price - if lower than your retail price - decimals only <sale_price>8.99</sale_price>
<sale_price>12.59</sale_price>
<sale_price>42</sale_price>
brand The brand name of the wine, if different from the winery or owner <brand>Yellow Tail</brand>
<brand>Purple Haze</brand>
<brand>Smoking Horse</brand>
bottle_size The wine's bottle size in ml - 750 is standard) <bottle_size>750</bottle_size>
<bottle_size>375</bottle_size>
<bottle_size>1500</bottle_size>
weight The weight of the wine <weight>1.2 lbs</weight>
<weight>0.5 kg</weight>
<weight>750 g</weight>

Additional Tags

Whether included in a store or a winery data file, these tags provide extra details that make products much more appealing to our engaged audience of wine lovers.
vineyard The wine's vineyard <vineyard>Anderson Valley Vineyard</vineyard>
<vineyard>Sunset Ranch Vineyard</vineyard>
<vineyard>Crystal Lake Vineyard</vineyard>
owner The name of the winery's owner, if different from the name of the winery <owner>Casella Wines</owner>
<owner>Domaine Clarence Dillon</owner>
<owner>Moët-Hennessy</owner>
designation Any other terms in the wine's name <designation>Reserva</designation>
<designation>Gran Cru</designation>
<designation>D.O.C.G.</designation>
percentage The wine's percentage alcohol by volume <percentage>12</percentage>
<percentage>14.1</percentage>
<percentage>15</percentage>
reviews Include each review inside a <review> tag <review>
    <rating>92</rating>
    <source>Wine Lover Magazine</source>
    <date>Jan 12, 2010</date>
    <body>A big fruity nose with characteristics of cranberry and wood undertones.</body>
</review>
winery_notes Production details provided from the winery <winery_notes> The 2003 harvest yielded a very small crop for us. In general, low yield is an indicator...</winery_notes>
<winery_notes> Great wines that don't receive the recognition they deserve, because their qualities are less overt...</winery_notes>
<winery_notes>The 2006 Shiraz was aged in French and American oak for 12 months. Purple-colored, it is very expressive, with a nose of smoke, spice box, blackberry...</winery_notes>
upc UPC number - bar code <upc>685522721055</upc>
<upc>785922731252</upc>
<upc>135148438304</upc>
drink_after Recommended date to drink the wine after <drink_after>June, 2012</drink_after>
<drink_after>2015</drink_after>
<drink_after>August, 2010</drink_after>
drink_before Recommended date to drink the wine before <drink_before>2011</drink_before>
<drink_before>Summer, 2015</drink_before>
<drink_before>2037</drink_before>
kosher Is the wine kosher? (1=yes, 0=no) <kosher>1</kosher>
<kosher>0</kosher>
non_alcoholic Is the wine non-alcoholic? (1=yes, 0=no) <non_alcoholic>1</non_alcoholic>
<non_alcoholic>0</non_alcoholic>
organic Is the wine organic? (1=yes, 0=no) <organic>1</organic>
<organic>0</organic>
acidity The wine's acidity - pH <acidity>6.5</acidity>
<acidity>5.8</acidity>
<acidity>6.2</acidity>
sugar The wine's sugar level - g/l <sugar>0.50</sugar>
<sugar>0.45</sugar>
<sugar>1.8</sugar>

CSV Data Files

Sample CSV Data File for Retailers

This template is good for stores with an E-Commerce website.

Show example Download file


        
            

                Data Field Title
                Examples
            

        
         
                                     
            

                
                id#

                
                
                

                

            

            
                         
            

                
                Name

                
                
                

                

            

            
                         
            

                
                Vintage

                
                
                

                

            

            
            

                
                Release Status

                
                
                

                

            

                         
            

                Appellation

                
                
                

                

            

            
                         
            

                Winery

                
                
                

                

            

            
                         
            

            

                
                Varietal

                
                
                

                

            

            
                         
            

                
                Type

                
                
                

                

            

            
                         
            

                
                Color

                
                
                

                

            

            
                         
            

                
                Price

                
                
                

                

            

            
                         
            

            
            

                
                In Stock

                
                
                

                

            

            
                         
            

            

                
                Organic

                
                
                

                

            

            
                         
            

                
                Kosher

                
                
                

                

            

            
                         
            

                
                Non-Alcoholic

                
                
                

                

            

            
                         
            

                
                Winery Notes

                
                
                

                

            

            
                         
            

                
                Size

                
                
                

                

            

            
                         
            

                
                Product URL

                
                
                

                

            

            
                         
            

                
                Image URL

                
                
                

                

            

            
                         
            

                Review 1

                
                
                

                

            

            
                         
            

                
                Review 2

                
                
                

                

            

            
                         
            

                
                Review 3

                
                
                

                

            

            
                         
            

                Review 4

                
                
                

                

            

            
                         
            

                Review 5

                
                
                

                

            

            
                         
            

                
                Review 6

                
                
                

                

            

            
                         
            

                
                Review 7

                
                
                

                

            

            
                         
            

                
                Review 8

                
                
                

                

            

            
                         
            

                Review 9

                
                
                

                

            

            
                         
            

                Review 10

Sample CSV Data File for Wineries

This template is good for wineries that want to make sure their products are well-represented on Snooth.

Show example Download file


        
            

                Data Field Title
                Examples
            

        
         
            

                
                Name

                
                
                

                

            

            
                         
            

                
                Vintage

                
                
                

                

            

            
            

                
                Release Status

                
                
                

                

            

                         

                         
            

                Appellation

                
                
                

                

            

            
                         
            

                Winery

                
                
                

                

            

            
                         
            

            

                
                Varietal

                
                
                

                

            

            
                         
            

                
                Type

                
                
                

                

            

            
                         
            

                
                Color

                
                
                

                

            

            
                         
            

                
                MSRP

                
                
                

                

            

            
                         
            

                
                Organic

                
                
                

                

            

            
                         
            

                
                Kosher

                
                
                

                

            

            
                         
            

                
                Non-Alcoholic

                
                
                

                

            

            
                         
            

                
                Winery Notes

                
                
                

                

            

            
                         
            

                
                Size

                
                
                

                

            

            
                         
            

                
                Image URL

                
                
                

                

            

            
                         
            

                Review 1

                
                
                

                

            

            
                         
            

                
                Review 2

                
                
                

                

            

            
                         
            

                
                Review 3

                
                
                

                

            

            
                         
            

                Review 4

                
                
                

                

            

            
                         
            

                Review 5

                
                
                

                

            

            
                         
            

                
                Review 6

                
                
                

                

            

            
                         
            

                
                Review 7

                
                
                

                

            

            
                         
            

                
                Review 8

                
                
                

                

            

            
                         
            

                Review 9

                
                
                

                

            

            
                         
            

                Review 10

Tips for better CSV data files

  • You can export a CSV file from almost any spreadsheet software. To learn how to create a CSV from an Excel file, click here.
  • If you're not using Excel to create your CSV, be sure that special characters within fields are properly escaped. Learn more here.
  • When saving a CSV file, it's important that you use the "CSV (MS-DOS)" option to ensure that accented characters are encoded correctly
  • It's OK to leave certain columns blank if you only have that type of information for some of the wines in your data file.
  • Price information from E-Commerce data files automatically expire every 30 days (90 days for wineries). This helps insure the information on Snooth always is up-to-date and accurate. The best way to ensure your prices never expire is to set up a dynamic data file.

CSV Field Reference

All the possible data you can include in your data file.

Field Title Description Examples

Basic Fields

* Required for all wines

Include as many of these fields as possible in your data file to reduce duplicate listings and consumer confusion.
name* A detailed description of the wine's name Two Hands Wines Gnarly Dudes Shiraz 2006
vintage The wine's vintage 1997
2005
NV
release_status The wine's release status Current
Prior
color The wine's color (red, white, or rose only) Red
White
Rose
type The wine's type (Typically "Table Wine") Table Wine
Sparkling
Madeira
varietal The wine's varietal, including blend composition separated by semicolons Cabernet Sauvignon (50%); Merlot (50%)
Grenache
Syrah (82%); Viognier (18%)
winery The wine's winery Dog Point Vineyard
Larkmead Vineyards
Dalla Terra
country The wine's country of origin Spain
USA
France
appellation The appellation/district of origin (most specific level) Ribera Del Duero
Alexander Valley
Sauternes

Tags for E-Commerce:

* Required for E-Commerce

These tags are most commonly used by retailers who want Snooth to link to their E-Commerce website.
sku* Your unique id for the wine 0000001
MB_4552331
Wine_ID_144336
product_url* Your URL for the wine. This is the page on your website that Snooth sends people who click the "Buy" buttons on Snooth. If you're interested in boosting clicks and tracking conversions, consider installing our tracking code. http://www.your-site.com/this-wine.html
image_url The main image for the wine http://your-site.com/this-wine.jpg
price* The wine's retail price as listed on your E-Commerce website - decimals only 9.99
13.59
45
currency* The wine price's 3-letter currency code - required for non-USD prices USD
GBP
EUR
in_stock* 1 or 0, indicating whether the wine is in stock at your E-Commerce website. (1="in stock", 0="out of stock") 1
0
sale_price The wine's discounted price - if lower than your retail price - decimals only 8.99
12.59
42
brand The brand name of the wine, if different from the winery or owner Yellow Tail
Purple Haze
Smoking Horse
bottle_size The wine's bottle size in ml - 750 is standard) 750
375
1500
weight The weight of the wine 1.2 lbs
0.5 kg
750 g

Additional Tags

Whether included in a store or a winery data file, these tags provide extra details that make products much more appealing to our engaged audience of wine lovers.
vineyard The wine's vineyard Anderson Valley Vineyard
Sunset Ranch Vineyard
Crystal Lake Vineyard
owner The name of the winery's owner, if different from the name of the winery Casella Wines
Domaine Clarence Dillon
Moët-Hennessy
designation Any other terms in the wine's name Reserva
Gran Cru
D.O.C.G.
percentage The wine's percentage alcohol by volume 12
14.1
15
review 1 Include as much information about the review as you can (reviewer name, source, date, etc...). For additional reviews, add extra columns to your document titled "review 2", "review 3", and so on. It is very dark ruby and opens with a fragrant black cherry bouquet with notes of chocolate and a hint of blueberry. On the palate, this wine is full bodied, nicely balanced, very smooth and almost velvety. - John Smith, Wine Lover’s Magazine, May 2009
winery_notes Production details provided from the winery The 2003 harvest yielded a very small crop for us. In general, low yield is an indicator...
Great wines that don't receive the recognition they deserve, because their qualities are less overt...
The 2006 Shiraz was aged in French and American oak for 12 months. Purple-colored, it is very expressive, with a nose of smoke, spice box, blackberry...
upc UPC number - bar code 685522721055
785922731252
135148438304
drink_after Recommended date to drink the wine after June, 2012
2015
August, 2010
drink_before Recommended date to drink the wine before 2011
Summer, 2015
2037
kosher Is the wine kosher? (1=yes, 0=no) 1
0
non_alcoholic Is the wine non-alcoholic? (1=yes, 0=no) 1
0
organic Is the wine organic? (1=yes, 0=no) 1
0
acidity The wine's acidity - pH 6.5
5.8
6.2
sugar The wine's sugar level - g/l 0.50
0.45
1.8

Snooth Media Network

Copyright © 2011 Snooth, Inc. All rights reserved. Terms of Use | Privacy Policy | Sitemap