Skip to content

Update Existing Orders

The Order Import function also supports updating existing order records. This is useful for making bulk edits to fields such as pricing, shipping information, agents, factories, or size quantities across multiple orders.

To update existing orders, users must use the same import template used for creating new orders. The system identifies each order by its Order Number and applies updates only to the fields that contain new values.

Quick Check - Before You Start
  • Every row you intend to update includes the correct Order Number for an order that already exists.
  • You are using the same Import Template as for new orders, downloaded fresh from Import Order.
  • Columns you do not want to change are left blank so existing values are kept.

Steps to Update

Step Description
1 Download the Import Template used for new order uploads.
2 In the template, ensure the Order Number matches an existing order. This field is mandatory for updates.
3 Fill in only the fields you want to update. Leave all other columns blank to keep existing values unchanged.
4 Upload the completed file using the Import Order popup.
5 Review the uploaded data in the Preview Window, then click Yes to proceed.
Partial Updates Only

The system will only update fields that contain values in the spreadsheet. Blank fields will be ignored, and the original data will be retained.

Info

  • You can update pricing, shipping dates, factory details, customer references, pack configurations, and size breakdowns.
  • Ensure all reference values (e.g., staff, departments, tags, colours, sizes, and currencies) match entries in Site Settings.
  • After uploading, download the Import Summary to verify which rows were successfully updated and identify any errors.

Troubleshooting

Why were my updates not applied to some orders?

The system matches rows by Order Number. Wrong or missing numbers, or values that fail validation, can skip or fail updates for those rows.

Steps to resolve:

  1. Confirm each Order Number in the file matches an existing order exactly.
  2. Download the Import Summary and read the error messages for failed rows.
  3. Correct the spreadsheet and import again.
I filled a cell but the field did not change—why?

Only non-blank cells in the import file are written; blanks leave the database value unchanged. Hidden characters or formulas can also prevent the value from being read as expected.

Steps to resolve:

  1. Ensure the cell truly contains the new value (paste as values, not formulas).
  2. Clear accidental spaces; re-enter the value if unsure.
  3. Re-import and check the Import Summary for that row.
Reference fields failed validation after my update attempt—what should I check?

Staff, departments, tags, colours, sizes, currencies, and similar columns must match Site Settings and configured lists.

Steps to resolve:

  1. Compare each reference column to the corresponding list in Site Settings.
  2. Align spelling and casing with the system.
  3. Run the import again and verify results in the Import Summary.