How to use rules to automatically highlight international orders.

How to use rules to automatically highlight international orders.

The following guide explains how to use rules to automatically highlight international orders.

This feature is available in the Professional, Premium and Enterprise subscriptions of One Stop Order Processing.

International highlighting is a feature that allows orders that are being shipped to an international address to be highlighted automatically in a
colour of your choice when import into the software allowing you easily disguise between international and national orders.

Creating an advanced rule-

1. Click the ... next to the Advanced button

2. Click Add

3. Name your rule

4.Select Use custom SQL: from the drop-down menu

5. In the box below paste the following


[Invoice].[sCountry]NOT LIKE '%United Kingdom%'




6. Select Set Order Colour to from the second drop down menu.



7. Either Click Get colour from Highlight colours to select a set colour or click the black box to choose a custom colour

8.Click OK



To add to Automation-

1. Open the import dialogue ( Click the button with the orange down arrow)

2. Click Set up Automatic Import and Processing..



3.Click Options

4. Double Click one of your options from the Actions box

5.Tick Advanced Order Processing



6. Tick Other Rules



7. The next time you import your orders, they will automatically be highlighted if they are being shipped internationally. 

Using One Stop Order Processing with eBay, Amazon, Magento, Shopify, Etsy,Onbuy, Flubit, X-Cart, eBid, SellerDeck, Oxatis, CubeCart, osCommerce, Interspire,CRE Loaded, ekmPowershop, Pinnacle Cart, Rakuten, RomanCart, Paypal, Asos, WooCommerce , PrestaShop, Groupon, Weebly, Mail Order, Telephone Sales, CDiscount,OpenCart, Channel Advisor, Royal Mail, MyHermes, UKMail, DPD, Yodel, UPS, Metapack, Parcel 2 go, Quickbooks, Sage, Xero, Parcelforce and Stripe