Product Importer

If you are looking to update existing products, first use the Product Exporter to export the products with their details and settings. The Advanced sheet format is the best for exporting and importing to edit products as it contains the most information and settings for your products. Edit the details and use the product importer to upload them. **The Product Importer will wipe any product information that is left blank in the excel sheet on products the already exist.**

The Product Importer tool will allow you to import multiple products into your admin panel. The import tools can also be used in conjunction with the Product Exporter to make mass updates to existing product details.

Importing Products: Learn how to import products using the product importer. Learn More >

Regular vs. Advanced Sheet Formats: Learn more about the differences between the two import sheet formats including column definitions: Learn More >

FAQs: Review frequently asked questions regarding importing products. Learn More >

Importing Products

The importer tool will review products based on SKU and either create a new product if the SKU does not exist or update the existing product that matches the SKU.

1. Go to Settings > Import/Export > Product Importer in the Admin Panel.

2. If you are importing products for the first time and do not yet have a excel sheet filled out in one of the two required import formats select either Download Regular Sample File or Download Advanced Sample File.

If you are looking to update existing products, first use the Product Exporter to export the products with their details and settings. The Advanced sheet format is the best for exporting and importing to edit products as it contains the most information and settings for your products.

3. Complete the sample sheet following the formatting guidance found in the Regular vs. Advanced Sheet Formats Documentation. When complete, make sure that your file is saved to s spot you can easily find on your computer and completely close the sheet (not just minimized).

If you filling out the sample sheet or editing a product export sheet to update existing products, be aware that all fields overwrite the existing content or setting on the product. It is best to user the Product Exporter (Advanced Format) when updating products to avoid wiping out settings on an existing product.

4. Click Browse to locate the import sheet you have saved on your computer.

5. Select the Format that the sheet uses. For more details the differences see the Regular vs. Advanced Sheet Formats Documentation.

6. Click Import.

A progress bar will let you know the status of your import.

Page Top

Regular vs. Advanced Sheet Formats

There are two product import/export sheets available: Regular & Advanced.

Regular Format: This sheet format includes the basic information you will need to create products in Vin65 and assign them to your website. If you are just starting out and don't have a lot of information and/or are not setting up products on POS, this might work best for you.
Advance Format: This sheet format contains additional settings than the regular sheet and also allows you to assign products both your website and POS. If you are going to be updating products that already exist in Vin65 you will want to use the Advanced sheet when exporting and importing your products to ensure that you do not overwrite settings already set on the product.

Page Top

Regular Sample File

This sheet format includes the basic information you will need to create products in Vin65 and assign them to your website. If you are just starting out and don't have a lot of information and/or are not setting up products on POS, this might work best for you.

Below is the list of definitions found on the Regular Sample File:

ProductTitle	The name of the product.
ProductType	The name of the product type assigned to the product. Example: Wine, Product, etc.
Brand	The brand name given to the product.
DepartmentCode	The department code the product is assigned to.
SubDepartmentCode	If a subdepartment is available, the code for a specific subdepartment the product is assigned to.
Teaser	The teaser added to the product.
Description	The full description added to the product.
Photo	The file name of the photo for the product. The name must exactly match the file name that has been uploaded to your assets. Example: Red-Wine-No-Label7.jpg
SKU	The SKU given to the product.
UnitDescription	The description of the product. Example: 750ml, 1.5ml, small, etc.
Weight	The weight of the product.
Price	The price of the product.
Vineyard Designation	The name of the producing vineyard added to the product.
BottleSizeInML	The bottle size chosen for the product in milliliters. This value must be numeric. Example: 375, 750, 1500, etc.
Vintage	The vintage is the single specified year (e.g. 2018) added to the details of the product. You can optionally specify that a wine is non-vintage using the following designations (not case sensitive): NV Non-Vintage Non Vintage NonVintage
Region	The region of the product.
Appellation	The appellation of the product.
WineType	The type of wine. Example: Red, White, etc.
Varietal	The varietal of the product.
BottlesInACase	How many bottles makes a case for this product.
WSRating	The Wine Spectator rating.
RPRating	The Robert Parker rating.
WERating	The Wine Enthusiast rating.
HarvestDate	The date of the harvest for the product.
Sugar	The sugar level of the product.
Acid	The acid level of the product.
PH	The pH level of the product.
Aging	The age of the product.
Fermentation	The fermentation details for the product.
BottlingDate	The bottling date of the product.
ResidualSugar	The residual sugar level of the product.
Tannin	The tannin amount for the product.
AlcoholPercentage	The percentage of alcohol content in the product.
TastingNotes	Tasting notes can be entered here.
Ratings	Any additional ratings for the product.
Awards	Any applicable awards can be added here for the product.
VineyardNotes	Any additional notes for the vineyard.
ProductionNotes	Any additional production notes.
WinemakerNotes	The notes for the product from the winemaker.
FoodPairing	Any food pairing notes.
OtherNotes	Any additional miscellaneous notes.

Page Top

Advanced Sample File

This sheet format contains additional settings than the regular sheet and also allows you to assign products both your website and POS. If you are going to be updating products that already exist in Vin65 you will want to use the Advanced sheet when exporting and importing your products to ensure that you do not overwrite settings already set on the product.

Below is the list of definitions for the columns found in the Advanced Product Importer Sample File:

