Resolved export shows only one product

Hello,
Two products will be shown as two different rows in excel file and not in one single row. Can you post me the debug log and also the file you exported to check?

It says : No debug log available
Is it possible to switch it on?

These fields are exported :

Aanhef,Voornaam,Achternaam,Adres,Postcode,Plaats,Telefoonnummer,E-mail,Geboortejaar,Cursus,Order status,Order status naam,Totaal

The field Cursus only shows 1 product, also when two products are ordered.

Hello,

It says : No debug log available
Is it possible to switch it on?

Have a look at top of this page under section "Where to get the debug information?" which explains how to enable and get the debug log.

herewith I send you the debug log.

thanks

Hello,
Your log is missing in the post, if file is big try to compress and post it.

ok sorry. again as 7zip file

Its not there again, send it as email to tharuna@csvimproved.com.

Hello,
Your debug log shows you have set few Group by fields based on user info fields. Can you remove them and try the export?

I removed those groupfields and did another export. But it didn't sort out the issue.
Still the export file shows only one product when there are more products ordered.
hereunder the logfile

Details
Date 2016-05-19 12:01:03 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 92 lines
2016-05-19 12:01:03 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:01:03 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:01:04 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:01:04 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:01:04 0 [DEBUG] CSVI Pro Version: 6.5.7
2016-05-19 12:01:04 0 [DEBUG] Joomla! version: 3.5.1
2016-05-19 12:01:04 0 [DEBUG] PHP version: 5.5.35
2016-05-19 12:01:04 0 [DEBUG] =========================
2016-05-19 12:01:04 0 [DEBUG] action: export
2016-05-19 12:01:04 0 [DEBUG] component: com_virtuemart
2016-05-19 12:01:04 0 [DEBUG] operation: order
2016-05-19 12:01:04 0 [DEBUG] localpath: /home/nederla1/public_html
2016-05-19 12:01:04 0 [DEBUG] ftphost:
2016-05-19 12:01:04 0 [DEBUG] ftpport:
2016-05-19 12:01:04 0 [DEBUG] ftproot:
2016-05-19 12:01:04 0 [DEBUG] ftpfile:
2016-05-19 12:01:04 0 [DEBUG] export_email_subject:
2016-05-19 12:01:04 0 [DEBUG] export_email_body:
2016-05-19 12:01:04 0 [DEBUG] export_filename:
2016-05-19 12:01:04 0 [DEBUG] export_file: csv
2016-05-19 12:01:04 0 [DEBUG] field_delimiter: ,
2016-05-19 12:01:04 0 [DEBUG] text_enclosure:
2016-05-19 12:01:04 0 [DEBUG] include_column_headers: Yes
2016-05-19 12:01:04 0 [DEBUG] signature: Yes
2016-05-19 12:01:04 0 [DEBUG] publish_state:
2016-05-19 12:01:04 0 [DEBUG] recordstart:
2016-05-19 12:01:04 0 [DEBUG] recordend:
2016-05-19 12:01:04 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-05-19 12:01:04 0 [DEBUG] export_price_format_decimal: 2
2016-05-19 12:01:04 0 [DEBUG] export_price_format_decsep: .
2016-05-19 12:01:04 0 [DEBUG] export_price_format_thousep:
2016-05-19 12:01:04 0 [DEBUG] header:
2016-05-19 12:01:04 0 [DEBUG] body:
2016-05-19 12:01:04 0 [DEBUG] footer:
2016-05-19 12:01:04 0 [DEBUG] language: nl-NL
2016-05-19 12:01:04 0 [DEBUG] splitorderline: No
2016-05-19 12:01:04 0 [DEBUG] ordernostart:
2016-05-19 12:01:04 0 [DEBUG] ordernoend:
2016-05-19 12:01:04 0 [DEBUG] orderlist:
2016-05-19 12:01:04 0 [DEBUG] orderdaterange:
2016-05-19 12:01:04 0 [DEBUG] orderdatestart:
2016-05-19 12:01:04 0 [DEBUG] orderdateend:
2016-05-19 12:01:04 0 [DEBUG] ordermdatestart:
2016-05-19 12:01:04 0 [DEBUG] ordermdateend:
2016-05-19 12:01:04 0 [DEBUG] order_address:
2016-05-19 12:01:04 0 [DEBUG] orderpricestart:
2016-05-19 12:01:04 0 [DEBUG] orderpriceend:
2016-05-19 12:01:04 0 [DEBUG] groupbyfields: {"name":[]}
2016-05-19 12:01:04 0 [DEBUG] sortfields:
2016-05-19 12:01:04 0 [DEBUG] use_system_limits: No
2016-05-19 12:01:04 0 [DEBUG] max_execution_time:
2016-05-19 12:01:04 0 [DEBUG] memory_limit:
2016-05-19 12:01:04 0 [DEBUG] =========================
2016-05-19 12:01:04 0 [DEBUG] Export field: Aanhef
2016-05-19 12:01:04 0 [DEBUG] Export field: Achternaam
2016-05-19 12:01:04 0 [DEBUG] Export field: First name
2016-05-19 12:01:04 0 [DEBUG] Export field: Adres
2016-05-19 12:01:04 0 [DEBUG] Export field: Postcode
2016-05-19 12:01:04 0 [DEBUG] Export field: Plaats
2016-05-19 12:01:04 0 [DEBUG] Export field: Telefoonnummer
2016-05-19 12:01:04 0 [DEBUG] Export field: E-mail
2016-05-19 12:01:04 0 [DEBUG] Export field: Geboortejaar
2016-05-19 12:01:04 0 [DEBUG] Export field: Cursus
2016-05-19 12:01:04 0 [DEBUG] Export field: Order status
2016-05-19 12:01:04 0 [DEBUG] Export field: Order status naam
2016-05-19 12:01:04 0 [DEBUG] Export field: Totaal
2016-05-19 12:01:04 0 [DEBUG] Export query
SELECT `title`,
`user_info1`.`last_name`,
`user_info1`.`first_name`,
`address_1`,
`zip`,
`city`,
`phone_1`,
`user_info1`.`email`,
`Geboortejaar`,
`order_item_name`,
`#__virtuemart_orders`.`order_status`,
`order_status_name`,
`order_total`
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_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_nl_nl` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_nl_nl`.`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`

