Wayvilo property CSV import and bulk updates

Keep external_id stable across re-imports. Nonblank cells update matching properties within your selected company; blank cells preserve saved values. Explicit No and 0 replace amenity/fee values. Photos, extra fees, taxes and manual channel prices stay on Wayvilo. Removing a CSV row does not delete a property. Published property updates publish directly; complete new verified-company listings bypass review. Incomplete new listings remain private drafts. Paused/archived listings remain hidden.

external_id: Optional ID from your own database. Keep it stable when importing again.
property_name: Required for import. All other values can be completed later.
destination: Region or destination, such as Deep Creek Lake.
location: Town, region and country. Do not include a private street address.
maximum_guests: Whole number from 1 to 50, or blank if unknown.
bedrooms: Whole number from 0 (studio) to 30, or blank if unknown.
bathrooms: Bathroom count or description, such as 3 full, 1 half.
home_size: Include the unit, such as 2,400 sq ft.
description: Plain-text description; 30 characters required before submission.
sleeping_layout: Beds and attached bathrooms by room. Quoted cells can contain line breaks.
policies_and_fees: Cancellation, pets, seasonal amenities, accessibility and optional charges.
direct_booking_url: HTTPS link to this property in your preferred booking engine.
property_page_url: Optional HTTPS link to the property information on your website.
airbnb_url: Exact HTTPS property listing, or blank.
vrbo_url: Exact HTTPS property listing, or blank.
booking_com_url: Exact HTTPS property listing, or blank.
base_nightly_rate: Optional base direct rate per night in USD, from $0.01 to $25,000. Enter the actual nightly rate; do not convert a stay total. Numbers only, such as 185 or 185.50; leave unknown rates blank.
base_nightly_rate_weekday: Optional base USD rate for Sunday–Thursday nights. Enter the rate itself; separately itemized fees are excluded.
base_nightly_rate_weekend: Optional base USD rate for Friday/Saturday nights. Date-free estimates use a 5 weekday / 2 weekend weekly average. A missing day-type rate uses base_nightly_rate.
cleaning_fee: Optional required direct-booking cleaning fee in USD, once per stay, from 0 to 5000. Enter 0 for no cleaning charge. Markup-based channel estimates reuse direct fees unless separate channel rules are saved in the editor. Additional required fees and channel-specific fees stay in the editor.
pet_fee: Optional direct-booking pet fee in USD, once per stay, from 0 to 5000. Shown as an optional extra; ordinary stay totals exclude it. Other pet-fee bases can be entered manually.
airbnb_markup_percent: Optional percentage added to the base rate, from 0 to 500. Enter 18 for 18%, not 0.18 or 18%. Blank means unknown; 0 means the same as direct.
vrbo_markup_percent: Optional percentage added to the base rate, from 0 to 500. Enter 8 for 8%. Leave unknown percentages blank.
booking_com_markup_percent: Optional percentage added to the base rate, from 0 to 500. Enter 25 for 25%. Leave unknown percentages blank.

amenity_*: Yes, No, or a factual detail. Unknown new amenities become No; blank update cells preserve saved values. amenity_minage: whole-number minimum age or blank.

AI prompt:
Fill the attached Wayvilo property import CSV using only the property database or source material I provide. Keep the existing column headers exactly as written, with one property per row. Do not invent property facts, descriptions, amenities, listing URLs, rates, fees or markup percentages. Leave undocumented cells blank. Use a stable external_id from my property database and preserve it across updates, even if the property name changes. Re-importing a matching external_id updates that company’s existing property; without an ID, the exact property name and location are used. Blank cells preserve existing values on updates. For new properties, undocumented amenities become No. For amenities use Yes, No, or a short factual detail; amenity_minage is a whole-number minimum booking age or blank. Use exact HTTPS property listing URLs, never channel search URLs. Put the actual base direct USD nightly rate in base_nightly_rate, excluding separately itemized fees. If known, enter Sunday–Thursday base nightly rates in base_nightly_rate_weekday and Friday/Saturday rates in base_nightly_rate_weekend. Do not convert a stay checkout total into a base nightly rate. Enter the required direct cleaning charge once per stay in cleaning_fee, and the optional direct pet charge once per stay in pet_fee. Enter 0 when the source confirms no charge; leave unknown fees blank. Do not add pet fees into the base rate or cleaning fee. Use plain numbers without currency symbols. OTA markup columns use percentage points: 18 for 18%, not 0.18 or 18%. Do not infer markups from commission fees. Markup-based channel estimates reuse direct fee rules by default; existing channel-specific fee rules are preserved. Review different channel cleaning, service or tax charges in the fee editor. Photos, tax rates, other fees and manual OTA price overrides are entered on Wayvilo and retained on updates. Do not add owner, verification, approval, photo, tax or publication columns. Use UTF-8 comma-separated CSV; quote cells containing commas, quotes or line breaks, and double embedded quotes. Return a downloadable .csv file without Markdown or commentary inside it.