CSV Fields Available

The different choices a product has. Use this to give a product different specifications. For example a t-shirt that comes in different sizes and colours. You can specify the sizes and colours like this: Size,XL[+1.99],M,S[-2.99];Colour,Red,Green,Yellow,ExpensiveColor[=24.00];AndSoOn,..,..

You can adjust the prices per attribute by using the following options:

• +: Add this amount to the configured price.
• -: Subtract this amount from the configured price.
• =: Set the product\’s price to this amount.

Usage:

1. Add the name “attribute” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with the attribute text.

Values:

• Text: No HTML code allowed.

attribute_values

Attribute values are the values of child products that are linked to the attributes of the parent product.
Usage:

1. Select the name “custom_attribute” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the attribute value text.

Values:

• Text: No HTML code allowed.
  The values must be seperated by a pipe symbol (|). E.g.: attribute_name::attribute_value|attribute_name::attribute_value

attributes

Attributes are part of a product and are used by the child products to give them specifications.
Usage:

1. Select the name “attributes” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the attributes text.

Values:

• Text: No HTML code allowed.
  The values must be seperated by a pipe symbol (|). E.g.: attribute_name::list_order|attribute_name::list_order

category_path

Parent products are categorized according to the category path. The category path specifies in which category a product belongs. This only counts for main products not for child products since child products relate to parent products, not to categories. For child products this field must be left empty. The product_parent_sku must be empty for main products since they do not relate to any other parent product.

Usage:

1. Select the name “category_path” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the path.

Values:

• Text: No HTML allowed
  The category path must be seperated by a forward slash (/). E.g.: Furniture/Chairs/Teak

custom_attribute

A custom attribute will add an input field to the product page with the description of the attribute supplied. Custom attributes are specified like this: Name;Extras;…
Usage:

1. Add the name “custom_attribute” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with the attribute text.

Values:

• Text: No HTML code allowed.

do_not_tax
A custom attribute will add an input field to the product page with the description of the attribute supplied. Custom attributes are specified like this: Name;Extras;…
Usage:

gift_wrap
This field is for defining if you want to offer giftwrap for the product. You have 2 options that you can use for the value.

manufacturer_id

The ID of the manufacturer that is related to the product and must be unique. This is used in combination with the manufacturer name. If no manufacturer name is specified, only the product manufacturer link will be added/updated. Adding/updating manufacturers follows the following process:

1. Name exists, ID exists –> ID is updated if different
2. Name exists, ID does not exist –> New manufacturer created with increment ID
3. Name does not exist, ID exists –> Generic name added with existing ID
4. Name does not exist, ID does not exist –> Do nothing

When no name or ID exists nothing is done to prevent numerous generic name manufacturers from being added.

Usage:

1. Select the name “manufacturer_id” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the manufacturer ID.

Values:

• Numeric

manufacturer_name

The name of the manufacturer that is related to the product. This is used in combination with the manufacturer ID. If no manufacturer ID is specified, only the name is checked. New manufacturers will be created with incremental IDs. The process of adding/updating manufacturers follows the following guidelines:

1. Name exists, ID exists –> ID is updated if different
2. Name exists, ID does not exist –> New manufacturer created with increment ID
3. Name does not exist, ID exists –> Generic name added with existing ID
4. Name does not exist, ID does not exist –> Do nothing

Usage:

1. Select the name “manufacturer_name” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the manufacturer name.

Values:

• Text: No HTML code allowed.

price_delete

The price_delete field is a special field. This field is used to determine if a price for a product should be deleted or not. This field is used when doing a multiple price upload. Before a price is deleted it needs to match the following fields:

• product_sku
• product_price
• product_currency
• price_quantity_start
• price_quantity_end

Usage:

1. Select the name “price_delete” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value Y. If the field contains any other value, the product will not be deleted.

Values:

• Y: Yes, the price is to be deleted
• N: No, the price is not to be deleted
• Empty: Empty value, the price is not to be deleted

price_quantity_end

The quantity at which the mentioned price is no longer available.

Usage:

1. Select the name “price_quantity_end” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values: Numeric

price_quantity_start

The quantity at which the mentioned price is available.

Usage:

1. Select the name “price_quantity_start” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values: Numeric

product_age

product_availability

This shows when the product is available. The value can be a descriptive text or the name of an image filename. Images must be placed in “shop_image/availability/”.
Usage:

1. Add the name “product_availability” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed.

product_available_date

The date a product will become availabable. For import the date should be in the format of day/month/year or day-month-year. On Windows systems the date goes until 19/01/2038.
Usage:

1. Add the name “product_available_date” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with a date value. If the field contains any other value, the data will be ignored.

