Order details

Each order in the system can be opened to access the Order Details view (Figure 1.1) and a number of associated order tools.

Figure 1.1 The Order details screen

The order details view consists of:

  • ribbon bar (1) which gives you access to a number of order tools
  • The order information area (2) where you can view the basic details of the order
  • A number of collapsible order detail boxes (3) which can be opened to access more advanced order details

This article will provide you with a rundown of all your options regarding order details.

When viewing an order the most prominent info is the basic order details (Figure 2.1).

Figure 2.1 The basic order details view

The basic order details provide you with a view of:

  • The OrderID, the order completion date, and potentially the ID of the base recurring order used to generate this order
  • The list of order items and any discountsorder line fields, unit, and stock location associated with each item
  • The payment and shipping methods selected - and any fees associated with them
  • The order subtotal, total, and totals excluding VAT & Taxes
  • The billing and shipping address details

In the upper right corner of the view you can access the edit order butto if permitted on your solution.

Below the basic order details you have access to the collapsible order detail boxes.

Consolidating taxes

By default all taxes are shown on separate orderlines – but this can get confusing if many taxes are applied, e.g. when using the Avalara AvaTax provider.

To make your order details less confusing, consolidate the taxes into a single order line by going to Settings > Ecommerce > Advanced configuration > General and activating the Taxes in backend settings (read more about the settings here).

The Comments box (Figure 3.1) lets you view and edit both the order comments and any customer comments.

Figure 3.1 Order comments

The Additional information box (Figure 4.1) contains any custom order fields present on your solution. Order fields are simply fields can be filled by either frontend user or backend staff, or during integration, and are a flexible way of working with custom order data in Dynamicweb.

Figure 4.1 An addtional information box with order fields

You can read more about custom order fields later in this article.

The order data box (Figure 5.1) provides you with access to various technical data about the order.

Figure 5.1 The order data box

You can view:

  • The standard sales tax or VAT rate
  • The shop the order was created from
  • The IP address of the computer usd to place the order
  • The last step in the order process (currently broken)
  • The exported info (returns true if order has been exported)
  • The order context of the order (if completed through an order context cart)

The currencies box (Figure 6.1) shows you the the details of the currency of the order

Figure 6.1 The Currencies box

You can review:

  • The name of the currency used for this order
  • The factor (exchange rate) compared with the default currency
  • The code for the currency

Read more about currencies in Dynamicweb here.

The transaction box (Figure 7.1) lets you review transaction details from the payment provider used for the order.

Figure 7.1 The transaction details box

The transaction details are returned to Dynamicweb from the payment providers, and consequently the information available may vary between providers.

Typically, the transaction number (in the payment provider system), statuscard type & card number (masked, except last 4 digits) is returned, but some providers may not return any information at all.

The Miscellaneous box (Figure 8.1) lets you review the price calculation date and the completion date. You can also access the user details of the (registered or unregistered) user who placed the order by clicking Details.

Figure 8.1 The Miscellanous details box

From the order details ribbon bar (Figure 9.1) you can access a number of tools for processing orders - use the arrow-buttons to navigate between orders.

Figure 9.1 The order details ribbon bar

The other order tools cover:

  • Capturing payment
  • Printing the order
  • Shipping documents
  • Track & Trace
  • The Order log

The Capture button (Figure 10.1) lets you capture payment for this order, as described in the Orders article.

Figure 10.1 The Capture button

These can be used to capture payment from and print the current order.

The Print button (Figure 11.1) lets you print the order details page, as described in the orders article.

Figure 11.1 The Print button

If your shipping provider supports it, you can click the Create shipping documents button (Figure 12.1) to create a .csv file (GLS) or send the data to the PacSoft webservice (Post Danmark) with the delivery details of an order, and use that with third party software to create labels automatically.

Figure 12.1 Creating shipping documents

The GLS provider creates a .csv file in the folder specified in the shipping provider settings (default is the /Files folder) – you must manually import this to the GLS Interline 7.0 service.

