Question about csv inport with variants?

  • Posts: 96
  • Thank you received: 14
12 years 11 months ago #37616

I'm still strugglin with the understanding of the perfect and shortest way to import an absurdly large list of products in my hikashop.

I want to export a csv of a similar product to use it as a template for the others. is this posible?
I have lots of products with variants and diferent prices/images for each variants and i want to add them in bunches.
By now i have realized that for the way i'm organizing my store is not to good to import 9000 product at once and knowing that i have to create the variants by hand i think the best way to go is:

1) Create the variants the product category contains.
2) Prepare the csv of that category in particular
3) Import the csv
4) Repeat 1,2,3 untill finish the store.

But i haven't understood the suggestion on this post link

-Lets say i have a "Wires and accessories" with ID 91 and a subcategory called "Wires" with ID 166
-In the "Wires" Category there will be products only with max two caracteristics, Diameter and Color
-The products in the "Wire" Category can contain one of those caracteristics, both, or none of them
-Each variant have its own SKU code and in some cases they could have a diferent image diferent from the one on listings.

so, is this sintax for the csv correct considering a Sample Wire in three diferent colors with 5 diferent diameters?:

Is this going to:

-Create a product with the name of "Sample Wire" and a code of sw-81
-Asign the color caracteristic to it
-Asign the diameter caracteristic to it
-Asign a diferent price as indicated for each variant
-Modify the product_code for each variant
-Change the image for the variants as desired

I dont want to mess everithing up when i begin importing my products, i need to find the right method to do this.
I have too many products with a lot of diferent caracteristics and sometimes i think this is simply impossible to automate.

I need to do it organizedly because i want to have some kind of coherence between my spreadsheets so i can use them to automate the creation of the printed catalog directly in indesign with the datamerge tool.

If i achieve this i will write a neverforget tutorial on catalog automation. ;-)



Thanks in advance

Attachments:
Last edit: 12 years 11 months ago by protorob.
The following user(s) said Thank You: Karloz

Please Log in or Create an account to join the conversation.

  • Posts: 96
  • Thank you received: 14
12 years 11 months ago #37652

I've found the export tool... it was so obviously placed at the top of the product listing on the admin pannel.
Form now on is very very simple to import products

I'm so happy!

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum