Importing Suppliers

In order to import your supplier data, please provide us with a spreadsheet with the following columns. For each column, we've outlined the data requirements. Those with an asterisk are required.

You can download an example supplier CSV here.

Supplier Name*

Plain text value (required).

Type*

This must be one of the below values (required).

  • ACCOMMODATION

  • ACTIVITY

  • FOOD

  • TRAVEL

  • OTHER

The import will force all values to uppercase so the format is not essential.

Category

The category you should use depends on the type you've picked. Below is a list of the categories per type.

  • Accommodation

    • Hotel

    • Hostel

    • Rental

    • Camping

  • Activity

    • Theatre

    • Shopping

    • Event

    • Concert

    • Beach

    • Winter Sport

    • Sport

    • Tour

    • Religious Site

    • Museum

    • Art Gallery

    • Relax

    • Walk

  • Food

    • Restaurant

    • Cafe

    • Bar

    • Street Food

    • Catering

  • Travel

    • SUV

    • Cruise

    • Flight

    • Drive

    • Taxi

    • Boat

    • Bicycle

    • Walk

    • Train

    • Subway/Metro

    • Tram

    • Bus

    • Coach

    • Scooter

    • Motorcycle

This should be a public URL to the image file

Rating

Accepts a value from 1 to 5

Email

Must be a valid email address.

Telephone

Takes a string of text. Can use numbers and symbols.

Address

Please include a full address, including the country.

Website

Can include https:// or not, but must be a valid domain.

Proposal Description

A description of this supplier that only shows on the proposal. Please ensure that when supplying the CSV file with your data, the file is appropriately escaped.

Trip Description

A description of this supplier that is only shown to the client on an upcoming trip. This can be the same value as the proposal description if you like. Please ensure that when supplying the CSV file with your data, the file is appropriately escaped.

Internal Notes

Any notes about the supplier that are useful to have in TripMapper. Please ensure that when supplying the CSV file with your data, the file is appropriately escaped.

The field below is also replicated on the product and the price. If you add values here, they will act as the default for all products and prices. If you add values to the product or price directly, they will override the values set here.

Cost Adjustment

A floating point number. If Cost Adjustment Type is PERCENT The number should be a percentage increase that all costs should receive. If the value is FIXED, the number should be a fixed currency value that all prices will be increased by.

Cost Adjustment Type

Accepts PERCENT or FIXED as the value

Profit Type

Accepts MARGIN or MARKUP and defines the calculation that is used for calculating your profit on top of the costs you add in the product pricing section.

Profit Percent

A percentage value that represents your markup or margin value for your product pricing.

Commission Type

Accepts DISCOUNT or REBATE and defines the way commission values are treated. Discount values discount the amount shown in the UI and used in calculations. Rebate doesn't affect the pricing in the calculations, and instead logs that value as earned commission for you to claim from your commission partner at a later date.

Commission Percent

A percentage value that represents the commission you earn through this supplier.

Tax Type

Accepts NET or GROSS, and is the percentage rate of sales tax or VAT that is payable on the goods or services your supplier provides. If you plan to enter prices net of tax, please set the value here to NET. If you're adding gross costs, please set this ot GROSS.

Tax Percent

A percentage value used to define the rate of tax payable on your supplier's goods or services.

Was this helpful?