How to automatically set custom values in orders as they are imported (e.g. for courier related values)
If you are using a custom courier or require other default values in orders as they are imported (based on set values or other order values) use the following approach. This example shows how to set default values for APC courier
Setup an advanced rule (click ... next to the Advanced button main screen) as follows:
The 2 SQL text values are:
(TCustomValues.C22 = '') OR IsNull(TCustomValues.C22)
TCustomValues.C20 = 'Service code', TCustomValues.C21 = 'Package size', TCustomValues.C22 = 'Number of Parcels', TCustomValues.C23 = 'Fragile'
You can either tick the orders and run the Advanced button on main screen or tick the Advanced Order Processing and Other Rules in the Automation task to set this for all orders as they are imported.
As you can see from this rule it only sets the default values if the main C20 has not been setup already.
Related Articles
How to automatically assign your UkMail Courier service when orders are imported.
This feature is available in the Professional, Premium and Managed subscriptions of One Stop Order Processing. Courier rules are a set of conditions that are run against your orders as they are imported that allows you to automatically have a ...How to Change the Courier sent to Websites (e.g. change Click and Drop to Royal Mail)
When you send tracking details to Amazon or Ebay you sometimes need to change the courier details setup in OSOP to what is expected by the website (e.g. Amazon). For example, Click and Drop should be sent as Royal Mail. The following article explains ...Automatically import your Amazon Orders into One Stop Order Processing
How to setup One Stop Order Processing to automatically import orders from Amazon SellerCentral This feature is available in Professional, Premium and Managed versions of One Stop Order Processing One Stop Order Processing can automatically retrieve ...How to filter on default customer entered order values
You can display custom entered values on the screen. However, you can only filter on them if values have been entered. This is because the default value is not actually stored in the database, but is displayed on the screen. If you want to filter on ...Using an AMTU replacement (e.g. EZOrderLink™) to automatically process Amazon orders and products
One Stop Order Processing (OSOP) provides automated support for Amazon orders and products by using the Amazon software AMTU. AMTU, provides the ability to download and upload Amazon order and product files to its website will stop working at some ...