Operation Module
Contract Export
Contract prices export is available for both office and b2b. Agencies may use contract export module with precise options settled for the automatically, cause of the restrictions by their market.
To export contract prices after you entered your system, please go to Operations / Facilities. Query the facilities, we suggest use Valid Contract option Yes, and choose target market on filter, so you may only have the related accommodation facilities on the screen. Choose the hotels using SHIFT or CTRL + mouse click. From the “Other actions” button on the bottom menu, choose “Export prices (excel)”.

Export prices option window will open. For b2b users Target market and Agent options will be set automatically.
Choose options as you required, you may include the discount rates and extras related to accommodation.
Click “Search” for starting export.

If hotels found with price and excel is not empty then you get a confirmation message.
Click OK to continue.

Depends on how many hotels you are exporting, when system finish preparing your list.
Your browser will download automatically or ask for confirmation to download prices.

Click here to download Sample-excelexport file to examine.
Excel file is importable to any Onesystem.

Contract import
Enter prices from Excel as shown below:
- Select OPERATION from the main menu tab.
- Select FACILITIES from the operation submenu.
- Other Actions
- Contract import – Paste the previously copied excel sheet.
Excel sheets have to include exact formatted data required by Onesystem. Please request the final version. The formatted excel sheet sample looks as below.

– Each room / meal combination is a price block.
Every block starts with a header line. (Green area)
- Column A : Hotel Location – Hotelname – Hotel Category & Type – Currency
- Column B : Defines if it is a check-in based period. Possible values : ch,c/in or 1. If it is not defined system accepts this period is accommodation based.
- Column C : Defines who can sell this period. – Empty : All; b2b : Only for agencies; b2c : Only on direct clients; no : closed for both
- Column D : Min/Max duration. Defines the filter for minimum and maximum duration of stay. Default is 0*365 days. If you want to define : Example: Only one number as 7. Then min/max dfs is 7 nights; Two numbers separated by dashas 7-14 defines min dfs is 7 and max dfs is 14 nights.
- Column E : Defines how many days before this period will be released (deactivated). Enter a numeric value, or leave empty.
- Column I : Markup type. Possible values
-
- % or 0 for markup by percentage.
- N or 1 for or cash markup.
- Column F : Defines if period is a special offer. SPO periods has priority on price calculation. If given days intersects with an SPO period, system will use SPO prices and ignore other regular periods. Possible values 1.
- Column G : Defines from which date this period is active. If you have this specific date then define date in d/m/Y format, otherwise leave it blank.
- Column H : Defines until which date this period is active. If you have this specific date then define date in d/m/Y format, otherwise leave it blank.
Between all column Markup Type/Value are very specific depends on your import style. You may override the values on excel from import wizard. If you are importing as prices are sales prices and using markups; system will create the contrary price by using defined markup. For example if you have defined markup %20 and hotel price is 200 EUR and importing as sales prices than. SALES PRICE IS : 200 EUR COST PRICE ID : 200 EUR X – %20 = 160 EUR
For example if you have defined markup %20 and hotel price is 200 EUR and importing as sales prices than. SALES PRICE IS : 200 EUR COST PRICE ID : 200 EUR X – %20 = 160 EUR
- Column J : Markup value. Numeric value. Leave empty for 0.
- Column K : Defines if period is No-SPO. NoSpo periods ignore all special discounts and kick-backs.
START IMPORT
- Log in to OneSystem.
- Go to OPERATION / FACILITIES tab from main menu.
- On the bottom menu click on other options and choose Contract Import.

This will open a window with an empty textbox. Copy price data from excel and paste into textbox. And click on next.

On the definition window system reads the defined headers and check the system equivalents. If equivalent can not be found then box will come empty, if you continue those prices will be ignored. Choose proper records for once using drop-down boxes. If it is a new room/meal type you may use […] buttons to define new ones in system. Click on next to continue import.

On final screen you have final options to select how you want to import these prices. Also you may prefer to ignore hotels by un-marking them from the box left.

MARKET: Defines which market space these prices belongs to.
THESE PRICES ARE : This option defines the character of the prices in excel sheet. There are possible 4 options.
- Cost prices : Prices in excel sheet are the cost prices. If you define markup parameters sales prices will be calculated as cost price + markup, otherwise cost and sales prices will be same.
- Sales prices : Prices in excel sheet are the sales prices. If you define markup parameters cost prices will be calculated as sales price – markup value, otherwise sales and cost prices will be same.
Below 2 options are not recommended. There work only with exact combination matches, which can cause ignoring some updates. If you want to enter cost / sales prices to defines prices In excel as 300 / 400 will be parsed more safely.
- Cost only : This option can be used only with import style “update only”. It will update only the cost prices where system find exact period, prices, room type etc. matches.
- Sales only : This option can be used only with import style “update only”. It will update only the sales prices where system find exact period, prices, room type etc. matches.
IMPORT STYLE :
Import styles define rules how to keep/delete/update existing records and new records.

