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.
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
Best regard
- arnaud49
- RO CSVI
- Monday, 09 July 2018
- Subscribe via email
0
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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`
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`
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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
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
Accepted Answer
Pending Moderation
Hello,
Have a look at Setting up a cron job document to run a export on command line.
Can you explain what you mean by command export? You can check the above linked document for command line export.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »