Please verify that you have the fields below in the following order in your CSV document. Also, be sure to check your documents for any of the restrictions listed.
| Product ID | Always | No | The productID column must be included in your import file, but may be left blank unless you want to update a product's name. (Leave blank if you are creating a new product) |
| Name | Always | Yes | Max: 150 characters For variation products, put the desired master/parent product name first and then list your variation group and the option for that group using a semicolon (;) to separate those and pipe (|) to separate the product and each option. (ie. Variation Master| Size| Large; Color| Red;) |
| Short Description | | No | Max: 255 characters |
| Long Description | | No | |
| Part Number | | No | Max: 50 characters |
| Quantity In Stock | | No | Min: -9,999,999 Max: 99,999,999 |
| Unlimited Stock | | No | TRUE or FALSE (defaults to FALSE) Automatically included on exports if Quantity in Stock is selected. |
| Reorder Level | | No | Min: 0 Max: 99,999 |
| License Option | | No | TRUE or FALSE (defaults to FALSE) Only applies to E-Products |
| Download Limit | | No | Min: 0 Max: 99,999 Only applies to E-Products |
| Instructions | | No | Only applies to E-Products |
| License Keys | | No | Only applies to E-Products. Separate individual keys using semicolons (;). |
| Store Cost | | No | Min: 0.00 Max: 999,999.99 |
| Customer Price | New Products | Yes | Min: 0.00 Max: 999,999.99 |
| MSRP | | No | Min: 0.00 Max: 999,999.99 |
| Handling Cost | | No | Min: 0.00 Max: 999,999.99 |
| Minimum Order Quantity | | No | Min: 1 Max: 99,999 |
| Maximum Order Quantity | | No | Min: 0 or min. order qty. Max: 99,999 |
| Weight Major | | No | Min: 0 Max: 99,999 (For example, for a 3 lbs. 6 oz. product the Weight Major is 3) |
| Weight Minor | | No | Min: 0 Max: 15 (For example, for a 3 lbs. 6 oz. product the Weight Minor is 6) |
| Length | | No | Length of the product (used in dimensional weighting) |
| Width | | No | Width of the product (used in dimensional weighting) |
| Height | | No | Height of the product (used in dimensional weighting) |
| Manufacturer Part Number | | No | Max: 50 characters |
| Manufacturer Name | | No | Max: 150 characters |
| Categories | New Products | Yes | Min: 1 category. Use tildes (~) to select subcategories and semicolons (;) to separate categories. (ex. Category 1 ~ Sub category;Category2) |
| Warehouse | | No | Enter the name of an existing warehouse or one you would like to create and it will be assigned to this product |
| Category Special | | No | TRUE or FALSE (defaults to FALSE) |
| Homepage Special | | No | TRUE or FALSE (defaults to FALSE) |
| Shipping Option | New Products | No | S - Shippable, F - Elligible for free shipping, N - Shipping not required. Note: all new Gift Certificates and E-Products are set to 'N' since they cannot be shipped. Regular products are defaulted to 'S'. |
| Tax Free | | No | TRUE or FALSE (defaults to FALSE) |
| Product Type | | No | S - Standard Product, G - Gift Certificate, E - E-Product. Note: all new E-Products will import as disabled. You will need to enable them once you have uploaded an associated file. (Defaults to 'S') |
| Related Products | | No | Enter the name of existing product(s). The product must exist in the database currently or in your import sheet, and each product must be separated semicolon (;) (ie. Product1; Product2;) |
| Page Layout | | No | Enter the name of an existing page layout to use. |
| Product URL | | No | Should include "http://" and your domain name, followed by the Product Page Name. (For Example: http://networksolutions.com/product.aspx) |
| Thumbnail Path | | No | Path to an image on your site that already exists (For example, /images/product.jpg) |
| Medium Image Path | | No | Path to an image on your site that already exists (For example, /images/product.jpg) |
| Large Image Path | | No | Path to an image on your site that already exists (For example, /images/product.jpg) |
| Meta Title | | No | |
| Meta Description | | No | |
| Meta Keywords | | No | |
| Sort Order | | No | |
| Enable | | No | TRUE or FALSE (defaults to FALSE) |
| Purchasable | | No | TRUE or FALSE (defaults to TRUE) |
| Price Message | | No | |
| Shipping Message | | No | |
| In Stock Message | | No | |
| Out Of Stock Message | | No | |
| Variations | | No | Use tildes (~) to separate variation groups, pipes (|) to delimit group names from options and (;) to separate options. (ex Size| Large; Medium; Small; ~ Color| Red; Blue;) |
| Attributes | | No | Format: Name=Value with semi-colons (;) as separators. For multi-value attributes, values should be separated by comma (,). Any name or value containing any character other than letters and numbers must be quoted. Examples: "ISBN-13"=2381739274901; Color=Red, Blue, Green; (multiple values) "Bin-Location"="1289-48", 121, "Back Left"; (multiple values) Author="Smith, Jones, et all" (Single Value) |
| Errors | | No | This holds the errors, if any, that are returned after importing. This field is not required. but will be added to the error report if there are any errors are encountered. |
| Delete | | No | TRUE or FALSE (defaults to FALSE. Set to True if you would like to delete this product) |
. However, this blog is not an official property of MC nor our parent company Network Solutions. I'm simply testing out a few things. My goal is to distribute information that should be helpful to small business owners and ecommerce web developers and to share new ideas I learn on a daily basis.
encourages its team members to maintain personal websites and respects their right to self-expression via 