Resolved Custom fields in Virtuemart, how to ?

Hello Xavier,
Please take a look at Product import with custom fields document for imports and Product export with custom fields document for exports. In import document under Related articles section you can find link for detail documentation for custom fields based on their types. Let me know if it helps.

Hi Tharuna,
I read all the doc before posting here. I'm going to read it again and come back if something goes wrong or if I can't find the solution.

Do you have a simple example (or even a template ready) with the native custom field "variant child" ?
This could help
Thanks a lot !
Xavier

Hello Xavier,
I guess you are talking about Generic child variant custom field type. Did you also read Import Generic child variant for VirtueMart document? The document has example content and steps to create import template.

THANKS !!!!
I will try today !!!

Thanks a lot for this example

Best regards,
Xavier

Hi Tharuna,
Ok, i'm back today because i did not find the right way to do what i want. I tried with the explanation "import generic child", but something is not working correctly.

I'm going to explain what i did.

In Virtuemart, let's say i have 3 products:
SH1001 - My first product
SH1002 - My second product
SH1003 - My third product.

I want to add children products (not variant with a custom field but some children products).

So, i have prepared a file and try to create a template like this :

My csv file :

Product_sku ; Product_name ; Product_parent_sku
CHILD1 ; children product 1 ; SH1001
CHILD2 ; children product 2 ; SH1001
CHILD3 ; children product 3 ; SH1001
CHILD4 ; children product 4 ; SH1002
CHILD5 ; children product 5 ; SH1002
CHILD1 ; children product 5 ; SH1002
CHILD1 ; children product 6 ; SH1003
CHILD1 ; children product 7 ; SH1003

I only have to create children for a parent with a different sku and name (content for each children will be done later), these children are chown in dropdown selector in the parent product for now (but later, they will have a specific price).

So, i have then create a template "import product" with the corresponding 3 fields as this is not "custom field" product but children product.

Unfortunatly, i cannot achieve this correctly. I cant find either a template "import children product" in the example.

Can you help me some further ? Do you have a detailed tutorial page for virtuemart children product import and export ?

Thanks a lot
Xavier

SUCCESS !!!!
As i was worried to not succeed to do this, i have recreate the import files, check several times, did the import of children for only one product and then, magic, it works well !!

