Dropship reports provide detailed information about Dropship orders, including product margins, shipping costs, charges, payouts, and order-level financial data.
CommentSold provides two Dropship reports:
- Product Margin Report: Shows the difference between the total selling price and total product cost to help track profitability.
- Shipping Cost Report: Shows shipping expenses associated with Dropship orders.
Use the table of contents below to navigate to specific sections of this article:
View, Generate and Export Dropship Reports
Product Margin Report
Provides insights into product profitability by showing the difference between the Total Price and the Total Cost.
Expand each customer order to view individual product details under an order by selecting the arrow on the right corner of each order.
Shipping Cost Report
Tracks shipping expenses for your Dropship orders.
When you generate a Dropship report, you do so for a specific date range. Each report should be considered an isolated snapshot of information available for the dates you entered.
You will need to generate a new report if you wish to view a date range different from the one you entered previously.
You have two options for viewing your report:
- Export the report. You can export the report to your device as a .CSV file. This is ideal if you wish to open the file in your preferred spreadsheet program for advanced filtering and reporting.
- View the report in CS. You can quickly view report data in CommentSold. This is ideal if you want to glance at individual figures and totals quickly, or if you wish to drill down to specific order details.
- Hover over the side menu of your CommentSold dashboard, then select Dropship.
- Select Reports at the top of the page.
- Select the desired type of report tab. Product Margin Report or Shipping Cost Report. You will now see customer orders listed (newest to oldest).
- Expand orders on the Product Margin Report tab to see more details.
- To narrow down the data, select a Date range from the drop-down at the top-right corner of the page.
- Select Generate Report at the top-right corner of the page.
- You can also select Export to CSV if you wish to export the report in .CSV format.
These reports will include all dropship orders regardless of payment processor.
|
Exported Product Margin Report in .CSV format. |
Exported Shipping Cost Report in .CSV format. |
- Order ID. Displays the CS order number. You can select this number to view the order details on your Orders page.
- Payment Method. Displays the customer payment method for the order (e.g., Credit Card, etc.). Please note that payments made via Klarna will appear as Credit Cards.
- Total Price. Displays the total sale price of the dropship product(s) in the order.
- Total Cost. Displays the total product cost of all dropship items in the order.
- Total Margin. Displays the profit margin for the dropship items in the order.
- Original Shipping Cost. Displays the shipping amount paid by the customer.
- Fulfillment Status. Displays the current fulfillment status of the order.
- Combined Shipping Refund: Displays the refund amount for combined shipping on multiple items.
- Finalized Shipping Cost. Displays the final shipping cost after adjustments.
- Combined Shipping Refund ID. Displays the ID associated with the combined shipping refund.
FAQs
What is the Product Margin Report in CommentSold?
The Product Margin Report shows the total selling price, total product cost, and total margin for Dropship products in customer orders.
What is the Shipping Cost Report in CommentSold?
The Shipping Cost Report tracks shipping expenses associated with Dropship orders.
How do I generate a Dropship report?
Go to Dropship > Reports, select Product Margin Report or Shipping Cost Report, choose a date range, and select Generate Report.
Can I export a Dropship report to CSV?
Yes. Select Export to CSV after choosing the report type and date range to download the report as a CSV file.
What is included in a Dropship Product Margin Report?
The report can include the Order ID, Payment Method, Total Price, Total Cost, Total Margin, Fulfillment Status, and shipping-related information.
What does Total Margin mean in a Dropship report?
Total Margin displays the profit margin for the Dropship items included in the order.
What does Total Cost mean in a Dropship report?
Total Cost displays the total product cost of all Dropship items included in the order.
What does Original Shipping Cost mean?
Original Shipping Cost displays the shipping amount paid by the customer for the Dropship order.
What is Finalized Shipping Cost?
Finalized Shipping Cost displays the shipping cost after applicable adjustments.
Does the Dropship report include orders paid through different payment processors?
Yes. Dropship reports include orders regardless of the payment processor used.
Can I view individual products in a Dropship order?
Yes. On the Product Margin Report, select the arrow next to an order to expand it and view individual product details.
Can I run a Dropship report for a different date range?
Yes. Select the desired date range and generate a new report. Each report is a snapshot of the information available for the selected dates.
What is the Combined Shipping Refund in a Dropship report?
Combined Shipping Refund displays the refund amount associated with combined shipping on multiple items.
What is the Combined Shipping Refund ID?
The Combined Shipping Refund ID displays the identifier associated with a combined shipping refund.