Resolved Export VirtueMart Order Item Export with complete user info

Hello,

I am trying desperately to create a command line CSV export with issue number, product SKU, product name, quantity, full name, address1, address2, city.

Have a look at Setting up a cron job document to run a export on command line.

The problem is that some information is in command export and other in command line
I do not see how to make a connection between the two

Can you explain what you mean by command export? You can check the above linked document for command line export.

I need to export for my carrier the lines of command of the day before with the fields:
sku item / item name / quantity / order number / full name / address 1 / address 2 / city / country


Except that on the export of the lines of command I do not have access to the complete information of order.
On the command exports if I add the fields sku product and quantity, I have only one line and not all the lines of the command.

Thank you for your help

Hello,
It looks like you are having one line in your export file but you are expecting multiple records on export. Is that what is your issue? If yes, can you post the debug log of the export to check? Check How to get debug information? document to get the debug log.

Yes indeed, I should have several product lines per order but I only have the first line of product

SELECT `#__virtuemart_orders`.`virtuemart_order_id`,
`#__virtuemart_order_items`.`virtuemart_product_id`,
`#__virtuemart_order_items`.`product_attribute`,
`#__virtuemart_products`.`product_sku`,
`product_quantity`,
`address_type`,
`user_info1`.`first_name` AS `billing_first_name`,
`user_info1`.`middle_name` AS `billing_middle_name`,
`user_info1`.`last_name` AS `billing_last_name`,
`company`,
`address_1`,
`address_2`,
`city`,
`user_info1`.`virtuemart_country_id`,
`phone_1`,
`#__virtuemart_orders`.`created_on`,
`user_info1`.`email`,
`order_number`,
`#__virtuemart_orders`.`order_status`
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_fr_fr` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_fr_fr`.`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`.`created_on` >= '2018-06-19 00:00:00' AND `#__virtuemart_orders`.`created_on` <= '2018-06-19 23:59:59'
GROUP BY `order_number`
ORDER BY `#__virtuemart_products`.`product_sku`

Hello,
In your export template on Fields tab you have added order_number as Group by field, can you remove that and check the export? If you still have issue, post the complete debug log file to check.