- Update/Create : System will create if period or price does not exists, otherwise updates the existing ones.
- Clear all : Delete whole contract records and insert excel content.
- Clear only room dependent : Don’t clear the periods (Update/Create mode), but clear the room prices before insert excel content where records match.
- Clear only period exists : Insert period which does not have match in system, clear the all room prices under period if matching period exists in system.
- Updated only : Update only the periods and prices already existing in the system with an exact parameter match.
OWNER : Leave empty for general, choose an agency from dropdown if these prices are specific to some agency. (deprecated)
FORCE MARKUP : Choose markup and enter a value if you want to override prices in excel.
Click on Next to continue importing the prices on waiting list.
Leisure tour packages
Mass tour packages
The main product of the tour operator is a package arrangement, which includes several synchronized services for the mass market. One system will allow you to do it in a quick and simple way, shown through the following subheadings.
Extra services
Flights & other transports
Transportation as an integral part of the package arrangement is a part without which the tourist product would not function properly. The system provides excellent tracking options for all flights, carriers and passengers.
- Open the OneSystem window on your browser.
- Select OPERATION from the main menu tab.
- Select TRANSPORT from the operation submenu
- NEW

You fill in all the fields as in the picture above, an explanation follows:
| DEPARTURE | Departure date and time of the transport |
| ARRIVAL | Arrival date and time of the transport |
| CODE | Unique ID defines this transport (optional) |
| TYPE | Type of transport which is definable. OneSystem transport is not limited to flights. You may define Bus, train etc. |
| CARRIER | Carrier company which organizes transport, in most cases the airline company. |
| REGISTRATION | Registration code represent Carrier code + Transport id. Most cases flight registration code. |
| PRODUCT CODE | Accounting product definition for transport only sales. |
| OPERATION | Filter definition to be used to define which operation transport belongs to. |
| GROUP | Filter definition to group the flights. (Especially important on package implementation to restrict transports) |
| FROM | Departure airport/point |
| TO | Arrival airport/point |
| CONNECTION | Defines connection airport if not defined as leg separately. |
| RISKLIMIT (SEATS) | Physical limit of the maximum seats available. |
| MIN/MAX RETURN | Restricts the return date on a roundtrip request. Default for both value is “0” |
| B2B | Transport is available for B2B sales. |
| B2C | Transport is available for B2C sales. |
| STATUS | Primary status for the flight. |
| HAND LUGGAGE | Defined allowed weight in kg. on seat for the passengers. |
| OPERATION NOTES | Notes for the employees who are authenticated to work on transports. |
| CLIENT NOTICES | Notices for the buyers. |
| COST | Cost is an arbitrary monetary value. Transport cost does not change, however cost per seat can be known only at the end of sales. Enter this number and finalize flight cost to see seat cost per passenger. |
| STATISTICS | Shows the currently status of availability and sales for the transport. |
When you have defined transport, departures, dates, you can search for them in the following way, on which you can see the exact number of passengers and available seats, percentage occupancy etc:
- OPERATION
- TRANSPORT
- QUERY

| DEPARTURE | Search by flight date |
| RESERVATION | Search by reservation |
| CARRIER | Airline or other carrier |
| FROM | Departure airport/point |
| TO | Arrival airport/point |
| SHOW RELATED | If you select “yes”, present all flights related to FROM. |
| REGISTRATION | Registration number of the transport |
| TRANSPORT TYPE | Flight, bus, train etc. Definable. |
| OPERATION | Operation type of the plain |
| TRANSPORT GROUP | Transport group of the plain. (Maybe used as filter if package making) |
| CODE | Unique ID for flight |
| MARKET | Specifies market of the flight if defined. |
| SHOW RT TO | Check positive number if you want to see return probabilities of filtered flights. (Reports in second tab in same screen) |
| DW | Day of the week (Monday is 1 / Sunday is 7) |
| ACCOUNT | Flight owner if defined. |
| PAXCOUNT | A fast search option for availability |
| SALES STATUS | Filter for sales status |
| STATUS | Primary status of the transport |
Hotels & other accommodation facilities
Accommodation facilities are the foundation of a touristic agency. As all windows in OneSystem facility management has also master-detail structure. To manage/create facilities
- Open the OneSystem window on your browser.
- Select OPERATION from the main menu tab.
- Select FACILITIES from the operation submenu.




































