Resolved I want Full Name to be Ship To Name

So basically i want the same functionality as Order Address Type....If there is not Name in Ship To the system will take the name from Bill To, and if there is a name in Ship To the system to take that name as Full Name... I don't know if that make sense

Again... i don't know what you did change in CSV 3 but everything was working fine in the 2.5 version.... So can someone tell me how to fix this "problem"?
So far this forum is not very useful.... Do you have any support ticket system? I'm ready to pay for support if is necessary!

This is the patch you give me for the old version

case 'full_name':
if ($address == 'BTST') {
$userfields[] = 'COALESCE('.$db->qn('user_info2.first_name').') AS '.$db->qn('first_name');
$userfields[] = 'COALESCE('.$db->qn('user_info2.middle_name').') AS '.$db->qn('middle_name');
$userfields[] = 'COALESCE('.$db->qn('user_info2.last_name').') AS '.$db->qn('last_name');
}
else {
$userfields[] = $db->qn('user_info1.first_name');
$userfields[] = $db->qn('user_info1.middle_name');
$userfields[] = $db->qn('user_info1.last_name');

Is this the fix? And where to put it the new version?

This is the file you send me 3 years ago...

https://www.dropbox.com/s/x8rcwc1uruxwhrj/orderexport.php?dl=0

It was inside administrator\components\com_csvi\models\com_virtuemart

Or can this be done with Rule? And what i need to put in the rule field?

Hello,

So far this forum is not very useful.... Do you have any support ticket system?

There is no second support system, you would have to wait just as long.

If you want to add some text, you could use the Edit button to alter your message and add more text.

This is the file you send me 3 years ago...

Sorry to say, I don't remember what I did 3 years ago. At least we have history to tell us, your original question is here.

Now to your question.

If there is not Name in Ship To the system will take the name from Bill To

That is what the Address Type field is for when you set it to Billing or shipping address.

Are you using the Advanced Order Export? That still has the code that you posted earlier for the full_name field.

Replace Full Name with Ship To name? Is this possible with rule?

Hello,

So far this forum is not very useful.... Do you have any support ticket system?

There is no second support system, you would have to wait just as long.

If you want to add some text, you could use the Edit button to alter your message and add more text.

This is the file you send me 3 years ago...

Sorry to say, I don't remember what I did 3 years ago. At least we have history to tell us, your original question is here.

Now to your question.

If there is not Name in Ship To the system will take the name from Bill To

That is what the Address Type field is for when you set it to Billing or shipping address.

Are you using the Advanced Order Export? That still has the code that you posted earlier for the full_name field.

I'm using order export. The problem right now is if someone create order for some other company his name is in Full Name when we export the file. And this is confusing for the people who receive the package.

How to make it like in our old system. When we export the orders Ship To name for Full Name?

"That is what the Address Type field is for when you set it to Billing or shipping address."
This work only for the Address not for the Full Name

I think i already confuse you so again and for the last time:

This is what i need

1.User make order
2.The system Export the order and take the Ship To Name and put it in Full_Name field
3. If the Order don't have the Ship To name the system will use Bill To name

I have Billing or shipping address enabled in my options but this function is working only for the address not for the name

Thanks

We are exporting data as CSV file

Do i need to patch the code or this can be done with Rule?

Hello,

I think i already confuse you so again and for the last time:

This is what i need

1.User make order
2.The system Export the order and take the Ship To Name and put it in Full_Name field
3. If the Order don't have the Ship To name the system will use Bill To name

I have Billing or shipping address enabled in my options but this function is working only for the address not for the name

The field you need to use in your export template to get shipping to name is shipping_full_name and not full_name. Add this field and see if it solves your issue.

Hello,
Can you load the attached patch file using maintenance menu and see if you get ship to name in full_name field if address is Billing or shipping address?

patch_vm_order_2016_12_23.zip

This patch fix only one part of the problem. Now the full name is empty if is the same (Bill to and Ship to are the same Full Name) Can you make it if the name is the same to use Bill To name? Right now the field is empty if both names are the same

Thanks

Hello,

Now the full name is empty if is the same (Bill to and Ship to are the same Full Name)

I don't see this happening with the patch. You are using the full_name field correct?

Please post your debug log of the export so I can check if the query is correct.

Hello,

Now the full name is empty if is the same (Bill to and Ship to are the same Full Name)

I don't see this happening with the patch. You are using the full_name field correct?.

Yes. I'm using full_name field and if the Bill Name and Ship Name are the same the system don't export any name... The field is empty inside the CSV file.

I send you PM with dropbox link to my debug info

Hello,

Received the debug log and looking at it but not understanding why you get an empty full name because the data is being pulled out of the database.

Can you give the attached updated patch a try? If it doesn't export the full name, can you also send me the exported file?

Success

With the new patch everything is working great! What was the problem in the first patch?

Thanks

Happy Holidays and thank you again for giving me the solution

Thank you for confirming it is now working.

The issue with the first patch was that it didn't completely recognize an empty name. The final patch has gone into the next release.

Happy holidays.

Thank you for confirming it is now working.

The issue with the first patch was that it didn't completely recognize an empty name. The final patch has gone into the next release.

Happy holidays.

Hi,
I want to upgrade to version 7.0.3. from CSVI Pro 7.0.0. I just want to be sure this patch was in the new version so i can update it?

Thanks

Hello,
Yes, you can update to 7.3.0 as the fix is available from CSVI 7.0 version.