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