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 Cost, Average 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.
- Go to Orders > Manage Orders.
- Open the order whose product(s) cost has changed.
- 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.
- From the order’s Toolbox, select Profit & Loss. See the updated results on the Profit and Loss panel.
Recalculate Order Cost in Bulk
To update and regenerate the Profit & Loss data for multiple orders, follow the steps below.
- Go to Orders > Manage Orders.
- Search and select the orders for which you want to recalculate the Order Cost.
- In the bottom-right corner, click the Actions menu icon and select the Recalculate Order Cost option.
- The action will be submitted to the Queued Job list.
Note: It may take a few minutes for the Orders Cost to update. - Return to the Manage Orders page > select the requested orders > from the Actions menu, select the Generate P&L option.
- 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
- From the order’s Action menu > ReCalculate Order Cost > Go.
- 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
- 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.”
- Enable the Select all pages option > Action menu > Re-Calculate Order Cost > Go. This creates a queued job.
- When completed, on that same Manage Orders page > Action menu > Generate P&L > Go. This creates a queued job to update the orders.
