Skip to main content
All CollectionsOrder ManagementSales Orders
Creating, Importing and Managing Sales Orders
Creating, Importing and Managing Sales Orders

Learn how to create sales orders and how to import orders from a spreadsheet

Brenda Beckham avatar
Written by Brenda Beckham
Updated this week

Creating Sales Orders is one of the most exciting moments of your business!  This is where you will begin to see all the results of your hard work come together! Whether your customers call you, walk into your retail store or visit your Showroom/eCommerce store online, a Sales Order will be generated to show what items they want to buy from you.  

For all Sales Orders,  you will manually enter them into Uphance using the instructions in this document unless the orders are coming in through your eCommerce store.  If they are coming in through your eCommerce store, those will automatically be fed into Uphance by your customers.

In general, a sale represents a single purchase transaction with a customer. Typically you will have one sale per customer per season.

How to Create a Sales Order

Sales created in Uphance start their existence in the DRAFT state (even those coming in from your eCommerce store).  And, you will have to "Confirm" the state before the sale is final.  In this state, you will add products to build your tentative customer order. 

To create the DRAFT Sale:

1. Select Order Management >> Sales Order from your left, main vertical menu

2. Click the Actions button at the top right corner and click New Draft Sale

3. Upon clicking, a popup modal would appear. Type your customer's company name.  If the customer is already set up in your company contacts database, a drop-down list for you to select from will appear when you start typing the name of the customer.  

If it is a new customer, you can update the contact information on the next screen.

Select the Season for the product they want to purchase from, specify the Channel (Currency/Price List) and the Warehouse you will fill the order from. Then click the Create Sale button.

How to Import Sales Orders From a Spreadsheet

Adding orders manually, one at a time, won't be practical if you have say, 1,000 orders you need to upload.

Thankfully, Uphance enables you to import sales orders into your account - and there's no limit to the number of orders you can import.

To import orders, first download the order import spreadsheet template by clicking Sales Orders >> Actions >> Upload Sales Order. Click Sales to download the template.

It will look something like this:

Populate the sheet with your orders' information, save and upload by clicking Actions >> Upload Orders once again.

Note: For your orders to be uploaded correctly, first, you must add the products you wish to import, alongside the customers who the orders are meant for to Uphance. Then ensure the product and customer names you enter in the sheet match what you've added to Uphance.

How to Add Products to Your Sales Order

Once you've created a new draft sales order, the next step is to add products to it and set your payment term. The process is simple:

When you are done, you can proceed to confirm the order.

How to Add an Attachment to Sales Orders

Uphance allows you to add attachments to your sales orders. This could be a PDF document, a spreadsheet, or an image.

The best way to go about this is to set up automatic attachments for your emails. You can learn how to do that here.

But if you prefer to do so manually, simply click the attachment icon on the Sales Order and upload the attachment.

If the attachment was uploaded successfully, you can easily access it by clicking the attachment icon again. You can either download or delete it.

How to Copy a Sales Order

There are times you just want to copy and duplicate a customer's order rather than create it from scratch.

This feature will also come in handy if you have a set of customers who order similar items each time they make a purchase. Using the order copy feature will save you the trouble of manually creating the orders for each time they come in.

First, locate the order you wish to copy. Next, click the Make a copy link.

The copied order will contain the same information as the original one. However, the order number will change.

All you have to do now is to confirm the order and ship it to your customers.

How to Locate a Sales Order

The Sales Order list allows you to search for customer orders by customer name, customer "tag", order date or other filters.

To open sales orders, navigate to Order Management >> Sales Orders


You can sort orders based on Customer name, Season, Brand, Order number, Status, Order date, Start ship date, and Cancel ship date.

