Resolved Import product child, atributtes, parent from VM1

Hello,

The product attributes as they existed in VirtueMart 1 no longer exist in VirtueMart 3, you will have to find another way of storing those attributes. The new thing in VirtueMart 3 is Multi Variants. However you will need CSVI 6 to import the multi variants. You will need to do a conversion once you figured out how you want to use child products in VirtueMart 3. There are a number of ways of doing it and you just need to see which one fits your needs the best.

Basic child products are imported by using the product_sku and product_parent_sku fields. Where the parent SKU is the SKU of your parent product. The parent product must be before the child products in your import file.

Hello Roland,
I can instal a "CSVI 6 Beta" simultaneus with CSVI 5 Pro? Or "CSVI 6 Beta" replace CSVI 5 Pro?
Maybe I have a little confussion about parent products, children products and attributes. I'm not sure if the problem are the attributes or the other...
I have the child products (parent) imported to Virtumart 3 but they are a different product than the Father Product not a size or option from it. It's difficult to explain for me but I try with an example:

In Virtuemart 1.1.9 I have a Father product named Estor Safari Azul and into it they are 6 copies of this product in 6 differents sizes and prices. The image was the same for all products. (I adjoint a screen capture)

Now, in Virtuemart 3 I have only a Father product without differents sizes and prices. It not show any size and show the low price of the differents sizes because is a default price in a Father product. (I adjoint also a screen capture)

Thanks for your help
Kind regards

Hello,

I can instal a "CSVI 6 Beta" simultaneus with CSVI 5 Pro? Or "CSVI 6 Beta" replace CSVI 5 Pro?

You cannot install CSVI 6 and CSVI 5 at the same time on the same site. You can replace CSVI 5 with CSVI 6

Before I continue with your example. Looking at your screenshot of VirtueMart 1, that layout is a customization, so it will never look like that in VirtueMart 3 unless you customize it.

Now your example. In VirtueMart 3 they introduced Multi Variants, this is the equivalent of the attributes in VM1. Here is Multi Variant tutorial on how to use with CSVI 6. Have a look at that and see if you can use that. You can always create a first product by hand of course to see how things work in VirtueMart.

There is an alternative, Stockable Custom Fields however CSVI doesn't support it yet. I am working on implementing support for this extension.

Hello Roland,
I would do step by step. At the moment I will try only to import a derivate products (Chlidren products), not attributes. I thinks I can do it with CSVI 5 Pro. Is correct?

I see that I imported ok the SKU of derivated products but they aren't associated with the principal product. A derivate product are showing as a different product ( not like a size or talle of the principal product). Then each SKU of same product belongs to a diferent size have a different price (that's ok) but they haven't a description (customer can't see the size) and they not shows the image. I think I do the export/import right. Maybe I need include more fields. For me will be ok that the child products appears like another product in some cases but I need they show the description (size) and the image. It's possible? Can you help me?
Another question: I can associated a derivate product with a principal product using CSVI 5 Pro? If that's possible will be the best solution.
Thanks a lot for your help.
Kind regards

Hello,

I will try only to import a derivate products (Chlidren products), not attributes. I thinks I can do it with CSVI 5 Pro. Is correct?

Correct, you need at minimum the fields product_sku and product_parent_sku. This is the most basic type of child products. Since you don't have any color selection whatsoever.

Another question: I can associated a derivate product with a principal product using CSVI 5 Pro?

You can use the related_products field to show these releated products.

Perhaps you can install the VirtueMart sample data and see how VirtueMart uses the different kind of parent/child products. You can export these products and see the way it is structured in the export file.

