ERP User GuideSAP Business One

SAP Business One

Sana Commerce 9.3
Your connector

Sales Order Data



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

While placing an order in the Sana web store a customer can select delivery method, payment method, add reference number and comment. All this information is stored in the sales order in SAP Business One. The Sana specific sales order data which is coming from the Sana web store can be seen in the sales order, on the Web Store tab and in the User-Defined Fields. It can be also seen on the Web Store tab and in the User-Defined Fields of a sales quotation and delivery document.

The table below provides the description of the Sana Commerce user-defined fields of the sales order.

Field Description
Promotion Code A discount code (from Sana Admin) applied to a sales order in the Sana web store.
Shop Account Email Customer's shop account e-mail from Sana Admin.
Promotable Quote

    This option is applicable only to the sales quotations.

This field indicates whether a customer can convert a quotation into an order from the order details page in the Sana web store. If the value of this field is Y, a customer can convert a quotation into an order directly in the Sana web store.

For more information, see "Order Processing".

Requested Delivery Date

  It applies only to promotable quotations which can be converted to sales orders in the Sana web store.

In the Sana web store, on the last checkout step, a customer can enter the requested delivery date. This date is stored in this user-defined field only for promotable sales quotations and copied to the sales orders converted from quotations.

For more information, see "Configure Sana Web Store".

Payment Method Name The name of the payment method selected in the Sana webshop while placing an order.
The payment cost is stored in the sales order freight charges and is registered on the payment cost account set in the Web Stores table.
Payment Transaction Id The unique payment transaction ID.
Payment Method Status The status of the payment method.
Title The title of the discount.
Discount Assortment Type The type of the discount. For example, fixed amount or percentage.
Authorization Status The status of the order after authorization. The order can be approved or declined.

For more information, see "Shop Account Roles".
Web Store The ID of the web store where an order was created. 
Invoice Discount Percentage The discount which can be granted to the customer when he or she pays the invoice prior to the due date.

For more information, see "Online Invoice Payments".
Promotion Discount Percentage The discount percentage coming from the Sana web store. This is not the discount managed in SAP Business One, but the one created in Sana Admin.

For more information. see "Discount Codes".
Shipping Method Name The name of the shipment method selected in the Sana web store while placing an order.
Return Attachments The URLs to the attachments added by the customer while creating a return order in the Sana web store.

For more information, see "Return Requests".
Return Reason Code The code of the return reason which a customer selects for the return order header while creating a return order in the Sana web store.

For more information, see "Return Requests".
Pickup location Id Some delivery services support pickup locations, for example Consignor. If a customer places an order in the Sana web store and selects a shipping carrier which supports pickup locations, he or she 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

Payment and shipping costs

Payment and shipping methods and their costs selected by a customer while placing an order are stored in the sales order freight charges. To see payment and shipping costs of the order, click on the arrow button in the Freight field at the bottom of the Sales Order window. The payment and shipping costs are registered on the accounts set in the Web Stores window.

Reference number, comments and requested delivery date




 NOTE

Comments, delivery date and reference number are available only to business customers up to Sana 9.3.1, starting from Sana 9.3.2 to all customers.


Customers and sales agents can enter a reference number, comments and requested delivery date in the web store while placing an order.

The Comments field is limited with 2048 characters.

You can enable and disable reference number, comments and requested delivery date in Sana Admin: Setup > Ordering & checkout > Ordering.

On the screenshot below you can see where the reference number, comments and requested delivery date are stored in the sales documents in SAP Business One.

Requested Delivery Date

  • If a customer creates an order, the requested delivery date will be stored in the Delivery Date field in the general area of the sales order.
  • If a customer creates a quotation, the requested delivery date will be stored in the Valid Until field in the general area of the sales quotation.
  • If a customer creates a promotable quotation which can be converted to a sales order in the Sana web store, the requested delivery date will be stored in the user-defined field Requested Delivery Date of the sales quotation. When a customer converts a quotation to a sales order, the requested delivery date will be copied. You can also set up the requested delivery date for promotable sales quotations which can be converted to sales orders in the web store settings in SAP Business One. Click: Web Store > Web Stores > General. For more information, see "Configure Sana Web Store".
ERP User GuideSAP Business One