How to import an Excel for ProWein 2023 - Exhibitors with more than 100 products

Created by Jonathan Harclerode, Modified on Tue, 17 Jan 2023 at 07:38 PM by Jonathan Harclerode


IMPORTANT: This is only available for ProWein exhibitors with more than 100 products. Excels will less than 100 products will be rejected.

 


How-to Guide

Here is how to populate the Google Sheet template with your wine data. Start by creating a copy of the ProWein template. 


Click this link to get the template. 


You will be asked to make a copy of the document.

If you are not currently logged into Google, you will be prompted to log in.



After you have created a copy of the document, populate it with the wine data from your producers. Read more about how to do this below in Data Fields.


After you have completed preparing the Google Sheet, send the link to support@bottlebooks.me. Data will be published to ProWein.com within a week.


Excel (alternative option)

You can also download an Excel template with your wine data.

Click here to download the Excel template.


After you have downloaded the document, populate it with the wine data from your producers. Read more about how to do this below in Data Fields.


After you have completed preparing the Excel file, send the file to support@bottlebooks.me. Data will be published to ProWein.com within a week.



Data Fields

The template contains a combination of required and optional data that you can publish to ProWein.com. This section explains more about each field.


Required fields


Stand order number - each exhibitor/producer at your stand has been assigned a stand order number (Standauftrags-Nummer). This is a 7-digit number. This column must be completed correctly for any data to be published.

Producer or Brand - Name of producer or brand for the product.

Product Name - Product name without vintage or producer name.

ProWein product category - Each exhibitor/producer should have chosen a product category when they registered for ProWein. Each exhibitor/producer gets one free product category, which is required in order for any products to be published to ProWein.com. Read more about product category codes on the ProWein OOS.


If this field is left blank, ProWein.com will automatically assign the first product category it finds for each exhibitor/producer.


If an exhibitor/producer has not selected a product category during their ProWein registration, no product information will be displayed until they do so.

ProWein product category 2 - If a second product category has been purchased, it can be assigned here.

Denomination - Not every DO has an official product category on ProWein.com. This column provides fine-grained control over how your DO is displayed for the individual products. This is not your ProWein Product Category, rather it is how your region or DO will be displayed on the product page.


One example of where this can be useful are for producers that have multiple DOs. For example, a large producer may have only a single ProWein product category - "South Africa." But this producer has wines from both Stellenbosch and Cape Town. Use denomination to indicate Stellenbosch and Cape Town DOs.

Tasting note for trade - Recommended maximum of 600 characters.


High-res bottle image - This must be a public URL. There may be an additional fee to process images that are provided by zip.

Sustainability certification -  If certified sustainable, enter the name of the certification.

 
Also, please notice that it can take up to a week to get your products searchable on ProWein.com and ProWein app.

We look forward to a successful ProWein and showcasing all your products to a global audience.

If you still have any questions about the process, don't hesitate to reach out to us at 
support@bottlebooks.me.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article