Import Product + Options

-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5
-- PHP version -- : 7.0
-- Browser(s) name and version -- : Firefox

I have a list of products that is upwards of 500,000+ items. I would like to import these products in one large batch or several segmented batches but I honestly don't know the first step or series of steps I should take to make that happen. Below are some key things I think would be helpful to make this import successful:

- I would like to import them and assign them to their specific category and brand
- Many of the products I am importing have a primary item description and then several options with them so I want to auto-assign the option to the primary
- Many of the products have varying characteristics

Can someone tell me the best approach to take?

Do I need to add all of the characteristics first or if they are missing will they be added automatically?
Is it possible to import the brand? I have over 800
Do I need to add all of the categories first or if they are missing will they be added automatically?
Is there a format/template already ready to go? I did an export of my existing test products and brand was not there, option was not there....

James

Hi!

I'm a bit in the same boat and have issues importing a car catalogue containing brands (which in my current installation is at the same level as product categories under root) lots of options such as engine position, engine cc, engine type, etc.
I am really wondering what is the best approach to import such a big amount of data and how to article the DB to make it efficient and working.
So far I am not been able to import anything. The categories get created automatically but that's it. For what it's worth my original csv file has the following headers:
model_id,model_make_id,model_name,model_trim,model_year,model_body,model_engine_position,model_engine_cc,model_engine_num_cyl,model_engine_type,mode_engine_valves_per_cyl,model_engine_power_ps,model_engine_power_rpm,model_engine_torque_nm,model_engine_torque_rpm,model_engine_bore_mm,model_engine_stroke_mm,model_engine_compression,model_engine_fuel,model_top_speed_kph,model_0_to_100_kph,model_drive,model_transmission_type,model_seats,model_doors,model_weight_kg,model_length_mm,model_width_mm,model_height_mm,model_wheelbase,model_lkm_hwy,model_lkm_mixed,model_lkm_city,model_fuel_cap_l,model_sold_in_us,model_make_display_name

Some guidance would be really appreciated as whether I need to create everything as a characteristics (and therefore manually input all the options?) or maybe custom fields work better, or maybe there is a third option?

Thank you in advance.

Fred

Ok, I got that already but I'm still struggling with a few issues. For example brand is not part of the product table by default. I installed a "hikashop" template and have the following structure:

hi!
ok, sorry I missed that product_manufacturer_id was linked to the brand. Thank you for the reminder.

For 2, if I wish to be able to sort the products by those fields I'll have to enter each value then?

Thank you.

Hi again!

So I managed to do my import \o/ and I am not wondering how can I do to sort my products by feature (or should I import differently basically?). For example let's say I have 600 cars, visitors will want to sort out products in order to see what they really want. I've tried to look at that through the demo website but couldn't find what I was looking for.
At this stage i am not really sure what would be those criteria but I guess doors count, year, price, brand, seat counts and maybe other things. Should I make those features stand apart like Brands is currently appearing in the back office, or there is a way to make a sort/filter through those fields? And if so how do I do that?

Thank you.

ps: also how do you make the category and brand appear in the product description?

Ok thank you very much, that clarifies a lot of things which were unclear for me.

Now let's say I've imported all my car types and I'm starting to set up the logic of the store where people come to post cars they want to sell. They chose one of the many models I have imported and add to it characteristics such as color, mileage, price they want to sell.

How can I also have one of these parameters as a filter, let's say for example mileage and price?

Thank you.