Author Topic: Importing products  (Read 1647 times)

Offline alevene

  • Full Member
  • ***
  • Posts: 104
  • Karma: +6/-7
    • View Profile
Importing products
« on: September 12, 2016, 12:22:19 PM »
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"



Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 3777
  • Karma: +184/-0
    • View Profile
Re: Importing products
« Reply #1 on: September 13, 2016, 01:25:41 AM »
Hi. Excel sometimes donot open CSV correctly.

Try free Open Office software
“Chuck Norris is so amazing.”
― Mother Teresa

Offline alevene

  • Full Member
  • ***
  • Posts: 104
  • Karma: +6/-7
    • View Profile
Re: Importing products
« Reply #2 on: September 13, 2016, 07:42:26 AM »
Thank you. Will do.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 3777
  • Karma: +184/-0
    • View Profile
Re: Importing products
« Reply #3 on: September 14, 2016, 01:44:33 AM »
Actually you can use Excell but it not show delimeter wizard when open so you need to do this in another way
In my excell version I need to open Excell then choose Import select my file and wizard ask about CSV parameters. If just double click and open CSV excell do this wrong way.  ::)
http://superuser.com/questions/407082/easiest-way-to-open-csv-with-commas-in-excel
“Chuck Norris is so amazing.”
― Mother Teresa