Customer Order Status Extract v2

Summary

The Customer Order Status Extract v2 provides a comprehensive breakdown of all orders processed through the web or telesales channels. This report includes details such as order number, third-party order number, customer's name, recipient address, product, despatch method, value, and order status.

You can also filter the report by status. A detailed explanation is provided further below.

Fields available in this report are:

Order Number, Third Party Order, Sender Name, Order Status, Recipient Name, Recipient Post Code, Despatch Policy, Delivery Status, Department, Sub Department, Stock code, Catalogue, Description, Colour, Size, Personalisation, Despatch Branch, Despatch Method, Quantity Ordered, Total Sell, Price Status, Quantity In Pick, Quantity Despatched, Quantity Returned, Line Status, Transaction Date, Source, Despatched Date, Email, Forename and Client Ref

Diffetence between V1 and V2 of Customer Order Status Extact.

There is no difference, and the purpose of building this is to enhance performance, as it operates in the background.

To access the report, follow these steps:

1. Navigate to the menu: Order Reporting > Customer Order Status Extract v2.

If the menu is not visible, you may need to adjust your permissions:

1. Go to Employee Maintenance.

2. Edit permissions for Order Reporting.

3. Ensure that permission for Customer Order Status Extract v2 is granted.

Once the report is created, you will be redirected to the reporting dashboard. The report will be available for download once it is ready.

Status:

Placed : The date that the order is created in the system. This will give you all the orders that was created in the system for that given date range.

Pending : This gives you the list of the orders that is still Outstanding in the system i.e. order placed but not fully despatched.
 
Completed :  The list of the order that is Shipped in the system in the given date range.   

Cancelled: The list of Cancelled order in the given date range.

Returned:  The list of Returned order in the given date range.

• Related Articles

• Customer Order Despatch Confirmation

  Once the order has been picked and packed you will need to update it as despatched. Special Note: Once you update the order the stock is updated and the customer is sent an email with the despatch details. Enter the order number of the order you wish ...

• Customer Order Picking Note Printing

  Customer Order Picking Note Printing To print the released orders select Picking Note Printing from the Order Despatching Menu. The screen above will be shown, there are options in this program to allow you to specify the orders you want to print or ...

• How Do I Set Up A Pre-Order or Kit Launch?

  PLEASE READ THE WHOLE DOCUMENT BEFORE YOU MAKE ANY CHANGES TO THE SYSTEM. NOTE: We need to know at least 1 week in advance when you are planning to go live with your Kit Launch. This is because we need to plan our resources to be able to assist you ...

• Use Customer Group Import Utility

  Import using a CSV with Client Ref, Name and Email Go to Customer Database > Customer Group Import Utility Click on the Import Season Ticket Holder tab. NOTE: The CSV File needs to have 3 columns and in the following order. The Name column can be ...

• Extract Customer Information

  To extract customer information you can go into Customer Database - Customer Database Extract Within here you can enter specific date ranges among other details and will include email address' for contact purposes. The below screenshot shows the ...