Bulk Inserting Vendor Contract Fees

Discovery's Bulk Insert option enables the rapid creation of multiple Vendor Contract Fees, provided all necessary vendor data is organized into an Insert template file*. All Insert template files are consolidated into a single downloadable file accessible on the Bulk Imports page within the Settings section.

Import Template Fields

The provided Insert template file (vendor_contract_fees.csv) needs to retain all fields (columns), in no particular order, even if the fields are not required.

The following fields are required to have data for each Vendor Contract Fee record:

• vendor_contract_id | Generated by Discovery upon Vendor Contract creation**.
  
• vendor_fee_name | Must be an approved vendor fee (case sensitive):
  • account-setup-fee
  • admin-fee
  • annual-price-increase
  • bulk-item-removal
  • city-tax
  • commercial-service-overage
  • compliance-and-business-impact-charge
  • container-service
  • contamination
  • delivery
  • dry-run-trip-charge
  • environment
  • extra-pickup
  • franchise-fee
  • fuel-energy-or-oil
  • fuel-environment
  • gate-access-fee
  • inactivity-charge
  • incineration
  • initial-delivery
  • landfill-surcharge
  • late-payment
  • liner-tarp
  • lock-installation
  • lock-recurring
  • minimum-tonnage
  • miscellaneous-or-data
  • mta-tax
  • push-out
  • recyclable-material-offset
  • regulatory-cost-recovery
  • relocate
  • removal
  • rental
  • repair
  • roll-off-or-compactor-service-overage
  • sales-tax
  • state-tax
  • swap
  • tax
• restriction | Must be an approved restriction (case sensitive): 
  • Uncapped
  • Not Allowed
  • $ per unit
  • $ per occurrence
  • % of service charges
• percentage | Required only if the restriction is "% of service charges." Represented as a decimal percentage.
• amount | Required only if the restriction is "$ per unit" or "$ per occurrence." Must be formatted as follows with an amount in dollars:  272.00.
• name | Name of Vendor Contract Fee as you would like it to appear in Discovery. Here you can provide a more descriptive name for this fee. Cannot appear exactly the same as the vendor_fee_name
  

Once all Vendor Contact Fees records have been added, upload the Insert template file using the New button on the Bulk Imports page under Settings. For more on how to do this, please visit the Bulk Imports Overview help document.

*Import file name and its column headers cannot be edited.

**When any ID field is required (_id), this indicates an ID that is generated and assigned by Discovery to a unique entity. You'll need to retrieve these ID's from Discovery. The general method to retrieve ID's in bulk is through a Custom Report. Please see the Export ID's with Custom Reports article covering how to generate a Custom Report to retrieve specific entity ID's.