The sort feature is on a toggle meaning that if you click the column heading once it will sort ascending and if you click it again it will sort them descending. These are the fields that you can sort:

  • Customer Name - Sorts customer orders by customer name from A-Z or from Z-A

  • Season - Sorts your product's Seasons by Season name from A-Z or from Z-A

  • Order Number - Sorts your Sales Orders by number from smallest to largest or largest to smallest

  • Order Date - Sorts your Sales Orders by order creation date from the most current or listing the oldest first

  • Start Ship Date - Sorts your Sales Orders by the date they should be shipped with the dates closest to the current date or with the older dates listed first.


Use the Search feature to Filter your order list for a specific customer name or sales order number. You can also search using order tags.


Use filtering to search for your order based on any number of these attributes: Seasons, sales status, channels, agents, brands, source of order (manual, Shopify, etc.), order and ship date, payment terms, and originating warehouse.


The "All Seasons" drop down menu allows filtering of Sales Orders by a particular Sales Order's Season. These are "Sales Order" seasons not "Product" seasons as you may have a Sales Order with products from multiple Product Seasons on one Sales Order. The Sales Order Season is the Season listed at the top of the Sales Order as shown in the Blue box below.

Note: if your Sales Order is in the wrong season, you can change that by clicking on that Sales Order Season and selecting a different one.


The "All Sales" drop-down menu allows filtering of Sales by multiple options. The default is "All Sales". However, if you click on the drop-down menu, you will see the additional options as illustrated in the image below.

The benefit of using these filters is that you will be able to gain additional insight into the status of your orders that may help you make business decisions on the next steps to move them forward through the process.

For example, you may want to use the Not Yet Invoices filter to get a list of Sales Orders that you need to create invoices for, or the Awaiting Shipment filter for orders that haven't been shipped yet. You may want to use the Awaiting Payment filter to see the sales orders that have not been paid for.

The Unconfirmed Sales may be a reminder to complete a task (e.g. call the customer for a billing or shipping address) so that you can Confirm the order.

The Confirmed & Open may be a reminder to follow up on a Production Order for fulfilment.


The Season, Sales and Agents filters allow you to select one item from each of the menu options. However, the All Channels drop-down menu allows you to select multiple pricing Channels. Select your intended channel by clicking the checkbox next to it. Keep in mind that you can select multiple channels at once.

Seeing Sales From Agents

You may want to see all Sales Orders for a particular Stylist. Use the All Stylist drop-down menu to select the stylist you want to filter for.

Changing Season for a Sales Order

Uphance allows you to change seasons for your orders even after confirming them. To change the season for an order, navigate to Order Management >> Sales Orders.

Locate the sales order you would like to update and change the season like so:

Locating Customer Sales History

You can also see the Sales History for a particular customer by bringing up your customer's profile Customer Relationship >> Customers. Scroll down a bit to the Sales History section. There, you will see all the customer's orders. Click on the Order number to bring up that particular order.

How to Add Customer Notes to Sales Orders

You can easily add customer notes/instructions to sales orders.

After adding the note, it will appear like this when you generate and download an Order Confirmation document:

But if for some certain reason, the customer note isn't showing on your OC document, you can manually add it via the document designer.

To do so, open the document designer, click Order Confirmation, and edit the active template followed by Order Confirmation again. This will launch the document designer interface. Add the Text component to where you want to display the customer note.

Next, change the merge tag of the text to Customer notes. Finally, add a heading to the customer note (optional). You can do this by duplicating an existing heading, altering the text to what you want or by adding a new heading.

How to Add Shipping Instruction to a Sales Order

Besides adding notes, you can also add shipping instructions to your sales orders. You can do so in two steps:

Step One: Input the instruction

Open an order (or create a new one) and then input the shipping instructions like so:

Step Two: Display the instructions

After inputting the shipping instructions, the next thing you will want to do is to add it to the document you want the instructions displayed.

For example, you may want it displayed on your Order Confirmation (OC), Pick Ticket, Delivery Notes, etc. Let's say you want to show it in your order confirmation documents.

To do so, fire up the Document Designer, select the document you are after (order confirmation in this instance) and edit the active template (you will know it's active if it has a dark grey overlay). Alternatively, duplicate the Standard Template and activate it. Then start editing the OC template.

Locate where you want to add the shipping instructions. Add a subheading (optional), and then a text.

Next, change the Merge Tags of the text to Shipment Instruction. Save.

The next time add a shipping instruction to an order and download the OC, you will see the instructions like so:

How to Check for Unshipped Orders

If you want to see all the orders picked or packed but haven't been shipped yet, navigate to Reports >> Inventory Reports >> Remaining to Ship. Select the warehouse you wish to run the report (or just pick all warehouses). You can also set other filter variables, such as customer, sales channel, agents, etc.

Finally, set a date range and run the report.

How to Check An Order's Status

Sales orders in Uphance can have one of these three statuses: Draft, Confirmed, or Complete.

If it is in a Draft state, it means the order has some or all of the required information, including customer information, but hasn't been confirmed yet.

Confirmed means the ordered products are ready for fulfilment and an invoice has been created for the order.

Once the order is paid for, shipped and received by the customer, it's completed.

You can easily check the status of an order by navigating to Order Management >> Sales Orders. You can search using the order number or the customer the order was for.

How to Create Balance Orders for Unpicked Items

There are times when you wish to add extra products to an order, even though you've already confirmed it and picked some items in the order already.

For example, let's say you had an order for 5 winter jackets. Two weeks ago, you picked and shipped 3 jackets, now you are left with 2. Then the customer calls and requests for an extra 4 pieces of jackets, in addition to 3 pieces of sweatpants for the same order. How do you handle that?

The easiest way to handle this is by creating a balance order. Put simply, balance orders are orders that account for unpicked items in an original sales order. The best part is that you can add extra items to a balance order.

When you create a balance order, Uphance will first create a cancellation for the unpicked items, and then move them into the balance order.

To create one, first, open an order with unpicked items. Then hit the Create button, and generate the balance order. Next, add more items to the order (though optional).

The balance order will appear on your list of sales orders. Be sure to note the order number. You can create pick tickets and shipment for the order, just the same way you would for regular orders.

Managing Exchange Rates

Uphance handles exchange rates for sales orders automatically, especially if the order is in a currency different from your home base currency.

For instance, if your home base currency is in USD and you get an order in EUR, Uphance will automatically convert the EUR to USD based on current market values once you confirm the order. But you can always manually input your exchange rates if you so desire.

How to Access And Manage Sales Order Reports

Uphance offers a wide variety of reporting capabilities that give you deep insights into your sales operations, giving you better control over your business.

One such report is the Sales Order Report. This report lets you see your sales by SKU, product, customer, variation, country, size, to name a few.

To access your sales report, click the Reports tab. Then select the report you would like to run. Set your parameters using the filters and click the Run button.

Interestingly, you can download the report as CSV/Excel. To do so, simply navigate to the bottom of the bottom of the page and select the format you would like to download the report.

Sales Order Current State Status Reports

Sales Order Current State Status reports show you which Sales Orders are unconfirmed, confirmed and open, not yet invoiced, awaiting shipment, awaiting payment, fully shipped, consigned, completed and cancelled. These reports are available by Season, Channel or Agent. And, they can be broken down even further.

To see the statuses of your sales orders, open Sales Orders and then pick the status you want to filter for from the All Sales dropdown:

In addition, you can use the additional filters to narrow down your reporting criteria by Season, Channel, Companies, Brands, etc.

Once you have your list filtered the way you want, you are ready to download the report. You can download it as PDF, Excel, or CSV. To download as PDF, click the PDFs button.

To download as CSV or Excel, scroll down to the bottom of the page and click your preferred download option.

Creating Refunds for Shopify Orders

When creating returns, credit notes or cancellations for a Shopify order, you can choose to send refunds directly to Shopify to avoid creating duplicates.

Did this answer your question?