I run a real-estate site powered by the MyHome theme (https://themeforest.net/item/myhome-real-estate-wordpress-theme/19508653). Every week I receive fresh inventory in either Excel or CSV format, and I want that file to flow straight into WordPress without any manual data entry. Here is what the file already contains: title, country, state, city, property type (house, land, villa…), offer type (sale, rent), area size, prices in seven different currencies, rooms, bathrooms, plus the Media Library ID for the featured image. Your job is to create a small import tool—whether it ends up being a one-off script, a lightweight plugin, or a WP-CLI command doesn’t matter to me, as long as it is clean, re-usable and future-proof. Because MyHome stores listings as a custom post type and distributes taxonomy data across posts, post_meta, terms, termmeta, term_taxonomy and term_relationships, the solution must map each column precisely to those tables. Countries, cities and property types must be created on the fly when they don’t yet exist and linked correctly when they do. Images arrive as existing attachment IDs, so the script simply needs to associate them rather than upload again. Deliverables (all must be met for acceptance): • Import tool with clear, commented code and zero hard-coded paths • A mapping file or interface so I can adjust columns later • Duplicate-prevention logic (title + city + type) • Step-by-step setup instructions and a short Loom or screenshot guide demonstrating one successful bulk import on my staging site The budget is tight, (30 to 50 usd) so efficiency matters. I’m only interested in someone who has built comparable bulk-importers for WordPress before and understands database-level operations, WP All Import filters, or WP-CLI scripting inside out. If that’s you, let me know how you’d approach the mapping and roughly how long the first working version will take.