|Resource name (required)||Name of a resource for which the reservation should be added. Note that this needs to match one of the resources in your site.|
|First name (required)||First name of the customer.|
|Last name (required)||Last name of the customer.|
|Email (required)||The customer's email address. Note that when a customer with this email address already exists, the existing customer will be attached to the reservation being imported. In such case, the customer will not be updated with the data imported from the CSV file. On the other hand, if a customer with this email address doesn't exist, it will be created with the details specified in other CSV rows.|
|Start time (required)||Beginning of the reservation. In case of full day reservations, enter the arrival (start) date without any time or set the time to 00:00:00. E.g. to reserve the entire day: 1st of July 2015,
enter 2015-07-01 or 2015-07-01 00:00:00 as the start time.
For hour-based reservation, specify the rental start date and time. E.g. 2015-07-01 12:30:00.
Note that only future reservations will be imported. Reservations with start time before the current time will be ignored.
|End time (required)||End of the reservation. In case of night reservations (e.g. accommodations), enter the departure date without any time.
E.g. to reserve a single night of the 1st of July 2015, enter 2015-07-02 (the departure date).
For full-day reservations, specify either the last date of the rental without time or the end date with the hour set to 23:59. E.g. to reserve the entire day: 1st of July 2015, enter 2015-07-01 or 2015-07-01 23:59:00 as the end time.
For hour-based reservations, specify the rental end date and time. E.g., to reserve a resource until 1st of July 2015 12:45, enter 2015-07-01 12:45:00 (we'll also accept times up to minute earlier, that is: 2015-07-01 12:44:59).
|Status (required)||Status of the reservations. You can use the following status identifiers that correspond to planyo statuses: 'reserved', 'verified', 'confirmed', 'checked in', 'checked out',
'cancelled by admin', 'cancelled by client'. If you want to combine a few statuses, they should be separated by a plus sign (+). e.g. 'reserved+confirmed'. You can also use the numeric
representation of statuses. For example, the status of '7' means that a reservation is completed, confirmed and that customer email is verified.
For details about numerical status values see this page in the Planyo API documentation.
|Quantity||Number of units to be reserved. The default is 1.|
|Color||Specify the color that will be assigned to the reservation. You can read more about this on this page. If you
don't want to assign any color, leave the field empty. When assigning a color, you can specify one of the following values:
#A8314F #FF3333 #4D4DFF #B84DFF #999999 #81FCF6 #FFBAF1 #DADAD2 #ECDC81 #CEF0FF #D1FFB3 #FFA4A4
|Unit name||If the resource has named units, you can specify the unit in this field. If reserving more than one unit, pass the units as comma-separated values, e.g. 'unit1,unit2'.|
|Sharing||Set the desired sharing mode ('1' or empty). Used only when sharing is possible for the resource.|
|Address||Customer's street address.|
|Zip||Customer's zip or postal code.|
|State||State or province.|
|Country||Two-letter country code (ISO 3166-1 alpha-2), e.g. US, DE, FR etc|
|Language||By specifying a 2-letter (ISO 639-1) language code (e.g. EN, DE, FR, ES, IT) you can change the language associated with the customer.|
|Phone country code||Phone country code (e.g. 1 for USA and Canada, 41 for Switzerland).||Phone||Phone number (excluding country code).|
|Mobile country code||Mobile country code (e.g. 1 for USA and Canada).|
|Mobile||Mobile number (excluding country code).|
|Created||Reservation creation time. When empty, the current time will be used.|
|Price||Total price for the reservation.|
|Payments||Payment made for this reservation. Note that payments are imported in the currency of the resource.|
|Notes||Notes for the reservation visible by the customer.|
|Admin notes||Admin notes for the reservation (not visible by the customer).|
|prop_xxx||One of the custom items in your reservation form. You'll need to replace spaces in the field name with underscore character, e.g.'prop_Wants_breakfast' for the form item 'Wants breakfast' (see Q204 in the faq for all possible values). Any non-alphanumeric characters also need to be replaced with underscores. The CSV file can contain multiple 'prop_xxx' fields.|