Comenaranjas
commented Thursday, 28 January 2016
Author
Hello
Im getting a very weird issue.
After installing the latest version my child products are not exported and neither others from different categories, I only get products exported from a concrete category.
I think that somehow the issue is related with the patch I applied here:
https://www.csvimproved.com/forum?view=topic&catid=44&id=32828
I had the same effect as when applying the patch there, I've had to reinstall csvi 6.4.3 to get all my products exported correctly again.
Regards
tharuna
commented Friday, 29 January 2016
Support
Hello,
Can you please post the debug log of the export?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Comenaranjas
commented Friday, 29 January 2016
Author
Hello
Debug log here:
Detalles
Fecha 2016-01-29 06:14:56 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Fecha Tiempo Línea Acción Comentario
Procesadas 87 líneas
2016-01-29 06:14:56 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-29 06:14:56 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 06:14:57 0 [DEBUG] Limpiar registros antiguos. 25 registros encontrados y umbral de 25 registros
2016-01-29 06:14:57 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 06:14:57 0 [DEBUG] CSVI Pro Versión:@version@
2016-01-29 06:14:57 0 [DEBUG] COM_CSVI_JOOMLA_VERSION
2016-01-29 06:14:57 0 [DEBUG] Versión PHP: 5.5.30
2016-01-29 06:14:57 0 [DEBUG] =========================
2016-01-29 06:14:57 0 [DEBUG] action: export
2016-01-29 06:14:57 0 [DEBUG] component: com_virtuemart
2016-01-29 06:14:57 0 [DEBUG] operation: order
2016-01-29 06:14:57 0 [DEBUG] localpath: /home/comenara/public_html
2016-01-29 06:14:57 0 [DEBUG] ftphost:
2016-01-29 06:14:57 0 [DEBUG] ftpport:
2016-01-29 06:14:57 0 [DEBUG] ftproot:
2016-01-29 06:14:57 0 [DEBUG] ftpfile:
2016-01-29 06:14:57 0 [DEBUG] export_email_subject:
2016-01-29 06:14:57 0 [DEBUG] export_email_body:
2016-01-29 06:14:57 0 [DEBUG] export_filename: Pedidos almacén [d]-[m]-[Y].csv
2016-01-29 06:14:57 0 [DEBUG] export_file: csv
2016-01-29 06:14:57 0 [DEBUG] field_delimiter: ,
2016-01-29 06:14:57 0 [DEBUG] text_enclosure: "
2016-01-29 06:14:57 0 [DEBUG] include_column_headers: Sí
2016-01-29 06:14:57 0 [DEBUG] signature: No
2016-01-29 06:14:57 0 [DEBUG] publish_state:
2016-01-29 06:14:57 0 [DEBUG] recordstart:
2016-01-29 06:14:57 0 [DEBUG] recordend:
2016-01-29 06:14:57 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-01-29 06:14:57 0 [DEBUG] export_price_format_decimal: 2
2016-01-29 06:14:57 0 [DEBUG] export_price_format_decsep: .
2016-01-29 06:14:57 0 [DEBUG] export_price_format_thousep:
2016-01-29 06:14:57 0 [DEBUG] header:
2016-01-29 06:14:57 0 [DEBUG] body:
2016-01-29 06:14:57 0 [DEBUG] footer:
2016-01-29 06:14:57 0 [DEBUG] language: es-ES
2016-01-29 06:14:57 0 [DEBUG] splitorderline: Sí
2016-01-29 06:14:57 0 [DEBUG] ordernostart:
2016-01-29 06:14:57 0 [DEBUG] ordernoend:
2016-01-29 06:14:57 0 [DEBUG] orderlist:
2016-01-29 06:14:57 0 [DEBUG] orderdaterange:
2016-01-29 06:14:57 0 [DEBUG] orderdatestart:
2016-01-29 06:14:57 0 [DEBUG] orderdateend:
2016-01-29 06:14:57 0 [DEBUG] ordermdatestart:
2016-01-29 06:14:57 0 [DEBUG] ordermdateend:
2016-01-29 06:14:57 0 [DEBUG] order_address: BTST
2016-01-29 06:14:57 0 [DEBUG] orderpricestart:
2016-01-29 06:14:57 0 [DEBUG] orderpriceend:
2016-01-29 06:14:57 0 [DEBUG] groupbyfields:
2016-01-29 06:14:57 0 [DEBUG] sortfields:
2016-01-29 06:14:57 0 [DEBUG] use_system_limits: No
2016-01-29 06:14:57 0 [DEBUG] max_execution_time:
2016-01-29 06:14:57 0 [DEBUG] memory_limit:
2016-01-29 06:14:57 0 [DEBUG] =========================
2016-01-29 06:14:57 0 [DEBUG] Export field: País
2016-01-29 06:14:57 0 [DEBUG] Export field: Bultos
2016-01-29 06:14:57 0 [DEBUG] Export field: Nº Pedido
2016-01-29 06:14:57 0 [DEBUG] Export field: Nombre
2016-01-29 06:14:57 0 [DEBUG] Export field: Referencia
2016-01-29 06:14:57 0 [DEBUG] Export field: Cantidad
2016-01-29 06:14:57 0 [DEBUG] Export field: Nota del comprador
2016-01-29 06:14:57 0 [DEBUG] Export query
SELECT COALESCE(`user_info2`.`virtuemart_country_id`, `user_info1`.`virtuemart_country_id`) AS `virtuemart_country_id`,
`#__virtuemart_shipmentmethods`.`shipment_element`,
`#__virtuemart_orders`.`virtuemart_order_id`,
`order_number`,
COALESCE(`user_info2`.`first_name`, `user_info1`.`first_name`) AS `first_name`,
COALESCE(`user_info2`.`last_name`, `user_info1`.`last_name`) AS `last_name`,
`order_item_sku`,
`product_attribute`,
`order_item_name`,
`product_quantity`,
`user_info1`.`customer_note`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`
LEFT JOIN `#__virtuemart_products` ON `#__virtuemart_products`.`product_sku` = `#__virtuemart_order_items`.`order_item_sku`
WHERE `#__virtuemart_orders`.`order_status` IN ('Z') AND `user_info1`.`address_type` = 'BT'
GROUP BY #__virtuemart_orders.virtuemart_order_id
Another template order export:
Detalles
Fecha 2016-01-29 06:18:59 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Fecha Tiempo Línea Acción Comentario
Procesadas 79 líneas
2016-01-29 06:18:59 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-29 06:18:59 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 06:19:00 0 [DEBUG] Limpiar registros antiguos. 25 registros encontrados y umbral de 25 registros
2016-01-29 06:19:00 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 06:19:00 0 [DEBUG] CSVI Pro Versión:@version@
2016-01-29 06:19:00 0 [DEBUG] COM_CSVI_JOOMLA_VERSION
2016-01-29 06:19:00 0 [DEBUG] Versión PHP: 5.5.30
2016-01-29 06:19:00 0 [DEBUG] =========================
2016-01-29 06:19:00 0 [DEBUG] action: export
2016-01-29 06:19:00 0 [DEBUG] component: com_virtuemart
2016-01-29 06:19:00 0 [DEBUG] operation: order
2016-01-29 06:19:00 0 [DEBUG] localpath: /home/comenara/public_html
2016-01-29 06:19:00 0 [DEBUG] ftphost:
2016-01-29 06:19:00 0 [DEBUG] ftpport:
2016-01-29 06:19:00 0 [DEBUG] ftproot:
2016-01-29 06:19:00 0 [DEBUG] ftpfile:
2016-01-29 06:19:00 0 [DEBUG] export_email_subject: Previsión de pedidos
2016-01-29 06:19:00 0 [DEBUG] export_email_body:
Este es un e-mail automático que envía la web.
Se adjunta un documento con pedidos confirmados hasta la fecha y hora de este e-mail.
Pedidos para sacar en el próximo envío.
2016-01-29 06:19:00 0 [DEBUG] export_filename:
2016-01-29 06:19:00 0 [DEBUG] export_file: html
2016-01-29 06:19:00 0 [DEBUG] field_delimiter: ,
2016-01-29 06:19:00 0 [DEBUG] text_enclosure: "
2016-01-29 06:19:00 0 [DEBUG] include_column_headers: Sí
2016-01-29 06:19:00 0 [DEBUG] signature: No
2016-01-29 06:19:00 0 [DEBUG] publish_state:
2016-01-29 06:19:00 0 [DEBUG] recordstart:
2016-01-29 06:19:00 0 [DEBUG] recordend:
2016-01-29 06:19:00 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-01-29 06:19:00 0 [DEBUG] export_price_format_decimal: 2
2016-01-29 06:19:00 0 [DEBUG] export_price_format_decsep: .
2016-01-29 06:19:00 0 [DEBUG] export_price_format_thousep:
2016-01-29 06:19:00 0 [DEBUG] header:
2016-01-29 06:19:00 0 [DEBUG] body:
2016-01-29 06:19:00 0 [DEBUG] footer:
2016-01-29 06:19:00 0 [DEBUG] language: es-ES
2016-01-29 06:19:00 0 [DEBUG] splitorderline: Sí
2016-01-29 06:19:00 0 [DEBUG] ordernostart:
2016-01-29 06:19:00 0 [DEBUG] ordernoend:
2016-01-29 06:19:00 0 [DEBUG] orderlist:
2016-01-29 06:19:00 0 [DEBUG] orderdaterange:
2016-01-29 06:19:00 0 [DEBUG] orderdatestart:
2016-01-29 06:19:00 0 [DEBUG] orderdateend:
2016-01-29 06:19:00 0 [DEBUG] ordermdatestart:
2016-01-29 06:19:00 0 [DEBUG] ordermdateend:
2016-01-29 06:19:00 0 [DEBUG] order_address: BTST
2016-01-29 06:19:00 0 [DEBUG] orderpricestart:
2016-01-29 06:19:00 0 [DEBUG] orderpriceend:
2016-01-29 06:19:00 0 [DEBUG] groupbyfields:
2016-01-29 06:19:00 0 [DEBUG] sortfields: {"name":["order_item_sku"]}
2016-01-29 06:19:00 0 [DEBUG] use_system_limits: No
2016-01-29 06:19:00 0 [DEBUG] max_execution_time:
2016-01-29 06:19:00 0 [DEBUG] memory_limit:
2016-01-29 06:19:00 0 [DEBUG] =========================
2016-01-29 06:19:00 0 [DEBUG] Export field: Referencia
2016-01-29 06:19:00 0 [DEBUG] Export field: Cantidad
2016-01-29 06:19:00 0 [DEBUG] Export query
SELECT `order_number`,
`product_attribute`,
`order_item_sku`,
`order_item_name`,
`product_quantity`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`
LEFT JOIN `#__virtuemart_products` ON `#__virtuemart_products`.`product_sku` = `#__virtuemart_order_items`.`order_item_sku`
WHERE `#__virtuemart_orders`.`order_status` IN ('Z') AND `user_info1`.`address_type` = 'BT'
GROUP BY #__virtuemart_orders.virtuemart_order_id
ORDER BY `order_item_sku`
As mentioned only products from a concrete category are being exported, really strange.
Regards
rolandd
commented Friday, 29 January 2016
Support
Hello,
Looking at the debug log, you say only products from a specific category are being export but this is an order export. You mean you only see certain orders with certain products?
If you still have, can you also post the debug log of your working export, we can put them next to each other and see what is different. The query itself looks OK, you are filtering on order status and address type, there are no other restrictions.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Comenaranjas
commented Friday, 29 January 2016
Author
I only see certains orders yes and certain products. The strange thing is that all products exported in the file are from the same category and only those will get exported.
Something has been changed in this version which affects this at least for us cause installing 6.4.3 back makes all orders and products export correctly.
Regards
rolandd
commented Friday, 29 January 2016
Support
rolandd wrote:
If you still have, can you also post the debug log of your working export
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Comenaranjas
commented Friday, 29 January 2016
Author
Hi, ye I have cause as mentioned I have to use 6.4.3
Detalles
Fecha 2016-01-29 13:33:24 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Fecha Tiempo Línea Acción Comentario
Procesadas 85 líneas
2016-01-29 13:33:24 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-29 13:33:24 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 13:33:25 0 [DEBUG] Limpiar registros antiguos. 25 registros encontrados y umbral de 25 registros
2016-01-29 13:33:25 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-01-29 13:33:25 0 [DEBUG] CSVI Pro Versión:@version@
2016-01-29 13:33:25 0 [DEBUG] COM_CSVI_JOOMLA_VERSION
2016-01-29 13:33:25 0 [DEBUG] Versión PHP: 5.5.30
2016-01-29 13:33:25 0 [DEBUG] =========================
2016-01-29 13:33:25 0 [DEBUG] action: export
2016-01-29 13:33:25 0 [DEBUG] component: com_virtuemart
2016-01-29 13:33:25 0 [DEBUG] operation: order
2016-01-29 13:33:25 0 [DEBUG] localpath: /home/comenara/public_html
2016-01-29 13:33:25 0 [DEBUG] ftphost:
2016-01-29 13:33:25 0 [DEBUG] ftpport:
2016-01-29 13:33:25 0 [DEBUG] ftproot:
2016-01-29 13:33:25 0 [DEBUG] ftpfile:
2016-01-29 13:33:25 0 [DEBUG] export_email_subject:
2016-01-29 13:33:25 0 [DEBUG] export_email_body:
2016-01-29 13:33:25 0 [DEBUG] export_filename: Pedidos almacén [d]-[m]-[Y].csv
2016-01-29 13:33:25 0 [DEBUG] export_file: csv
2016-01-29 13:33:25 0 [DEBUG] field_delimiter: ,
2016-01-29 13:33:25 0 [DEBUG] text_enclosure: "
2016-01-29 13:33:25 0 [DEBUG] include_column_headers: Sí
2016-01-29 13:33:25 0 [DEBUG] signature: No
2016-01-29 13:33:25 0 [DEBUG] publish_state:
2016-01-29 13:33:25 0 [DEBUG] recordstart:
2016-01-29 13:33:25 0 [DEBUG] recordend:
2016-01-29 13:33:25 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-01-29 13:33:25 0 [DEBUG] export_price_format_decimal: 2
2016-01-29 13:33:25 0 [DEBUG] export_price_format_decsep: .
2016-01-29 13:33:25 0 [DEBUG] export_price_format_thousep:
2016-01-29 13:33:25 0 [DEBUG] header:
2016-01-29 13:33:25 0 [DEBUG] body:
2016-01-29 13:33:25 0 [DEBUG] footer:
2016-01-29 13:33:25 0 [DEBUG] language: es-ES
2016-01-29 13:33:25 0 [DEBUG] splitorderline: Sí
2016-01-29 13:33:25 0 [DEBUG] ordernostart:
2016-01-29 13:33:25 0 [DEBUG] ordernoend:
2016-01-29 13:33:25 0 [DEBUG] orderlist:
2016-01-29 13:33:25 0 [DEBUG] orderdaterange:
2016-01-29 13:33:25 0 [DEBUG] orderdatestart:
2016-01-29 13:33:25 0 [DEBUG] orderdateend:
2016-01-29 13:33:25 0 [DEBUG] ordermdatestart:
2016-01-29 13:33:25 0 [DEBUG] ordermdateend:
2016-01-29 13:33:25 0 [DEBUG] order_address: BTST
2016-01-29 13:33:25 0 [DEBUG] orderpricestart:
2016-01-29 13:33:25 0 [DEBUG] orderpriceend:
2016-01-29 13:33:25 0 [DEBUG] groupbyfields:
2016-01-29 13:33:25 0 [DEBUG] sortfields:
2016-01-29 13:33:25 0 [DEBUG] use_system_limits: No
2016-01-29 13:33:25 0 [DEBUG] max_execution_time:
2016-01-29 13:33:25 0 [DEBUG] memory_limit:
2016-01-29 13:33:25 0 [DEBUG] =========================
2016-01-29 13:33:25 0 [DEBUG] Export field: País
2016-01-29 13:33:25 0 [DEBUG] Export field: Bultos
2016-01-29 13:33:25 0 [DEBUG] Export field: Nº Pedido
2016-01-29 13:33:25 0 [DEBUG] Export field: Nombre
2016-01-29 13:33:25 0 [DEBUG] Export field: Referencia
2016-01-29 13:33:25 0 [DEBUG] Export field: Cantidad
2016-01-29 13:33:25 0 [DEBUG] Export field: Nota del comprador
2016-01-29 13:33:25 0 [DEBUG] Export query
SELECT COALESCE(`user_info2`.`virtuemart_country_id`, `user_info1`.`virtuemart_country_id`) AS `virtuemart_country_id`,
`#__virtuemart_shipmentmethods`.`shipment_element`,
`#__virtuemart_orders`.`virtuemart_order_id`,
`order_number`,
COALESCE(`user_info2`.`first_name`, `user_info1`.`first_name`) AS `first_name`,
COALESCE(`user_info2`.`last_name`, `user_info1`.`last_name`) AS `last_name`,
`order_item_sku`,
`product_attribute`,
`order_item_name`,
`product_quantity`,
`user_info1`.`customer_note`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`
WHERE `#__virtuemart_orders`.`order_status` IN ('Z') AND `user_info1`.`address_type` = 'BT'
Regards
rolandd
commented Friday, 29 January 2016
Support
Hello,
I believe I found the issue, there is a grouping by order ID done in the new release. Can you check if the attached patch file solves the issue for you?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Comenaranjas
commented Friday, 29 January 2016
Author
Thank you guys, that patch solved it. Now all products are exported correctly,
Regards
Log in to reply to this topic.