Cetec ERP has a mass order update tool that allows you to update existing orders you have in your system. This tool is typically used to update dates, order resale values, and line comments for your orders:

• Click Sales » Orders » Order Mass Update.
• Once on the Import Order Data screen select the xlsx/csv file you want to use to update orders.
  • NOTE*: Required columns here are Order Number and Line Number **for all mass order update imports **- the system needs to know which order and which line on the order to update.
  • NOTE*: Updating Resale values requires the Resale column
  • NOTE*: Updating dates for orders uses the Due Date, Ship Date, and Target Wip Date columns
• Click the Import File button.
• If you used header columns, make sure to deselect the first data row.
• Designate the column headers that you want to use.
• Make sure the correct column headers are mapped to their respective columns.
• Once ready, hit the Update button.
• This will import the updated data to your orders in the system.
• Validate the orders that youve updated, and make sure data is good there!