How can I update existing sales orders in bulk?

You can update existing sales orders with an import! 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, see here for how to import your file.

A sales order import can’t be used to:

  • Update products, descriptions and quantity
  • 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 and follow the steps here to import it into inFlow!

Was this article helpful?

Yes
No

Thank you for your input, your feedback is important to us.

Thank you for your input, your feedback is important to us.  Please share some more information about why you find this article unhelpful.

  • This field is for validation purposes and should be left unchanged.