I still have an issue where i dont know where to search : as i'm french native, we use in french some words like "L'ARTICLE" with a " ' "
In my csv file, it is correct, in the backend name, it is correct, (i can see for example "L'ARTICLE..." but in the product name and the list, i have in result "L1#39;ARTICLE...".
The only way i found so far is to open the article, delete the "L'....." and retype again manually the "L'....". Then, i have the correct name shown in the page.

Note : this is not seems to be linked to ROCSVI as this is also the same problem when i copy paste from Calc/Excel to Virtuemart when i create the products : i have to correct this also...

If you have some clues on this, it could save me a lot of time

Have a nice day !
Xavier

Additionnal information : this is happening only on product creation. If i copy paste a second time the name (from Calc to Virtuemart product name in product edition), the name is not "translate" again and shown correctly...

Mistery... or Virtuemart bug

Xavier

Hello Xavier,

Unfortunatly, i cannot achieve this correctly. I cant find either a template "import children product" in the example.

Can you help me some further ? Do you have a detailed tutorial page for virtuemart children product import and export ?

You don't need a separate template for importing children products. You just need to have product_parent_sku field for child products with SKU of parent. That should import the child products.

Mistery... or Virtuemart bug

Which VirtueMart version are you using? I tried L'ARTICLE in product_name and it seems to be imported correct. Please post sample of your import file and debug log to check. To get the debug log check How to collect debug information? document.

Hi Tharuna,
I copy a part of the log here :

2020-10-24 	08:46:34 	17 	[QUERY] 	INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03035','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0')

2020-10-24 	08:46:34 	17 	[DEBUG] 	No parent found

2020-10-24 	08:46:34 	17 	[QUERY] 	SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable'

2020-10-24 	08:46:34 	17 	[DEBUG] 	Check product language entry

2020-10-24 	08:46:34 	17 	[QUERY] 	SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 734

2020-10-24 	08:46:34 	17 	[DEBUG] 	Check if the product slug exists

2020-10-24 	08:46:34 	17 	[QUERY] 	SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' AND `virtuemart_product_id` != 734

2020-10-24 	08:46:34 	17 	[DEBUG] 	Check if the product slug exists

2020-10-24 	08:46:34 	17 	[QUERY] 	SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' AND `virtuemart_product_id` != 734

2020-10-24 	08:46:34 	17 	[DEBUG] 	Insert the dummy entry for the product language

2020-10-24 	08:46:34 	17 	[QUERY] 	INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (734, 'enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg')

2020-10-24 	08:46:34 	17 	[DEBUG] 	Query for ProductLang

2020-10-24 	08:46:34 	17 	[DEBUG] 	Executed store

2020-10-24 	08:46:34 	17 	[QUERY] 	UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '734'

2020-10-24 	08:46:34 	17 	[DEBUG] 	Checking manufacturer

2020-10-24 	08:46:34 	17 	[DEBUG] 	Processing custom available field: Disponibilité

2020-10-24 	08:46:34 	17 	[DEBUG] 	Processing custom available field: prixbase

2020-10-24 	08:46:34 	17 	[DEBUG] 	Processing custom available field: ongletssousproduits

2020-10-24 	08:46:34 	17 	[DEBUG] 	Processing custom available field: complémentsousonglet

2020-10-24 	08:46:34 	17 	[DEBUG] 	Update has fields after all processing

2020-10-24 	08:46:34 	17 	[QUERY] 	UPDATE `k14d3_virtuemart_products` SET `has_categories` = 0 , `has_manufacturers` = 0 , `has_medias` = 0 , `has_prices` = 0 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 734

2020-10-24 	08:46:34 	18 	[DEBUG] 	Use field value for field product_sku

2020-10-24 	08:46:34 	18 	[DEBUG] 	Use field value for field product_parent_sku

2020-10-24 	08:46:34 	18 	[DEBUG] 	Use field value for field product_name

2020-10-24 	08:46:34 	18 	[DEBUG] 	Process line 18

2020-10-24 	08:46:34 	18 	[DEBUG] 	Load a row

2020-10-24 	08:46:34 	18 	[DEBUG] 	Processing item: AR03036

2020-10-24 	08:46:34 	18 	[DEBUG] 	Looking for parent SKU

2020-10-24 	08:46:34 	18 	[DEBUG] 	Checking product parent SKU

2020-10-24 	08:46:34 	18 	[QUERY] 	SELECT `virtuemart_product_id` FROM `k14d3_virtuemart_products` WHERE `product_sku` = 'P000100'

2020-10-24 	08:46:34 	18 	[DEBUG] 	Product tax:

2020-10-24 	08:46:34 	18 	[DEBUG] 	Query for Product

2020-10-24 	08:46:34 	18 	[DEBUG] 	Executed store

2020-10-24 	08:46:34 	18 	[QUERY] 	INSERT INTO `k14d3_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_discontinued`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','525','AR03036','0','KG','M','','0','0','0','0','0000-00-00 00:00:00','','0','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|','0','','','','0','0','0','2020-10-24 08:46:34','675','2020-10-24 08:46:34','675','0000-00-00 00:00:00','0')

2020-10-24 	08:46:34 	18 	[DEBUG] 	No parent found

2020-10-24 	08:46:34 	18 	[QUERY] 	SELECT customfield_params FROM k14d3_virtuemart_product_customfields WHERE virtuemart_product_id = 525 AND customfield_value = 'stockable'

2020-10-24 	08:46:34 	18 	[DEBUG] 	Check product language entry

2020-10-24 	08:46:34 	18 	[QUERY] 	SELECT `virtuemart_product_id`,`slug` FROM `k14d3_virtuemart_products_fr_fr` WHERE `virtuemart_product_id` = 735

2020-10-24 	08:46:34 	18 	[DEBUG] 	Check if the product slug exists

2020-10-24 	08:46:34 	18 	[QUERY] 	SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' AND `virtuemart_product_id` != 735

2020-10-24 	08:46:34 	18 	[DEBUG] 	Check if the product slug exists

2020-10-24 	08:46:34 	18 	[QUERY] 	SELECT COUNT(`virtuemart_product_id`) FROM k14d3_virtuemart_products_fr_fr WHERE `slug` = 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' AND `virtuemart_product_id` != 735

2020-10-24 	08:46:34 	18 	[DEBUG] 	Insert the dummy entry for the product language

2020-10-24 	08:46:34 	18 	[QUERY] 	INSERT INTO `k14d3_virtuemart_products_fr_fr` (`virtuemart_product_id`,`slug`) VALUES (735, 'enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg')

2020-10-24 	08:46:34 	18 	[DEBUG] 	Query for ProductLang

2020-10-24 	08:46:34 	18 	[DEBUG] 	Executed store

2020-10-24 	08:46:34 	18 	[QUERY] 	UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO VERT AMANDE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-vert-amande-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '735'

And attach the csv file used.

The import template is very simple and exactly the same than the csv file.
The Virtuemart version is : VirtueMart 3.8.4 10335

Thanks
Xavier

Maybe it could be easier for you with the full log..
Here it is

Xavier

For the record, i have open also a thread here on virtuemart forum : http://forum.virtuemart.net/index.php?topic=145701.0

Xavier

Hello Xavier,
There is no problem with import with special characters in L'ARTICLE , see the query below. The text is updated with escape character. If this is an issue only with frontend and not in backend then it could be a problem on how VirtueMart is rendering this value. Can you also check in database on how this value is stored in #__virtuemart_products_fr_fr table? is it saved as L'ARTICLE or L1#39;ARTICLE?

UPDATE `k14d3_virtuemart_products_fr_fr` SET `product_s_desc`='',`product_name`='ENDUIT A L\'ARGILE ARGIL DECO TERRE ORANGEE (Sac de 12.5 kg)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='enduit-a-l-argile-argil-deco-terre-orangee-sac-de-12-5-kg' WHERE `virtuemart_product_id` = '718'

Hi again Tharuna,
I follow the thread also on virtuemart.net.
I make some test as soon i have time and come back with the results (i have to import a "dummy" product" for the test, and then prepare all the stuff needed


Thanks again
Xavier