Export orders: empty fields in csv

Shopware 6 (English)
1

Good afternoon,

We are currently migrating from Shopware 5 to Shopware 6, and in order to manage our shipments, it is essential for us to use the Import/Export module of Showpare 6 to be able to obtain the data of the orders in CSV.

The problem we have encountered is that it is impossible for us to know the ISO or ISO3 value of the shipping country and the shortcode of the country state. For this we have duplicated the Default orders profile, and we have added a field linked to the Database entry = „deliveries.shippingOrderAddress.country.iso“ and another field linked to the Database entry = „deliveries.shippingOrderAddress.countryState.shortCode“.

shipping_address_country_state
shipping_address_country_state1795×659 40.1 KB

Up to this point all the steps have been correct, but when exporting the CSV these new fields appear empty, without any value. This is strange, since the country ISO of the billing adress is shown correctly: billingAddress.country.iso

Steps to reproduce:

  1. Duplicate Default orders profile.
  2. Add a field linked to the Database entry = „deliveries.shippingOrderAddress.country.iso“.
  3. Add another field linked to the Database entry = „deliveries.shippingOrderAddress.countryState.shortCode“.
  4. Export the created profile as CSV.

How can we solve this error?, we need to show the ISO of the country where the order is being shipped and the shortcode of the country state in the CSV.

Thanks for the help!

1 „Gefällt mir“