How to Manually Import Fullfilment Data

Overview

Sellegr8 automatically imports reconciliation reports from Walmart via their API, typically once every two weeks. These reports include Walmart Fulfillment Services (WFS) fees, among other charges or reimbursements. This ensures that your financial dashboards reflect accurate data.

However, if you use another fulfillment provider (e.g., ShipStation, Deliverr, etc.) or require more frequent updates than those provided through the Walmart API, you can manually import your own fulfillment data using a CSV file.

Key Steps:

• Download and populate a provided CSV template.
• Upload the file to Sellegr8 Costs & Fees page
• Follow tailored steps for WFS or ShipStation to ensure compatibility.

This process ensures up-to-date financial data for precise profitability tracking in Sellegr8

Walmart Fulfillment Services (WFS) Users

1. Log in to your Walmart Seller Central account.
2. Download your Payments Report" as documented in this article.
3. In Sellegr8, navigate to Finance > Costs & Fees and click the "Import" button to upload the downloaded report.

ShipStation Users

1. Follow the instructions in this article to generate the Shipment Line Items Report.

   • Ensure you select Shipment Line Items Report" in Step 4.

     Verify the report includes the following columns:

   • OrderID
   • OrderItemID
   • OrderNumber
   • TrackingNumber
   • CarrierFee
   • StoreName
2. If the default report does not include these columns, create a custom report with them.
3. Once your report is ready, click the Import button in Sellegr8 and upload the file.

Manual Import Process

If you are user another fulfillment service, you can manually create a CSV file with the required data and upload it to Sellegr8. To manually import fulfilment cost data into Sellegr8:

1. Download the CSV Template
   1. Navigate to Finance > Costs & Fees
   2. Click the "Get Template" button to download an empty CSV file.
2. Fill in the CSV Template
   1. Enter your transaction details into the template. Do not modify the column headers.
   2. Save the file once completed.
3. Import the CSV File
   1. Navigate to Finance > Costs & Fees
   2. Click the "Import" button and upload the completed CSV file.

Summary

This guide explains how to manually import Walmart reconciliation reports into Sellegr8. While Sellegr8 automatically retrieves these reports via Walmart's API, users can also upload CSV files for more frequent updates or when using alternative fulfillment providers like ShipStation. The process involves downloading a template, filling in transaction details, and uploading the completed file. Specific instructions are provided for users of Walmart Fulfillment Services and ShipStation to ensure accurate data integration and financial tracking.

Frequently Asked Questions

What is the purpose of importing reconciliation reports into Sellegr8?

Importing reconciliation reports allows Sellegr8 to accurately calculate your fulfillment costs, fees, and reimbursements. This ensures that your financial dashboards reflect up-to-date and precise profitability data.

How often does Sellegr8 import Walmart reconciliation reports automatically?

Sellegr8 automatically imports reconciliation reports from Walmart via their API approximately once every one to two weeks, depending on when Walmart makes them available.

When should I manually import a reconciliation report?

Manual import is recommended if:

• You use a fulfillment provider other than Walmart (e.g., ShipStation, Deliverr).
• You need financial data updates more frequently than the automatic import schedule.

Where can I get the CSV template for manual import?

You can download the empty CSV template by clicking the "Get Template" button in Sellegr8. This template includes the required column headers for successful import.

Can I change the column headers in the CSV template?

No. It is important not to change the column titles in the CSV template, as Sellegr8 relies on these headers to correctly interpret the data.

What file types are supported for manual import?

Sellegr8 supports CSV file format for manual imports. Ensure the file follows the structure of the provided template.

How do WFS users obtain the reconciliation report?

WFS users can download the "Settlement Report" directly from Walmart Seller Central. This report can then be uploaded into Sellegr8 using the "Import" button.

What information should be included in a ShipStation report?

The ShipStation report should include the following columns:

• OrderID
• OrderItemID
• OrderNumber
• TrackingNumber
• CarrierFee
• StoreName

You can either download the "Shipment Line Items Report" or create a custom report containing these fields.

What should I do if the default ShipStation report does not include the required columns?

If the default report is missing required columns, you can create a custom report in ShipStation with the necessary fields before importing it into Sellegr8.

I am using a third-party fulfillment service that is not currently supported by Sellegr8. What should I do?

If you're using a fulfillment provider not yet supported by Sellegr8, you have two options:

1. Use the manual import process
2. Contact our team and ask for a direct integration. When reaching out, please provide the following:

• A link to the fulfillment company's website.
• If available, a sample CSV report from your account containing order details.

This information will help us evaluate the integration requirements and potentially expedite support for your provider.