One Stop Order Processing
One Stop Order Processing for Ebay, Amazon, RomanCart, SellerDeck/Actinic, CubeCart, Rakuten, eBid, ekmPowershop, Magento, Pinnacle Cart, Shopify, Actinic Online/Oxatis, osCommerce, X-Cart, CRE Loaded, Interspire and other Systems, Mail Order and Telephone Sales
www.1stoporders.co.uk
Selecting Display Fields

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:
Text Text fields, for example, WAREHOUSE A
Date Date value. Dates must be in the format YYYY/MM/DD HH:MM, for example, 2013/12/03 12:37
Number A numeric value. For example, 18.74.
Price A price field. This will be shown using the currency


When filtering (with custom entered fields) it will use the Field type selected for the field. You can also sort on the fields using the Field type selected.

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]

If you put a ! before the second value you can take the portion of the string before the text given. For example, to include all the text before a space in the item title use the following:

[%Item title%][$][1][! ]

You can also search for certain words, not just single characters.

[.] 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:

1 - yyyy-mm-dd
2 - dd/mm/yyyy
3 - dd/mm/yy
4 - mm/dd/yy
5 - yymmdd

If you use nothing or 1 after the [D] it will use the format YYYY-MM-DD.

For example, to display the date as day/month/year use.

[%Invoice Date%][D]2

[?] 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,

The quick brown fox jumped over the fence[?]jumped[?][?]

This would return

21

as this is the position in the text of the work jumped.

A more complex example is to use the returned value to extract the text from the sentence.

For example, if you want to only display the text after a # in the Order item's SKU you can find the location of the # and show all characters after the #.

[%SKU%][$][[%SKU%][?]#[?][?][+]1][15]

This is applied to the SKU

Door Handle#419C

this shows

419C

To see how this macro works this can be broken down into several parts

1 The [%SKU%][?]#[?][?] looks for a # in the SKU and returns the location of it, in the example, 12.
2 Then the [+]1 is used, which adds 1 to the location, which then makes the value 13 (12 +1).
3 The 13 is then used in the [$] macro, which is Display a portion of a string. This would then use

[%SKU%][$][13][15]

This shows up to 15 characters from the 13 position in the string. The 15 is abitary number, if your SKUs are longer use a higher value (e.g. 254).

[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:

{{ORD_ID}} The current order's ID
{{ORD_ITEM_ID}} The current order line's ID

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

3.1415926[r]3

This will show

3.142

As the number has been rounded to the nearest whole number (in the decimal places).

[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]

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.

<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?


Mole End Group of Companies
www.mole-end.biz
www.1stoporders.co.uk
www.integratedlabels.co.uk
www.invoicepaper.co.uk
www.palletpaper.co.uk
www.baypaper.co.uk
Products, plugins and utilities for Actinic Desktop and 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 Integrated Label Paper in Bulk, by the pallet. In Stock and ready for Despatch. Print Ebay Invoices with a peel out label with the customer's details on directly from Ebay