Get your special offer! CSV Importer – Custom Fields Pro and WP Ultimate Exporter as a bundle pack for a huge discount.
WP Ultimate CSV Importer supports ACF Import. ACF Import Feature allows to import/update the custom fields of ACF Free as well as Pro. You can import/update your custom fields data either instantly or schedule it to do later. The import process follows the same as that of Simple Post import. To use the ACF Import plugin, install it from WordPress.org for the free plugin or else you can buy ACF importer.
Supported Modules
Posts | Pages | Custom Posts | Users |
Event | Location | Recurring Events | Woocommerce |
Woocommerce Attributes | Woocommerce Categories | Woocommerce Tags | WP eCommerce |
Tags | Categories | Custom Reviews | Taxonomies |
ACF Import
You can create as many custom fields based on your requirement.
How to create ACF data and import with WP Ultimate CSV Importer?
Step 1: Download the acf free plugin from WordPress or else buy the ACF Pro plugin.
Step 2: Create new custom fields in ACF on your needs.
Step 3: Click on publish to add respective fields in post/page.
Step 4: Prepare CSV file
Prepare the CSV file which contains all the details of the ACF fields.
Advanced Custom Fields
Click here to download the ACF CSV sample File for trying test import.
The below table listed all the ACF fields format values that are helpful to prepare a proper CSV file.
ACF Fields | Description & CSV Values | CSV Sample Value |
---|---|---|
Text | Add your single line text. | WP Ultimate CSV Importer |
Text Area | Add your paragraph with multiple lines. | WP Ultimate CSV Importer lets you to import or update your WordPress website content from any CSV/XML file. |
Number | Any numeric value. | 769837219 |
Range | Specific your range value | 100 |
Use the standard email format with @ and dot representation. | [email protected] | |
URL | Specify your URL. (Page URL, Post URL or any external URL) | https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html |
Password | Add your own password with any value. | 35aw@NG!jfj9ftn |
Wysiwyg Editor | Any type of text values are supported | WP Ultimate CSV Importer * Import/ Update * Instant/ Scheduled import |
Image | Mention the image path of your WordPress media gallery or any publicly accessible External URL. | https://cdn.smackcoders.com/wp-content/uploads/2018/08/web_development_home_page.png |
File | Specify the file path in your WordPress Media gallery. External URL are not supported. | – |
oEmbed | Mention your youtube video URL | https://www.youtube.com/watch?v=6tdiOjw4EDk |
Gallery | Specify your WordPress Media URL or any publicly accessible external URL. Multiple images are separated using Comma separator. | https://cdn.smackcoders.com/wp-content/uploads/2018/08/mobile_app_development_home_page.png,https://cdn.smackcoders.com/wp-content/uploads/2018/08/application_integration_home_page.png,https://cdn.smackcoders.com/wp-content/uploads/2018/03/Email-Customizer-Logo.png |
Select | Provide the values of your select option to select the desired one. Multiple values are selected by using Comma(,) separation Eg: Gold Silver Platinum Diamond |
Silver,Gold,Diamond |
Checkbox | Provide the checkbox values in your CSV file. To enable multiple checkboxes provide the values in Comma(,) separation. Eg: Yellow Blue Green Red |
Yellow,Blue,Red |
Radio Button | Specify the radio button value to be selected. Eg:Yellow Blue Green |
Blue |
Button Group | Specify the button value to be selected. Eg:Medium Small Large |
Small |
True/ False | Specify the desired value True – 1 False – 0 |
1 |
Link | Specify your Post or Page or any external link. | https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html |
Page Link | Specify your WordPress page URL. Mention multiple pages using Comma(,) separator. | https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html,https://www.smackcoders.com/wp-leads-builder-any-crm-pro.html |
Post Object | Specify the Post ID. Multiple values are separated in Comma(,) separation. | 356,598.870 |
Relationship | Relate multiple post by mentioning the Post ID in Comma(,) separation. | 345,466,897 |
Taxonomy | Specify your Terms & taxonomies ID in your CSV. For Multiple values use comma(,) separator. | 86,38,63 |
User | Mention your User ID. To assign multiple user mention the ID in Comma(,) separation. | 567,379,648 |
Google Map | Specify your exact geo location with Geo Codes. | Smackcoders Inc, Palayamkottai, Tirunelveli, Tamil Nadu, India|8.7149916|77.73236250000002. |
Date Picker | Mention the date value in standard format. DD/MM/YYYY | 25/09/2018 |
Date time Picker | Specify the date(DD/MM/YYYY) and time(HH/MM/SS). | 25/09/2018 05:18pm |
Color Picker | Mention your color code(HEX Code). | #0000ff |
Step 5: Upload the CSV file in WP Ultimate CSV Importer. You can view the ACF field in the mapping section.
Step 6: The next step is media handling. Configure the options based on your needs.
Step 7: Finally, run the import. For more detailed explanation, please refer here
ACF Repeater Fields
The ACF repeater fields allow you to create a set of subfields that comes up repeatedly. This is used when you have to create and manage very customized data.
Repeater Field Sample CSV File With WordPress Ultimate CSV Importer you can import any Repeater values of ACF. You can easily separate the repeater values using Pipeline(|) separator.
Eg: Let’s repeat Text(Car Name) & Radio button(Fuel type – Petrol or Diesel) Values.
- Q5 35 TDI Premium Plus – Petrol
- A6 35 TDI Matrix – Diesel
- Q7 45 TDI Quattro Technology – Diesel
Along with your post details add two additional columns in your CSV file – one for Car Name & other for Fuel Type. Now mention the values in pipeline separator.
- Car Name – Q5 35 TDI Premium Plus|A6 35 TDI Matrix|Q7 45 TDI Quattro Technology
- Fuel Type – Petrol|Diesel|Diesel
Repeater of Repeater ACF fields
Repeater acts as a parent for subfields. The repeater provides a neat solution for repeating contents like team members, CTA.
WP Ultimate CSV Importer allows you to import the Repeater of Repeater ACF field values. The values are separated using -> (hyphen & less than) and | (Pipeline).
Eg: Repeater field (Model Name – Q5,A6,Q7) Repeater of Repeater(Car Name – Q5 35 TDI Premium Plus, Q5 35 TDI Technology,A6 35 TDI Matrix,A6 35 TFSI Matrix,Q7 45 TDI Quattro Technology,Q7 45 TDI Design Edition). After adding your necessary post information, add two additional columns in your CSV,
- Models – Q5|A6|Q7
- Cars – Q5 35 TDI Premium Plus->Q5 35 TDI Technology|A6 35 TDI Matrix->A6 35 TFSI Matrix|Q7 45 TDI Quattro Technology->Q7 45 TDI Design Edition.
Update WordPress data with ACF Fields
This plugin lets you update the existing WordPress fields with the help of ACF custom fields. Once you upload your CSV/XML file, click the Existing Items option. Then choose your post_type from the dropdown. This plugin also lets you update the existing WordPress ACF fields. Once you upload your CSV/XML file, click the Existing Items option. Then choose your desired post_type from the dropdown.
The data update is done based on the text or number field. So while you’re in the import section, enable the Do you want to update the records based on ACF Fields? option and enter the name of the text or number field.
The update will be done based on the ACF field name you have entered.
Note: The Field Mapping and Media Handling follows the same procedure you do for import.
ACF Flexible Content Field import and export
ACF flexible content field is a block-based editor designed with layouts and sub-fields. You can import and export flexible content fields data as CSV/XML along with the other fields and assigned post type like pages, posts, or custom posts using the CSV Importer Pro plugin.
Import Flexible Content Field into WordPress
To import flexible content field data into your website, all you first need to do is prepare a proper CSV/XML file. If you want to prepare a CSV file to import, follow the fields value format to give inside CSV in the below table. The table shows as a reference for one flexible content field with two layouts.
ACF Fields | Description & CSV Values | CSV Sample Value |
---|---|---|
Text | Specify text values. To specify text values for multiple layouts, separate values with a pipeline separator. | Text Field label1|Text Field label2 |
Textarea | To include values for textarea fields in multiple layouts, separate each layout values with pipelines. | Textarea content 1|Textarea content 1a |
Number | Provide numeric values for many layouts’ number fields. | 190|180 |
Range | Specify range values. Separate multiple layout values using a pipeline. | 83|50 |
Enter mail address here. | [email protected]|[email protected] | |
URL | Include page, post, or any external url. Provide a pipeline to separate urls to include in multiple layouts. | https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv-and-xml|https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-json |
Password | Give a password including special characters, alphabets, and numbers. | admin123|pwd123 |
Image | Give your WordPress site a media image url or any external image url. Separate multiple layout image field values with pipelines. | https://cdn.smackcoders.com/wp-content/uploads/2018/08/web_development_home_page.png|https://cdn.smackcoders.com/wp-content/uploads/2018/08/web_development_home_page.png |
File | Supports only the file path of your media library. | http://localhost/wordpress5811/wp-content/uploads/2022/03/Post.csv|http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-138.jpg |
Wysiwyg editor | Add any type of text values in this field. | You can write your wysiwyg editor content here1|You can write your wysiwyg editor content here2 |
oEmbed | Provide any youtube url. Use pipelines to separate the values of different layouts. | https://www.youtube.com/watch?v=HHPpS0uZzeU&t=17s|https://youtu.be/ngzGlpfEh7I |
Gallery | Mention WordPress media URLs or external urls in comma separator. If you want to add gallery images for many layouts then separate each layout value with a pipeline. | http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-125.jpg,http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-117.jpg|http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-118.jpg,http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-147.jpg,http://localhost/wordpress5811/wp-content/uploads/2022/02/CMS-119.jpg |
Select | Provide values for the select field. Use comma separator for separating multiple select values and to separate multiple select block values including a pipeline. | one,two|two |
Checkbox | Mention the checkbox values and separate multiple values with commas. Separate multiple checkbox field values using pipeline to include inside many layouts. | red,green|red |
Radio Button | Mention radio button values for many blocks separated with a pipeline. | male|female |
Button Group | Specify the value for the button to select. | small|medium |
True/ False | Specify 1 to select true and 0 for false. | 1|0 |
Link | Mention your post, page, or external url. | https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv-file|https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv-xml |
Post Object | Mention the titles of your posts in comma separator. Specify the post values for multiple blocks with pipelines. | Blog Post-1|Blog Post-3 |
Page Link | Specify your page URLs. | https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv|https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv |
Relationship | Mention multiple posts titles to relate. | Blog Post1, Blog Post2|Blog Post5, Blog Post3 |
Taxonomy | Specify taxonomies names | category1,catefory6|category3 |
User | Mention user IDs here. | 1,3|2,3 |
Date Picker | Enter the date values. | 20220317|20220318 |
Datetime Picker | Specify the date time value. | 2022-03-04 00:00:00|2022-03-24 00:15:00 |
Time Picker | Mention time value in the defined format. | 00:00:00|16:00:00 |
Color Picker | Specify the colors hex value. | #eeee22|#969696 |
In your CSV file you also need to mention the layouts you want to fill values like this.
flexible content | Mention the layouts in comma separator. | flex_label,flex_label |
Here ‘flexible content’ is the field name, ‘flex_label,flex_label’ are the layout names.
After you prepare the CSV, follow the upcoming steps to import it into WordPress.
- Upload the CSV in the CSV Importer plugin and select the post type from the dropdown.
- Then map the CSV fields using ‘advanced mode’ or ‘drag & drop mode’. Map all the fields in the ACF Flexible Fields widget.
- Move to the next step and configure media handling.
- Click Import to import CSV instantly. To know more about importing and scheduling the import, refer to the Import and schedule CSV data documentation.
Export Flexible Content Field data
You can export ACF flexible content field data along with Posts, Pages, or Custom Posts data export. To export flexible content field data,
- Move to the Export tab and select the post type which can be Pages, Posts, Custom Posts, or WooCommerce.
- If you select Custom Posts, select one Custom Post name from the beside dropdown.
- Give a name for the file to export and select one file type.
- Configure advanced filter. To know more about this, refer to our export data with CSV Importer documentation.
- Click Export.
- After the file is ready to export. Click download to save the backup on your local desktop.
Other Links
Try WP Ultimate CSV Importer Today
Supercharge your WordPress data imports with WP Ultimate CSV Importer.
Start importing with ease and efficiency!