<img src="abc.png" />
    
call to replace anchor tags contains '/admin' in href

Exporting orders

Reviewing orders one by one sometimes becomes chaotic, if multiple orders are to be reviewed. StoreHippo provides you with an option to export orders in bulk in CSV format that can be used as a backup.

Go to Orders > Orders section in StoreHippo Admin Panel to export the orders. Click on the vertical ellipsis button in the top section. The following drop-down appears:

Click on Export and a popup opened with the following fields:

Repeat order data

An order may contain multiple products. All the products in the order take a separate row in the CSV where the specifications of the product are different whereas rest of the details about the order such as transaction ID, shipping status, financial status remain same. 

If repeat order data is checked then it will display whole data of the order (order specific as well as product specific) in all of the rows, allotted to different products in the order.
For e.g., If we have exported the order data of an order with two products, then two rows will be allotted to the product. If it is exported with repeat order data checked then you can check the id, order id, status fields that are specific to the entire order repeated in both the rows.

If repeat order data is unchecked then it will display the order specific data in the first row allotted to that order, whereas for rest of the products it will only display the product-specific information such as product name, product price etc.
For e.g., we have exported the order data of an order with two products, hence two rows will be allotted to the product. If it is exported with repeat order data unchecked then it will show the entire order related data in the first row whereas data for the specific products will be shown in the respective rows.

Stored Filters

Choose the filter for which you want to export the file. To add a new filter, click on Add New and enter the Name of the filter. The filter stored automatically when the file is exported and will be available in the drop-down for the later use. 

Columns

You can export all of the columns in the order data, else you can also export specific columns based on your requirement.

  • All: Once clicked on 'All', then it will export all of the columns in the order data.
  • Select Columns: You can also select specific columns that are to be exported based on your requirement.

Filters

You can filter out the orders to be exported based on various filters. Click on Use Current Filter to apply the currently used filter. 

To create the advanced filters, click on Add filter and provide details in the following fields. 

Field

In the field drop-downyou will get below-mentioned options based on which you can filter out the orders.

  • Order id: You can search for a specific order based on its order ID.
  • Created on: You can search orders for a particular date on which the order was placed.
  • Shipping status: You can also search for orders based on their shipping status that can Not be Shipped, Ready to Ship, In Transit, Delivered etc.

Operator

Once the field is selected then you will be asked to select the operator.

  • Equals: It will filter out the orders that are equal to the value of the field selected.
  • Not equal: It will filter the orders that are not equal to the value of the field selected.
  • Greater than: It will filter out the orders whose order amount is not equal to 2500 but greater than 2500.
  • Less than: It will filter out the orders whose order amount is not equal to 2500 but less than 2500.
  • Less than or equal: It will filter out the orders whose order amount is less than or equal to 2500.
  • Greater than or equal: It will filter out the orders whose order amount is greater than or equal to 2500.


Value

Once the field and operator are selected then you can enter the value to be filtered. You can add multiple filters and system will filter out the data based on both of the filters selected.

Number of records

By default system exports 500 records in one go. However, the maximum limit to be exported in one go is 10000. To export 10000 records in one go, you can mark the number of records as 10000 or less.

Start marker

Start marker allows you to set the starting index for the export. The export will skip the number of orders specified in the field. In the first set, only 10000 records are exported. Hence to export next 4000 records, you can keep the number of records as 10000 and start marker as 10001, hence it will export records from 10001 to 20000.

Send To

Provide the email id on which you want to send the downloadable link to the exported file. The CSV file can be downloaded by the link provided in the mail. The link expires automatically after 7 days.

2018-06-20T10:12:58.951Z