Order Fulfillment
      Back to home
      1. Spark Shipping Knowledge Base
      2. User Guides
      3. Order Fulfillment

      Vendor Fulfillment Detail Report

      The Vendor Fulfillment Detail Report provides detailed fulfillment data, enabling vendors to track and analyze order fulfillment statuses. This report can be scheduled for automatic email delivery or run on demand for specific date ranges.

      Accessing the Report

      1. Navigate to the Email Reports Section

        • Go to the "Email Reports" section in the application.

        • Ensure the correct email address is set in Site Settings - Advanced options.

      2. Automated Report Scheduling

        • Check the box for Fulfillment Details Report to enable automatic emails.

        • Set the Daily Run Time (e.g., 6:00 AM EST) for the report to be sent.

        • Click Update Email Reports to save the schedule.

      3. Running the Report Manually

        • Use the Send Email Report Now section.

        • Select a Start Date and End Date.

        • Click Run Report to generate and send the report immediately.

      Report Format & Data Structure

      The report is delivered in CSV format, containing detailed fulfillment information. Below is a sample CSV template showing the expected format:

      Download the sample CSV template

      The CSV file includes the following columns:

      • Order ID – Unique identifier for each order.

      • Vendor Name – The name of the vendor fulfilling the order.

      • Product SKU – Stock Keeping Unit (SKU) of the item.

      • Product Name – Name of the product being fulfilled.

      • Quantity Ordered – Number of units ordered.

      • Quantity Fulfilled – Number of units successfully fulfilled.

      • Tracking Number – Shipping tracking number (if applicable).

      • Shipping Carrier – The carrier handling the shipment.

      • Fulfillment Date – The date the order was fulfilled.

      • Status – The current fulfillment status (e.g., Pending, Fulfilled, Shipped, Cancelled).

      Common Use Cases

      • Monitoring Vendor Performance: Track how quickly and accurately vendors fulfill orders.

      • Inventory Planning: Understand fulfillment trends to manage stock levels effectively.

      • Customer Support: Quickly resolve fulfillment-related inquiries by referencing tracking details.

      • Discrepancy Auditing: Compare fulfillment data against expected shipments to identify any inconsistencies.

      Troubleshooting & FAQs

      1. I’m not receiving the automated email report.

      • Verify that the correct email address is set in Site Settings - Advanced options.

      • Ensure the Fulfillment Details Report checkbox is selected.

      • Check your spam/junk folder.

      2. The report is missing data.

      • Ensure the selected date range includes valid orders.

      • Verify that vendors have submitted fulfillment data correctly.

      • If issues persist, contact support for further assistance.

      3. How do I change the email recipient?

      • Navigate to Site Settings - Advanced options and update the email address.