Values:

• Date: day/month/year or day-month-year

product_box

Specify the number of items in the box.
Usage:

1. Add the name “product_box” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with the number of items in the box.

Values:

• Number

product_currency

A different currency can be specified on a per product basis.
Usage:

1. Select the name “product_currency” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value of the new currency.

Values:

• Text: No HTML allowed
  E.g.: EUR, USD, IDR

product_delete

The product_delete field is a special field. This field is used to determine if a product should be deleted or not.
Usage:

1. Add the name “product_delete” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with the value Y. If the field contains any other value, the product will not be deleted.

Values:

• Y: Yes, the product is to be deleted
• N: No, the product is not to be deleted
• Empty: Empty value, the product is not to be deleted

product_desc

Long description for the product.
Values:

• Text: HTML code allowed.

product_discount

Specify the amount or percentage of discount the product has. The values entered are exact values, no calculation is made. This is the same as if you are filling in a discount via the Product Discount List. If the discount already exists, it will not be added to the database but the product will be linked to the existing discount. The criteria for determining if a discount already exists the following values have to be exactly the same:

1. Amount, be it a total or percentage
2. Start date
3. End date

This prevents from filling the database with a huge number of the same discounts.

Usage:

1. Add the name “product_discount” to the configuration screen. The name is case sensitive and should be lowercase.
2. Optional: Add the name “product_discount_date_start” to the configuration screen. The name is case sensitive and should be lowercase.
3. Optional: Add the name “product_discount_date_end” to the configuration screen. The name is case sensitive and should be lowercase.
4. Add the chosen columns to your CSV file with the corresponding values.

Values:

• product_discount
  • Number
    e.g. 10
  • Percentage: Must include the % sign
    e.g. 10%
• product_discount_date_start
  • Date: day/month/year or day-month-year
    Day and month can be a 1 or 2 digit notation.
    Year can be a 2 or 4 digit notation.
• product_discount_date_end
  • Date: day/month/year or day-month-year
    Day and month can be a 1 or 2 digit notation.
    Year can be a 2 or 4 digit notation.

product_discount_date_end

The day the discount for a product ends. For more information see “product_discount”.

Usage:

1. Select the name “product_discount_date_end” from the dropdown menu on the configuration screen.
2. Add the chosen columns to your CSV file with the date value.

Values:

• product_discount_date_end
  • Date: day/month/year or day-month-year
    Day and month can be a 1 or 2 digit notation.
    Year can be a 2 or 4 digit notation.

product_discount_date_start

The day the discount for a product starts. For more information see “product_discount”.

Usage:

1. Select the name “product_discount_date_start” from the dropdown menu on the configuration screen.
2. Add the chosen columns to your CSV file with the date value.

Values:

• product_discount_date_start
  • Date: day/month/year or day-month-year
    Day and month can be a 1 or 2 digit notation.
    Year can be a 2 or 4 digit notation.

product_discount_id

product_full_image

The filename of the image as located in the “shop_image/product/” folder. The filename can also be a URL.
NOTE: If you have dynamic resizing enabled, you need to fill the “product_thumb_image” field. VirtueMart resizes the image specified there.

Usage:

1. Add the name “product_full_image” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with a text value.

Values:

• Text:
  • No HTML code allowed
  • URL\’s are allowed.

product_fundamental

 

Separate multiple Fundamental codes with commas. e.g.: 1,3,7 would be “Independent Play, Motor Skills, and Logical Thought.”

 

Fundamental codes:

product_height

The height of the product.
Values:

• Number

product_in_stock

The number of articles that you have in stock.

Usage:

1. Add the name “product_in_stock” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with a numeric value. If the field contains any other value, the default value will be used.

Values:

• Number

product_length

The length of the product.

Usage:

1. Select the name “product_length” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values:

• Numeric

product_lwh_uom

The measurement of length, width and height of the product.This can be inches, centimeters, etc.

Usage:

1. Select the name “product_lwh_uom” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_name

The name of the product.Values:

• Text: No HTML code allowed.

product_packaging

Specify the number of items in the package.
Usage:

1. Add the name “product_packaging” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with the number of items in the package.

Values:

• Number

product_parent_sku

The product parent sku is needed to identify the parent of child products. Please note: the “category_path” field MUST be empty otherwise the product will be treated as a parent product.
Usage:

1. Select the name “category_path” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the product_sku value of the parent product.

Values:

• Numeric
• Letters

product_price

The price for a product without currency denominator.

Usage:

1. Select the name “product_price” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a price value.

Values:

• Numeric

product_publish

The status if a product is published or not.
Values:

• Y: Yes, the product is published
• N: No, the product is not published
• Empty: Empty value, the product is published.

product_s_desc

Short description for the product.
Values:

• Text: No HTML code allowed.

product_sales

The number of products that have been sold.

Usage:

1. Select the name “product_sales” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values:

• Numeric

product_sku

The unique identifier for a product.
Values:

• Number
• Letters

product_special

When a product is set to be “On Special” it will be featured in the Featured Products block.
Usage:

1. Select the name “product_special” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value Y.

Values:

• Y: Yes, the product is on special
• N: No, the product is not on special
• Empty: Empty value, the product is not on special

product_tax_id

The ID of the tax rate that you want to apply to the product
Usage:

1. Select the name “product_tax_id” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the product_tax_id value of the appropiate tax.

Values:

• Numeric

product_thumb_image

The filename of the thumbnail image as located in the “shop_image/product/” folder. The filename can also be a URL.
NOTE: If you have dynamic resizing enabled, there still needs to be a value in this field. VirtueMart resizes the image that is specified here.

Usage:

1. Add the name “product_full_image” to the configuration screen. The name is case sensitive and should be lowercase.
2. Add a column to your CSV file with a text value.

Values:

• Text:
  • No HTML code allowed
  • URL\’s are allowed.

product_type_browsepage

This is a custom page to show your product types. Leave this BLANK if you have no individual php-file for it.

Usage:

1. Select the name “product_type_browsepage” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text:
  • No HTML code allowed
  • URL’s are allowed.

product_type_description

A description for your product type.

Usage:

1. Select the name “product_type_description” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: HTML code allowed

product_type_flypage

This is a custom page to show your product types. Leave this BLANK if you have no individual php-file for it.

Usage:

1. Select the name “product_type_flypage” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text:
  • No HTML code allowed
  • URL’s are allowed.

product_type_name

The name of the product type. This name must be unique and without spaces.

Usage:

1. Select the name “product_type_name” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_type_parameter_default

A default value to show when there is nothing else filled in for the parameter.

Usage:

1. Select the name “product_type_parameter_default” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_type_parameter_description

A description for your product type parameter.

Usage:

1. Select the name “product_type_parameter_description” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: HTML code allowed

product_type_parameter_label

A label for your product type parameter.

Usage:

1. Select the name “product_type_parameter_label” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_type_parameter_list_order

Specify in which order the product parameter is to be displayed.

Usage:

1. Select the name “product_type_parameter_list_order” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values:

• Numeric

product_type_parameter_multiselect

Set to yes to show possible parameter values as multiple select items

Usage:

1. Select the name “product_type_parameter_list_multiselect” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value Y or N.

Values:

• Y: Yes, the values are multi select
• N: No, the values are not multi select
• Empty: Empty value, the values are not multi select

product_type_parameter_name

The name of the product type parameter. This name must be unique and without spaces as it will be the column name for the parameter details.

Usage:

1. Select the name “product_type_parameter_type” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_type_parameter_type

This sets the type of parameter that will be used. There are a number of different values that can be used.

Usage:

1. Select the name “product_type_parameter_type” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value.

Values:

• Text:
  • I: Integer
  • T: Text
  • S: Short Text
  • F: Float
  • C: Char
  • D: Date & Time
  • M: Time
  • V: Multiple Values
  • B: Break Line

product_type_parameter_unit

The unit the product type parameter refers to.

Usage:

1. Select the name “product_type_parameter_unit” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_type_parameter_values

These are the values for the parameter and have to meet the requirement set by the parameter type.

Usage:

1. Select the name “product_type_parameter_values” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• This depends on the type set in the product_type_parameter_type field. All values have to be semi-colon (;) seperated.

product_type_publish

The status if a product type is published or not.

Usage:

1. Select the name “product_type_publish” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Y: Yes, the product type is published
• N: No, the product type is not published
• Empty: Empty value, the product type is published.

product_unit

The unit of the product as it is sold. I.e. box, bag, etc.
Usage:

1. Select the name “product_unit” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with the value Y.

Values:

• Text: No HTML allowed

product_url

A URL to either a picture or webpage of the product. When linked to a picture, the picture will be shown on the product details page.

Usage:

1. Select the name “product_url” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML allowed

product_weight

The weight of the product.

Usage:

1. Select the name “product_weight” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a numeric value.

Values:

• Numeric

product_weight_uom

The measurement of weight of the product.This can be pounds, kilo, etc.

Usage:

1. Select the name “product_weight_uom” from the dropdown menu on the configuration screen.
2. Add a column to your CSV file with a text value.

Values:

• Text: No HTML code allowed

product_width

The width of the product.
Values:

• Number