Sage Order Entry Import by Excel

SUGGESTED

Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.

  • 0

    Hello,

    Make sure your Excel file contains the necessary columns, such as order details or line items, including the product name or identifier and the corresponding unit price. Ensure that the data is correctly formatted in the Excel file. Access the functionality within your order management software or system to import data from an Excel file. Look for options related to importing or updating order details. During the import process, you may be prompted to map the fields in your Excel file to the corresponding fields in the software. Ensure that you correctly map the unit price column from your Excel file to the appropriate field in the order details. mybkexperience Once the import is complete, review the imported order details in your software. Locate the column or field that corresponds to the unit price, and manually update the prices if needed. Depending on your software, there may be an option to mass-update the unit prices based on the imported data.

  • 0

    Use Realisable IMan.  This allows insert/update/delete of OE order details.  No programming needed.

  • 0
    SUGGESTED

    wait, are you just trying to import a sales order with pricing?  not "updating" a sales order??? because thats simple.  You just need to ensure you upload and have the PRIUNITPRC column on there and populated with whatever you want it to price at.  You can't update existing orders this way, but you can totally import a new one.

    I think everyone is assuming you are trying to UPDATE an existing order, but after reading again, maybe you just want to import with set pricing?