Select Page
Common searched topics: Manufacturing, Label printing, Sales order
Browse features guide
Managing products
Label printing
Imports, exports & integrations
Sales
Stock level reports
inFlow settings
Manufacturing
Sales
  • Sales orders
  • Importing
  • Exporting
Sales order update (bulk)

How to update existing sales orders in bulk

You can bulk update existing sales orders with an import! See below for full details

Web/Windows

First, export your current sales orders from inFlow or create a new sales order import file.

We’ve outlined the different changes you can make to your sales orders below. Click a link to jump to that section. Once you’ve made the necessary updates, take a look at this article on how to import your file.

A sales order import can’t be used to:

  • Update products, descriptions, quantity, and serial numbers
  • Update pricing, discounts, taxing, and currency information
  • Re-open previously fulfilled orders

Cancel orders in bulk

In your sales order import file, change the entry in the IsCancelled column to ‘TRUE’ for any order you’d like to cancel with an import:

Note: this value must be applied to every item line that belongs to the same order.

Fulfill orders in bulk

When you import your sales orders into inFlow, you will have two import options:

  • Import orders as Open – Orders should be manually processed later.
  • Import orders as Completed – Update inventory now, taking it from default locations.

To fulfill all of your orders in your import file, select the option to import your orders as completed. It is not possible to fulfill only some orders in the import file.

Note: it is not possible to re-open existing orders that have already been completed using an import.

Pay orders in bulk

You can apply payments to multiple orders by updating the AmountPaid and DatePaid columns in your import file:

Note: the amount paid is applied to every item line that belongs to the same order.

Revert a sales order to a quote and vice versa

To revert a sales order to a quote, or a quote into a sales order, change the IsQuote column to:

  • ‘TRUE’ to update it to a quote
  • ‘FALSE’ to update it to a sales order

Note: this value must be applied to every item line in the same order.

Update customer information, dates, and custom fields

You can update customer information, dates, and custom fields by changing the values in the corresponding columns in your import file:

  • Customer information: Customer, ContactName, Phone, Email, BillingAddress columns, ShippingAddress columns
  • Dates: OrderDate, DueDate, Date Paid
  • Custom fields: Custom1 through Custom10

Note: the updated value must be applied to every item line that belongs to the same order.

Once you’ve created your import file, make sure to save it as a CSV file type. For more on how to import to inFlow take a look at the importing article.

Was this guide helpful?
Yes, thanks!
Not really
Thank you for your input, your feedback is important to us!

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

In this tab
    Similar articles

    A complete guide on how to set up inFlow.

    Get advice and answers from the inFlow Support team