Hello,
I need import product child and atributtes. The origen is a Joomla 1.5.26 with Virtuemart 1.1.9. I have CSVI 5 Pro (No 6 Beta).
I wish to import this to new Joomla 3 with Virtuemart 3. The products are yet imported ok but no the derivate products (or child products)
How I can export that from VM 1.1.9 and export the csv field to VM3? Do you know the field names in both virtuemart versions?
Thanks for your help
Kind regards
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
prefix_csvi_settings(csvi_setting_id,params) VALUES (1, '');
Thanks for your help
Kind regards
Hello,
This error happens if you have the incorrect table in the database. Please uninstall CSVI 6 and remove the prefix_csvi_settings table and then install CSVI 6 again, see how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
I remove the prefix_csvi_settings table but I can't install. Apears another errors like this:
Advertencia
Unknown column 'csvi_log_id' in 'field list' SQL=SELECT csvi_log_id FROM it2rb_csvi_logs ORDER BY csvi_log_id
Thanks for your help
Kind regards
Hello,
Not sure what has happened with your installation but I recommend doing a clean installation of CSVI. See the Uninstall CSVI tutorial on how to remove CSVI completely. It is important to remove all the tables from the database before doing a new installation.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
I repeat the proces step by step following the tutorial and I install the csvi 6. I install after the plugin CSVI PRO Virtumart. It see that all it's ok but the component interface in not the same, it appears rare. Then I try uninstall all but I can't unistall the pluguin CSVI PRO Virtuemart. Then I try to install again the csvi 5 pro stable but I can't. I remove all csvi tables from PHPMyadmin and finally I can install again the csvi 5 pro stable. At the moment I prefer wait a CSVI 6 Pro stable version because with the CSVI 5 Pro I'm fine. I would like to use the CSVI 6 only in order to do that the derivate products are inside the principal products. I think this is only possible with the CSVI 6.
Now I have imported ok the principal products and the derivate products. But I can't see the derivate products. I would like that the derivate products are only accesible from the principal product with a drop down list. I know how to do it if I create the derivate products from the principal product, but I don't know how I can do it if the derivate products exist. Is possible to do it? Or I must to do it manually, creating the derivate products from each principal product?
I adjoint a images in order you can understand better the solution that I wish.
Thanks for your help. Kind regards
Hello,
I install after the plugin CSVI PRO Virtumart. It see that all it's ok but the component interface in not the same, it appears rare.
The interface has changed between CSVI 5 and CSVI 6.
At the moment I prefer wait a CSVI 6 Pro stable version because with the CSVI 5 Pro I'm fine.
That is OK, CSVI 6 stable won't be much of a difference to CSVI 6 RC1.
Let's start at the beginning, can you create the derivate products manually in VirtueMart and make them show up as a dropdown?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Rolland,
Let's start at the beginning, can you create the derivate products manually in VirtueMart and make them show up as a dropdown?
Yes, in my last post I adjoint an image like this. Also they are information in this links (In Spanish)
http://www.webempresa.com/blog/item/919-creacion-de-subproductos-en-virtuemart-20.html
https://www.youtube.com/watch?v=E4T52Wf6iHA
Thanks. Kind regards
Hello,
Since you know how to manually create derivate products in VirtueMart, export the fields product_sku, product_parent_sku, custom_title, custom_value and custom_param for this 1 product. Let's see how that looks like. You should be doing the same for the other products then.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Rolland,
In VirtueMart 1.1.9 I can't find some of this fields in Eport products templates. I explain which fields I can find that maybe are the same with name changed in VM 3.
custom_title (In VM 1.1.9 not exist) -> custom (exist)
custom_value (In VM 1.1.9 not exist) -> custom_ attribute (exist)
custom_param (In VM 1.1.9 not exist) -> I can't find any field that can be the same
Thanks for your help
Kind regards
Hello,
The fields custom_title, custom_value and custom_param are VirtueMart 2/3 only. In VirtueMart 1 these used to be the attribute fields but they are not exchangeable. In VirtueMart 3 these fields are used by the Custom Fields feature.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
You say
In VirtueMart 1 these used to be the attribute fields but they are not exchangeable.
This meaning that I can't do it?
Thanks for your help
Kind regards
Hello,
Not saying it cannot be done but it would require manual changing of the data. The way VirtueMart 1 and VirtueMart 3 handles attributes is very very different. Nothing CSVI can do about that. At least you can export the data but then you will need to modify it as needed for VirtueMart 3.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.