Import of products and variants price not working

-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3.3.1
-- PHP version -- : 5.4.3

Hi there I am trying to import a .csv with my products and their variants/characteristics and while I have managed to get the product in and its variants are there, there is no price being associated to each variant and the product code is changing on import and we have specific codes setup for each variant of each product already and would like them to stay the same, I have been testing with a single product my .csv for this product is attached.

Hi,

Few fixes have been made recently and are available in the version 2.3.2 of HikaShop, thanks to download it from our website and test with this new version.

Hi, thanks for the reply. but I have tested on the new version of hika shop and unfourtunatly I still get the same results e.g no price being entered for variants and also the product code does not stay the same as what is in my .csv. did you look over my .csv? is it formatted correctly? I referred to the documentation and as many posts as I could find on the subject of importing variants and as far as I can tell my .csv should work.

Can someone please clarify? I'm starting to get close to my deadline for getting this working. So a prompt reply would be greatly appreciated.

Thanks in advance

Hi,

When looking at it the first time it seemed to be correct but there is few errors.
- The first variant "Amyris0" got the same product code than the main product.
- You have to use the product code of the main product and not its name for the parent_product_id column
- The file was not correctly formatted, probably the breakline which were not correct.

Thanks to try that file:

Hi Xavier, thanks for the reply yes that file works correctly and from it I have formatted the rest of my products in the same way and almost everything works perfectly except now my products are not being assigned to a category but the variants and prices are all correct. could you have a look at this file and tell me what I might be doing wrong? Thanks and even though I'm having these few hold ups I'm still impressed by your software much better than VM

Hi thanks for the reply, I've managed to get the import sorted now, so thank you very much for that. But I'm having trouble setting up the filters for the store now. I simply need a filter that searches all products on their name, description and product_code no matter what page/category i am in. is there a simple way to do this? i have read the documentation and forum posts but am striggling to get it to display products, whenever i filter i get a list of categorys.

Thanks

Hi thanks for the reply, Unfortunately I have tried to do as you suggested but now I just get a completely blank page no matter what I search for. I could do with help getting this sorted as its the last thing I need to do before going live.

Thanks

Hi so i got a list of products showing and the search works on the name field and product description, but when i search on the product code it doesn't show products who's variants/characteristics are the same as the product code i search for any way to change this?

Hi,

Thanks to give us a screenshot of your search module settings, and another one for the settings of your selected product listing menu.

Hi, thanks for reply I think this is what you mean?

Am iI going to get a reply to this thread at all either?

Just came across this thread while investigating how to get the filter to work on variant product codes.

Appreciate it might be a bit resource intensive but the example you cite Nicolas is quite extreme. My shop has about 80 products with about 10 variants each so resources shouldn't be a problem, but it means filtering by product code is useless if you have variants.

I would very much like to see this facility added, we can then decide for ourselves whether to use it or not.

Thanks,

Ian

Yes as a workaround that would do it, and it would be ok if I maintain the site myself but when I hand it over to the customer it's extra maintenance and not in my view an acceptable solution for a system that is supposed to be easy to use. Why not just add the capability to filter on variants?

Ian

Hi Nicolas,

I had a similar problem with search some time ago in a site using another cart, all the filter needs to do is find the product code of the variant and then return the product code of the parent, everything else is as if you had filtered for the parent. I don't see that as being overly complicated.

Thanks for the offer but on principle I'm not sure I'd be willing to pay for a plugin to include functionality that should already be there, and it would still be a very untidy workaroud.

Regards,

Ian