**Before you can batch import, you will first want to perform an export of current pricing and edit the file.**

Export Pricing:

  1. Enter the Wines tab
  2. In the left sub-navigation on the left side, find the Import/Export section
  3. Locate the Prices sub-navigation
  4. Click on Export Prices
  5. Click the box to show disabled prices, or leave it blank only to see active pricing
  6. Select detailed or basic export
  7. Click Export

We currently support two Excel formats, a Detailed and a Basic format. In most cases, you probably want to consider the Basic format.

Note: Not all export columns are updatable. Several only exist for your reference. Please refer to the Import Wines Prices screen for more information  

Basic Format

This Excel format is fairly simple. You can see the columns required by going to the upload screen. 

  1. Click on the Wines tab 
  2. On the left, click on Import Prices
  3. Now click on the Basic tab

Required columns are:

  • A – Upload type
  • B – Wine Code
  • C - Wine Name
  • D - Price Label

Description of Columns

  • Price Label: the full name of the price, examples: Case Price, Frontline, BTG

  • Privacy: whether the price is public or private. Please see this article for what this means

  • Sort Order: the order you would like this price to be displayed when there are multiple prices shown for this Wine. The value is a number, and the sorting is done from lowest to highest. Example: if you have two price points: "Case Price" and "Case 5 Price," and you want to show them in that order, then you could use a Sort Order value of 1 for the first price and 2 for the second.

  • Account Name: the full name matching a Vinosmith Account to lock this Price to this Account