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 |