1. ocean12
  2. RO CSVI
  3. Wednesday, 18 November 2015
  4.  Subscribe via email
Hi,

how can I add the DeliveryAddress in the advanced xml export.

Best regards
Ocean
Accepted Answer Pending Moderation
Hello,

The advanced order export only exports one address, which is either the shipping or the billing address. If you are in need of both, you can use the Snelstart export. This has a set of shipping_ field names you can use for the export. The advanced order export has not yet been updated with this.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
it works
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hi,

when the shipping address is the same as invoice address my field for delivery address is empty.
is there a way to tell CSVi export, when [shipping_address_1] is empty then use [address_1]

Best regards
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
In order export template settings on options tab, there is a filter to set order address type, set it to "Billing or shipping address" and try the export. See if it helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Okey what if the billing address is not always the same as the shipping address?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
If you click on the Help button in CSVI it will explain your questions :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Well there is a bug in that option.
When I don't select a shipping address (address same as invoice) it is still taking my shipping address because it exists.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
When I don't select a shipping address (address same as invoice) it is still taking my shipping address because it exists.
CSVI doesn't know about the address same as invoice option because it isn't stored. It can only see if VirtueMart has stored the billing and/or the shipping address. When both addresses are the same VirtueMart only stores the billing address.

In your case this order should have the shipping address stored in the database as well then. Can you check that?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Correct I have more ST addresses and one BT address in my database.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
I would expect that in the userinfo table but not in the orders table. As far as I know the orders have 1 BT address and 0 or 1 ST address.

So the orders table should always have more BT addresses than ST addresses.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
see attachment user info

the attachment before was the order info.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
is the export not using the order info to check which address id it must take?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
How would it know which address to take? The address ID is not stored with the orders but they are linked based on order ID. As I said before and as your screenshot shows, the order has 2 different addresses. If they were the same, there would only be 1 entry in that table.

That is why the option Billing or Shipping is there. Orders will be exported with their billing address unless a shipping address exists. The shipping address will be used in this case.

The case which you want, if there is no shipping address stored to fill the shipping values with the billing values, doesn't exist. Only the other way around. So use billing unless a shipping address exists.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
No.... :silly:

in virtuemart_order_userinfo_id you can see if virtuemart_order_id has a ST and BT address, see order 182.
then the export must use both.

When virtuemart_order_id had only BT address, see order 181, then the export must use the BT address for ST address
then it will be correct.

In your case it will always use my ST address when there is, even when I don't want that. Sometimes a order must send to a different address.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
No.... :silly:

When virtuemart_order_id had only BT address, see order 181, then the export must use the BT address for ST address
then it will be correct.
This is not implemented. The ST fields will only use the ST fields if they exist.

Sometimes a order must send to a different address.
Yes, that is what the Billing or shipping option is for. If there is an ST it will be used, otherwise the BT will be used.

Just in your case it is not the shipping_ fields that are filled but just the regular address fields. In short, the regular address fields can contain BT or ST data and the shipping_ fields only contain ST data. In your scenario the shipping_ fields can also contain BT data, how I understand it. That is just not implemented.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
So, what do I have to do to get the write information in the export?
senario 1:
shipping address (ST) is same as invoice address (BT)
senario 2:
shipping address is different from invoice address

now the template is like this:

[code type=xml]
<Customer>
<ID>[virtuemart_user_id]</ID>
<ContactPerson>[full_name]</ContactPerson>
<InvoiceAddress>
<Line1>[company]</Line1>
<Line2>[address_1]</Line2>
<Line3>[address_2]</Line3>
<Line4>[zip] [city]</Line4>
</InvoiceAddress>
<DeliveryAddress>
<Line1>[shipping_company]</Line1>
<Line2>[shipping_address_1]</Line2>
<Line3>[shipping_address_2]</Line3>
<Line4>[shipping_zip] [shipping_city]</Line4>
</DeliveryAddress>
</Customer>
[/code]

Order address type = Billing or shipping address
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,

So, what do I have to do to get the write information in the export?
Apply the patch that I have attached and it takes the billing information if the shipping information is empty.

senario 1:
shipping address (ST) is same as invoice address (BT)
This is your main issue, the delivery address will be empty because VirtueMart hasn't stored any shipping address.

senario 2:
shipping address is different from invoice address
That will work because VirtueMart has stored 2 addresses.

Would have been better if VirtueMart just consistently stored both addresses.
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!