After a long day of tweaking, I found there were several problems: The whitespace in the XML matters. The importer throws errors when each item’s child elements are not in the same line. Any whitespace between them will cause an indentation error and fail that row’s import. This doesn’t seem to matter on the actual … Read more
still,users who also search for a solution to ease WooCommerce site management, including import of valiables, can consider Store Manager and its trial version for testing
By doing a SHOW CREATE TABLE on wp_postmeta, I got the structure of that table which included this: PRIMARY KEY (`meta_id`), So the key that MySQL can do the ‘insert or update’ on is the meta_id, which you’re not providing. Therefore in your query, it will always be added as a new row. EDIT: The … Read more
Googling for “split wxr file” returned several results, including python script for splitting .wxr file GUI for splitting WXR files (OSX and Windows) .Net splitter for WXR files Haven’t tried any of these, but the comments look positive.
My advice is to not do long running bulk-operations over a web-connection in the first place. PHP works just fine from the command line. Write your one-time script to do whatever it is that you need it to do. If you need access to WordPress functions in that process, then include the wp-load.php file at … Read more
update_field() is ACF function so I would guess the issue is with it. From quick look at source it calls get_field_object() and so on, so environment might not be sufficient for it to work correctly during import. There is no “half” state for native meta data, either it exists in database or it doesn’t. You … Read more
Find duplicate posts with same slug and author
Finally I found the solution to this issue on documentation of wp all import https://www.wpallimport.com/documentation/troubleshooting/encoding/ If you’re sure that your XML file is valid, it’s not using UTF-8 encoding, and WP All Import is still rejecting it, try adding this code snippet inside your child theme’s functions.php file add_filter( ‘is_xml_preprocess_enabled’, ‘wpai_is_xml_preprocess_enabled’, 10, 1 ); function … Read more
I ended up writing a bunch of MySQL statements. My process went: Add users into wp_users. Add first name into wp_usermeta. Add last name into wp_usermeta. Add nickname into wp_usermeta. Add last activity into wp_usermeta. (This is important for BuddyPress; otherwise, users won’t show up in the members-loop) Add name to BuddyPress. Add custom “phone” … Read more
Best thing to do is read the docs: http://codex.wordpress.org/Tools_Export_Screen and http://codex.wordpress.org/Importing_Content#WordPress and work with WXR files rather than trying to export directly from the database. You also have the option on Import to grab images. Or you can merge the contents of the three wp-content/uploads/ directories, but be aware that it’s possible some images may … Read more