How do I Bulk Import/Export Internal Price for Fulfillment Orders

• If you handle fulfillment orders, you as a seller are responsible for revenue and of course, you will incur revenue for your orders.
• Amazon is not aware of the price for the fulfillment order so therefore the Revenue for that order will be reported as zero from Amazon
• We recommend our users use the Internal Price feature because If you do not record the revenue as part of the order, your overall profit will be understated
• This article details the process of uploading fulfillment order revenue in bulk.
  • If you want to learn how to do it for individual orders, please refer to this article: How to Add Internal Price for a Fulfillment order

Recommended Process For Fulfilment Orders Internal Price Bulk Upload

• Go to the menu and select Sales–> Orders
• First of all, you need to know about the download and upload Internal Price options
• Please follow the steps below to download the INTERNAL_PRICE:
  • STEP1:  Click on the Reports button

  

• • STEP 2: On the resulting panel, select the report type, from the downloads section, which here, in this case, is INTERNAL_PRICE
  • STEP 3: Choose the account for which you want to download and edit the Internal Price for
  • STEP 4: Click on the download button

• Please follow the steps below to upload the Internal Price Report:
  • STEP1:  Click on the Reports button

• • STEP 2: On the resulting panel, select the report type, from the uploads section, which here, in this case, is INTERNAL PRICE
  • STEP 3: Choose the account for which you want to upload the internal price for
  • STEP 4: Choose the file you want to upload
  • STEP 4: Click on the upload button

• Detailed instructions follow later, but here’s a short summary of the process we suggest you use to bulk-manage Internal Price:
  • Download Internal Price spreadsheet template using the Download Button provided (Refer to the screenshot above)
    • You can find the function at Sales->Orders->Reports->Downloads->Report type->Download
  • Open the exported file in Excel or other application which can read and update Excel files
  • Observe the sequence and structure of the exported file and read the rest of this article to gain a better understanding
  • Please note that the exported file will only contain fulfillment orders starting with S01 or S02
  • In Excel or alike, amend the Internal Price entries for any order you wish to update
  • Upload your modified Internal Price file onto SellerLegend using the Upload Button provided
    • You can find the function at Sales->Orders->Reports->Uploads->Report Type->Upload(Refer to the screenshot above)
  • Check for Upload error messages, if any
  • Correct the errors in the Excel file
  • Repeat the last 3 steps above (Upload, Check, Correct) until the Internal Price upload is accepted without any errors
  • Spot check the outcome by verifying on SellerLegend a sample of the Orders you modified with the bulk Internal Price management process

The Bulk Upload Excel File Format And Rules

• You now know we will be using an Excel file to manage Bulk Internal Price. Let’s get the file format and rules explained first.
• Every row of the Excel file must respect the following format

•  The Excel File Rules
  • Upon download, the file will contain one row per fulfillment order in SellerLegend for the marketplace selected
  • If this is the first time you downloaded the Internal Price file, the Internal Price for all your fulfillment orders column will be zero
  • You cannot assign Internal Price to orders which are not yet recorded in SellerLegend
  • If you delete an order row in the file, it will not delete the order, nor change the currently existing Internal Price for the order
  • The Excel file must have a header row with the column titles as per the above table (see column Excel File Header Title)
  • The Excel file must not have more than one tab, and no cell formulas are allowed
  • If you have used lookup formulae to assign shipping costs to orders, please make sure to copy/paste the values in-place before attempting the upload

Fulfillment Orders Internal Price Bulk Upload Process Details

• Go to the menu and select Sales–> Orders
• At the top right side of the Orders screen, you will see a Reports button related to bulk management of Internal Price (Refer to the screenshot above)
• Click on the Reports button
• In the resulting panel, select the Report Type and Account ID of your choice and click on the Download button
• You will see a green popup screen saying ‘A Request Has Been Submitted’
• On the Menu, click on Reports –> Exported Reports
• In the resulting list of reports, locate the report type INTERNAL_PRICE with the Request Made date corresponding to the time you requested the download which matches the file name which you have just uploaded
• When the Status column shows DONE, click on the blue Actions button and select Download
• This will produce an Excel file with all your fulfillment Orders and their current Internal Price if any already exist
  • Open the file in Excel
  • Amend the Internal Price for the downloaded fulfillment orders in the Excel file according to your needs
  • Save the updated file.
• On the Menu, go back to Sales->Orders
• Click on the Reports button
• In the resulting panel
  • Choose the Report type
  • Make sure to choose the correct Account ID to upload the file to
  • Select the Excel file you just saved
  • Click on the Upload button
• Once the upload is completed, on the Menu, go to Reports –> imported Reports
• Check the outcome of your upload:
  • If the Request Completed column shows DONE, the Excel file was imported without errors
  • If the Request Completed column shows DONE_WITH_WARNINGS the Excel file contained errors
    •  Click on the Download button and open the exported Excel file.
      • Erroneous shipping costs definitions will show in red. To find out why the data is erroneous, hover on each of the fields and the erroneous fields will show an Excel comment with the appropriate error message.
      • Correct the errors in the Excel file you are viewing
      • Once all errors have been corrected, save the Excel file
    • Repeat the Upload process with the Excel file you have just saved

Related Posts

• How to Add Internal Price for a Fulfillment order