Categories
View Replies (8)

Resolved CSVIPRO 6.5.0 breaks order export

  1. Comenaranjas
    Comenaranjas
  2. RO CSVI
  3. Thursday, 28 January 2016
  4.  Subscribe via email
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
0
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
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?
Attachments (1)
patch_orderexport_vm_20161929.zip
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. # 7
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
Thank you guys, that patch solved it. Now all products are exported correctly,

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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