Michael Bissett mbissett

A description of import types

New Items Import -

This is primarily used to create and manage products. It keeps internal track of the products that it imports, which means that it can later update/create/delete products as they're changed/added/removed in your import file. It's also the only import type that can add/remove variations for variable products.

One limitation of new items imports is that cannot detect/update products that it didn't previously create. If you need to use a "New Items" import with a file that contains existing products, you can use WP All Import's API to prevent duplicates from being imported: https://www.wpallimport.com/documentation/developers/code-snippets/#do-not-create-products-with-duplicate-sku.

Link Products Without SKU to Orders While Importing

Import your products and add a custom field "_old_id" containing the import element {id[1]}, like this: https://d.pr/i/pLxdiJ.
Import your orders and use the following custom PHP function in the 'Product SKU' field (it should look like this https://d.pr/i/8ijjl4):

//Usage example: [my_connect_orders({productid[1]})]

function my_connect_orders( $product_id ) {
    global $wpdb;
    $query = 'SELECT `post_id` FROM `' . $wpdb->prefix . 'postmeta` WHERE `meta_key` = "_old_id" AND `meta_value` = "' . $product_id . '"';

XPath doesn't allow you to make queries with Cyrillic symbols unless you disable XML pre-processing by adding this code in your child themes functions.php file (or in a plugin like Code Snippets: https://wordpress.org/plugins/code-snippets/):

function wpai_is_xml_preprocess_enabled( $is_enabled ) {
	return false;
}
add_filter( 'is_xml_preprocess_enabled', 'wpai_is_xml_preprocess_enabled', 10, 1 );

Once that code is in place, upload your file to an import and queries like this will be possible:

WordPress doesn't allow multiple users to share the same e-mail address, but there are certain plugins that change that behavior. This is an example workaround using the Allow Multiple Accounts plugin.

Install and activate this plugin: https://wordpress.org/plugins/allow-multiple-accounts/
Use a custom PHP function in the import to generate a fake e-mail for the imported user(s): [fake_email()]. Screenshot: https://d.pr/FREE/Yr0MOL.
Store the real e-mail in a Custom Field named '_email_temp'. Screenshot: https://d.pr/ERw4F9
Use our API to change the users e-mail to the real e-mail after the user is saved.

	<?php

	// Hat tip to Trey Mills for the original code inspiration

	add_action('pmxi_saved_post', 'update_images_in_post_content', 10, 3);

	function update_images_in_post_content($id) {

	$media = get_attached_media( 'image', $id );

	<?php
	/*
	################### READ ME #################################
	You'll pass the URL to your feed/file to this function inside the "Download from URL" option when creating an import.

	Image examples: https://d.pr/hCfNek and https://d.pr/MnerNb.

	1. [custom_file_download("ftp://username:[email protected]/full/path/to/file.csv","csv")]
	2. [custom_file_download("http://example.com/full/path/to/file.csv","csv")]