One Stop Order Processing
One Stop Order Processing |
|
To change how the information is displayed or available to
use for filters press the Customize Current View button (
)
Views
You can define up to 30 views, each having your
own choice of fields. You can quickly and easily move between views. Several
pre-defined views are created during the installation. These can be amended
or new views created from them.
You can also share views with other users by exporting your own.
When you change views the current filter settings are saved. This means that each filter can have their own pre-configured filters. If you don’t want this feature untick the Store this view’s filter settings option. This will mean that when you change views the current filter will be applied to the orders within the new view (unless that field is not available in the new view).
New
You can create a new view. You can choose which
view to copy the fields from.
Delete
Any view can be deleted. You must always have at
least 1 view defined.
Rename
The name of any view can be changed.
Import
You can import views exported from other PCs.
NOTE: When you import view information this will overwrite any individual definitions for custom values that you have defined. Your individual views will not be affected.
Export
This will prompt you for a filename to save the
information to. If you want to share information with other users save the view
onto a main server and then import to the machine(s).
Adding fields to a view
You can add various fields to each view. These additional fields can be used when you export data or can be used in calculations.
Selected and Available fields
The right hand pane shows the current fields that
are displayed in the order browser. To change the order of fields use the Up
and Down buttons. If you want to remove any fields from the Selected
list press the < button (or double click the item). To remove all
items press the <All button.
To add fields to the Selected list select the required field in the Available list and press the > button (or double click the item to add). To add all the fields press the All> button. The fields shown in the Available list are those not already selected from the current field Type.
Amend field details
You can also change the displayed name of any field.
This is the name that is displayed for the column heading and the field to filter
by. Click on the Amend field details button to display the dialog.
If you are using a non custom field you can apply the text in the Field value
to the end of the displayed field by putting !!!
at the start of the text. This can be used to use any of the functions and macros
(described below) on any displayed value. For example, entereing a value of
!!![U] will make the displayed
text UPPERCASE.
The details about the existing field are displayed:
| ID | This is the unique ID for this field. | ||||||||
| Field name | The name to display for the column heading. If you want to use the original name click on the Use Original name button. | ||||||||
| Field name | The name used is also the name used for the column heading in any exported file (if a header is chosen to be included). | ||||||||
| Field value | This contains the default value to use for the field if it is blank. The default value can refer to any field. For example, delivery instructions. | ||||||||
| Field type | You can change the type of the field. By default, the fields are of type text. You can chaneg the type to:
|
||||||||
| Allow editing in order list | If this field can be changed in the main Order List you can tick this option. This allows you to select any value in this field (on the main orders list) and change its value. To edit a field click the value to amend and press F2 or right click the mouse and select the Edit Item menu option | ||||||||
| Edit as list | If you allow editing of a field in the main Orders List you can also apply a list of certain values to choose from. This can be useful for selecting various codes or values specific to the field, for example, an internal SKU code that is to be applied to this order. To display the List Manager click on List Manager on the Order Display tab in the Options ( select the Tools->Options menu item). | ||||||||
| Include in Exported Information | If you are going to export information you may not want to include
all the information displayed. This may be because the information is used
for data filtering. Example 1: Checkout date is used as part of the calculation for other fields Example 2:The export format must only show 80% of the order cost. The Grand total is displayed, but Include in Exported information is not ticked for it. The warehouse cost is calculated as 80% of the displayed order cost and Include in Exported information is ticked. |
||||||||
| Include field | When this field is exported you can include the total of the column data in the information exported. | ||||||||
| Total in export | You must also tick the Include column totals after data option when exporting the data. |
Using default values
Using default values in fields allows you to create
your own analysis of your data and also extend the information displayed (or
exported).
There are two main uses for defaulting a value. You can use a default value if a field is blank. This applies to any built-in field, or custom field. For example, delivery instructions.
The more common use of default values is when using custom fields (described in more detail later in this section). There are two types: the same value for all orders or a different value for each order.
You can default a value from 1 (or more) of the other fields
displayed in your view. You can only use the fields displayed in your
view.
You can also perform calculations or use conditional values on items in the
default value. You can use the following operators.
| [+] | The two values either side are added up | ||||
| [-] | The value to the right is taken away from the value on the left. | ||||
| [/] | The value on the left is divided by the value on the right. | ||||
| [*] | The two values are multiplied together. | ||||
| [<] |
Compares the value and if it is less than the value given show
the first value otherwise show the second value. For example, to show Parcel Force for orders less than £100 and UKMail for orders over and including £100 use: [%Total Cost%] [<] 100 [Parcel Force] [UKMail] |
||||
| [>] |
Compares the value and if it is greater than the value given show
the first value otherwise show the second value. For example, to alert someone (by adding text into a certain field) to check all orders over £200 use: [%Total Cost%] [>] 200 [Check Order] |
||||
| [=] |
Compares the value and if it equals value given show the first
value otherwise show the second value. This can include text aswell as
numeric values. For example, to change the drop shipper depending upon a certain product use: [%Product Ref%] [=] IL42 [SmartShipper][We Ship] |
||||
| [U] |
Make the field UPPERCASE. You should put the opertaor after the field value. This can be useful for making certain fields more visible. For example, to make the Delivery company name UPPERCASE use: [%Delivery Company%] [U] |
||||
| [l] |
Make the field lowercase. You should put the opertaor after the field value.This can be useful for making certain fields more readable when joined with other fields. For example, to make the built up sentence (which is itself made up from other fields) more readable use: [%Text Words%][l] |
||||
| [$] |
Display a portion of a field. The 2 values following the operator are the position to start in the text followed by the number of characters to use. This can be useful when values have to be a fixed length for certain export functions or using certain characters in a value as a code to another system. For example, to use the first 3 characters of a product code as a warehouse location (or dropshipper) use the following. You can then base other fields on tests on this field. [%Product Ref%][$][1][3] |
||||
| [.] | Take the absolute value of the number. For example, 19.21
would be shown as 19. This is very useful for any Inland Revenue figures
where only the £ (GBP) number is required. For example: [%Grand total%][.] If you put a number after the [.] this will show the number to that number of decimal places. e.g. [.]2 will show a number as 56.72. |
||||
| [#] | Replace a letter or word with another word. This can be useful
if you wish to replace certain words (for branding) or to remove unwanted.
To replace the word Free with Additional use: [%Item title%][#][Free][Additional] To remove all commas from an address line: [%Invoice Address line 1%][#][,][] |
||||
| [D] | Display the date (if a date field) in the format YYYY-MM-DD.
This is useful when some export formats need the date in a different format. The formats supported are: |
||||
| [?] | Find a word within a field. If the text is found show the
first value otherwise the second value. For example, to look for the word
Fast in the shipping instructions use the following: [%Delivery Instructions%][?]Fast[UPS][DHL] This will display UPS if the word fast is used in the shipping instructions or DHL if it is not. This can be used to display order processing information based upon the order's choices. If you want to find the location of a the value winthin the first text you should put ? in both the possible returned values. This can be useful if you want to extract certain text from another word. For example, This is applied to the SKU To see how this macro works this can be broken down into several parts |
||||
| [I] | Display the ISO country code. If you use the default value
for the fields as !!![I] the country will be shown as the country ISO code. For example, United Kingdom will be displayed as UK. |
||||
| <!> | You can access the underlying data using SQL directly. You will need to know information about the underlying data. You can use the following values in the SQL to reference the current order being displayed:
For example, to show the total tax for all order lines on the main product reference only using the following SQL <!>Select sum(dTax) from TOrderLine where (nOrderLineSeq={%ORD_ITEM_ID%} AND sSKU='{%SKU%}') You can use the other fields in the view as normal (in this example, sSKU. You don't have to include the fields referenced in the SQL in the view if you are using their database names. |
||||
| [r] | Round a number to the nearest number of decimals places. For example, if you use the This will show |
||||
| [A] | Remove any accents from accented characters. This is very useful when exporting addresses to courier systems. For example, Royal Mail DMO or UPS. To make sure all accents are removed from an address changed the detault value of each address line to [!!!][A] |
||||
| [Z] | The Zone of the text used (i.e. postcode), for example The returned value is shown below: 1 - Mainland UK |
||||
| [Z] | The Zone of the text used (i.e. postcode), for example The returned value is shown below: 1 - Mainland UK |
You can also use numbers in calculations. For example, 4 or 512.6 or £3.1415926.
The example shown above is [%Grand total%] [*] 0.05. This shows all values in the Warehouse cost field as 5% of the Total order cost. When you use calculations if either of the numbers uses your currency symbol (e.g. £) this will be used in the value displayed.
You can also perform calculations on fields which have other calculations performed on them. For example, another field, Warehouse VAT, maybe defined as [%Warehouse cost%] [*] 0.175. This will perform the calculation for the Warehouse cost before the WareHouse VAT. It does not matter the order that they appear in the view.
If you want the users of One Stop Order Processing to be able
to enter a different value for each order use a Custom Value: Entered for
each order. They will enter the value in the Custom order details page.
Other Macros
{{TODAY}}
Today's date
{{TOMORROW}}
Tomorrow's date.
{{TIME}}
Current time.
{{30DAYSFROMTODAY}}
30 days from current date.
{{30DAYSFROMORDERDATE}
30 days from the curent order's date
<ML>
If you put this value at the start of a default value this will make the current line also appear in product and order detail line item lines when exported. This is useful if you want to include additional information for exported product order lines where the field being exported in a custom value. For example, using a default value of <ML>[%Temp2LineNumber%] for a Custom Fixed field will also export this field for the product lines (where other fields of this type are exported).
XMLOPEN
When you are exporting the order details as XML you can specify new nodes (folders) by using the a default value of XMLOPEN. This will create a new Node with a name of the field. To specify the end of ths node's scope you should create a field with a default value of XMLCLOSE. Using this approach you can create a hierarchy within an XML file. You should use a Custom Fixed field for this entry.
XMLCLOSE
You MUST create a Custom Fixed field with a default value of XMLCLOSE when you want to close the XML node specified in the XMLOPEN field. The name of the field must be the same as the field name used in the XMLOPEN field. You MUST also close he last opened field given in the XMLOPEN field.
You can also use nested conditions and operations
An example is :
[%Sales source%][=]Ebay[[%Grand total%][<]13[RoyalMail][UkMail]][[%Sales source%][=]Amazon-SC[DHL][ParcelForce]]
This will send all Ebay orders that are less than £13 with RoyalMail, All Ebay orders more than £13 with UKMail, all Amazon orders with DHL and all others with ParceLforce.
This is explained below in the following pseudo code
| if [%Sales source%] [=] Ebay { |
||
| if [%Grand total%] [<] 13] { |
||
| [RoyalMail] | ||
| } else { |
||
| [UkMail] | ||
| } | ||
| } | ||
| else { |
||
| if [ [%Sales source%] [=] Amazon-SC] { |
||
| [DHL] | ||
| } else { |
||
| [ParcelForce] | ||
| } | ||
| } | ||
More ways to use fields
If you want users to be able to enter different
calculations for each order set the default value to include [+] 0. This tells once stop
Order Processing that any value entered may include calculations. If values
aren’t entered the default value will be 0. You can set the default value to
any number as long as it includes a sum (using [+], [-], [/] or [*]).
If you want the user to be able to enter other fields (from the view), for each order set the default value as a field. For example, [%Grand total%]. If you are using this approach note that no validation is carried out and if the wrong field is entered a blank value is used.
If you are exporting to a 3rd party system and you require the exported file to have a number of empty fields set the default value for a custom value to contain the required number of empty items. For example, if the exported format requires a 255 values per line Comma Separated Value (CSV) file where the fields only occupy the first 120 values; create a default value for one of the custom values to be ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,. When exported the commas (,,,,,,,,,, …) will be put onto the end of the existing output values.
Field Types
The field Types are the main groups that
the information is taken from. When you select the Type the list of Available
fields changes in the Available pane.
If you want to show the details of each order line you should select entries from the Order Line/Item Status. This will then show 1 line in the display for each line of the order. For example, an order has 5 items there are 5 lines shown for that item. When you come to perform an action on that order (e.g. Print an Invoice), however many items within the particular order are selected it will only print (or whatever action) that order once.
There are 2 additional field types:
Custom Value: Fixed
This allows you to enter up to 50 additional columns
to your views all having the same value. This value can be based upon another
field (or fields) and can include calculations. (Refer to the Amend field
details for more information on for more information on setting up these
values.). This field can be very useful for adding in required values for an
export file, where One Stop Order Processing does not provide the relevant information.
The first 15 of these values are shown on the Custom values order detail page, but can’t be changed on that page. If you require the information to be shown in the order details you should make sure that the information is stored in one of the first 15 values.
Custom Value: Entered for each order
This type of field allows you to have a default
value (described in the previous Amend field details section) that can
be overridden, if required. You can create up to 50 of these values. If you
require the details to be amended on the custom values order details page you
should use one of the first 15 values. If you require more than 50 Fixed values
you can use these custom fields in the same way as the Fixed Custom values.
Field details
When you select a field on either the Available
or Selected lists the field’s details are shown. This information is used to
quickly identify the characteristics of a particular field. The following information
provided is shown below.
| Name | The actual name used and its default name. |
| Type | The group the field comes from (e.g. Order information). |
| Default Value | The default value applied to the field. |
| ID | The unique ID for the item. |
| Export | Will this be included in the exported information? |
One Stop Order Processing allows you to import and process orders for Ebay, Amazon, SellerDeck, Shopify, Magento, osCommerce, BigCommerce, RomanCart, eBid, XCart, Oxatis, Groupon, Wowcher, Paypal, Cdiscount. ekmpowershop, Etsy, Flubit, OpenCart, PinnacleCart, PrestaShop, WooCommerce, Weebly, ChannelAdvisor, ASOS Marketplace, OnBuy, Mighty Deals , Mail Order and Telephone Sales
Mole End Group of Companies |
|||||
| Products, plugins and utilities for SellerDeck | All your orders, from all your systems, all together in one simple-to-use application | Integrated label invoice paper and free software packages and templates. Print your invoice and labels at the same time | Print Amazon Despatch Notes with a peel out label with the customer's details on directly from Amazon | Print Ebay Invoices with a peel out label with the customer's details on directly from Ebay | |