Import Variants - CSV Help Please

Hi,

I am trying to import a complete list of products(books)which have variants of either Paperback or Hardback. I have created a charateristic called "Format" with the two variants. I am struggling to get the variants imported, or at least associated with a main product, but im wondering if its because of the product_parent_id im using although I have tested with different numbers

I have attached my import file,to see if anyone can point me in the right direction.

On another note - is it easy to upgrade from the free version to the full version?

Thanks

Dave

Hi dlarge,

You csv seems not to be well formatted, I suggest you to export your existing products to have a csv model. Then edit this csv to import your new variants.
Some documentation about csv:
www.hikashop.com/en/support/documentatio...shop-import.html#csv

To upgrade, you just have to install the business version in the extensions manager of Joomla, and it will work.

Hi Thanks for your reply,

I had followed the documentation but was unclear about certain things, but I have followed your instructions and seem to have got what i want(ish) now.

I have another question regarding variants - As I said previously a lot of my products will have two variants - named paperback and hardback, but some products will only be available in paperback. I would like on the product item page for it to say just paperback so thought I could just add one variant and then when i click on the item it would say Format(which is the charateristic) and then one radio button with paperback - is this possible to do? Should I be looking at the business edition so I can add custom fields? With the custom fields would I be able to add fields like author and then display them on the item page?

Thanks

Dave

Hi,

For the products having only one variant, it mean that there is only on product, so why adding a variant ?
You can just create a custom field with the type product to set the Format.
And yes, with the business edition you can add fields like "author" which are displayed on the item page.

Ok here's my dilema, im trying to work out the best way to display whether the books are paperback or hardback, which is easier enough when the book has both options, but dont know how to display "paperback" when its the only option.

It seems that I cant add a custom field with the type product in the free version - when i click new custom field it defaults to the address table and I cant change it. My other worry then if I was able to add a custom field - would i be able to disable the view of this for the variant products otherwise i will be displaying the custom field with the word paperback and then the words paperback or hardback from the variant options. i hope im explaining what i mean here...

So I cant figure out how I can display "paperback" in the product item page unless I put it in the description. I would like it in the same place as when I have variants enabled.

Many thanks for your help and patience.

Dave

For the products which are only "paperback", just create a custom field on the table product.
For the products with variants "paperback" and "hardback", add the variants.

To display the custom fields only on the "paperback" product, create a category, display the custom field only for this category, and add this category to your "paperback" products.
By this way the custom fields will only be displayed on the "paperback" products.

To have the same display than when it's variants, you just have to customize your product page by editing some css properties in HikaShop > Configuration > Display "frontend css file".

Ok thank you for your help.

I'm just being a little dim here - Can you confirm that I can only create a custom field on the table product in the full business version and not the free one. Unless your talking about adding the custom field within sql? I dont get a drop down box to change from the address table to the product table on the display,custom field page.

Other than the above clarification im good to go - so thank you very much for your help. Great Support

Dave