The Post Danmark provider send the data to the PacSoft webservice, and also saves the data to DB:EcomOrders >> OrderShippingDocumentData.

Creating shipping documents is implemented for the:

  • GLS shipping provider - compatible with GLS Interline 7.0 (Uni-Connect).
  • Post Danmark Servicepoints provider - compatible with PacSoft

Please note, that the order details transferred correspond to the shipping details, not the billing information.

If your solution has a track & trace scheme configured, you can click the Track & Trace button in the toolbar to open the delivery window (Figure 13.1) and enter tracking details for an order.

Figure 13.1 The track and trace window

The delivery window allows you to:

  • Provide a Track & Trace number
  • Select a Track & Trace URL scheme for generating a direct URL to the parcel service
  • Enter data into  the required data fields (e.g. a tracking code & languages ID, depending on your scheme)
  • Click the look up button to verify that the information entered is correct

Once created, you can use the track & trace template tags in order receipts and email notifications to generate tracking URLs for your customers.

You can read about creating Track & Trace schemes later in this article.

If you need to take a closer look at the flow of an order – e.g. for error handling – click the log button in the toolbar (Figure 14.1).

Figure 14.1 An order log

Before you can edit orders, order editing must be enabled on your solution in advanced configuration:

  • Go to Settings > Ecommerce > Advanced configuration > General
  • Check the Allow edit order for all users checkbox (read more about the settings here)

You cannot edit an order which has already been captured.

Occasionally, a customer may contact you in order to change their order in some way, or you may want to apply a discount to an existing (but not processed) order.

With order editing in Dynamicweb, you can:

  • Edit customer information
  • Edit shipping details
  • Add or remove products and product discounts
  • View and compare order versions

To edit an order, simply click the edit button in the order details view (Figure 15.2).

Figure 15.2 The Edit button

This opens an editable version of the order details - starting with the order items list (Figure 15.3).

Figure 15.3 Editing the order items list

You can:

  • Edit the quantity and price of each order list item
  • Remove discounts and products

Using the Editing-tools you can also add products and add discounts to an order (Figure 16.1).

Figure 16.1 Editing order items

You can:

  • Add an order discount to the order
  • Add a product with or without an orderline discount to match

The total price of the order is recalculated automatically.

If you want to resend an edited orders to the customer, you can set up a new order state – e.g. ‘Resend order’ – and automate the process. Read more about order flows and order states.

Limitations & Advanced behavior

  • You cannot add a discount which makes the total price less than 0
  • Payment and shipping fees are not recalculated.
  • There is no recalculation of the order if you change the amount of items in a part list, and the main product is set to e.g. Fixed price plus changes.

You can further configure the order edit behavior on your solution by going to Settings > Ecommerce > Advanced configuration > General and configuring the Edit and delete permissions settings.

Read more about the settings in this article.

With the show history button (Figure 17.1) you can view previous versions of the order - and compare them with the current order.

Figure 17.1 Viewing the order edit history

From the order edit history, you can:

  • Click the show icon to see a snapshot of the order from right before the next edit
  • Click the compare icon to open a window comparing the current version with a selectable previous version, including a column highlighting the changes between the two versions

With custom order fields, you can create input fields to be filled by customers during checkout, for example:

  • An input field for entering coupon or promotional codes
  • A checkbox for requesting an additional service (e.g. a product catalog) with the order (Figure 18.1)
  • A text field, for entering order comments

And so on – if you can dream it, you can do it! Provided that you dream about creating custom order fields, of course.

Here’s how to make that dream come true.

Figure 18.1 An example of a custom order field

Custom order field are created by going to Settings > Ecommerce > Orders > Order fields and clicking New in the toolbar to open the order field defintion (Figure 19.1).

Figure 19.1 Creating a custom order field

From here you must:

  • Specify a name and a unique system name for the field
  • Provide a template tag-value for the field. Use this value in your templates to render the field content on the frontend
  • Select a field type for the field (see table below)

The field types available to you are:

Field type

Function

Text (5-255)

Standard text field where you can type between 5 and 255 characters

Long text

Inserts a text box where you can type several thousand characters.

Checkbox

Inserts a checkbox

Date

Inserts a drop down where a date can be selected

Date/time

Inserts a drop down where a date and time can be selected

Integer

Inserts a field where integers can be entered

Decimal number

Inserts a field where decimal numbers can be entered

Link

Inserts a field where you can enter a link to another web page or a file in your File Manager

File Manager

Inserts a field where you can select a file from your File Manager

Once you have created one or more order fields, you can add them to your shopping cart by modifying the templates used during the checkout process.

Read more about the checkout process in the Shopping Cart documentation, and about the CustomOrderFields template tags in the template tag documentation.

When a product is added to a cart, it is created as an order line.

Order line fields are used to allow customers to provide more information about an order before checkout.

For instance, shops which sell goods by certain measurements – e.g. cables or fabric – may find it useful to allow the customer to specify how many meters or inches of a product they wish to order, either on the product details page (Figure 20.1).

Figure 20.1 A custom order line field on a product details page

Or in the shopping cart (Figure 20.2).

Figure 20.2 A custom order line field in the shopping cart

To use order line fields you must:

  • Create order line fields in the backend
  • Configure one or more product groups to use the fields
  • Change your templates to render the fields in the frontend

To create an order line field go to Settings > Ecommerce > Orders > Order line fields and click New in the toolbar to open the order line field definitions (Figure 21.1)

Figure 21.1 Creating an order line field

From here you must:

  • Provide a name and a system name for the field
  • Specify a field length in characters

To use an order line field you must attach it to a product group - read more in the product groups documentation.

Rendering order line fields in frontend

Order line fields can be rendered both on the product details page and in the shopping cart. This allows customers to enter the field values both before adding the product to the cart and when the product is in the cart.

  • To render order line fields from the product details template, use the Product.OrderLineFields loop. This is optional (but recommended).
  • To render order line fields from the shopping cart template, use the Order.OrderLineFields loop. This is required.

If the same product with the same order line data is added to the cart twice the two product instances are stacked as one product, unless they are parts lists (which are always show as separate products).

If two instances of the same product with different order line data are added to the cart, they are listed as two separate products.

In order to integrate Track & Trace information in your orders you need to create and configure a Track & Trace scheme.

A track & trace scheme is simply an URL schema with a set of parameters associated with it.

To create a Track & Trace schema:

  • Go to Settings > Ecommerce > Orders > Track & Trace
  • Click New track and trace in the toolbar to open the Track & Trace scheme configuration view (Figure 22.1)
Figure 22.1 Creating a track & trace scheme

From the edit window, you must:

  • Name the track & trace scheme. It’s usually a good idea to use the shipping provider’s name.
  • Provide an URL schema – these are particular to your delivery service, and you should contact them if in doubt. The URL schema should contain a number of parameters, which are unique to each delivery.
  • Create the required number of parameters matching the parameters in the URL schema– and provide them with a name, and optionally a default value and a description
  • Save and close your tracking schema

Database

These are the database tables relevant for Orders and related features:

EcomOrders

Contains orders. Incomplete orders are indicated by an idea containing CART. On checkout carts are converted to orders and given a new id (containing ORDER).