i removed the field and added it again. also i added the field product sku.
unfortunately both still only show 1 ordered item/sku.

hereunder the logfile

Details
Date 2016-05-19 12:05:07 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 94 lines
2016-05-19 12:05:07 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:05:07 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:05:08 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:05:08 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:05:08 0 [DEBUG] CSVI Pro Version: 6.5.7
2016-05-19 12:05:08 0 [DEBUG] Joomla! version: 3.5.1
2016-05-19 12:05:08 0 [DEBUG] PHP version: 5.5.35
2016-05-19 12:05:08 0 [DEBUG] =========================
2016-05-19 12:05:08 0 [DEBUG] action: export
2016-05-19 12:05:08 0 [DEBUG] component: com_virtuemart
2016-05-19 12:05:08 0 [DEBUG] operation: order
2016-05-19 12:05:08 0 [DEBUG] localpath: /home/nederla1/public_html
2016-05-19 12:05:08 0 [DEBUG] ftphost:
2016-05-19 12:05:08 0 [DEBUG] ftpport:
2016-05-19 12:05:08 0 [DEBUG] ftproot:
2016-05-19 12:05:08 0 [DEBUG] ftpfile:
2016-05-19 12:05:08 0 [DEBUG] export_email_subject:
2016-05-19 12:05:08 0 [DEBUG] export_email_body:
2016-05-19 12:05:08 0 [DEBUG] export_filename:
2016-05-19 12:05:08 0 [DEBUG] export_file: csv
2016-05-19 12:05:08 0 [DEBUG] field_delimiter: ,
2016-05-19 12:05:08 0 [DEBUG] text_enclosure:
2016-05-19 12:05:08 0 [DEBUG] include_column_headers: Yes
2016-05-19 12:05:08 0 [DEBUG] signature: Yes
2016-05-19 12:05:08 0 [DEBUG] publish_state:
2016-05-19 12:05:08 0 [DEBUG] recordstart:
2016-05-19 12:05:08 0 [DEBUG] recordend:
2016-05-19 12:05:08 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-05-19 12:05:08 0 [DEBUG] export_price_format_decimal: 2
2016-05-19 12:05:08 0 [DEBUG] export_price_format_decsep: .
2016-05-19 12:05:08 0 [DEBUG] export_price_format_thousep:
2016-05-19 12:05:08 0 [DEBUG] header:
2016-05-19 12:05:08 0 [DEBUG] body:
2016-05-19 12:05:08 0 [DEBUG] footer:
2016-05-19 12:05:08 0 [DEBUG] language: nl-NL
2016-05-19 12:05:08 0 [DEBUG] splitorderline: No
2016-05-19 12:05:08 0 [DEBUG] ordernostart:
2016-05-19 12:05:08 0 [DEBUG] ordernoend:
2016-05-19 12:05:08 0 [DEBUG] orderlist:
2016-05-19 12:05:08 0 [DEBUG] orderdaterange:
2016-05-19 12:05:08 0 [DEBUG] orderdatestart:
2016-05-19 12:05:08 0 [DEBUG] orderdateend:
2016-05-19 12:05:08 0 [DEBUG] ordermdatestart:
2016-05-19 12:05:08 0 [DEBUG] ordermdateend:
2016-05-19 12:05:08 0 [DEBUG] order_address:
2016-05-19 12:05:08 0 [DEBUG] orderpricestart:
2016-05-19 12:05:08 0 [DEBUG] orderpriceend:
2016-05-19 12:05:08 0 [DEBUG] groupbyfields: {"name":[]}
2016-05-19 12:05:08 0 [DEBUG] sortfields:
2016-05-19 12:05:08 0 [DEBUG] use_system_limits: No
2016-05-19 12:05:08 0 [DEBUG] max_execution_time:
2016-05-19 12:05:08 0 [DEBUG] memory_limit:
2016-05-19 12:05:08 0 [DEBUG] =========================
2016-05-19 12:05:08 0 [DEBUG] Export field: Aanhef
2016-05-19 12:05:08 0 [DEBUG] Export field: Achternaam
2016-05-19 12:05:08 0 [DEBUG] Export field: First name
2016-05-19 12:05:08 0 [DEBUG] Export field: Adres
2016-05-19 12:05:08 0 [DEBUG] Export field: Postcode
2016-05-19 12:05:08 0 [DEBUG] Export field: Plaats
2016-05-19 12:05:08 0 [DEBUG] Export field: Telefoonnummer
2016-05-19 12:05:08 0 [DEBUG] Export field: E-mail
2016-05-19 12:05:08 0 [DEBUG] Export field: Geboortejaar
2016-05-19 12:05:08 0 [DEBUG] Export field: Order status
2016-05-19 12:05:08 0 [DEBUG] Export field: Order status naam
2016-05-19 12:05:08 0 [DEBUG] Export field: Totaal
2016-05-19 12:05:08 0 [DEBUG] Export field: order_item_name
2016-05-19 12:05:08 0 [DEBUG] Export field: order_item_sku
2016-05-19 12:05:08 0 [DEBUG] Export query
SELECT `title`,
`user_info1`.`last_name`,
`user_info1`.`first_name`,
`address_1`,
`zip`,
`city`,
`phone_1`,
`user_info1`.`email`,
`Geboortejaar`,
`#__virtuemart_orders`.`order_status`,
`order_status_name`,
`order_total`,
`order_item_name`,
`order_item_sku`
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_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_nl_nl` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_nl_nl`.`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`

