How Do I Bulk Import/Export Shipping Costs For Past FBM/FBA Orders

Overview

If you handle FBM orders, you are responsible for shipping and will incur shipping costs. You can also manually add shipping costs for FBA orders. If you do not record these costs, your overall profit will be overstated.

SellerLegend provides a bulk upload process to manage shipping costs across all your orders via Excel.

Recommended Process

1. Select the marketplace you want to work in (repeat once per marketplace)
2. Download the Shipping Costs spreadsheet template
3. Open the file in Excel and amend shipping costs for the orders you want to update
4. Upload the modified file back to SellerLegend
5. Check for upload error messages and correct any errors
6. Repeat upload until accepted without errors
7. Spot check by verifying a sample of modified orders

How to Download the Shipping Report

1. Go to Sales → Orders and click the Reports button (top right)
2. In the download section, select report type FBM Shipping
3. Choose the account
4. Choose FBM orders only or All Orders (if you want to update FBA orders as well)
5. Click Download
6. Go to Reports → Exported Reports and wait for status to show DONE
7. Click the Actions button and select Download

How to Upload Shipping Costs

1. Go to Sales → Orders and click the Reports button
2. In the upload section, select report type Shipping Cost
3. Choose the correct Account ID
4. Select your modified Excel file
5. Click Upload
6. Go to Reports → Imported Reports to check the outcome:
   • DONE — file imported without errors
   • DONE_WITH_WARNINGS — file contained errors. Download the result file; erroneous entries appear in red. Hover over fields to see error messages.

Excel File Format

Every row must follow this format:

Field	Excel Header	Notes
Amazon Order ID	amazon_order_id	Mandatory — must be a valid, existing order number
Shipping Cost	shipping_cost	Mandatory — decimal number (e.g., 12.34)
Miscellaneous Costs	miscellaneous_costs	Mandatory — decimal number (e.g., 0.17)

Excel File Rules

• On first download, shipping and miscellaneous costs columns will be zero
• You cannot assign costs to orders not yet recorded in SellerLegend
• Deleting a row will not delete the order or change its existing shipping cost
• The file must have a header row with the exact column titles above
• The file must have only one tab and no cell formulas
• If you used lookup formulas to assign costs, copy/paste values in place before uploading

TIP

This bulk method is for past or current orders. To set shipping costs for future FBM orders, see How Do I Enter Shipping Cost For Future FBM Orders.