Export Orders and Coupons

Exporting all your WooCommerce orders and coupons individually can be time-consuming. The free version of the Order / Coupon / Subscription Export Import Plugin for WooCommerce helps you export all your orders and coupons from one store to another efficiently and quickly.

To export WooCommerce orders/coupons:

• Click on WebToffee Import/Export(Basic) > Export.

As a first step, you need to choose the post type as Order.

Choose from the below options to continue with your export:

•  Quick export : exports the basic/standard fields.
•  Based on a pre-saved template : exports data as per the specifications(filters, selective column, mapping etc) from the previously saved file.
  Note: The template will be listed in the drop down only if you have saved it in previous exports, if you go through the Advanced export, at Step 5 you will get an option to save the template. Once you save that, next time when you want to export a pre-saved template, it will be populated within the drop down.
•  Advanced export: Takes you through a detailed process of filtering/column selection/advanced options that may be required for your export.
  
  Note: You can also save this file as a template for future use.
  

Filter data that needs to be exported as per the below criteria.

• Total number of orders to export : The actual number of orders you want to export. e.g. Entering 500 with a skip count of 10 will export orders from 11th to 510th position.
• Skip first n orders: Specify the number of orders to be skipped from the beginning. e.g., Enter 10 to skip the first 10 orders from export.
• Order IDs: Filter orders using Order IDs to export specific orders. Use a comma to add multiple IDs.
• Order Statuses: Filter orders by their status type. You can specify more than one type for export.
• Product: Export orders containing specific products. Key-in the particular product names to export orders accordingly.
• Email: Input the customer email to export orders about only these customers.
• Coupons : Enter coupons codes separated by comma to export orders on which these coupons have been applied.
• Date from : Export orders placed on and after the specified date.
• Date to : Export orders placed upto the specified date.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template. One can also move the columns to reorder the arrangement.

When you reach Step 5, the following window will appear. You can exclude the already exported orders, export line items into separate columns and rows, or export the orders in batches.

Exporting in smaller batches reduces the strain on the server, preventing performance slowdowns or timeouts. By splitting the process into batches, exports are quicker and less likely to fail due to overwhelming the system.

• Save the template file for future export as shown below(if needed).

• Click on Export and export or schedule the export to finish.

As a first step, you need to choose the post type as Coupon.

Choose from the below options to continue with your export:

•  Quick export : exports the basic/standard fields.
•  Based on a pre-saved template : exports data as per the specifications(filters, selective column, mapping etc) from the previously saved file.
  Note: The template will be listed in the drop down only if you have saved it in previous exports, if you go through the Advanced export, at Step 5 you will get an option to save the template. Once you save that, next time when you want to export a pre-saved template, it will be populated within the drop down.
•  Advanced export: Takes you through a detailed process of filtering/column selection/advanced options that may be required for your export.
  Note: You can also save this file as a template for future use.

Click on Step 3, to view the following window where one can filter data on the basis of:

• Total number of coupons to export : The actual number of coupons you want to export. e.g. Entering 500 with a skip count of 10 will export users from 11th to 510th position.
• Skip first n coupons : Specify the number of users to be skipped from the beginning. e.g. Enter 10 to skip first 10 users from export.
• Coupon Statuses : Export coupons with respect to their status.
• Coupon Type : Select the coupon type for export.
• Coupon amount: From: Specify the minimum discount amount for which the coupon was levied.
• Coupon amount: To : Specify the maximum discount amount for which the coupon was levied.
• Coupon Expiry Date: From: Specify the date from which the coupon will expire.
• Coupon Expiry Date: To: Specify the date till which the coupons will remain invalid.
• Sort columns: Sort the columns to get an exported file in a specified order.
• Sort By: Select the order in which you want the sorted columns to appear

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template. One can also move the columns to reorder the arrangement.

When you reach Step 5, the following window will appear. Exporting in smaller batches reduces the strain on the server, preventing performance slowdowns or timeouts. By splitting the process into batches, exports are quicker and less likely to fail due to overwhelming the system.

• Save the template file for future export as shown below(if needed).

• Click on Export and export or schedule the export to finish.