Field name Data type Length
OrderId nvarchar 50
OrderShopId nvarchar 255
OrderDate datetime 8
OrderModified datetime 8
OrderComplete bit 1
OrderDeleted bit 1
OrderStateId nvarchar 50
OrderVAT float 8
OrderIP nvarchar 255
OrderReferrer nvarchar 255
OrderTransactionValue nchar 2
OrderTransactionType nvarchar 50
OrderTransactionStatus nvarchar 50
OrderTransactionAmount float 8
OrderTransactionPayGatewayCode nvarchar 4
OrderTrackTraceNumber nvarchar 50
OrderShippingMethod nvarchar 255
OrderShippingMethodFee float 8
OrderPaymentMethod nvarchar 255
OrderPaymentMethodFee float 8
OrderSalesDiscount float 8
OrderCurrencyName nvarchar 50
OrderCurrencyRate float 8
OrderCurrencyCode nvarchar 3
OrderCart bit 1
OrderFieldsXML nvarchar Max
OrderReSendEmail nvarchar 255
OrderCustomerNumber nvarchar 255
OrderCustomerCompany nvarchar 255
OrderCustomerName nvarchar 255
OrderCustomerAddress nvarchar 255
OrderCustomerAddress2 nvarchar 255
OrderCustomerZip nvarchar 50
OrderCustomerCity nvarchar 255
OrderCustomerCountry nvarchar 50
OrderCustomerRegion nvarchar 50
OrderCustomerPhone nvarchar 50
OrderCustomerFax nvarchar 50
OrderCustomerEmail nvarchar 255
OrderCustomerCell nvarchar 50
OrderCustomerRefId nvarchar 255
OrderCustomerEAN nvarchar 255
OrderCustomerVatRegNumber nvarchar 50
OrderDeliveryCompany nvarchar 255
OrderDeliveryName nvarchar 255
OrderDeliveryAddress nvarchar 255
OrderDeliveryAddress2 nvarchar 255
OrderDeliveryZip nvarchar 50
OrderDeliveryCity nvarchar 255
OrderDeliveryCountry nvarchar 50
OrderDeliveryRegion nvarchar 50
OrderDeliveryPhone nvarchar 50
OrderDeliveryFax nvarchar 50
OrderDeliveryEmail nvarchar 255
OrderDeliveryCell nvarchar 50
OrderTotalPrice float 8
OrderComment nvarchar Max
OrderCustomerComment nvarchar Max
OrderWeight float 8
OrderVolume float 8
OrderPriceWithVAT float 8
OrderPriceWithoutVAT float 8
OrderPriceVAT float 8
OrderPriceVATPercent float 8
OrderShippingFeeWithVAT float 8
OrderShippingFeeWithoutVAT float 8
OrderShippingFeeVAT float 8
OrderShippingFeeVATPercent float 8
OrderPaymentFeeWithVAT float 8
OrderPaymentFeeWithoutVAT float 8
OrderPaymentFeeVAT float 8
OrderPaymentFeeVATPercent float 8
OrderPriceBeforeFeesWithVAT float 8
OrderPriceBeforeFeesWithoutVAT float 8
OrderPriceBeforeFeesVAT float 8
OrderPriceBeforeFeesVATPercent float 8
OrderCustomerAccessUserId int 4
OrderCustomerAccessUserUserName nvarchar 255
OrderShippingMethodId nvarchar 50
OrderPaymentMethodId nvarchar 50
OrderGatewayResult nvarchar Max
OrderStepNum int 4
OrderTransactionNumber nvarchar 255
OrderCustomerCountryCode nvarchar 50
OrderDeliveryCountryCode nvarchar 50
OrderStepHistory nvarchar Max
OrderLanguageId nvarchar 50
OrderTransactionMailSend bit 1
OrderShippingMethodDescription nvarchar Max
OrderPaymentMethodDescription nvarchar Max
OrderCustomerNewsletterSubcribe bit 1
OrderGatewayPaymentStatus nvarchar 255
OrderGatewayTransactionProblems nvarchar Max
OrderGatewayUniqueId nvarchar 255
OrderCaptureInfo nvarchar Max
OrderCartV2StepIndex int 4
OrderSecret nvarchar 255
OrderShippingCountrySelection nvarchar 255
OrderPaymentCountrySelection nvarchar 255
OrderCustomerAccepted bit 1
OrderDebuggingInfo nvarchar Max
OrderHasSetUserDetails bit 1
OrderTrackAndTraceId int 4
OrderTrackAndTraceParameters nvarchar Max
OrderIntegrationOrderId nvarchar Max
OrderRequisition nvarchar 255
OrderAXOrderId nvarchar Max
OrderVisitorSessionId nvarchar 255
OrderIsExported bit 1
OrderVoucherCode nvarchar 36
OrderCustomerSurname nvarchar 255
OrderCustomerInitials nvarchar 50
OrderCustomerPrefix nvarchar 50
OrderDeliverySurname nvarchar 255
OrderDeliveryInitials nvarchar 50
OrderDeliveryPrefix nvarchar 50
OrderShippingDocumentData nvarchar Max
OrderShippingProviderData nvarchar Max
OrderCompletedDate datetime 8
OrderSecondaryUserId int 4
OrderReceiptShowCount int 4
OrderCaptureAmount float 8
OrderTransactionCardType nvarchar 100
OrderExternalPaymentFee float 8
OrderAutoId int 4
OrderPriceCalculationDate datetime 8
OrderTotalPoints float 8
OrderTotalRewardPoints float 8
OrderTotalDiscountWithVAT float 8
OrderTotalDiscountWithoutVAT float 8
OrderTotalDiscountVAT float 8
OrderTotalDiscountVATPercent float 8
OrderIsQuote bit 1
OrderTransactionCardNumber nvarchar 50
OrderCustomerTitle nvarchar 255
OrderCustomerFirstName nvarchar 255
OrderCustomerMiddleName nvarchar 255
OrderCustomerHouseNumber nvarchar 255
OrderDeliveryTitle nvarchar 255
OrderDeliveryFirstName nvarchar 255
OrderDeliveryMiddleName nvarchar 255
OrderDeliveryHouseNumber nvarchar 255
OrderCheckoutPageID int 4
OrderVisitorSessionDate datetime 8
OrderPriceCalculatedByProvider bit 1
OrderTaxTransactionNumber nvarchar 50
OrderVoucherUseType int 4
OrderContextID nvarchar 50
OrderGiftcardTransactionFailed bit 1
OrderShippingFeeRuleName nvarchar 255
OrderRecurringOrderId int 4
OrderPaymentRecurringInfo nvarchar Max
OrderSavedCardID int 4
OrderIsRecurringOrderTemplate bit 1
OrderTransactionToken nvarchar Max
OrderTransactionTokenCheckSum nvarchar 128
OrderIsLedgerEntry bit 1
OrderIsPayable bit 1
OrderReturnOperations nvarchar Max

