Skip to main content

Add Merchant-Fulfillment Shipping Costs to Merchant Sales

Add shipping costs to merchant-fulfilled sales manually or in bulk using a CSV import to ensure accurate accounting in InventoryLab.

If you don't pay for shipping for merchant-fulfilled orders through Amazon, you can add this cost individually or in bulk to the sales transactions on your Merchant Sales page.

Add Shipping Costs Individually

  1. Navigate to Accounting > Merchant Sales.
    ​

  2. To filter for all of the orders without a shipping cost, use the Advanced Search button and select No Shipping Cost on Shipping Cost.
    ​

  3. Click Search to display results.
    ​

  4. Click on the Order ID of the sale you need to add merchant shipping costs for.
    ​

  5. Click the appropriate MSKU if applicable, and add in the cost to the right. It will automatically save and display within the expenses area.
    ​

    Screen_Shot_2022-02-03_at_8.38.51_AM.png

Add Shipping Costs in Bulk

  1. Navigate to Accounting > Merchant Sales.
    ​

  2. To filter for all of the orders without a shipping cost, use the Advanced Search button and select No Shipping Cost on Shipping Cost.
    ​

  3. Click on Search to display results.
    ​

  4. Click on the Export button to get a .CSV file of the results.
    ​

    Screen_Shot_2018-12-12_at_1.27.16_PM.png

  5. Open the file and add the amount as a negative number under the Shipping Cost column.
    ​

    MFN_Sales_3-19-20_17_15_csv.png

  6. Save the file.
    ​

  7. Go back to the Accounting > Merchant Sales page and click Import.
    ​

    Screen_Shot_2018-12-12_at_1.28.43_PM.png

    You'll first receive a reminder that is not applicable when adding MFN shipping costs. Select MFN Shipping Cost from the drop-down.
    ​

  8. Once the prompt appears to import, select your file and click Next.
    ​

    The next screen allows you to match the fields in InventoryLab with the columns in your .CSV file. The required fields are in red.
    ​

  9. Be sure that you select a column to match with Order ID, Shipping Cost, and MSKU.
    ​

    InventoryLab_-_MFN_Sales.png

  10. Click Next.

That’s it! You should now receive an Import Success message.

Note: Imported changes can take up to 20 minutes to take effect on your account.

What's Next?

Did this answer your question?