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 >
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).
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.
There are two product import/export sheets available: Regular & Advanced.
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.
|
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.
|
SKU | The SKU given to the product. |
UnitDescription |
The description of the product.
|
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.
|
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):
|
Region | The region of the product. |
Appellation | The appellation of the product. |
WineType |
The type of wine.
|
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. |
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.
|
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.
|
isDisplayOnWebsite |
Allows the user to declare if the product is to be displayed on the website. Format is in:
|
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.
|
UnitDescription |
The description of the product.
|
isNonTaxable |
Allows the user to declare if the product is taxable or not.
|
isByPassComplianceAndFulfillment |
Allows the user to declare if the product is to bypass compliance/fulfillment or not.
|
isNoShippingCharge |
Allows the user to declare if the product has a shipping charge or not.
|
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.
|
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.
|
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.
|
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]).
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.
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.
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.