How to Retrieve Order Totals

Instructions for retrieving order totals for account reconciliation or accounting for your studio or business
  1. Login to richmondprolab.com with your email address and pin

  2. Click on your account number in the upper rightcorner of the page

  3. Select Shipping History on the right side of the page
    image.png

  4. On the Shipping History page, select the Search by Date text box

  5. Select the preferred date range and click Done
    image.png

  6. Click on Show Shipments and the page will populate with all orders within the date range
    image.png

  7. Scroll to the bottom of the page to download a CSV of order product and shipping totals
    image.png

  8. Open the spreadsheet in Excel or similar software to view order history details

  9. To calculate your total in Excel: Use the formula "=SUM(C:C)" in a blank cell in Excel


Important notes on CSV Column headings:

image.png

  • Line Item - the specific item that was charged (typically order ID or shipping)

  • Shipment Number - the ID number (not tracking) for the order(s) and shipment

    • Since multiple orders can be shipped within the same package, use the shipment number to cross-reference orders that are shipped together

  • Billed Amount - amount billed for particular line item

    • For example, orders that have shipped should have at least 2 billed amounts

      • one line item for order charges - listed as the Order Number

      • second line item for the shipping - listed as Shipping

  • Special Notes - any special instructions, order comments, etc. that were input during order submission

  • Customer Order ID - the order number listed in the software that submitted the order

  • Team/Event Name - the Order ID entered for ROES order or the Project Name for FLOW orders