Resolved Advanced order: export only one order data record

Hello Teresa,
You have set the date range filter on options tab in your export template settings to export the records of this month. Please check if the orders missing are having created_on field date to be of this month. If yes, can you send me your test site mysql dump to check? You can either send me a private message or post an email to tharuna@csvimproved.com.

Hello Tharuna,

it's the same when I set the date range filter to "Don't use". When I set the filter to last run, an error comes up - see attachment - and the exported file contains no data.

Send you a private message with access data.

Kind regards,

Teresa

Hello Tharuna,

attached the sql dump and log for the last export with date range of "this year".

Kind regards,

Teresa

Hello Teresa,
Thank you for sending the details, it really helped to find the cause for the issue. The export will be fixed once you load the attached patch file from CSVI maintenance menu. Run the export and let me know.


patch_vm_order_advance_export_2016-11-04.zip

Hello Tharuna,
thank you very much for the quick solution!!! Installed the patch and it works great

Kind regards,

Teresa

Hello,
still a bit trouble with xml export of address data. If an order has a different shipment address, I need both addresses billing AND shipment exported. I added all necessary fields to the template. However only one address is exported. Tried different settings in template option regarding addresses.

<Shipping_Billing>[address_type]</Shipping_Billing>

<Billing_Title>[title]</Billing_Title>
<First_Name_Billing>[first_name]</First_Name_Billing>
<Last_Name_Billing>[last_name]</Last_Name_Billing>
<Full_Name_Billing>[full_name]</Full_Name_Billing>
<Company_Billing>[company]</Company_Billing>
<Address_1_Billing>[address_1]</Address_1_Billing>
<Address_2_Billing>[address_2]</Address_2_Billing>
<City_Billing>[city]</City_Billing>
<State_Billing>[state_name]</State_Billing>
<Zip_Billing>[zip]</Zip_Billing>
<Country_Name_Billing>[country_name]</Country_Name_Billing>
<Email_Billing>[email]</Email_Billing>
<Phone_Billing>[phone_1]</Phone_Billing>
<Mobile_Billing>[phone_2]</Mobile_Billing>


<Shipping_Title>[shipping_title]</Shipping_Title>
<First_Name_Shipping>[shipping_first_name]</First_Name_Shipping>
<Last_Name_Shipping>[shipping_last_name]</Last_Name_Shipping>
<Full_Name_Shipping>[shipping_full_name]</Full_Name_Shipping>
<Company_Shipping>[shipping_company]</Company_Shipping>
<Address_1_Shipping>[shipping_address_1]</Address_1_Shipping>
<Address_2_Shipping>[shipping_address_2]</Address_2_Shipping>
<City_Shipping>[shipping_city]</City_Shipping>
<State_Shipping>[shipping_state_name]</State_Shipping>
<Zip_Shipping>[shipping_zip]</Zip_Shipping>
<Country_Name_Shipping>[shipping_country_name]</Country_Name_Shipping>
<Email_Shipping>[shipping_email]</Email_Shipping>
<Phone_Shipping>[shipping_phone_1]</Phone_Shipping>
<Mobile_Shipping>[shipping_phone_2]</Mobile_Shipping>

How can I solve this?

Kind regards,

Teresa

Hello Teresa,

Let me have a look at this with you. Looking at the debug log you posted in your initial post I see that the Order address type is set to Don't use, that should be enough to export both addresses. I wonder if the patch has an influence on that. I will check that and see what I can find. Can you post the new debug log of your export for me?

Hello Rolandd,

attached the last debug log. Order Id 5 should contain a shipment address.Thanks for your help!

Kind regards,

Teresa

Hello Teresa,
There is a problem with your data, the virtuemart_user_id stored in database is 0 for the shipping address in your database. If you know how to do, go to PHPMyadmin >> select your database >> Select table #__virtuemart_order_userinfos, you can see column virtuemart_user_id as 0 and there is only one row with shipping address. You need to correct that so you see the details in your XML. Let me know if it helps.

Good morning Tharuna,

the order with virtuemart_user_id 0 is a guest order without registration.

I just made a new order with my registered account, however no shippg data is given over to XML.

Kind regards,

Teresa

Hello Theresa,

Thank you for that info. I have also taken a look at the database dump you posted and one issue I noticed is that the virtuemart_product_manufacturers and the virtuemart_manufacturers table is empty. Is it really empty in your case?

I have reworked the order advanced export routine and it now outputs all the shipping info and all orders. Can you apply the attached patch file and let me know if it works for you?

Hello Rolandd,

1. That's correct - we normally don't need manufactorers because the vendor is the manufactorer, it's a small champagne producer in SW-Germany.

