1. chabi01
  2. RO CSVI
  3. Tuesday, 21 April 2020
  4.  Subscribe via email
Hello,
In Virtuemart (very last version), i cant find out how to export and import for products the custom fields..

I would like for each product to at least "activate" the field "variants" to show children products or if possible also choose another custom fields and values associates.

I have create a export template with all the fields for products to see if i can see this, but i can't see the information...

Where can i find how to manage the custom fields in my import - export template for products ?

Thanks a lot :)
Xavier
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
THANKS !!!!
I will try today !!!

Thanks a lot for this example :)

Best regards,
Xavier
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Maybe it could be easier for you with the full log..
Here it is :)

Xavier
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
For the record, i have open also a thread here on virtuemart forum : http://forum.virtuemart.net/index.php?topic=145701.0

Xavier
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
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'
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 13
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!