How to Split Orders

IN THIS GUIDE

Overview
Shopify and BigCommerce Instructions
Manually Split Orders
Automatically Split Orders with Rules
Instructions for Each Method
Take Action After Split Happens

Overview

Rules can tell Order Desk how to split your orders and where to send them once they're split. When orders are split, the tax, shipping, handling and discounts are split proportionally between the new and original order.

This guide covers splitting options and how to create rules for after orders split to tell split orders where to go.

If you aren't familiar with the Rule Builder, take a few moments to read through the How to Work with Rules guide.

Shopify and BigCommerce Instructions

Splitting orders that come from Shopify or BigCommerce will be a slightly different process than what is explained in this guide. For instructions, read the guides on how to split by vendor for Shopify or for BigCommerce.

If your Shopify or BigCommerce orders need to be split using another method, continue reading this guide for options.

Manually Split Orders

To manually split an order, open the order page and select the item(s) that need to be split into a new order. Click Split Order.

The order will be split into two separate orders based on the items selected. After the split takes place, you will be redirected to the new order.

Automatically Split Orders with Rules

Orders can be split automatically with rules using these different methods:

  • CODE/SKU: split specific SKUs out of orders.
  • ITEM NAME: split specific items out of orders based on their names.
  • CATEGORY CODE: Category Code is a unique field used for the Foxy integration allowing you to categorize your items. If you are using Foxy, you can use it to split your items into separate orders. Shopify vendors will also be placed in this field.
  • DELIVERY TYPE: Delivery Type is a unique field for FoxyCart shops. If you set the Delivery Type on your items in FoxyCart, you can split using this method.
  • VARIATION: split items with specific variations out of orders.
  • ITEM METADATA: split items with specific metadata tags out of orders. This is the most versatile, fully customizable method for splitting orders.
  • ALL: split every item into a new order.

Creating a Split Rule

From the Rule Builder, choose the Order Rule type:

Select the event that you want to split orders on. This is typically going to be  Order is Imported, but any event can be used.

Under the Filters & Actions tab, select the Split Order action:

The empty box under Split Order is where you can tell the Rule Builder what orders to split. 

The info added to this box must be formatted properly, so follow the instructions in the next section to find out how to do this for the split method you need. 

While setting up your rules, be mindful of capitalization, spacing and punctuation. In most cases, names and values will need to be an exact match to what is on your items for the split rules to work.

Do not add any additional actions to a rule that splits orders. Use a second rule for when Order is Split to tell Order Desk what actions to take on a split order. This way the split action has a chance to complete before any additional actions start running.

Instructions for Each Method

Split By
Code/SKU | Item Name | Category Code | Delivery Type | Variation | Item Metadata | Split All Items

Special Features
Split Method Wildcard | Split All Items of Specific Type

Split by Code/SKU

This method works if you have a small number of product SKUs to split out of orders. If you have more than a dozen or so SKUs you want to split out, another split method will be more efficient.

To split a single SKU into its own order, add your SKU behind CODE| in the input box:

CODE|SKU1

You can also add multiple SKUs by separating them with a comma: SKU1,SKU2,SKU3 and so on. This will split these SKUs, if they come in with an order, into a single order. This will not create separate orders for each SKU.

Split by Item Name

To split orders by the item name, set up your rule as:

NAME|value

Replace "value" with the actual item name to be split out. For example, split the Apple Treats item into their own orders with:

NAME|Apple Treats

You can add more than one name to a split rule, separating the name values by a comma:

NAME|Apple Treats,Carrot Treats

This will split the targeted items into a single order rather than separate individual orders. If you need to separate the treat items into individual orders, set up two separate rules:

NAME|Apple Treats
and
NAME|Carrot Treats

Split by Category Code

The category code comes in on items from certain shopping carts. If your shopping cart supports this field, you will see it in the item details directly in an order:

To split by the category code, set up your rule as:

CATEGORYCODE|value

Replace "value" with the actual category code you are using, such as:

CATEGORYCODE|Apparel

Split by Delivery Type

The delivery type field only works with FoxyCart shops. If you have set the delivery type on your items in FoxyCart, you will see it come through in the item details directly in the order:

Delivery type values are: Ship, No Ship, Download and Future.

To split by the delivery type, set up your rule as:

DELIVERYTYPE|value

Replace "value" with the delivery type you want to split, which would look like this:

DELIVERYTYPE|Ship

Split by Variation

You can use the variation field set on your items to split orders. Set up your rule as:

VARIATION=name|value

Replace "name" with the exact name of your variation (size, color, pattern, etc.) being mindful of capitalization, spaces and punctuation. Replace "value" with what the variation is (8oz, small, red, argyle, etc.)

For example, to split out all red products where the variation name is Color and the value is Red, use:

VARIATION=Color|Red

You can also combine variations of the same type into the same split orders, such as:

VARIATION=size|8oz,15oz
and
VARIATION=color|red,blue,orange

Split by Item Metadata

Splitting by an item's metadata is the most versatile and easily customizable option for splitting your orders. In many cases, metadata will come in from your shopping cart with your items, such as these metadata fields that came in from Shopify:

If the data you need doesn't come in from your shopping cart, add it directly to your saved inventory items here in Order Desk:

When an order comes in from the shopping cart, metadata fields will be synced into the item in the order (Automatically Sync Details With Inventory Items must be enabled on your store for this to work):

You can use any metadata field on your items or that come in from the shopping cart to split orders. Using the above screenshots as an example, we could use the metadata field we've set called pattern to split out all snowflakes items like this:

METADATA=pattern|snowflakes

The most commonly used split rules are set up to look at the inventory location on an item, specifically called inventory_location:

When you have different vendors or fulfillment services, you can set their names in this location field and use that to split your orders by vendor:

METADATA=inventory_location|BuckLtd

Once split, you can set up rules to send the newly separated orders to each separate vendor, integration or fulfillment service, which we'll go over in the next section.

If you need to split all vendor/location names into their own orders, skip down to the Special Features: Split All Items of Specific Type section below for instructions on setting up one rule to split all orders rather than one rule per vendor/location.

Split All Items out of Orders

If you need to split every item into its own order, add ALL to the split order input box:

Split orders cannot be merged back together, so be certain this is what you intend to do before creating a rule to split all items into separate orders.

If you also want to split multiple quantities of a single product into separate orders you will first need to use a rule with the action Convert Item Quantities to Separate Items. Once converted, you can run an ALL split rule on your orders.

Special Feature: Split Method Wildcard

If you add the * symbol to your split rule, it will act as a wildcard, that is, it will look for anything like what is in the rule. For instance:

NAME|mug*

This will split any items with mug in the name. Capitalization does not matter when using the wildcard.

Another wildcard example is to look for a specific piece of information, such as the middle part of a set of SKUs, and only splitting those items out. For example, if you need to split out any SKU with -A- in the middle of it, use:

CODE|-A-*

Special Feature: Split All Items of Specific Type

If you want to split all items of a specific type, just use the method type itself without adding a pipe and a specific value. For instance, to split out every item that has a different name into its own order, use:

NAME

This works for every method type.

If you work with multiple vendors, instead of setting up a split rule for each vendor/location name, you can split all orders by the inventory_location name by using:

METADATA=inventory_location

Take Action After Split Happens

After orders have been split, you can tell Order Desk what you want to happen to them, such as submitting them for fulfillment, moving them to a specific folder, emailing someone about the order, tagging the order a certain color, etc.

To do this, you will need to create a new rule.

Add New Rule

Create a new rule using the Order Rule type, this time selecting Order is Split as the event:

Set Filters

Use the filter that matches your split method:

  • If Item Code
  • If Item Name
  • If Item Category Code
  • If Item Delivery Type
  • If Item Variation
  • If Item Metadata

Choose your operator:

You will most likely want to use Equals, In List or Contains:

Equals Must be an exact match for a single value. Case and space sensitive. "If it equals this value."
In List The exact match must be in a list of values, separated by commas. "If it's in this list of values."
Contains Does not need to be an exact match and is not case sensitive. "If it's like this value."

Set your value(s). For instance:

If Item Code Equals SKU1
If Item Code  In List SKU1,SKU2,SKU3
If Item Name Contains mug

Variations and item metadata need to include the name of the field as well as the value like in the split rule itself. For instance:

If Item Variation color Equals red 

or

If Item Metadata Contains inventory_location|BuckLtd

Add Actions

To finish your rule, add the actions you want applied to a split order. Actions include Submit to Integration, Send Email to Customer and Change Folder, among others.

Still need help? Contact Us Contact Us