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. |
| 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_quantity | |
| backorder | "0" to disable or "1" to enable. |
| out_of_stock_message | Use HTML. |
| 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. |
| recurring | "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). |
| membership_renewal | Number of days (0 or blank for none). |
| notes | |
| gtin | |
| brand | |
| mpn |