Once the Listdom Excel add-on is installed and activated, a new Excel tab appears in Listdom → Import / Export with three main options:
- Import
- Mapping Templates
- Export
Import
In the Import section, you can upload your Excel file, map its fields to Listdom’s default fields, and initiate the import process by clicking on the Import button. The steps include:
1. Mapping Table: A table to map the Listdom default fields with the uploaded Excel file. The columns of this table are:
- Listdom Field: Align Listdom fields (e.g., title, price, tags) with your Excel columns. Required fields are marked with a red star.
- Type: The type of field e,g, text, number, URL, email, etc.
- Mapping: The columns of the uploaded Excel file which must be assigned to Listdom fields one by one. Try to map the fields as much as you can and only map the correct fields to avoid corrupted data after import. Only the mapped column of the file will be imported.
- Default Value: You can insert a default value for some fields if your Excel file does not contain a value. For example, select USD for currency if it’s not included in your Excel file.
| Listdom Field | Definition | |
|---|---|---|
| 1 | Unique ID | It’s required if you want to update the listings later. If you don’t map it then listdom tries to update the existing listing with same title and content! |
| 2 | Listing Title * | It is required |
| 3 | Listing Content | The description of the listing. |
| 4 | Listing Date | Date of listing creation. |
| 56 | Listing Owner | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. |
| 7 | Listing Status | The Status field stores different status of the listings including: Published, Draft, Trash, Pending, Expired, On Hold and Offline. Default value is Published. |
| 8 | Price | The price field of the listing |
| 9 | Price Max | The price max field of the listing |
| 10 | Price After | the price description of the listing |
| 11 | Currency | The currency of the listing price |
| 12 | Listing Address | The address of the listing |
| 13 | Listing Latitude | The latitude of the listing address |
| 14 | Listing Longitude | The longitude of the listing address |
| 15 | Listing Link | Listing custom link |
| 16 | Listing Email | Listing email |
| 17 | Listing Phone | Listing phone |
| 18 | Listing Website | Listing website |
| 19 | Listing Contact Address | Listing contact address |
| 20 | Listing Remark | The owner message of the listing |
| 21 | Featured Image | A URL field should get mapped. It should contain the featured image URL. |
| 22 | Listing Gallery | A URL field should get mapped. It should contain URLs to images separated by comma |
| 23 | Listing Category | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. Separate the items with comma. |
| 24 | Listing Locations | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. Separate the items with comma. |
| 25 | Listing Tags | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. Separate the items with comma. |
| 26 | Listing Features | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. Separate the items with comma. |
| 27 | Listing Labels | if a new value is available in the Excel file that doesn’t exist on the website, the Excel add-on will create a new entity based on that value term and assign that to the listing. Separate the items with comma. |
| 28 | Facebook account URL of the listing. | |
| 29 | Twitter account URL of the listing. | |
| 30 | Instagram account URL of the listing. | |
| 31 | WhatsApp number URL of the listing. | |
| 32 | Youtube | Youtube account URL of the listing. |
| 33 | Tiktok | Tiktok account URL of the listing. |
| 34 | Telegram | Telegram account URL of the listing. |
| 35 | Visible Until | The final date of the visibility of the listing. |
👉 The Visibility field is only available in the Listdom Visibility Add-on.
2 Mapping Name: Save your field mappings as a template by naming it during the import process.
3. Load Template: If you’ve already saved some mapping templates before, then you can apply saved templates from the dropdown for quicker imports.
Note: You need to assign each column from the imported file to an existing field in the mapping table. Custom fields cannot be created directly within the file and then imported into the site. Instead, you must first create the fields on the site; this allows them to be included in the mapping table. Once the fields are set up, you can map and import the relevant columns into the site. Below, you can find out how to import custom fields to the Listdom.
How to Add and Import Custom Fields
It is possible to add custom fields to the Excel file and import them into Listdom. To do this, you first need to create the custom fields in Listdom and then add the corresponding columns to your Excel file. This will allow you to map the columns in the uploaded file to the custom fields you created in Listdom. There are two available methods to add custom fields in Listdom:
1. Attributes: This feature is part of the Listdom Pro addon. To learn how to create custom fields using Attributes, click here.
The available attribute types to import are:
| Attribute Type | |
|---|---|
| 1 | Text Input |
| 2 | Number Input |
| 3 | Email Input |
| 4 | URL Input |
| 5 | Dropdown |
| 6 | Textarea |
Note: You can insert several attributes of each type for a listing.
2. ACF plugin: ACF, or Advanced Custom Fields, is a popular plugin that allows users to add custom fields to WordPress post types. Listdom has a fantastic integration with this plugin. To utilize this feature, you’ll need the Listdom ACF addon. Click here for more information on this process.
The available ACF fields to import to Listdom are:
| ACF Field | |
|---|---|
| 1 | Text |
| 2 | Text Area |
| 3 | Number |
| 4 | Range |
| 5 | |
| 6 | URL |
| 7 | Password |
| 8 | Image |
| 10 | WYSIWYG Editor |
| 11 | oEmbed |
| 12 | Select |
| 13 | Checkbox |
| 14 | Radio Button |
| 15 | Button Group |
| 16 | True False |
| 18 | Post Object |
| 19 | Page Link |
| 24 | Date Picker |
| 25 | Date Time Picker |
| 26 | Time Picker |
| 27 | Color Picker |
Note: You can insert several field of each type for a listing.
Note: The fields inside the ACF Accordion and Tabs will be imported too.
How to Import Taxonomies Using the Excel Add-on
You can easily add locations, categories, tags, features, and labels to your site through the listing import process. To do this, first create a sample listing with a unique ID. In your import file, assign the desired terms for each taxonomy by listing them in their corresponding columns, separated by commas within a single cell. When you perform the import using the Excel add-on, any locations, categories, tags, features, or labels that do not already exist on your site will be automatically created and associated with the sample listing. After the import is complete, you can delete the sample listing if you wish, and all newly created taxonomy terms will remain available for future use across your site.
Mapping Templates
This section displays all your saved mapping templates. You can remove any templates you no longer need.
Export
Export all website listings into an Excel file. You can then edit this file and re-import it to update your listings.