Hello Roland,
I see that the fields "product_parent_sku" are empty when export from Virtuemart 1.1.9. A Child products have a "product_sku" but no a "product_parent_sku". The image is only in a Principal Product.
I adjoint a screen capture of product and product child from Virtuemart 1.1.9. The principal product has a "product_sku" and the children products are also a "product_sku" (Not a "product_parent_sku"
The children products have a custom_field (campo personalizado) named "Cualidades" with the label "Medidas" and in this field they are the size.
Thanks!
Kind regards

Hello,

A Child products have a "product_sku" but no a "product_parent_sku".

The product_parent_sku is not visible on the edit screen of VirtueMart. You will see it when you do the export. The SKU of the principal product is the product parent SKU of the child products.

Hello Roland,
I have the parent products and child products imported but they are showing as a different and independent products. The parent product has a image but has not a price. And the child product have not a image but have a price... I thinks this is because I made a incorrect import of products on the beguinin.

My question is: I must to delete all products and information and repeat the export-import from zero or I can arrange it without delete the products that I have now imported? For example, I can import only the fields product_sku and product_parent_sku and then will be arranged the products? After this, I will show a child products into the parent products?
I'm not sure if chlid products on Virtuemart 1 are the same than Size on Virtuemart 3...

Thanks for your patint help
Kind regards

Hello,

I have the parent products and child products imported but they are showing as a different and independent products.

Something has been setup wrong then, without the required information I can't tell.

I must to delete all products and information and repeat the export-import from zero or I can arrange it without delete the products that I have now imported?

You don't need to delete the products, they will be updated once you run a new import.

For example, I can import only the fields product_sku and product_parent_sku and then will be arranged the products?

That should be OK.

I'm not sure if chlid products on Virtuemart 1 are the same than Size on Virtuemart 3...

I am not sure what you mean by that. VM3 has different ways of dealing with child products, you will need to see which way fits your needs. Just the new type Multi Variant is only supported by CSVI 6.

Hello,
I imported a parent and child products. They are imported as a independent product but at the moment is not a problem for me. It's OK, they have prices, images and all information.

But I did something and now the prices of the products that they haven't a parent sku are empty. I tried to import the prices for this products but I can't. I don't understand. Appears a message that say "Not find the product_sku" but the field is in the csv file and the separate fields are ok. I use ~ to separate fields and ^ for enclosure text. These are the same in csv file and import template.
I did a lot of tests and I no find the solution. Can you help me?
Note: I can't install the "com_csvi_6.0beta4_pro"
Thanks!
Kind regards

Hello,

"Not find the product_sku"

That could also mean that the fields in your template are not in the correct order. Without the debug log and CSV file I can't help further.

Note: I can't install the "com_csvi_6.0beta4_pro"

Don't install it, the latest version is beta 6. You should install that.

Hello,
In Downloads section I can't find the component or extension beta6, I find only a plugins but not the component.
I can't to send you a last debug log because I not donlowed it. But I addjoint a debug log zip of one previous importation of this morning. Maybe with it can see something wrong.
Thanks
Kind regards

Hello,

I can't find the component or extension beta6

click extension click VirtueMart addon

Now I have'nt any CSVI extension because after try to isntall 6beta4 the CSVI 5 Pro desapears in my Joomla

You can't install CSVI 6 on top of CSVI 5. Most likely you have a broken installation now. You can check the Uninstall CSVI page. To clean things up.

The debug log only shows me the message it can't find the product SKU, without the CSV file I find it hard to understand what is going on.

Hello,
I have againt installed csvi 5 pro, runs ok and I have the past information :-). I tried again to import and without succes. I adjoint the last csvi file and the last debug file
Thanks

Hello,

Ok all good again

Well your columns are in the wrong order, check the fieldnames in your template and the fieldnames you have in your CSV file, they do not match. First in your template is product_parent_sku, first in your CSV file is product_sku. The same goes for all other fields. So, fix that first and then try again.

Hello,
I try again but not runs. Price products are not updated. I adjoint log
NOTE: I try to install the csvi6 and not runs. (Before I remove the database csvi and unisntall the version 5 Pro) Then I can't install any csvi. Not csvi 5 pro and not csvi 6. I restore the web backup and now I can work again.
I will try again to import prices with different csv files, but if you are somme idea that can be the error I will be thankfulled for your help
Kind regards

Hello,

Not csvi 5 pro and not csvi 6.

Are you running Joomla 3.4.1? That is required for CSVI 6. If you have 3.4.1, what error do you get on installation? Make sure you install the component before the addon.

For all products I see this:

Child product and empty price, not adding so it will take the price of the parent product

That means your column configuration is incorrect (assuming this since there is no CSV file). Make sure the columns in your template match the columns in your CSV file.

Hello,
Finally I can import prices :-) I adjoint a example of csv file that I used now. It runs ok. Maybe the problem before was that I used a lot of fields, I'm not sure...

Now, they are only one think different thnat the original web in Joomla 1.5.26 with Virtuemart 1.1.9. In the original web they are a parent product and into it they are the clild products. For example, the parent prodyct and child product are the same name, only change the measures. Now, parent products and child products are imported as a independents products, the parent product is showing without price and the child products of it (the same product with different measures) I adjoint two images. ¿Is possible solve it or the difference is because now I use a responsive template and the old template was not responsive?
Thanks for your help

Hello,

Now, parent products and child products are imported as a independents products

You need to set the product_parent_sku for the child products to make them related. Did you do that?

Just the layout of your old site is customized, so if you want the same layout, you will need to modify your site template.

Hello,
I can't install CSVI 6 or I not donlowad the correct file:
This is the error thay I see after try install it

Advertencia

Unknown column 'csvi_setting_id' in 'field list' SQL=INSERT IGNORE INTO `[color=#bb0000]prefix[/color]_csvi_settings` (`csvi_setting_id`, `params`) VALUES (1, '');

Thanks for your help
Kind regards