ProductTitle	The name of the product.
POSTitle	The name of the product to be shown on the POS.
SKU	The SKU given to the product.
Price	The price of the product.
SalePrice	The price of the product when it is on sale.
CostOfGoods	The cost of goods associated for the product.
ProductType	The name of the product type assigned to the product. Example: Wine, Product, etc.
Brand	The brand name given to the product.
DepartmentCode	The department code the product is assigned to.
SubDepartmentCode	If a subdepartment is available, the code for a specific subdepartment the product is assigned to.
isActive	Allows the user to declare if the product is an active product or not. 1 = Active 0 = Inactive
isDisplayOnWebsite	Allows the user to declare if the product is to be displayed on the website. Format is in: 1 = Active 0 = Inactive
ActionMessage	Any action message for the product.
Teaser	The teaser added to the product.
Description	The full description added to the product.
Category	The website category (website page) the product is assigned to The category name in the spreadsheet must exactly match the website Category (Page) that you have created. Website categories (Pages) must be created prior to import. For more information see the POS Categories Documentation.
POSCategory	The POS Category (section on the POS) that the product is assigned to. The category name in the spreadsheet must exactly match the POS Category that you have created. POS Categories must be created prior to import. For more information see the POS Categories Documentation.
Photo	The file name of the photo for the product. The name must exactly match the file name that has been uploaded to your assets. Example: Red-Wine-No-Label7.jpg
UnitDescription	The description of the product. Example: 750ml, 1.5ml, small, etc.
isNonTaxable	Allows the user to declare if the product is taxable or not. 1 = Non-Taxable 0 = Taxable
isByPassComplianceAndFulfillment	Allows the user to declare if the product is to bypass compliance/fulfillment or not. 1 = ByPass 0 = Do Not ByPass
isNoShippingCharge	Allows the user to declare if the product has a shipping charge or not. 1 = Product will be NOT be charged shipping 0 = Product will be charged shipping
isNoPromosApplicable	Allows the user to declare if the product is applicable for promotions. Format is in: 1 (no promos can be applied) or 0 (promos apply).
Weight	The weight of the product.
Price2 ...to... Price11	These columns allow the user to define any additional price level prices for the product.
Supplier	The supplier of the product.
ReOrderSKU	The SKU a customer may use if they wish to re-order the product.
ShippingStrategy	The shipping strategy assigned to the product. Please ensure that the strategy names are matching 1:1 with the strategies set up in your Shipping Rates tables.
Vineyard Designation	The name of the producing vineyard added to the product.
BottleSizeInML	The bottle size chosen for the product in milliliters. This value must be numeric. Example: 375, 750, 1500, etc.
Vintage	The vintage added to the details of the product.
Region	The region of the product.
Appellation	The appellation of the product.
WineType	The type of wine. Example: Red, White, etc.
Varietal	The varietal of the product.
BottlesInACase	How many bottles makes a case for this product.
WSRating	The Wine Spectator rating.
RPRating	The Robert Parker rating.
WERating	The Wine Enthusiast rating.
HarvestDate	The date of the harvest for the product.
Sugar	The sugar level of the product.
Acid	The acid level of the product.
PH	The pH level of the product.
Aging	The age of the product.
Fermentation	The fermentation details for the product.
BottlingDate	The bottling date of the product.
ResidualSugar	The residual sugar level of the product.
Tannin	The tannin amount for the product.
AlcoholPercentage	The percentage of alcohol content in the product.
TastingNotes	Tasting notes can be entered here.
Ratings	Any additional ratings for the product.
Awards	Any applicable awards can be added here for the product.
VineyardNotes	Any additional notes for the vineyard.
ProductionNotes	Any additional production notes.
WinemakerNotes	The notes for the product from the winemaker.
FoodPairing	Any food pairing notes.
OtherNotes	Any additional miscellaneous notes.
UsesInventory	Allows the user to determine if the product is using WineDirect's Inventory tools or not. 1 = Uses Inventory 0 = Does not use Inventory

Page Top

Product Importer FAQs

What does "Spreadsheet in an incorrect format" mean?
Can I assign products to my website or POS with the importer?
Can I update existing products using the importer?
Do I have to setup all wine settings like Wine Types, Appellations, Regions, Bottle Sizes, etc before I import my products?

What does "Spreadsheet in an incorrect format" mean?

Your spreadsheet cannot be imported because one or more of the column headers do not match the sample sheet. It is best to download either the Regular or Advanced Sample Sheet and make sure that all columns are present, spelled correctly, and contain the correct spelling and capitalization.

Common issues are that a column has been deleted from the sample sheet that you are trying to import or the name of the column does not match the required format (example: pproduct title instead of ProductTitle [missing capitalization and includes a space between words]).

Top Of Page

Can I assign products to my website or POS with the importer?

Yes. Products can be assigned to your website categories (pages) using either the Regular or Advanced import sheets.

POS categories can only be assigned using the Advanced import sheet.

You can only assign a product to one category per import. If you would like to add a product to multiple website pages or POS categories, you will need to upload more than one spreadsheet - in this case, all you need to change between each different spreadsheet is the Categories or POSCategories column(s).

If a Category or POS Category does not exist prior to import it will not be created.

Top Of Page

Can I update existing products using the importer?

Yes. The importer will look to see if a product already exists that matches the SKU listed in your spreadsheet. If a match is found the importer will update the product with all of the information in in the spreadsheet. In no match is found a new SKU and product will be created.

You should use the Product Exporter (Advanced Format) to first export your products, edit the details in the exported sheet, and import the edited sheet.

When updating existing products, be aware that all fields overwrite the existing content or setting on the product. Even if a field is left blank it will set adjust the setting to it's default option and in the case of text, clear the text. It is best to user the Product Exporter (Advanced Format) when updating products to avoid wiping out settings or content on an existing product.

Top Of Page

Do I have to setup all wine settings like Wine Types, Appellations, Regions, Bottle Sizes, etc before I import my products?

No. Product information such as: Wine Types, Appellations, Regions, Bottle Sizes, etc. Are automatically created based on the data within your spreadsheet when you import it. These can be edited manually afterwards as well (for spelling mistakes, etc.) under the Store > Products section of the admin panel.

Top Of Page