EcomOrderFlow

Contains order flow setup from Settings -> Ecom -> Orders -> Order flows.

Field name Data type Length
OrderFlowId int 4
OrderFlowIsDefault bit 1
OrderFlowName nvarchar 255
OrderFlowDescription nvarchar Max
OrderFlowOrderType int 4

EcomOrderStates

Contains definitions of individual order states in an order flow (OrderFlowId).

Field name Data type Length
OrderStateId nvarchar 50
OrderStateName nvarchar 255
OrderStateDescription nvarchar Max
OrderStateIsDefault bit 1
OrderStateDontUseInstatistics bit 1
OrderStateIsDeleted bit 1
OrderStateMailTemplate nvarchar 255
OrderFlowId int 4
OrderStateMailSender nvarchar 255
OrderStateMailSenderName nvarchar 255
OrderStateMailSubject nvarchar 255
OrderStateAutoId int 4
OrderStateSendToCustomer bit 1
OrderStateOthersMailTemplate nvarchar 255
OrderStateOthersRecipients nvarchar Max
OrderStateSortOrder int 4
OrderStateOrderType int 4
OrderStateAllowOrder bit 1

EcomOrderStateRules

Defines flow between order states (OrderStateRuleFromState -> OrderStateRuleToState).

Field name Data type Length
OrderStateRuleId int 4
OrderStateRuleFromState nvarchar 50
OrderStateRuleToState nvarchar 50

EcomOrderDebuggingInfo

Debug log for order flows. Links to order (EcomOrders) via OrderDebuggingInfoOrderID.

