# Import Products

You can Import Products into the system from any Comma Separated Values (CSV) File. CSV file format is a universally accepted way to move data between systems. Most spreadsheet programs and databases can save data as a CSV text file so it is an ideal way to upload and create Products automatically in the system.

| ### Select Formatted Text File to Upload
CSV File: | Click on the [Browse] button to select a CSV text file from your local computer that contains the Products that you wish to import. NOTE: You do not need to import all the available columns.
| ### Import Options
Update Existing Products: | Select this option if you want to update (overwrite) existing Products with the same Product ID found in your import file.

##

## Import from CSV file

The easiest way is to get your data into columns in a spreadsheet. You may import Products by uploading a CSV file. You can save a CSV file from Microsoft Excel. Here are the guidelines for the CSV file:

- The first row of the CSV file must contain the names of the columns that you wish to import data for.
- You may use any number of columns from the list below.
- Columns can be listed in any order.
- If you are saving a CSV file on a Mac, you might need to select the "Windows CSV" format in Excel.

### Available Columns

Here is the list of the valid Product Properties that you can import. Place one of the following on the first row of each of your data columns:

Column | Instructions
--- | ---
name | This is the Product ID / SKU.
short_description |
full_description | Use HTML.
details | Use HTML.
code | Use HTML.
keywords |
image_name | Name of an uploaded File in the system (e.g. "example.jpg"). You can mass-upload images by uploading a zip file in the Files tab.
price | Amount without a dollar sign (e.g. "1.99", not "$1.99").
taxable | "0" to disable or "1" to enable.
selection_type | "checkbox", "quantity", "donation", or "autoselect".
default_quantity |
address_name | This is the Catalog Name.
title |
meta_description |
meta_keywords |
inventory | "0" to disable or "1" to enable inventory tracking.
inventory_quantity |
backorder | "0" to disable or "1" to enable.
out_of_stock_message | Use HTML.
required_product_id |
form | "0" to disable or "1" to enable.
form_name |
form_label_column_width | Percentage without a percent sign (e.g. "30", not "30%", leave blank for auto).
form_quantity_type | "One Form per Quantity" or "One Form per Product".
shippable | "0" to disable or "1" to enable.
primary_weight_points |
secondary_weight_points |
preparation_time |
free_shipping | "0" to disable or "1" to enable.
extra_shipping_cost | Amount without a dollar sign (e.g. "1.99", not "$1.99").
commissionable | "0" to disable or "1" to enable.
commission_rate_limit | Percentage without a percent sign (e.g. "10.00", not "10.00%").
order_receipt_message | Use HTML.
order_receipt_bcc_email_address |
email_page_id |
email_bcc_email_address |
recurring | "0" to disable or "1" to enable.
recurring_schedule_editable_by_customer | "0" to disable or "1" to enable.
recurring_days_before_start |
recurring_number_of_payments |
recurring_payment_period | "Monthly", "Weekly", "Every Two Weeks", "Twice every Month", "Every Four Weeks", "Quarterly", "Twice every Year", or "Yearly" (leave blank for none).
recurring_profile_disabled_perform_actions | "0" to disable or "1" to enable.
recurring_profile_disabled_expire_membership | "0" to disable or "1" to enable.
recurring_profile_disabled_revoke_private_access | "0" to disable or "1" to enable.
recurring_profile_disabled_email | "0" to disable or "1" to enable.
recurring_profile_disabled_email_subject |
recurring_profile_disabled_email_page_id |
recurring_sage_group_id | Recurring group ID from Sage payment gateway (0 or blank to create new group for each order)
contact_group_id |
membership_renewal | Number of days (0 or blank for none).
grant_private_access | "0" to disable or "1" to enable.
private_folder_id |
private_days | Number of days (0 or blank for no expiration).
start_page_id |
reward_points |
notes |
google_product_category |
gtin |
brand |
mpn |