Hanging on import

-- url of the page with the problem -- : ckdev.info/safety
-- HikaShop version -- :2.2.3
-- Joomla version -- : 3.2
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Chrome 31.0.1650.63 m
-- Error-message(debug-mod must be tuned on) -- : Can't see any

I have a potential client who has a database of 60k + products. Obviously this would be a crazy job to manually enter. He sent me an export of his inventory in Excel. Unfortunately it is over 30Mb so I can't import in one hit.

As I had never done any import before, I cut and pasted out a very small section of the Excel file (attached). However, when I try to import, HS just sits there thinking and thinking and nothing happens. Having told him, based on what I have read on your site, that HS can import Excel files, I'm not embarrassed it isn't working on such a tiny file.

Is there more I need to do in HS before trying to import? It is a brand new installation with absolutely no mods.

EDIT: After a very long time - well over 10 minutes - I finally got a 500 error.

Ah, what a dummy! Was trying to import a standard Excel file. Saved as a CSV, but every column gave an error like this (this is the first column):

The column 'itemno' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_display_quantity_field | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored

I understood (maybe incorrectly) from the tutorial that HS made any columns it didn't have as stock standard. Am I missing a step? I have attached the CSV file.

Hi,
The best solution will probably be to :
- Create some products and categories manually
- Export them through a CSV file so that you'll be able to know the exact structure that your CSV file needs to have
- Make sure that your CSV file have a good structure and import it back.

Done that. HS CSV export is so different to the original there's no way this will work. Guess I'll have to use something else.

Hi Nicolas

That's not at all what I got from his post but no matter. The HS exported file structure is so vastly different to the one I attached that I may as well enter every product manually. It would probably be quicker and easier than trying to ewrite the CSV file the client gave me.

As you can see from the attached file (what I exported from HS after adding just one product and one category), the only similarity between the 2 files is that they're both CSV. From there, they are as different in structure as night and day. The HS one doesn't even have column headings. It was not at all what I expected to see after reading the documentation.

Cannot see where to do that.

I see no column headings in HS export file. Not in the sense of Excel column headings anyway. Maybe that great long string of names is considered column headings in cell A1.

Again, the structure is not even vaguely alike - I'm looking at both files in Excel - screenshots of what I see are attached.

Even using the Import function from the Data tab makes no difference. I see EXACTLY the same as before. I'm sure the import routine works, it just isn't going to for me. Don't know why, and I have a client who wants me to get going.