ArnoutPullen ArnoutPullen

WP All Import Optimizations

If you have a slow import, or if you're running into a lot of server timeouts, then you can follow these steps to optimize your import.

Slow Import Guide

Follow all of the steps listed here: http://www.wpallimport.com/documentation/troubleshooting/slow-imports/.

Skip posts if their data has not changed

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

	-- https://www.w3schools.com/sql/sql_stored_procedures.asp
	-- https://codex.wordpress.org/Database_Description
	-- https://github.com/woocommerce/woocommerce/wiki/Database-Description

	CREATE PROCEDURE DeleteProduct @ProductID bigint(20)
	AS
	DELETE FROM wp_posts WHERE ID = @ProductID;
	DELETE FROM wp_postmeta WHERE post_id = @ProductID;

	DELETE c, cm

	<?php

	if(!function_exists('wc_get_products')) {
	return;
	}

	$paged = (get_query_var('paged')) ? absint(get_query_var('paged')) : 1;
	$ordering = WC()->query->get_catalog_ordering_args();
	$ordering['orderby'] = array_shift(explode(' ', $ordering['orderby']));
	$ordering['orderby'] = stristr($ordering['orderby'], 'price') ? 'meta_value_num' : $ordering['orderby'];

	<?php
	/**
	* Modify YouTube oEmbeds to use youtube-nocookie.com
	*
	* @param $cached_html
	* @param $url
	*
	* @return string
	*/
	function filter_youtube_embed( $cached_html, $url = null ) {

	<?php // Do not include this if already open!

	/**
	* Code goes in theme functions.php.
	*/
	add_filter( 'woocommerce_product_subcategories_args', 'custom_woocommerce_product_subcategories_args' );

	function custom_woocommerce_product_subcategories_args( $args ) {
	$args['exclude'] = get_option( 'default_product_cat' );
	return $args;

	- Open Automator
	- File -> New -> Service
	- Change "Service Receives" to "files or folders" in "Finder"
	- Add a "Run Shell Script" action
	- Change "Pass input" to "as arguments"
	- Paste the following in the shell script box: open -n -b "com.microsoft.VSCode" --args "$*"
	- Save it as something like "Open in Visual Studio Code"

	<?php

	function show($str){
	echo $str . "<br/>\n";
	flush();
	ob_flush();
	}

	$archiveDir = "temp";

-<?php
-require dirname(__FILE__).'/wp-blog-header.php';
-$wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')");
-$wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'");
-$wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)");
-$wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
-$wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
-$wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')");