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:

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