Seller Fees CSV Export & Import

Objective

As an admin user or Seller Manager, I want to have an overview of the fees that Sellers are paying.

As an admin user or Seller Manager, I want to massively apply fees to Sellers through CSV upload.

Critical Knowledge

If you want to enable Seller Fees Export and Import, please raise a TMLSD ticket. The parameter that needs to be enabled is fees/export_import/enabled.

For performance concerns, there is a configurable cap for the number of rows in CSV export. Default value is 100,000 rows.

 Seller Fees Export

  • The Seller Fees Export function allows an admin user to have an overview of fees applied to all the Sellers.
Step Description Image
1
  • Access the Seller Management section in the administration menu.
  • Click “Export” and select “Seller Fees”
SF-Export-Fees
2
  • Wait for the export to be available and then download it at the bottom of the page in the export manager.
 3
  • Open the downloaded Excel file.
  1. Seller ID / Seller Name:
    • The export contains all Sellers that are on Seller Center.
    • A Seller can have an empty row.
      • This means they do not pay any fee.
    • If a Seller pays several fees, there will be several rows for this Seller (one row per fee).
  2. “Fee Name”:
    • “Fee name” describes the fee applied to the Seller.
    • “%” at the end of the fee name means that the fee type (and, therefore, the amount) is expressed in a percentage.
  3. “Amount”:

    • As stated above, “Amount” does not reflect the type, only the value (which can be a percentage or fixed).
  4. “Status”:

    • Don’t miss this column. It could happen that a Seller has several fees associated with them but all of them disabled.
SF-guide-sellername
SF-guide-amount

Seller Fees Import

  • The Seller Fees Import function allows an admin user to massively apply fees to Sellers.
Critical Knowledge

  • For a more user-friendly import, we have added validation and dropdown menus for the fees. These currently only work if you open the file with OpenOffice.

Step Description Image
1
  • To add the first fee to a Seller:
    • Simply click on the dropdown menu and select the fee name you want, fill the “Amount” and “Status”
    • Please note that “Fee Name,” “Amount,” and “Status” are mandatory.
  • To add or modify fees to a Seller that already pays other fees:
    • Duplicate rows if necessary.
    • Fill out all the mandatory fields.
SF-adding-fee
2
  • Save the file as a CSV (not .xlsx).

 

 
 3
  • In Seller Center > Administration > Seller Management, click “Import” and access the Import screen.
  • Select “Seller Fees” as the “Import Mode”
SF-import-mode
4
  • Upload the file and confirm.