Order Item Cost Regeneration


Overview

You can easily rebuild your Order’s P&L in Sellercloud if the product cost has changed. The Items Cost on your Orders’ P&L is calculated based on either the product’s Site CostAverage Cost, or Last Cost depending on how the calculation is configured as per the Order Profit & Loss Calculated Using client setting.

After changing the item cost for any product in an order, you should regenerate your Order’s P&L to apply the latest changes. You can update either an individual order or a bundle of orders via a file import.

To learn more about the Profit and Loss report on the individual order, refer to Order Profit & Loss Overview.


Recalculate Order Cost Individually

To update and regenerate Profit & Loss data for an individual order, follow the steps below.

  1. Go to Orders > Manage Orders.
  2. Open the order whose product(s) cost has changed.
  3.  In the upper-right corner, click Actions and select Recalculate Order Cost. Alternatively, you can use the Generate P&L action described under the next header.
    Note: It may take a few minutes to update the report.
    Recalculate Order Cost
  4. From the order’s Toolbox, select Profit & Loss. See the updated results on the Profit and Loss panel.P&L Report

Recalculate Order Cost in Bulk

To update and regenerate the Profit & Loss data for multiple orders, follow the steps below.

  1. Go to Orders > Manage Orders.
  2. Search and select the orders for which you want to recalculate the Order Cost.
  3. In the bottom-right corner, click the Actions menu icon and select the Recalculate Order Cost option.Update Orders Cost
  4. The action will be submitted to the Queued Job list.
    Note: It may take a few minutes for the Orders Cost to update.
  5. Return to the Manage Orders page > select the requested orders > from the Actions menu, select the Generate P&L option.
  6. The action will be submitted to the Queued Job list. Once processed, the P&L for each selected order will be updated with new values.

When adjusting or updating the cost on an item, use the following procedures to update P&L for related orders. This can be done in a single order or in bulk.

Updating a single order

  1. From the order’s Action menu > ReCalculate Order Cost > Go.
  2. After seeing the message “Order Cost re-calculated successfully,” click the P&L tab’s Re-generate P&L icon and await the message “P&L re-generated successfully.”

Updating orders in bulk

Before you Generate P&L for 5000+ orders, check with SellerCloud Support.
  1. From the Manage Orders page, search for orders with a specific SKU or SKUs.
    When searching for orders, set the Max Records filter to a higher number than the number of order records found, and set the Advanced Search’s Order Date Range to “All Dates.”
  2. Enable the Select all pages option > Action menu > Re-Calculate Order Cost > Go. This creates a queued job.
  3. When completed, on that same Manage Orders page > Action menu > Generate P&L > Go. This creates a queued job to update the orders.

Was this article helpful?

Related Articles