TOP

Product Importer

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).

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: 3757501500, 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: RedWhite, 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.

Page Top


Product Importer FAQs

  1. What does "Spreadsheet in an incorrect format" mean?
  2. Can I assign products to my website or POS with the importer?
  3. Can I update existing products using the importer?
  4. 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.

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