Probably the easiest way to do this is to connect to the database using MySQL Workbench or similar, and extract the data using a SQL query e.g. select u.user_login, u.user_email, m1.meta_value as first_name, m2.meta_value as last_name, m3.meta_value as billing_codice_snep, m4.meta_value as codice_snep from wp_users u left join wp_usermeta m1 on m1.user_id = u.id and m1.meta_key … Read more
Export WordPress User Meta to CSV/Excel
<script src=”https://wordpress.stackexchange.com/questions/355504/<?php echo plugins_url();?>/client/jquery.js”></script> <button id=”excel” onClick =”$(‘#dataTable’).tableExport({type:’excel’,escape:’false’});”> XLS</button> <button id=”print”>Print me</button> <table class=”dash-table” width=”100%” cellspacing=”0″ cellpadding=”10px” border=”0″ id=”dataTable”> <tr> <td>Client Name</td> <td>Email</td> <td>Health Condition</td> <td>Changes</td> <td>Image</td> </tr> <?php foreach ($results1 as $key => $value) { ?> <tr> <td><?php echo $value->rclient_name;?></td> <td><?php echo $value->email;?></td> <td><?php echo $value->health_condition;?></td> <td><?php echo $value->changes;?></td> <td><img src=”https://wordpress.stackexchange.com/questions/355504/<?php echo $value->image;?>” width=”50px” … Read more
<?php //edit.php?s&post_status=all&post_type=shirts&action=-1&m=0&slug=03-02-2020&filter_action=Filter&paged=1&action2=-1 //$parse_uri = explode(‘wp-content’, $_SERVER[‘SCRIPT_FILENAME’]); //require_once($parse_uri[0] . ‘wp-load.php’); header(“Content-Description: File Transfer”); header(“Content-Type: application/csv”); header(‘Content-Disposition: attachment; filename=”wp.csv”‘); header(‘Pragma: no-cache’); header(‘Expires: 0’); global $post; //https://developer.wordpress.org/reference/classes/wp_query/ $post_status = isset($_REQUEST[‘post_status’]) && $_REQUEST[‘post_status’]==’all’ ? ‘any’ : ‘publish’; $date = explode(‘-‘,$_REQUEST[‘slug’]); $posts_per_page = $_REQUEST[‘action2’]; $paged = (get_query_var(‘paged’)) ? get_query_var(‘paged’) : 1; $arg = array( ‘post_type’ => $_REQUEST[‘post_type’], ‘post_status’ => $post_status, … Read more
Add this code to your functions.php file and then you can use [product_title id=”123″] shortcode If you want other product meta you can edit the function to return any product data you would want /** * Product title shortcode. * `[product_title id=”123″]` to get a specific product title, by ID * * @return string The … Read more
How do I export categories, site stats, comments and posts from wordpress to excel
Exporting post info into a formatted table and into MailChimp as automated as possible
Did you check the “Download and import file attachments” option during export? Here’s an answer talking about it. If no then the data on images simply wasn’t part of the export – but the posts that were exported still reference those image IDs from the old site (which don’t exist on the new site). If … Read more
how to convert a wp multisite into a single site with content from subsites
Is there a way to export WordPress comments to a non-wordpress, HTML coded site?