1. Huubss
  2. RO CSVI
  3. Monday, 19 October 2020
  4.  Subscribe via email
Hello,

I try to export the virtuemart product with a custom field, a generic product variant, but I cannot select it. I use that to distinguish the colors. It's not available in the dropdown for template fields.
Accepted Answer Pending Moderation
Hello,
Generic child variant fields are not available as individual template fields. You need to use custom_title, custom_value and custom_param fields to export these values.
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
Hello,
Generic child variant fields are not available as individual template fields. You need to use custom_title, custom_value and custom_param fields to export these values.


And how does that work exactly?

Wait but i see in te documentation that you can export the custom fields, but I just need that one value of the custom field in my order export. Is that possible?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
And how does that work exactly?

You did not mention you were using VirtueMart order export. The reply was based on VirtueMart product export and that is the format RO CSVI uses to import the generic child variant in VirtueMart product import.

Wait but i see in te documentation that you can export the custom fields, but I just need that one value of the custom field in my order export. Is that possible?

With custom_title, custom_value and custom_param fields, it is all custom fields for a product as there is no option to export only one custom field. Since you are saying order export i guess you are looking to export custom field value for that order. If that is the case use product_attribute field in export. This is the field where VirtueMart stores the custom field values for every order. Let me know if that is what you are looking for.
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
Hello,
And how does that work exactly?

You did not mention you were using VirtueMart order export. The reply was based on VirtueMart product export and that is the format RO CSVI uses to import the generic child variant in VirtueMart product import.

Wait but i see in te documentation that you can export the custom fields, but I just need that one value of the custom field in my order export. Is that possible?

With custom_title, custom_value and custom_param fields, it is all custom fields for a product as there is no option to export only one custom field. Since you are saying order export i guess you are looking to export custom field value for that order. If that is the case use product_attribute field in export. This is the field where VirtueMart stores the custom field values for every order. Let me know if that is what you are looking for.


Hi unfortunately, the field is not being exported when I use the product_attribute field. All the other fields are there but the specific generic cart variant is not being exported.. Any idea why?

Another option is to use the short description of the product, because that is the field where I define the value of the generic child variant.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Hi unfortunately, the field is not being exported when I use the product_attribute field. All the other fields are there but the specific generic cart variant is not being exported.. Any idea why?

If the Generic child variant field is one of the cart input field then VirtueMart stores it in product_attribute field. Is your field a cart input field?

Another option is to use the short description of the product, because that is the field where I define the value of the generic child variant.

Product language table fields are not supported in Order export but you can use RO CSVI Advanced Custom table export link VirtueMart Order, Products and Product language tables with virtuemart_product_id field and export the short description of the product along with other export fields.
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. # 5
Accepted Answer Pending Moderation
Hello,
Hi unfortunately, the field is not being exported when I use the product_attribute field. All the other fields are there but the specific generic cart variant is not being exported.. Any idea why?

If the Generic child variant field is one of the cart input field then VirtueMart stores it in product_attribute field. Is your field a cart input field?

Another option is to use the short description of the product, because that is the field where I define the value of the generic child variant.

Product language table fields are not supported in Order export but you can use RO CSVI Advanced Custom table export link VirtueMart Order, Products and Product language tables with virtuemart_product_id field and export the short description of the product along with other export fields.


Yes it is in cart input...
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
I tried the advanced custom tabel export, but I have some issues. First, how can I set the order status to a certain status or export? And secondly how can I add custom fields, just as the Virtuemart export does?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Huub,

Unfortunately the custom table export has no idea about Virtuemart fields, so there is no option to filter on them or select custom fields.

The issue is that one custom field is not in the product_attribute, correct? Can you give some more information as to which field this is in VirtueMart? Please also tell me how this field is setup. Virtuemart is supposed to store cart input values into this field. In case they don't you will never know what the customer actually ordered.
Kind regards,

RolandD

=========================
If you use our extensions, 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
Hello Huub,

Unfortunately the custom table export has no idea about Virtuemart fields, so there is no option to filter on them or select custom fields.

The issue is that one custom field is not in the product_attribute, correct? Can you give some more information as to which field this is in VirtueMart? Please also tell me how this field is setup. Virtuemart is supposed to store cart input values into this field. In case they don't you will never know what the customer actually ordered.


That is indeed unfortunate. It's a custom field called Generic Child variant. To select a child product. The field is setup in the following way:

Custom field
Screenshot 2020-10-22 at 09.04.50.png
In product
Screenshot 2020-10-22 at 09.05.33.png

Please let me know if you need anything else.


