Importing Prices

In order to import your pricing 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).

Product Name*

Plain text value (required).

Price Label*

Plain text value (required). This is the name you want to give to your price. Typically, it will be something like high or low season.

Available From

This will be the month and date the price is applicable from (i.e. January 1). This allows the price to be appropriately shown to you when picking it for the itinerary.

Available To

This will be the month and date the price is applicable to (i.e. June 30). This allows the price to be appropriately shown to you when picking it for the itinerary.

Expires

This is the month, day, and year that the price expires (i.e. August 25, 2025).

Currency*

This should be the three-character ISO currency code (i.e. USD or GBP). A full list of codes can be found here.

Unit*

Pick from one of the approved units below:

  • PER_PERSON

  • PER_GROUP

  • PER_ADULT

  • PER_CHILD

  • PER_DAY

  • PER_NIGHT

  • PER_HOUR

Cost*

The currency value for the cost of this good or service. This should be formatted as either a whole number (i.e. 1000) or, if required, a floating point number (i.e. 149.99).

If you add values here, they will always be used when this price is added to an itinerary. If you leave them blank, the values in the product or supplier will be used instead.

Cost Adjustment

A floating point number. If Cost Adjustment Type is PERCENT the the number should be a percentage increase all costs should recieve. If the value is FIXED the number should be a fixed currency value all prices should 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 addin 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 good or services.

Excluded Fields

Please note that, at this time, we are not supporting the following fields/features as part of our CSV import:

  • Advanced Pricing

Was this helpful?