{"id":16,"date":"2026-09-16T10:28:30","date_gmt":"2026-09-16T10:28:30","guid":{"rendered":"https:\/\/docs.latw.ai\/uncategorized\/data-model\/"},"modified":"2026-09-16T10:28:30","modified_gmt":"2026-09-16T10:28:30","slug":"data-model","status":"publish","type":"post","link":"https:\/\/docs.latw.ai\/pl\/esti-to-wordpress\/data-model\/","title":{"rendered":"Data Model"},"content":{"rendered":"

Data model reference<\/h1>\n

The plugin creates no database tables and no taxonomies<\/strong>. Everything lives in wp_posts<\/code>, wp_postmeta<\/code> and a handful
\nof options.<\/p>\n

Post type<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n
<\/th>\n<\/th>\n<\/tr>\n<\/thead>\n
Name<\/td>\nosfec_offer<\/code><\/td>\n<\/tr>\n
Public<\/td>\nyes, has_archive<\/code> = the archive slug<\/td>\n<\/tr>\n
Rewrite<\/td>\n\/{archive_slug}\/{post_name}\/<\/code>, with_front<\/code> = false<\/td>\n<\/tr>\n
show_in_rest<\/code><\/td>\ntrue<\/code> \u2014 so the CPT works in the Query Loop block and in page-builder loops<\/td>\n<\/tr>\n
supports<\/code><\/td>\ntitle<\/code> only<\/td>\n<\/tr>\n
Capabilities<\/td>\ncreate_posts<\/code> is do_not_allow<\/code>; map_meta_cap<\/code> is on<\/td>\n<\/tr>\n
Menu icon<\/td>\ndashicons-building<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

post_content<\/code> holds the imported description (descriptionWebsite<\/code>, falling back to description<\/code>), run through
\nwp_kses_post()<\/code>. post_title<\/code> comes from portalWwwTitle<\/code> \/ portalTitle<\/code>, falling back to “type, city”.<\/p>\n

The slug is built once, at creation, from the title plus the public offer number, and is never rewritten on update<\/strong> \u2014
\na price change must not move the URL.<\/p>\n

Meta<\/h2>\n

Every key carries the _osfec_<\/code> prefix. Empty values are not stored<\/strong>: a field missing from the payload has no meta
\nrow, so get_post_meta()<\/code> returns ''<\/code>. Zero is kept \u2014 the ground floor is a real value.<\/p>\n

None of these are registered with register_post_meta()<\/code>, and none are exposed through the REST API.<\/p>\n

Identity<\/h3>\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_id<\/code><\/td>\nint<\/td>\nEsti offer ID. The upsert key<\/td>\n<\/tr>\n
_osfec_number<\/code><\/td>\nstring<\/td>\nPublic offer number (numberExport<\/code>, falling back to number<\/code>)<\/td>\n<\/tr>\n
_osfec_hash<\/code><\/td>\nstring<\/td>\nMD5 of the mapper version plus the payload. Drives change detection<\/td>\n<\/tr>\n
_osfec_synced_at<\/code><\/td>\nint<\/td>\nUnix timestamp of the last write<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Classification<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_type<\/code><\/td>\nslug<\/td>\nType name without the bracketed variant, slugified: mieszkanie<\/code><\/td>\n<\/tr>\n
_osfec_type_label<\/code><\/td>\nstring<\/td>\nRaw Esti type name: Dzia\u0142ka (Rolna)<\/code><\/td>\n<\/tr>\n
_osfec_subtype<\/code><\/td>\nslug<\/td>\nSlugified bracketed variant: rolna<\/code><\/td>\n<\/tr>\n
_osfec_subtype_label<\/code><\/td>\nstring<\/td>\nThe variant itself: Rolna<\/code><\/td>\n<\/tr>\n
_osfec_transaction<\/code><\/td>\nslug<\/td>\nsale<\/code>, rent<\/code>, purchase<\/code>, lease<\/code><\/td>\n<\/tr>\n
_osfec_market<\/code><\/td>\nslug<\/td>\nprimary<\/code>, secondary<\/code><\/td>\n<\/tr>\n
_osfec_tags<\/code><\/td>\nCSV<\/td>\nMarketing labels from Esti<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Price and size<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_price<\/code><\/td>\nfloat<\/td>\nEmpty when the price is hidden in Esti or is not positive<\/strong><\/td>\n<\/tr>\n
_osfec_currency<\/code><\/td>\nstring<\/td>\nPLN<\/code>, EUR<\/code>, USD<\/code><\/td>\n<\/tr>\n
_osfec_price_m<\/code><\/td>\nfloat<\/td>\nPrice per m\u00b2 (pricePermeter<\/code>)<\/td>\n<\/tr>\n
_osfec_price_prev<\/code><\/td>\nfloat<\/td>\nPrevious price, stored only when it was higher than the current one<\/td>\n<\/tr>\n
_osfec_area<\/code><\/td>\nfloat<\/td>\nTotal area<\/td>\n<\/tr>\n
_osfec_area_usable<\/code><\/td>\nfloat<\/td>\nUsable area<\/td>\n<\/tr>\n
_osfec_rooms<\/code><\/td>\nint<\/td>\n<\/td>\n<\/tr>\n
_osfec_floor<\/code><\/td>\nint<\/td>\nFloor the unit is on<\/td>\n<\/tr>\n
_osfec_floors<\/code><\/td>\nint<\/td>\nFloors in the building<\/td>\n<\/tr>\n
_osfec_year<\/code><\/td>\nint<\/td>\nYear built<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Location<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_city<\/code><\/td>\nstring<\/td>\nlocationExportCityName<\/code>, falling back to locationCityName<\/code><\/td>\n<\/tr>\n
_osfec_commune<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_county<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_province<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_street<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_postal<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_lat<\/code>, _osfec_lng<\/code><\/td>\nstring<\/td>\nCoordinates as strings<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Location values are stored raw<\/strong>. Esti mixes upper case, lower case and trailing spaces; formatting is the template’s
\njob.<\/p>\n

Media<\/h3>\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_photos<\/code><\/td>\nJSON<\/td>\nArray of full-size URLs on the Esti CDN (_max<\/code> variant)<\/td>\n<\/tr>\n
_osfec_thumb<\/code><\/td>\nstring<\/td>\nThe first photo as its _min<\/code> variant<\/td>\n<\/tr>\n
_osfec_video<\/code><\/td>\nstring<\/td>\nExternal link<\/td>\n<\/tr>\n
_osfec_tour<\/code><\/td>\nstring<\/td>\nExternal link to a virtual tour<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Read photos with osfec_photos()<\/code> rather than decoding the JSON yourself.<\/p>\n

Dictionary-backed attributes<\/h3>\n

These hold numeric IDs<\/strong>, not labels. Resolve them with osfec_attribute_label()<\/code>; an ID the dictionary cannot name
\nyields an empty string, and the caller is expected to drop the row rather than print a number at a buyer.<\/p>\n\n\n\n\n\n\n\n\n\n\n
Key<\/th>\nEsti payload key<\/th>\n<\/tr>\n<\/thead>\n
_osfec_ground_type<\/code><\/td>\ngroundType<\/code><\/td>\n<\/tr>\n
_osfec_ground_fencing<\/code><\/td>\ngroundFencing<\/code><\/td>\n<\/tr>\n
_osfec_ground_shape<\/code><\/td>\ngroundShape<\/code><\/td>\n<\/tr>\n
_osfec_ground_ownership<\/code><\/td>\ngroundOwnership<\/code><\/td>\n<\/tr>\n
_osfec_building_type<\/code><\/td>\nbuildingType<\/code><\/td>\n<\/tr>\n
_osfec_building_heating<\/code><\/td>\nbuildingHeating<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Agent<\/h3>\n\n\n\n\n\n\n\n\n
Key<\/th>\nType<\/th>\nNotes<\/th>\n<\/tr>\n<\/thead>\n
_osfec_agent_id<\/code><\/td>\nint<\/td>\nEsti agent ID (contactId<\/code>)<\/td>\n<\/tr>\n
_osfec_agent_name<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_agent_email<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n
_osfec_agent_phone<\/code><\/td>\nstring<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The agent is meta, not a taxonomy<\/strong>, so filtering by agent runs through meta_query<\/code>. The photo, role and office are
\nnot per-offer meta: they come from the agent directory option, matched on _osfec_agent_id<\/code>. osfec_agent()<\/code> merges both
\nsources.<\/p>\n

Options<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Option<\/th>\nAutoloaded<\/th>\nContents<\/th>\n<\/tr>\n<\/thead>\n
osfec_settings<\/code><\/td>\nyes<\/td>\nEvery setting, one array. Read it through OSFEC_Settings::get()<\/code> \/ ::value()<\/code><\/td>\n<\/tr>\n
osfec_agents<\/code><\/td>\nno<\/td>\nAgent directory keyed by Esti agent ID: name<\/code>, photo<\/code>, position<\/code>, office<\/code>, email<\/code>, phone<\/code><\/td>\n<\/tr>\n
osfec_dictionary<\/code><\/td>\nno<\/td>\nFlattened Esti dictionary, id => label<\/code><\/td>\n<\/tr>\n
osfec_runs<\/code><\/td>\nno<\/td>\nThe last 20 sync runs, newest first, up to 200 events each<\/td>\n<\/tr>\n
osfec_last_sync<\/code><\/td>\nno<\/td>\nUnix timestamp of the last successful cleanup<\/td>\n<\/tr>\n
osfec_license_key<\/code><\/td>\nno<\/td>\nThe activated license key<\/td>\n<\/tr>\n
osfec_license_status<\/code><\/td>\nno<\/td>\nLast verdict from the license server: active<\/code>, invalid<\/code> or version_mismatch<\/code><\/td>\n<\/tr>\n
osfec_license_expires<\/code><\/td>\nno<\/td>\nDate the subscription is paid to, empty for a lifetime license<\/td>\n<\/tr>\n
osfec_license_type<\/code><\/td>\nno<\/td>\nLicense type as the server names it<\/td>\n<\/tr>\n
osfec_license_allowed_version<\/code><\/td>\nno<\/td>\nNewest plugin version the license covers<\/td>\n<\/tr>\n
osfec_license_activated_at<\/code><\/td>\nno<\/td>\nUTC datetime of the first successful activation<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Transients<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
Transient<\/th>\nTTL<\/th>\nPurpose<\/th>\n<\/tr>\n<\/thead>\n
osfec_sync_ids<\/code><\/td>\n1 h<\/td>\nEsti ID \u2192 post ID map for the current run<\/td>\n<\/tr>\n
osfec_sync_seen<\/code><\/td>\n1 h<\/td>\nEsti IDs seen so far in the current run; cleanup depends on it<\/td>\n<\/tr>\n
osfec_sync_error<\/code><\/td>\n24 h<\/td>\nLast failure message, shown on the settings screen<\/td>\n<\/tr>\n
osfec_map_<key><\/code><\/td>\n6 h<\/td>\nSlug \u2192 raw value map for a meta key, e.g. osfec_map_city<\/code><\/td>\n<\/tr>\n
osfec_map_type_options<\/code><\/td>\n6 h<\/td>\nType slug \u2192 label<\/td>\n<\/tr>\n
osfec_map_subtypes<\/code><\/td>\n6 h<\/td>\nSubtype slug \u2192 label<\/td>\n<\/tr>\n
osfec_update_latest<\/code><\/td>\n12 h (1 h after a failure)<\/td>\nplugin\/latest<\/code> payload from the license server. A site<\/strong> transient<\/td>\n<\/tr>\n
osfec_update_info<\/code><\/td>\n12 h (1 h after a failure)<\/td>\nplugin\/info<\/code> payload, feeding the “View details” screen. A site<\/strong> transient<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The slug maps are flushed at the end of every successful run, so a new city shows up in the filter dropdowns as soon as
\nthe run that imported it finishes.<\/p>\n

Scheduled events<\/h2>\n\n\n\n\n\n\n\n
Hook<\/th>\nSchedule<\/th>\nArgument<\/th>\n<\/tr>\n<\/thead>\n
osfec_sync_start<\/code><\/td>\nosfec_6h<\/code> (every 6 hours)<\/td>\n\u2014<\/td>\n<\/tr>\n
osfec_sync_page<\/code><\/td>\nsingle event, 30 s after the previous page<\/td>\nzero-based page number<\/td>\n<\/tr>\n
osfec_license_check<\/code><\/td>\ndaily<\/code><\/td>\n\u2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

OSFEC_API::PER_PAGE<\/code> is 100.<\/p>\n

Change detection<\/h2>\n

_osfec_hash<\/code> is md5( OSFEC_MAPPER_VERSION . wp_json_encode( $offer ) )<\/code>. When the stored hash matches, the offer is
\ncounted as unchanged and nothing is written.<\/p>\n

OSFEC_MAPPER_VERSION<\/code> is a constant in the main plugin file. Bump it whenever the mapping changes<\/strong>: every hash then
\ndiffers and the whole catalogue is re-imported on the next run.<\/p>\n

Constants<\/h2>\n\n\n\n\n\n\n\n\n\n\n
Constant<\/th>\nValue<\/th>\n<\/tr>\n<\/thead>\n
OSFEC_VERSION<\/code><\/td>\nPlugin version, also the asset cache buster<\/td>\n<\/tr>\n
OSFEC_FILE<\/code><\/td>\nMain plugin file<\/td>\n<\/tr>\n
OSFEC_PATH<\/code><\/td>\nPlugin directory, trailing slash<\/td>\n<\/tr>\n
OSFEC_URL<\/code><\/td>\nPlugin URL, trailing slash<\/td>\n<\/tr>\n
OSFEC_MAPPER_VERSION<\/code><\/td>\nMapping revision, part of the hash<\/td>\n<\/tr>\n
OSFEC_BASENAME<\/code><\/td>\nplugin_basename()<\/code> of the main file, the key core uses in the update transient<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Class map<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Class<\/th>\nResponsibility<\/th>\n<\/tr>\n<\/thead>\n
OSFEC_CPT<\/code><\/td>\nPost type and rewrite rules<\/td>\n<\/tr>\n
OSFEC_API<\/code><\/td>\nEsti HTTP client: fetch_page()<\/code>, fetch_agents()<\/code>, fetch_dictionary()<\/code><\/td>\n<\/tr>\n
OSFEC_Mapper<\/code><\/td>\nPayload \u2192 post fields and meta. No side effects<\/td>\n<\/tr>\n
OSFEC_Sync<\/code><\/td>\nRun loop, cron, upsert, cleanup<\/td>\n<\/tr>\n
OSFEC_Log<\/code><\/td>\nRun records and the log screen<\/td>\n<\/tr>\n
OSFEC_License<\/code><\/td>\nKey verification, the License tab, the gate in front of every run<\/td>\n<\/tr>\n
OSFEC_Updater<\/code><\/td>\nUpdates from the license server: the update transient and plugins_api<\/code><\/td>\n<\/tr>\n
OSFEC_Settings<\/code><\/td>\nSettings screen, sanitization, manual sync<\/td>\n<\/tr>\n
OSFEC_Query<\/code><\/td>\nGET parameters \u2192 WP_Query<\/code> arguments<\/td>\n<\/tr>\n
OSFEC_Frontend<\/code><\/td>\ntemplate_include<\/code>, thumbnails, assets, shortcode, block<\/td>\n<\/tr>\n
OSFEC_Schema<\/code><\/td>\nJSON-LD in wp_head<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Every class exposes a static init()<\/code> that registers its own hooks; the main file calls them in order on
\nplugins_loaded<\/code>.<\/p>\n

No hooks of its own<\/h2>\n

The plugin fires no custom actions and applies no custom filters. Extension points are: the template overrides, the
\nosfec_*<\/code> helper functions, the shortcode and block attributes, the CSS, and WordPress’s own hooks (pre_get_posts<\/code>,
\ntemplate_include<\/code>, the_content<\/code>, \u2026). See Building a custom UI<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Data model reference The plugin creates no database tables and no taxonomies. Everything lives in wp_posts, wp_postmeta and a handful of options. Post type Name osfec_offer\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_latwm_translated_slug":"","footnotes":""},"categories":[2],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-esti-to-wordpress"],"_links":{"self":[{"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":1,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"predecessor-version":[{"id":51,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/posts\/16\/revisions\/51"}],"wp:attachment":[{"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.latw.ai\/pl\/wp-json\/wp\/v2\/tags?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}