Hello,
Can you send me your Joomla administrator login details and database access details? I will look into your site directly.

I sent login details to contact@csvimproved.com hope we can fix it.

Hello,
I just checked your site and did a export of order with order items and I dont see any issue as reported. I have added group by field as virtuemart_product_id and sort by order_number to your template "deelnemerslijst" and also two template fields order_number and product_sku for my testing. I can see that all products in that order are exported. I cross checked it with virtuemart orders page. Can you check the export now and tell me if that is what you wanted?

Two products will be shown as two different rows in excel file and not in one single row.

Is there a workaround for this?

Was hoping to combine quantity and sku of each item purchased in each order in one cell. For example: "2 sku1 3 sku2 1 sku3" and the rest of the order details in one Virtuemart Order Export row.

Is this possible?

Best

Hello Monica,

Was hoping to combine quantity and sku of each item purchased in each order in one cell. For example: "2 sku1 3 sku2 1 sku3" and the rest of the order details in one Virtuemart Order Export row.

Is this possible?

You can use CSVI combine rule plugin for combining these two fields for each row but it is not possible for multiple rows, Have a look at the combine plugin document to know how to create rule for the same.

To do multiple row combine you need to create your own code in an override to make export work as you need it.

Thanks Tharuna,

OK, just to clarify...

An export containing multiple sku's in one line such as:

John Smith, 11 Test Street, Beverley Hills, CA, 90210, 2 sku1 3 sku2 1 sku3, 55-555-555 is not possible, but the combine plugin is able to create something like:

John Smith, 11 Test Street, Beverley Hills, CA, 90210, 2 sku1, 55-555-555
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 3 sku2, 55-555-555
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 1 sku3, 55-555-555

If I want the first example I'd need to create an override... Correct?

Best,

Monica

Hello Monica,

If I want the first example I'd need to create an override... Correct?

Yes, you need to create an override to export multiple sku's in one line.