Where to find the upload

To get to the product upload navigate to the products page. From there the upload is in the upper right hand corner. The download will provide you a list of your products in the exact same format as the upload and can be a helpful starting point when adding new SKUs to Products.

How the product download/upload is structured

In VineSpring a "Product" can hold one or more "SKUs". So it may be helpful to think of a "Product" as more of a container and not what you would traditionally think of which is a "SKU". See this help article for more information on how products and SKUs are structured and used within VineSpring: How do I enter new SKUs and Products?

The product download file is in the same format that will be needed for the product upload. The first 10 columns are related to the product itself while the last 31 columns are all related to the SKU. So if you have more than one SKU under a product the first 10 columns will be duplicated for each of those SKUs.

Both the product upload and download are in Comma-Separated Values format or CSV. While these types of files are easy to work with and are universally recognized by spreadsheet programs such as Microsoft Office and Numbers there are limitations in terms of formatting. There is no meta-data that can be stored with a CSV file which is why you can easily open the file in a text editor such as Microsoft Notepad and Mac TextEdit.

Column Definitions

Below is a description of each of the allowable fields in the upload. If a field is required there is a asterisk (*) after the name. For more information on each field see the article, How Do I enter new SKUs and Products?

It can be helpful to enter one product and SKU into the admin interface and then download the products so you can see where each of the values you data entered is displayed in the file.

Name

Related To/ Type

Notes

Id

Product/ String

The unique ID assigned within VineSpring. Leave this field blank for NEW products when uploading. If you want to update a SKU then use the product ID defined in the download.

Attributes *

Product/ String

A definition of the attributes that are available to the SKUs.

CanViewProduct

Product/ Boolean

TRUE/FALSE

Description

Product/ String

Note that special characters are not allowed in the CSV format.

DetailImage

Product/ String

Should be only the name of the file, for example: image.jpg

DisplayOrder

Product/ Number

Will default to 999 if not uploaded

ListImage

Product/ String

Should be only the name of the file, for example: image.jpg

Name *

Product/ String

Name of the product, for example "2019 Chardonnay"

Tags

Product/ String

Comma delimited list of tags, note that this field must be surrounded in double quotes if you have more than one tag.

Teaser

Product/ String

Brief description of product shown on the main shop page. Note that special characters are not allowed in the CSV format.

AttributeValues *

SKU/ String

Comma delimited list of of the values that correspond to the Attributes defined, note that this field must be surrounded in double quotes if you have more than one

IncrementQty

SKU/ Number

Can the SKU be purchased individually or are they sold in pairs or other groupings such as a 6-pack. Defaults to 1 if left empty.

MinQty

SKU/ Number

The minimum number of SKUs a customer can purchase. Defaults to 1 if left empty.

MaxQty

SKU/ Number

The maximum number of SKUs a customer can purchase. Defaults to unlimited if left empty.

Custom1

SKU/ String

Custom fields allow you to populate details that can be used by your web developer in site design.

Custom2

SKU/ String

Custom3

SKU/ String

Custom4

SKU/ String

Custom5

SKU/ String

Custom6

SKU/ String

Custom7

SKU/ String

Custom8

SKU/ String

Custom9

SKU/ String

Custom10

SKU/ String

DepthInches

SKU/ Number

Can be populated if needed by your fulfillment house.

LengthInches

SKU/ Number

Can be populated if needed by your fulfillment house.

HeightInches

SKU/ Number

Can be populated if needed by your fulfillment house.

WeightOunces

SKU/ Number

This should be populated if you are assigning a shipping plan that calculates shipping cost based upon weight and not quantity.

IsTaxExempt

SKU/ Boolean

TRUE/FALSE

Note that if you are using ShipCompliant this must be set on their side of things

SKUName

SKU/ String

Name of the SLU, for example "2019 Chardonnay". This can be the same or different than the Product Name.

Price

SKU/ Number

This should be a decimal value and not include the dollar sign. Example: 19.99

ShipCompliantBrandKey

SKU/ String

The next two fields only need to be populated if you are using ShipCompliant. These values must match exactly to what is in ShipCompliant. For example if the brand in ShipCompliant displays as "Bob's Brand" do not enter "bobs brand" as it will not match.

ShipCompliantProductKey

SKU/ String

AvalaraTaxCode

SKU/ String

If using Avalara this is the code you want to match to on the Avalara side. This must match what is in Avalara exactly, including case.

ShippingPlanName

SKU/ String

The name of an existing Shipping Plan that will be tied to this product. This value must match exactly including spaces and case. For example if you have a shipping plan called, "750 ML", do not enter "750ml" in this field as it will not match.

SKU *

SKU/ String

This is the actual SKU itself. It should not contain special characters and should be in all caps. While you can enter spaces in the upload, we suggest that your SKUs do not contain spaces. An example of this value would be "2019CHSW"

AdminAvailable

SKU/ Boolean

TRUE/FALSE indicating if this SKU is available for purchase on the Admin side of VineSpring

StorefrontView

SKU/ Boolean

TRUE/FALSE indicating if this SKU is will be shown at all on the storefront

StorefrontPurchase

SKU/ Boolean

TRUE/FALSE indicating if this SKU is will be available for purchase on the storefront

isAllocated

SKU/ Boolean

TRUE/FALSE indicating if the SKU is Allocated

AllocationMessage

SKU/ String

If TRUE above then provide a message to customers indicating that the SKU is allocated. For Example, "This product is only available through an allocation, please sign up for our mailing list for more information on how to purchase this product

Troubleshooting

My images are not showing up

Defining an image in the upload does not actually upload the image into the VineSpring system. Ensure that you have the name of the file exact including and dashes, underscores and that the extension is correct.

The accented characters I used are uploading as junk

The CSV file format does not support the upload of accented characters such as those in the word, "Rosé". You will need to upload the text "Rose" and then come back in and modify the text within the VineSpring application itself to use accented characters.

My SKUName is not showing on the storefront

Check to make sure that not only the product field CanViewProduct is set to TRUE but that the SKU level fields of StorefrontView and StorefrontPurchase are set to TRUE.

Did this answer your question?