Also is it possible to somehow get the same functionality as the Virtuemart export ?
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
That is indeed unfortunate. It's a custom field called Generic Child variant. To select a child product. The field is setup in the following way:

Setting up the custom field as shown in your screenshot and checking the order, VirtueMart does not save the field in product_attribute field probably because child variant is just another product in VirtueMart and does not treat it as a custom field.

Also is it possible to somehow get the same functionality as the Virtuemart export ?

Custom table export is a generic export and cannot have functionality based on specific extension.
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. # 10
Accepted Answer Pending Moderation
Hello,
That is indeed unfortunate. It's a custom field called Generic Child variant. To select a child product. The field is setup in the following way:

Setting up the custom field as shown in your screenshot and checking the order, VirtueMart does not save the field in product_attribute field probably because child variant is just another product in VirtueMart and does not treat it as a custom field.

Also is it possible to somehow get the same functionality as the Virtuemart export ?

Custom table export is a generic export and cannot have functionality based on specific extension.


Ok but in my order overview the generic child variant is treated like a custom field, and it is displayed in the order overview.

Also is it possible to somehow get the same functionality as the Virtuemart export ?

Custom table export is a generic export and cannot have functionality based on specific extension.

I understand but is it possible to get the same functionality, in linking tables and such?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
Ok but in my order overview the generic child variant is treated like a custom field, and it is displayed in the order overview.

Please post a screenshot of the order overview page. I am seeing Generic child variant is shown along with product name in Order details page in VirtueMart admin.

I understand but is it possible to get the same functionality, in linking tables and such?

Since you need product short description to be exported in Order export, you can follow the below solution.

1. Add product_s_desc as a custom available field for VirtueMart Order export as explained in the Adding your own custom available fields document.
2. Update available fields.
3. You can then create an override for VirtueMart order export and link Product language table to the export query and export product_s_desc field by adding it as a template field in VirtueMart order export.

Let me know if that helps.
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. # 12
Accepted Answer Pending Moderation
Hello,
Ok but in my order overview the generic child variant is treated like a custom field, and it is displayed in the order overview.

Please post a screenshot of the order overview page. I am seeing Generic child variant is shown along with product name in Order details page in VirtueMart admin.


See screenshot


I understand but is it possible to get the same functionality, in linking tables and such?

Since you need product short description to be exported in Order export, you can follow the below solution.

1. Add product_s_desc as a custom available field for VirtueMart Order export as explained in the Adding your own custom available fields document.
2. Update available fields.
3. You can then create an override for VirtueMart order export and link Product language table to the export query and export product_s_desc field by adding it as a template field in VirtueMart order export.

Let me know if that helps.


Ok I'll try this..
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
Ok but in my order overview the generic child variant is treated like a custom field, and it is displayed in the order overview.

Please post a screenshot of the order overview page. I am seeing Generic child variant is shown along with product name in Order details page in VirtueMart admin.

I understand but is it possible to get the same functionality, in linking tables and such?

Since you need product short description to be exported in Order export, you can follow the below solution.

1. Add product_s_desc as a custom available field for VirtueMart Order export as explained in the Adding your own custom available fields document.
2. Update available fields.
3. You can then create an override for VirtueMart order export and link Product language table to the export query and export product_s_desc field by adding it as a template field in VirtueMart order export.

Let me know if that helps.


I hve some trouble with the adding the product_s_desc to the custom available field. What is the line of override.sql i need?


INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('skip', 'skip', 'orderexport', 'com_virtuemart');


is this correct?

Also the last step is difficult for me, can you help me out?

https://rolandd.com/documentation/ro-csvi/override-import-export-routines

I added the overrides, but what do i Have to put in that file?
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('skip', 'skip', 'orderexport', 'com_virtuemart');


Use the below query in override.sql file to get product_s_desc field.

INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`, `action`)
VALUES
('product_s_desc', 'product_s_desc', 'order', 'com_virtuemart', 'export');


Also the last step is difficult for me, can you help me out?

https://rolandd.com/documentation/ro-csvi/override-import-export-routines

I added the overrides, but what do i Have to put in that file?

In the export query you can see virtuemart product table joined based on SKU field, you need to add another join after that for VirtueMart Product language table to the query so Product description is fetched. Something like below where XX_XX is the language


$query->leftJoin(
$this->db->quoteName('#__virtuemart_products_XX_XX')
. ' ON ' . $this->db->quoteName('#__virtuemart_products_XX_XX.virtuemart_product_id') . ' = ' . $this->db->quoteName('#__virtuemart_products.virtuemart_product_id')
);
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. # 15
  • Page :
  • 1


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