I haven't had any luck with importing products using an Excel spreadsheet.
I read this page -
http://docs.abantecart.com/pages/tools/import.html and downloaded the sample "tab delimited" file for review.
When I created a simple spreadsheet in Excel and saved as tab delimited. I reopened the file, selected tax delimited and got this -
A B C A B C A B C
2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3
Very nice
Why does the sample not work the same way?
Excel imported the file, products-insert-example-tab. It looks like garbage.
"action products.model products.sku products.location products.quantity products.stock_status_id products.manufacturer_id products.shipping products.ship_individually products.free_shipping products.shipping_price products.price products.tax_class_id products.date_available products.weight products.weight_class_id products.length products.width products.height products.length_class_id products.status products.viewed products.sort_order products.subtract products.minimum products.cost product_descriptions[0].language_id product_descriptions[0].name product_descriptions[0].meta_keywords product_descriptions[0].meta_description product_descriptions[0].description product_descriptions[1].language_id product_descriptions[1].name product_descriptions[1].meta_keywords product_descriptions[1].meta_description product_descriptions[1].description products_related[0].related_id products_to_categories[0].category_id products_to_categories[1].category_id products_to_categories[2].category_id products_to_categories[3].category_id products_to_downloads[0].download_id products_to_stores[0].store_id product_options[0].product_option_id product_options[0].attribute_id product_options[0].group_id product_options[0].sort_order product_options[0].status product_options[0].element_type product_options[0].required product_option_descriptions[0][0].language_id product_option_descriptions[0][0].name product_option_descriptions[0][1].language_id product_option_descriptions[0][1].name product_option_values[0][0].product_option_value_id product_option_values[0][0].group_id product_option_values[0][0].sku product_option_values[0][0].quantity product_option_values[0][0].subtract product_option_values[0][0].price product_option_values[0][0].prefix product_option_values[0][0].weight product_option_values[0][0].weight_type product_option_values[0][0].attribute_value_id product_option_values[0][0].grouped_attribute_data product_option_values[0][0].sort_order product_option_value_descriptions[0][0][0].language_id product_option_value_descriptions[0][0][0].name product_option_value_descriptions[0][0][0].grouped_attribute_names product_option_value_descriptions[0][0][1].language_id product_option_value_descriptions[0][0][1].name product_option_value_descriptions[0][0][1].grouped_attribute_names product_option_values[0][1].product_option_value_id product_option_values[0][1].group_id product_option_values[0][1].sku product_option_values[0][1].quantity product_option_values[0][1].subtract product_option_values[0][1].price product_option_values[0][1].prefix product_option_values[0][1].weight product_option_values[0][1].weight_type product_option_values[0][1].attribute_value_id product_option_values[0][1].grouped_attribute_data product_option_values[0][1].sort_order product_option_value_descriptions[0][1][0].language_id product_option_value_descriptions[0][1][0].name product_option_value_descriptions[0][1][0].grouped_attribute_names product_option_value_descriptions[0][1][1].language_id product_option_value_descriptions[0][1][1].name product_option_value_descriptions[0][1][1].grouped_attribute_names product_specials[0].product_special_id product_specials[0].customer_group_id product_specials[0].priority product_specials[0].price product_specials[0].date_start product_specials[0].date_end product_tags[0].tag product_tags[0].language_id product_tags[1].tag product_tags[1].language_id product_tags[2].tag product_tags[2].language_id product_tags[3].tag product_tags[3].language_id resource_map[0].resource_id resource_map[0].object_name resource_map[0].object_id resource_map[0].default resource_map[0].sort_order resource_library[0][0].resource_id resource_library[0][0].type_id resource_descriptions[0][0][0].language_id resource_descriptions[0][0][0].name resource_descriptions[0][0][0].title resource_descriptions[0][0][0].description resource_descriptions[0][0][0].resource_path resource_descriptions[0][0][0].resource_code resource_descriptions[0][0][1].language_id resource_descriptions[0][0][1].name resource_descriptions[0][0][1].title resource_descriptions[0][0][1].description resource_descriptions[0][0][1].resource_path resource_descriptions[0][0][1].resource_code resource_map[1].resource_id resource_map[1].object_name resource_map[1].object_id resource_map[1].default resource_map[1].sort_order resource_library[1][0].resource_id resource_library[1][0].type_id resource_descriptions[1][0][0].language_id resource_descriptions[1][0][0].name resource_descriptions[1][0][0].title resource_descriptions[1][0][0].description resource_descriptions[1][0][0].resource_path resource_descriptions[1][0][0].resource_code resource_descriptions[1][0][1].language_id resource_descriptions[1][0][1].name resource_descriptions[1][0][1].title resource_descriptions[1][0][1].description resource_descriptions[1][0][1].resource_path resource_descriptions[1][0][1].resource_code resource_map[2].resource_id resource_map[2].object_name resource_map[2].object_id resource_map[2].default resource_map[2].sort_order resource_library[2][0].resource_id resource_library[2][0].type_id resource_descriptions[2][0][0].language_id resource_descriptions[2][0][0].name resource_descriptions[2][0][0].title resource_descriptions[2][0][0].description resource_descriptions[2][0][0].resource_path resource_descriptions[2][0][0].resource_code resource_descriptions[2][0][1].language_id resource_descriptions[2][0][1].name resource_descriptions[2][0][1].title resource_descriptions[2][0][1].description resource_descriptions[2][0][1].resource_path resource_descriptions[2][0][1].resource_code"
"insert 558003 testsku 99 1 0 0 0 0.0000 29.5000 1 2011-08-29 75.00 2 40.00 25.00 15.00 0 1 8 1 0 1 0.0000 1 Skinsheen Bronzer Stick ""<p>"
" Bronzes"