Field name Data type Length
OrderDebuggingInfoId int 4
OrderDebuggingInfoOrderId nvarchar 50
OrderDebuggingInfoSource nvarchar 255
OrderDebuggingInfoTime datetime 8
OrderDebuggingInfoMessage nvarchar Max
OrderDebuggingInfoType int 4
OrderDebuggingInfoOrderAutoId int 4

EcomOrderField

Contains order field definitions from Settings -> Ecom -> Orders -> Order fields.

Field name Data type Length
OrderFieldId nvarchar 255
OrderFieldName nvarchar 255
OrderFieldSystemName nvarchar 255
OrderFieldTemplateName nvarchar 255
OrderFieldTypeId int 4
OrderFieldTypeName nvarchar 255
OrderFieldLocked bit 1
OrderFieldSort int 4
OrderFieldAutoId int 4

EcomOrderLineFields

Contains order line field definitions from Settings -> Ecom -> Orders -> Order line fields.

Field name Data type Length
OrderLineFieldSystemName nvarchar 255
OrderLineFieldName nvarchar 255
OrderLineFieldLength int 4
OrderLineFieldAutoId int 4
EcomOrderLineFieldsSorting int 4

EcomOrderLineFieldGroupRelation

Contains information about which orderline fields are associated to products in a specific group.

Field name Data type Length
OrderLineFieldGroupRelationSystemName nvarchar 255
OrderLineFieldGroupRelationGroupId nvarchar 255
OrderLineFieldGroupRelationAutoId int 4
OrderLineFieldGroupRelationShopID nvarchar 255

EcomOrderLines

Contains orderlines from orders (EcomOrders) linked via (OrderLineOrderId).

Field name Data type Length
OrderLineId nvarchar 50
OrderLineOrderId nvarchar 50
OrderLineParentLineId nvarchar 50
OrderLineBOM bit 1
OrderLineDate datetime 8
OrderLineModified datetime 8
OrderLineProductNumber nvarchar 255
OrderLineProductId nvarchar 30
OrderLineProductVariantId nvarchar 255
OrderLineProductName nvarchar 255
OrderLineProductVariantText nvarchar 255
OrderLineUnitPrice float 8
OrderLineVatPercent float 8
OrderLineVatPrice float 8
OrderLineQuantity float 8
OrderLineType nvarchar 255
OrderLineReference nvarchar 255
OrderLineBOMItemId nvarchar 50
OrderLineUnitId nvarchar 50
OrderLineWeight float 8
OrderLineVolume float 8
OrderLinePriceWithVAT float 8
OrderLinePriceWithoutVAT float 8
OrderLinePriceVAT float 8
OrderLinePriceVATPercent float 8
OrderLineUnitPriceWithVAT float 8
OrderLineUnitPriceWithoutVAT float 8
OrderLineUnitPriceVAT float 8
OrderLineUnitPriceVATPercent float 8
OrderLinePageId int 4
OrderLineDiscountId nvarchar 50
OrderLineFieldValues nvarchar Max
OrderLineAttachment nvarchar Max
OrderLineAutoId int 4
OrderLineWishListId int 4
OrderLinePriceCalculationReference nvarchar 255
OrderLineUnitPriceCalculationReference nvarchar 255
OrderLineUnitPoints float 8
OrderLineUnitRewardPoints float 8
OrderLinePoints float 8
OrderLineRewardPoints float 8
OrderLineRewardId int 4
OrderLineReverseChargeForVat bit 1
OrderLineTotalDiscountWithVAT float 8
OrderLineTotalDiscountWithoutVAT float 8
OrderLineTotalDiscountVAT float 8
OrderLineTotalDiscountVATPercent float 8
OrderLineGiftCardCode nvarchar Max

EcomTrackAndTrace

Contains setup data for track and trace as defined in Settings -> Ecommerce -> Orders -> Track and trace.

Field name Data type Length
TrackAndTraceId int 4
TrackAndTraceName nvarchar 255
TrackAndTraceURL nvarchar Max
TrackAndTraceParameters nvarchar Max