How do I edit the Supplier Unit Cost for a SKU?

Once a PO is created in Ordoro, the Supplier Unit Cost on that PO is fixed. Any changes made to the supplier cost on the product page will not retroactively update existing POs.

If the unit cost needs to be adjusted, you’ll need to edit the Supplier Unit Cost directly on the PO itself. There are two ways to update the Supplier Unit Cost, outlined below.

Topics

  1. Creating a PO
  2. Editing an existing PO
  3. Updating Supplier Unit Cost in Bulk on the Product Level

Creating a PO

When you create a PO and add a SKU, Ordoro automatically pulls in the Supplier Unit Cost associated with that SKU and supplier. Unless you manually edit it, this will be the cost used on the PO.

  • NOTE: If you change the supplier from the dropdown while creating the PO, you may notice that the Supplier Unit Cost updates based on the selected supplier.

You can edit the Supplier Unit Cost while creating your PO, by typing in the new Supplier Unit Cost into the Supplier Unit Cost field.

When you click on Order More, the Supplier Unit Cost will be saved, and your PO will be created. Ordoro calculates the PO Price Total by multiplying the Supplier Unit Cost (stored with up to six decimal places, e.g., $2.000010) by the Quantity.

Editing an existing PO

You can edit the Supplier Unit Cost at any stage of the PO process.

  1. Select the PO you would like to update.
  2. Under the Supplier Unit Cost column, edit the cost for the applicable SKU(s).

Important: If you update the supplier cost on the product page, it will not update existing POs. For existing POs, the supplier unit cost must be edited directly on the PO.

Updating Supplier Unit Cost in Bulk on the Product Level

If you need to update supplier costs across multiple products for future POs, you can use the Data Import tool.

  1. Click your business name in the upper right-hand corner of Ordoro.
  2. Select Data Import.

  1. Choose Create/Update Supplier SKUs from the dropdown menu.

  1. Download the example file and format your spreadsheet accordingly.
  2. Update the Supplier Unit Cost field for the products you want to change. Save the file.

IMPORTANT: It’s crucial to remove entire columns from the file if you’re not updating certain columns. Leaving them blank will result in overwriting with a null value.

  1. Drag the file to the Data Import page.

  1. Follow steps 6-10 in our Data Import support article to complete the changes.