After the Export Orders extension release, we got a lot of questions about its fitness for particular use. In this article, we’ll tell you about the most popular Q&As, as well as show the needed settings.

Without further ado, let’s start.

 

Use case #1. Export specific orders

Problem

I need to export all the orders that have a specific delivery city. Also, I need these columns in my exporting file: shipping city, order id, order creating date, order subtotal, customer name from the shipping info.

Solution

Our extension includes field configurations and filters. This is how it works.

Step 1. Go to System > Export Orders > Profiles and create a new profile by clicking Add New Profile.

Step 2. Then, open the Fields Configuration tab. Here you can add the needed columns and customize their names for the export file if needed. To show you the example, we will open the Order (root entity) and add subtotal,increment_id, and created_at fields:

use case 1 order fields

Next, in the Sales Order Shipping Address, we enable fields: firstname, lastname, and city:

use case 1 shipping fields

Step 3. When you have added all the needed columns, move to the Export Filters tab. There you can add filters to export the required orders only. In our case, we need to export orders with the specific delivery city. For this, we open the Sales Order Shipping Address section and choose the city from the Field For Filtering dropdown:

use case 1 city filter

Also, make sure that you enabled the Exclude Parent Entity Row If No Results Found option.

Step 4. Then fill out this form and save the profile.

As a result, you will get the file that has all the necessary columns, and you will save time on filtering and exporting particular info about orders.

Problem

I want to export orders that were placed by guest users.

Solution

Here are 3 options you can use to filter these orders: by customer_id, customer_is_guest, customer_group_id.

After you have created a new profile, and chosen the needed fields, go to the Export Filters tab. Open the Order section and click Add Filter.

Customer_group_id filter allows you to export orders placed by a specific customer group, for example, not logged in or retailer:

use case 1 customer group

Customer_is_guest filter exports all the orders made by not logged in users:

use case 1 customer is guest

And if you want to use the filter by customer_id, you set the filter condition to the is null option:

use case 1 customer id

Use case #2. Export custom fields

Problem

I want to export custom fields from a 3rd-party extension.

Solution

Our plugin allows you to export additional attributes from 3rd-party extensions. For this, you need to set up the 3d Party Connection.

Step 1. Navigate to System > Export Orders > 3rd Party Connections and click Add New Connection:

use case 2

Step 2. Then, enter the name of the integration that your managers will understand, and choose the table that you want to join from the Table to Join dropdown.

Step 3. In the Parent Entity field, specify where you want to join this table.

Step 4. Next, choose the field from the joinable table that will connect these 2 tables.

Step 5. In the Base Table Key field, enter the corresponding field from the parent entity table.

Step 6. Save the changes.

After this, you will be able to export fields and values from this table.

Use case #3. Take action to orders after exporting

Problem

I need to export all the orders with the pending status every hour and then change their status to processing. Is it possible?

Solution

Our plugin includes a lot of features for automation. ‘Actions after exporting’ is one of them.

Step 1. Create a new profile and add filters as we described in the first example:

use case 3 filter

Step 2. Then, go to the General Configuration tab, and open the Actions With Orders After Exporting section.

Step 3. There you will see all the available actions that our extension can do after reporting is complete. For this case, you’ll need to set the Change Processed Orders Status To field to Processing and Add Comment to Status History if needed:

use case 3 action

Step 4. Next, you need to open the Automatic Export tab, enable the Run Profile by Cron option and indicate how often you want to export this profile:

use case 3 cron

Use case #4. Export by a trigger

Problem

I want to export a profile whenever someone places a new order.

Solution

Our extension supports both options for automatic exporting: by event and by cron. For this case, you’ll need to use exporting by an event.

Step 1. Create a new profile and set Export Only New Entities to Yes, if you don’t want to export old orders:

use case 4 new entities

Step 2. Then, go to the Automatic Export tab and set the Run Profile by Event field to Yes.

Step 3. In the Export Event filed, choose what events will trigger exporting. In our case, we use order creation:

use case 4 event

Use case #5. Send export reports by email

Problem

I need to send a sales report to stakeholders every day. It should include the order number, date, total, and Qty. Can I send this export file to several emails?

Solution

After the export file is generated, you can send it by email. To do it automatically, specify email addresses in the Output Options tab.

In the Export File Storage section, you can choose the email sender, enter email address and subject, and select the email template:

use case 5

If you need to send this report to multiple email addresses, just enter them separated with commas.

Use case #6. Export orders for the ERP system

Problem

I need to export an XML file via FTP every 5 minutes by cron.

Solution

Our extension supports 6 file formats: CSV, XML, ODS, XLSX ,JSON, and Template . To choose the XML, create a new profile, and open the File Settings tab. Here you can choose the file format and customize additional fields that will appear depending on the chosen format:

use case 6 file type

In the Output Options, you can set up where you want to store this export file. Our extension supports server, FTP, SFTP, email, Rest API Endpoint. To upload the file by FTP, you need to specify the host, file path, username, and password:

use case 6 ftp

Also, as we mentioned above, you can set up automatic exporting by cron.

Explore Export Orders and don’t forget that all our export and import extensions will be combined in an all-in-one Import and Export solution.

Our extension was designed to meet the most popular needs and ERP systems requirements, but we are open to your feature requests and can offer you custom development for unique cases.

That’s it for today!

Stay tuned!

P.S. Special thanks to Yulia Tihomirova, Karina Luzan, and Alexander Seravin for the help with this post.