Sales Order Data

WATCH THE VIDEO

This article contains the description of the Sana specific sales order data which is filled in by a customer in the Sana webshop during the checkout process.

While placing an order in the Sana webshop a customer can select delivery method, payment method, add reference number and comment, select requested delivery date. All this information is stored in the sales order in Microsoft Dynamics GP.

To check the Sana specific sales order data in Microsoft Dynamics GP, open the necessary sales order and at the top of the Sales Transaction Entry window click: Additional > Sana Commerce.

The table below provides the description of the Sana specific fields.

Field

Description

General

Webshop ID

The webshop ID where an order was created.

Sana Order ID

The ID of the order which was created from the Sana webshop when connection between the webshop and Microsoft Dynamics GP was lost. In this case, when connection is back and the order is sent to GP, it will be checked by this ID not to create the order duplicate.

Document No.

The number of the sales document.

SOP Type

The type of the sales document.

Reference No.

The reference number which a customer can enter on the Order Overview step while placing an order in the webshop.

Shop Account Email

Customer's shop account e-mail from Sana Admin.

Admin Account Email

The email address of a webshop administrator.

If customers face some difficulties in the checkout process, a customer service representative can impersonate customers and place the order for them. If a customer service representative impersonates a customer and places an order in the Sana webshop, then the e-mail address of the webshop administrator will be recorded into the sales order.

Using this field, a sales manager in Microsoft Dynamics GP can easily differentiate sales orders placed by the customer and customer service representative.

For more information, see Shop Accounts.

Order Authorization status

The status of the order after authorization. The order can be approved or declined.
For more information, see Shop Account Roles.

Shipment Method Name

The name of the delivery method selected by a customer in the Sana webshop while placing an order.

Quote Promotable

NOTE

This option is applicable only to the sales quotes.

The Quote Promotable checkbox indicates whether a customer can convert a quote into an order from the quote details page in the Sana webshop. If this checkbox is selected, a customer can convert a quote into an order directly in the Sana webshop.

For more information, see Order Types: Quotes and Orders.

Persisted Order

Sana provides several order processing strategies, one of which is optimized for large orders. It allows placing large orders, for example an order that consists of more than 100 order lines.

If this checkbox is selected, it means that this order or quote is in process of creation by a customer using the optimized for large orders order processing strategy and it is not completed yet. Therefore, a user in Microsoft Dynamics GP should not process (ship, invoice, etc.) draft orders and quotes.

Return Reason

The return reason which a customer selects for the return order while creating a return order in the Sana webshop.

For more information, see Return Orders.

Payment

Payment Method

The name of the payment method selected by a customer in the Sana webshop while placing an order.

Payment Status

The status of the order payment.

Payment Transaction ID

The unique payment transaction ID. For more information, see Payment Transaction IDs.

Payment Method Type

NOTE

Applies to: Sana Commerce Cloud 10.0.56 and higher in Microsoft Dynamics GP

Sana stores the payment method type that was used by the customer to pay for the order, such as Visa, Mastercard, American Express, etc. This payment method type is sent by the payment service provider used to process payments.

NOTE

Currently, only the payment method type sent by Sana Pay payment provider is stored in this field. Other payment providers do not support this feature for now.

Promotion

If a customer applied a discount from Sana Admin to the sales order, information about discount will be available in the Promotion section. There you will see the title of the discount, discount type and amount / percentage, etc.

If a webshop discount from Microsoft Dynamics GP is applied in the shopping cart, the webshop discount amount will be shown in the Webshop Discount field.

Pickup Location

Pickup Location ID

Some delivery services support pickup locations, for example nShift. If customers place an order in the Sana web store and select a shipping carrier which supports pickup locations, they can select a pickup location instead of the shipping address. In this case, the ID and address of the selected pickup location will be stored in these fields. 

Pickup Location Address

Comments and Requested Delivery Date

When placing an order in the webshop, it is possible to enter a reference number, comment and requested delivery date on the Order overview step.

You can show and hide these fields on the last checkout step per customer type and make them optional or required. For more information, see Checkout Header Fields.

This information is also saved with the sales order to Microsoft Dynamics GP.

To view the Requested delivery date, click on the expansion button in the Date field. The requested delivery date is stored in the Requested Ship Date field. If a customer does not enter the requested delivery date while placing an order in the webshop, the current date of the order will be used.

For more information about the requested delivery date, see Delivery Dates.

The Comments field is limited with 2000 characters.

To view sales order comments in Microsoft Dynamics GP, open the necessary order and at the top click: Additional > Sana Commerce. In the Sana Sales Transaction Details window see the Comment text box.