2. Patch file is installed, however a sql error comes up:
Fehler
Unknown column 'shipping_address_1' in 'field list' SQL=SELECT `#__virtuemart_orders`.`virtuemart_order_id`, `address_1`, `address_2`, `address_type`, `address_type_name`, `agreed`, `city`, `company`, `user_info1`.`virtuemart_country_id`, `coupon_code`, `coupon_discount`, `#__virtuemart_orders`.`created_by`, `#__virtuemart_orders`.`created_on`, `customer_note`, `customer_number`, (`order_discount` / `order_total`) * 100 AS `discount_percentage`, `user_info1`.`email`, `fax`, `first_name`, `user_info1`.`first_name`, `user_info1`.`middle_name`, `user_info1`.`last_name`, `invoice_number`, `ip_address`, `last_name`, `#__virtuemart_orders`.`locked_by`, `#__virtuemart_orders`.`locked_on`, `middle_name`, `#__virtuemart_orders`.`modified_by`, `#__virtuemart_orders`.`modified_on`, `order_billDiscountAmount`, `order_billTax`, `order_billTaxAmount`, `order_create_invoice_pass`, `order_currency`, `order_discount`, `order_discountAmount`, `order_item_currency`, `order_item_name`, `order_item_sku`, `order_language`, `order_number`, `order_pass`, `order_payment`, `order_payment_tax`, `order_salesPrice`, `order_shipment`, `order_shipment_tax`, `#__virtuemart_orders`.`order_status`, `order_status_name`, `order_subtotal`, `order_tax`, `order_total`, `payment_currency_id`, `payment_currency_rate`, `#__virtuemart_orders`.`virtuemart_paymentmethod_id`, `payment_name`, `phone_1`, `phone_2`, `product_attribute`, `product_basePriceWithTax`, `product_discountedPriceWithoutTax`, `product_final_price`, `product_item_price`, `product_priceWithoutTax`, `product_item_price` * `product_quantity` AS `product_price_total`, `product_quantity`, `product_subtotal_discount`, `product_subtotal_with_tax`, `product_tax`, `#__virtuemart_orders`.`virtuemart_shipmentmethod_id`, `shipping_address_1`, `shipping_address_2`, `shipping_city`, `shipping_company`, `shipping_country_2_code`, `shipping_country_3_code`, `shipping_country_name`, `shipping_email`, `shipping_fax`, `shipping_first_name`, `shipping_full_name`, `shipping_last_name`, `shipping_middle_name`, `shipping_phone_1`, `shipping_phone_2`, `shipping_state_2_code`, `shipping_state_3_code`, `shipping_state_name`, `shipping_title`, `shipping_zip`, `user_info1`.`virtuemart_state_id`, `title`, `tos`, `#__virtuemart_orders`.`virtuemart_user_id`, `#__virtuemart_orders`.`user_currency_id`, `user_currency_id`, `user_currency_rate`, `virtuemart_order_item_id`, `virtuemart_order_userinfo_id`, `virtuemart_product_id`, `virtuemart_state_id`, `#__virtuemart_orders`.`virtuemart_vendor_id`, `zip` 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_de_de` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_de_de`.`virtuemart_paymentmethod_id` LEFT JOIN `#__virtuemart_shipmentmethods_de_de` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods_de_de`.`virtuemart_shipmentmethod_id`

Kind regards,

Teresa

Hello Teresa,

Apologies for that, my mistake. Attached the updated patch file.

we normally don't need manufactorers because the vendor is the manufactorer

Ok, that explain it. This is also something I want to look in further to optimize.

Hello Rolandd,

installed the patch and still no shipping data in XML export.

Kind regards,

Teresa

Hello Teresa,

That I am surprised about because I used the data you posted earlier in this thread. Can you send me a private message with Joomla and FTP login details? I will have a look to see what is going on.

Hello Rolandd,

installed the new patch and and playing around with exports. On first view all looks fine! Shipping_email is not given over - it's not important!

A real problem is, that all products in orderline are coming now twice AND it's impossible to import the XML into ACCESS database.

Kind regards,

Teresa

Good morning Teresa,

Those duplicates happen because of the way data is retrieved from the database. That can be resolved by grouping fields as explained in the Use of Group by and Sort by fields. I have done this for the SD2000-OA template, so please check if that is OK for you now. Looks good to me.

Hello Tharuna,

Roland has made an override for the advanced export. I know, Roland is outside, but I have some trouble with earlier working fields:

"order_status_name" AND "payment_name" will no longer be passed to the XML. The override is used in the templates SD2000-OA Modified and SD2000-OA.

Due to we are in a final test state, kindly request your help.

Kind regards,

Teresa

Hello Teresa,
I am looking into this, will let you know on what i find.

Hello Teresa,
Can you check the export now? I have fixed both "order_status_name" AND "payment_name" in export file. Please confirm.