/**
* Test wc_get_filename_from_url().
*
* @since 2.2
*/
public function test_wc_get_filename_from_url()
{
$this->assertEquals('woocommerce.pdf', wc_get_filename_from_url('https://woocommerce.com/woocommerce.pdf'));
$this->assertEmpty(wc_get_filename_from_url('ftp://wc'));
$this->assertEmpty(wc_get_filename_from_url('http://www.skyverge.com'));
$this->assertEquals('woocommerce', wc_get_filename_from_url('https://woocommerce.com/woocommerce'));
}
/**
* Gets an array of downloadable files for this product.
*
* @since 2.1.0
*
* @return array
*/
public function get_files()
{
$downloadable_files = array_filter(isset($this->downloadable_files) ? (array) maybe_unserialize($this->downloadable_files) : array());
if ($downloadable_files) {
foreach ($downloadable_files as $key => $file) {
if (!is_array($file)) {
$downloadable_files[$key] = array('file' => $file, 'name' => '');
}
// Set default name
if (empty($file['name'])) {
$downloadable_files[$key]['name'] = wc_get_filename_from_url($file['file']);
}
// Filter URL
$downloadable_files[$key]['file'] = apply_filters('woocommerce_file_download_path', $downloadable_files[$key]['file'], $this, $key);
}
}
return apply_filters('woocommerce_product_files', $downloadable_files, $this);
}
/**
* Product Exporter Tool
*/
public static function do_export($post_type = 'product')
{
global $wpdb;
$export_limit = !empty($_POST['limit']) ? intval($_POST['limit']) : 999999999;
$export_count = 0;
$limit = 100;
$current_offset = !empty($_POST['offset']) ? intval($_POST['offset']) : 0;
$csv_columns = $post_type == 'product' ? include 'data/data-post-columns.php' : (include 'data/data-variation-columns.php');
$product_taxonomies = get_object_taxonomies($post_type, 'name');
$export_columns = !empty($_POST['columns']) ? $_POST['columns'] : '';
$include_hidden_meta = !empty($_POST['include_hidden_meta']) ? true : false;
$product_limit = !empty($_POST['product_limit']) ? sanitize_text_field($_POST['product_limit']) : '';
$exclude_hidden_meta_columns = (include 'data/data-hidden-meta-columns.php');
if ($limit > $export_limit) {
$limit = $export_limit;
}
$wpdb->hide_errors();
@set_time_limit(0);
// Disable GZIP
if (function_exists('apache_setenv')) {
@apache_setenv('no-gzip', 1);
}
@ini_set('zlib.output_compression', 'Off');
@ini_set('output_buffering', 'Off');
@ini_set('output_handler', '');
$filename_suffix = 'woocommerce-product-export';
if ('product_variation' === $post_type) {
$filename_suffix = 'woocommerce-product-variations-export';
}
$filename = sprintf('%s-%s.csv', $filename_suffix, date_i18n('Y_m_d_H_i_s', current_time('timestamp')));
header('Content-Type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=' . $filename);
header('Pragma: no-cache');
header('Expires: 0');
$fp = fopen('php://output', 'w');
// Headers
$all_meta_keys = self::get_all_metakeys($post_type);
$found_attributes = self::get_all_product_attributes($post_type);
// Loop products and load meta data
$found_product_meta = array();
// Some of the values may not be usable (e.g. arrays of arrays) but the worse
// that can happen is we get an empty column.
foreach ($all_meta_keys as $meta) {
if (!$meta) {
continue;
}
if (!$include_hidden_meta && !in_array($meta, array_keys($csv_columns)) && substr($meta, 0, 1) == '_') {
continue;
}
if ($include_hidden_meta && (in_array($meta, $exclude_hidden_meta_columns) || in_array($meta, array_keys($csv_columns)))) {
continue;
}
$found_product_meta[] = $meta;
}
$found_product_meta = array_diff($found_product_meta, array_keys($csv_columns));
// Variable to hold the CSV data we're exporting
$row = array();
if ($post_type == 'product_variation') {
$row[] = 'Parent';
$row[] = 'parent_sku';
}
// Export header rows
foreach ($csv_columns as $column => $value) {
if (!$export_columns || in_array($column, $export_columns)) {
$row[] = esc_attr($value);
}
}
// Handle special fields like taxonomies
if (!$export_columns || in_array('images', $export_columns)) {
$row[] = 'images';
}
if (!$export_columns || in_array('file_paths', $export_columns)) {
if (function_exists('wc_get_filename_from_url')) {
$row[] = 'downloadable_files';
} else {
$row[] = 'file_paths';
}
}
if (!$export_columns || in_array('taxonomies', $export_columns)) {
foreach ($product_taxonomies as $taxonomy) {
if (strstr($taxonomy->name, 'pa_')) {
continue;
}
// Skip attributes
$row[] = 'tax:' . self::format_data($taxonomy->name);
}
}
if (!$export_columns || in_array('meta', $export_columns)) {
foreach ($found_product_meta as $product_meta) {
$row[] = 'meta:' . self::format_data($product_meta);
}
}
if (!$export_columns || in_array('attributes', $export_columns)) {
foreach ($found_attributes as $attribute) {
$row[] = 'attribute:' . self::format_data($attribute);
$row[] = 'attribute_data:' . self::format_data($attribute);
$row[] = 'attribute_default:' . self::format_data($attribute);
}
}
if (function_exists('woocommerce_gpf_install') && (!$export_columns || in_array('gpf', $export_columns))) {
$row[] = 'gpf:availability';
$row[] = 'gpf:condition';
$row[] = 'gpf:brand';
$row[] = 'gpf:product_type';
$row[] = 'gpf:google_product_category';
$row[] = 'gpf:gtin';
$row[] = 'gpf:mpn';
$row[] = 'gpf:gender';
$row[] = 'gpf:age_group';
$row[] = 'gpf:color';
$row[] = 'gpf:size';
$row[] = 'gpf:delivery_label';
$row[] = 'gpf:adwords_grouping';
$row[] = 'gpf:adwords_labels';
$row[] = 'gpf:custom_label_0';
$row[] = 'gpf:custom_label_1';
$row[] = 'gpf:custom_label_2';
$row[] = 'gpf:custom_label_3';
$row[] = 'gpf:custom_label_4';
}
$row = array_map('WC_PCSVIS_Exporter::wrap_column', $row);
fwrite($fp, implode(',', $row) . "\n");
unset($row);
while ($export_count < $export_limit) {
$product_args = apply_filters('woocommerce_csv_product_export_args', array('numberposts' => $limit, 'post_status' => array('publish', 'pending', 'private', 'draft'), 'post_type' => $post_type, 'orderby' => 'ID', 'order' => 'ASC', 'offset' => $current_offset));
if ($post_type == 'product_variation') {
$product_args['orderby'] = 'post_parent';
if ($product_limit) {
$parent_ids = array_map('intval', explode(',', $product_limit));
$child_ids = $wpdb->get_col("SELECT ID FROM {$wpdb->posts} WHERE post_parent IN (" . implode(',', $parent_ids) . ");");
$product_args['post__in'] = $child_ids;
}
}
$products = get_posts($product_args);
if (!$products || is_wp_error($products)) {
break;
}
// Loop products
foreach ($products as $product) {
$row = array();
// Pre-process data
$meta_data = get_post_custom($product->ID);
$product->meta = new stdClass();
$product->attributes = new stdClass();
// Meta data
foreach ($meta_data as $meta => $value) {
if (!$meta) {
continue;
}
if (!$include_hidden_meta && !in_array($meta, array_keys($csv_columns)) && substr($meta, 0, 1) == '_') {
continue;
}
if ($include_hidden_meta && in_array($meta, $exclude_hidden_meta_columns)) {
continue;
}
$meta_value = maybe_unserialize(maybe_unserialize($value[0]));
if (is_array($meta_value)) {
$meta_value = json_encode($meta_value);
}
$product->meta->{$meta} = self::format_export_meta($meta_value, $meta);
}
// Product attributes
if (isset($meta_data['_product_attributes'][0])) {
$attributes = maybe_unserialize(maybe_unserialize($meta_data['_product_attributes'][0]));
if (!empty($attributes) && is_array($attributes)) {
foreach ($attributes as $key => $attribute) {
if (!$key) {
continue;
}
if ($attribute['is_taxonomy'] == 1) {
$terms = wp_get_post_terms($product->ID, $key, array("fields" => "names"));
if (!is_wp_error($terms)) {
$attribute_value = implode('|', $terms);
} else {
$attribute_value = '';
}
} else {
if (empty($attribute['name'])) {
continue;
}
$key = $attribute['name'];
$attribute_value = $attribute['value'];
}
if (!isset($attribute['position'])) {
$attribute['position'] = 0;
}
if (!isset($attribute['is_visible'])) {
$attribute['is_visible'] = 0;
}
if (!isset($attribute['is_variation'])) {
$attribute['is_variation'] = 0;
}
$attribute_data = $attribute['position'] . '|' . $attribute['is_visible'] . '|' . $attribute['is_variation'];
$_default_attributes = isset($meta_data['_default_attributes'][0]) ? maybe_unserialize(maybe_unserialize($meta_data['_default_attributes'][0])) : '';
if (is_array($_default_attributes)) {
$_default_attribute = isset($_default_attributes[$key]) ? $_default_attributes[$key] : '';
} else {
$_default_attribute = '';
}
$product->attributes->{$key} = array('value' => $attribute_value, 'data' => $attribute_data, 'default' => $_default_attribute);
}
}
}
// GPF
if (isset($meta_data['_woocommerce_gpf_data'][0])) {
$product->gpf_data = $meta_data['_woocommerce_gpf_data'][0];
}
if ($post_type == 'product_variation') {
$post_parent_title = get_the_title($product->post_parent);
if (!$post_parent_title) {
continue;
}
$row[] = self::format_data($post_parent_title);
$parent_sku = WC_Product_CSV_Import_Suite::get_meta_data($product->post_parent, '_sku');
$row[] = $parent_sku;
}
// Get column values
foreach ($csv_columns as $column => $value) {
if (!$export_columns || in_array($column, $export_columns)) {
if ($post_type == 'product_variation' && $column == '_regular_price' && empty($product->meta->{$column})) {
$column = '_price';
}
if (isset($product->meta->{$column})) {
$row[] = self::format_data($product->meta->{$column});
} elseif (isset($product->{$column}) && !is_array($product->{$column})) {
if ($column === 'post_title') {
$row[] = sanitize_text_field($product->{$column});
} else {
$row[] = self::format_data($product->{$column});
}
} else {
$row[] = '';
}
}
}
// Export images/gallery
if (!$export_columns || in_array('images', $export_columns)) {
$image_file_names = array();
// Featured image
if (($featured_image_id = get_post_thumbnail_id($product->ID)) && ($image = wp_get_attachment_image_src($featured_image_id, 'full'))) {
$image_file_names[] = current($image);
}
// Images
$images = isset($meta_data['_product_image_gallery'][0]) ? explode(',', maybe_unserialize(maybe_unserialize($meta_data['_product_image_gallery'][0]))) : false;
$results = array();
if ($images) {
foreach ($images as $image_id) {
if ($featured_image_id == $image_id) {
continue;
}
$image = wp_get_attachment_image_src($image_id, 'full');
if ($image) {
$image_file_names[] = current($image);
}
}
}
$row[] = implode(' | ', $image_file_names);
}
// Downloadable files
if (!$export_columns || in_array('file_paths', $export_columns)) {
if (!function_exists('wc_get_filename_from_url')) {
$file_paths = maybe_unserialize(maybe_unserialize($meta_data['_file_paths'][0]));
$file_paths_to_export = array();
if ($file_paths) {
foreach ($file_paths as $file_path) {
$file_paths_to_export[] = $file_path;
}
}
$file_paths_to_export = implode(' | ', $file_paths_to_export);
$row[] = self::format_data($file_paths_to_export);
} elseif (isset($meta_data['_downloadable_files'][0])) {
$file_paths = maybe_unserialize(maybe_unserialize($meta_data['_downloadable_files'][0]));
$file_paths_to_export = array();
if ($file_paths) {
foreach ($file_paths as $file_path) {
$file_paths_to_export[] = (!empty($file_path['name']) ? $file_path['name'] : wc_get_filename_from_url($file_path['file'])) . '::' . $file_path['file'];
}
}
$file_paths_to_export = implode(' | ', $file_paths_to_export);
$row[] = self::format_data($file_paths_to_export);
} else {
$row[] = '';
}
}
// Export taxonomies
if (!$export_columns || in_array('taxonomies', $export_columns)) {
foreach ($product_taxonomies as $taxonomy) {
if (strstr($taxonomy->name, 'pa_')) {
continue;
}
// Skip attributes
if (is_taxonomy_hierarchical($taxonomy->name)) {
$terms = wp_get_post_terms($product->ID, $taxonomy->name, array("fields" => "all"));
$formatted_terms = array();
foreach ($terms as $term) {
$ancestors = array_reverse(get_ancestors($term->term_id, $taxonomy->name));
$formatted_term = array();
foreach ($ancestors as $ancestor) {
$formatted_term[] = get_term($ancestor, $taxonomy->name)->name;
}
$formatted_term[] = $term->name;
$formatted_terms[] = implode(' > ', $formatted_term);
}
$row[] = self::format_data(implode('|', $formatted_terms));
} else {
$terms = wp_get_post_terms($product->ID, $taxonomy->name, array('fields' => 'slugs'));
$row[] = self::format_data(implode('|', $terms));
}
}
}
// Export meta data
if (!$export_columns || in_array('meta', $export_columns)) {
foreach ($found_product_meta as $product_meta) {
if (isset($product->meta->{$product_meta})) {
$row[] = self::format_data($product->meta->{$product_meta});
} else {
$row[] = '';
}
}
}
// Find and export attributes
if (!$export_columns || in_array('attributes', $export_columns)) {
foreach ($found_attributes as $attribute) {
if (isset($product->attributes) && isset($product->attributes->{$attribute})) {
$values = $product->attributes->{$attribute};
$row[] = self::format_data($values['value']);
$row[] = self::format_data($values['data']);
$row[] = self::format_data($values['default']);
} else {
$row[] = '';
$row[] = '';
$row[] = '';
}
}
}
// Export GPF
if (function_exists('woocommerce_gpf_install') && (!$export_columns || in_array('gpf', $export_columns))) {
$gpf_data = empty($product->gpf_data) ? '' : maybe_unserialize($product->gpf_data);
$row[] = empty($gpf_data['availability']) ? '' : $gpf_data['availability'];
$row[] = empty($gpf_data['condition']) ? '' : $gpf_data['condition'];
$row[] = empty($gpf_data['brand']) ? '' : $gpf_data['brand'];
$row[] = empty($gpf_data['product_type']) ? '' : $gpf_data['product_type'];
$row[] = empty($gpf_data['google_product_category']) ? '' : $gpf_data['google_product_category'];
$row[] = empty($gpf_data['gtin']) ? '' : $gpf_data['gtin'];
$row[] = empty($gpf_data['mpn']) ? '' : $gpf_data['mpn'];
$row[] = empty($gpf_data['gender']) ? '' : $gpf_data['gender'];
$row[] = empty($gpf_data['age_group']) ? '' : $gpf_data['age_group'];
$row[] = empty($gpf_data['color']) ? '' : $gpf_data['color'];
$row[] = empty($gpf_data['size']) ? '' : $gpf_data['size'];
$row[] = empty($gpf_data['adwords_grouping']) ? '' : $gpf_data['adwords_grouping'];
$row[] = empty($gpf_data['adwords_labels']) ? '' : $gpf_data['adwords_labels'];
$row[] = empty($gpf_data['custom_label_0']) ? '' : $gpf_data['custom_label_0'];
$row[] = empty($gpf_data['custom_label_1']) ? '' : $gpf_data['custom_label_1'];
$row[] = empty($gpf_data['custom_label_2']) ? '' : $gpf_data['custom_label_2'];
$row[] = empty($gpf_data['custom_label_3']) ? '' : $gpf_data['custom_label_3'];
$row[] = empty($gpf_data['custom_label_4']) ? '' : $gpf_data['custom_label_4'];
}
// Add to csv
$row = array_map('WC_PCSVIS_Exporter::wrap_column', $row);
fwrite($fp, implode(',', $row) . "\n");
unset($row);
}
$current_offset += $limit;
$export_count += $limit;
unset($products);
}
fclose($fp);
exit;
}
/**
* @deprecated
*/
function woocommerce_get_filename_from_url($file_url)
{
return wc_get_filename_from_url($file_url);
}
/**
* Read downloads from post meta.
*
* @param WC_Product
* @since 2.7.0
*/
protected function read_downloads(&$product)
{
$meta_values = array_filter((array) maybe_unserialize(get_post_meta($product->get_id(), '_downloadable_files', true)));
if ($meta_values) {
$downloads = array();
foreach ($meta_values as $key => $value) {
$download = new WC_Product_Download();
$download->set_id($key);
$download->set_name($value['name'] ? $value['name'] : wc_get_filename_from_url($value['file']));
$download->set_file(apply_filters('woocommerce_file_download_path', $value['file'], $product, $key));
$downloads[] = $download;
}
$product->set_downloads($downloads);
}
}
/**
* Save downloadable files.
*
* @param WC_Product $product Product instance.
* @param array $downloads Downloads data.
* @param int $deprecated Deprecated since 2.7.
* @return WC_Product
*/
private function save_downloadable_files($product, $downloads, $deprecated = 0)
{
if ($deprecated) {
wc_deprecated_argument('variation_id', '2.7', 'save_downloadable_files() not requires a variation_id anymore.');
}
$files = array();
foreach ($downloads as $key => $file) {
if (empty($file['file'])) {
continue;
}
$download = new WC_Product_Download();
$download->set_id($key);
$download->set_name($file['name'] ? $file['name'] : wc_get_filename_from_url($file['file']));
$download->set_file(apply_filters('woocommerce_file_download_path', $file['file'], $product, $key));
$files[] = $download;
}
$product->set_downloads($files);
return $product;
}
echo esc_attr($download->get_id());
?>
" rel="<?php
echo esc_attr($download->get_product_id()) . ',' . esc_attr($download->get_download_id());
?>
" class="revoke_access button"><?php
_e('Revoke access', 'woocommerce');
?>
</button>
<div class="handlediv" aria-label="<?php
esc_attr_e('Click to toggle', 'woocommerce');
?>
"></div>
<strong>
<?php
echo '#' . esc_html($product->get_id()) . ' — ' . apply_filters('woocommerce_admin_download_permissions_title', $product->get_name(), $download->get_product_id(), $download->get_order_id(), $download->get_order_key(), $download->get_download_id()) . ' — ' . esc_html($file_count) . ': ' . wc_get_filename_from_url($product->get_file_download_path($download->get_download_id())) . ' — ' . sprintf(_n('Downloaded %s time', 'Downloaded %s times', $download->get_download_count(), 'woocommerce'), $download->get_download_count());
?>
</strong>
</h3>
<table cellpadding="0" cellspacing="0" class="wc-metabox-content">
<tbody>
<tr>
<td>
<label><?php
_e('Downloads remaining', 'woocommerce');
?>
</label>
<input type="hidden" name="permission_id[<?php
echo $loop;
?>
]" value="<?php
function wc_update_210_file_paths()
{
global $wpdb;
// Upgrade file paths to support multiple file paths + names etc
$existing_file_paths = $wpdb->get_results("SELECT * FROM {$wpdb->postmeta} WHERE meta_key = '_file_paths' AND meta_value != '';");
if ($existing_file_paths) {
foreach ($existing_file_paths as $existing_file_path) {
$needs_update = false;
$new_value = array();
$value = maybe_unserialize(trim($existing_file_path->meta_value));
if ($value) {
foreach ($value as $key => $file) {
if (!is_array($file)) {
$needs_update = true;
$new_value[$key] = array('file' => $file, 'name' => wc_get_filename_from_url($file));
} else {
$new_value[$key] = $file;
}
}
if ($needs_update) {
$new_value = serialize($new_value);
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_key = %s, meta_value = %s WHERE meta_id = %d", '_downloadable_files', $new_value, $existing_file_path->meta_id));
}
}
}
}
}
global $wpdb, $woocommerce;
// Pages no longer used
wp_trash_post(get_option('woocommerce_pay_page_id'));
wp_trash_post(get_option('woocommerce_thanks_page_id'));
wp_trash_post(get_option('woocommerce_view_order_page_id'));
wp_trash_post(get_option('woocommerce_change_password_page_id'));
wp_trash_post(get_option('woocommerce_edit_address_page_id'));
wp_trash_post(get_option('woocommerce_lost_password_page_id'));
// Upgrade file paths to support multiple file paths + names etc
$existing_file_paths = $wpdb->get_results("SELECT * FROM {$wpdb->postmeta} WHERE meta_key = '_file_paths' AND meta_value != '';");
if ($existing_file_paths) {
foreach ($existing_file_paths as $existing_file_path) {
$needs_update = false;
$new_value = array();
$value = maybe_unserialize(trim($existing_file_path->meta_value));
if ($value) {
foreach ($value as $key => $file) {
if (!is_array($file)) {
$needs_update = true;
$new_value[$key] = array('file' => $file, 'name' => wc_get_filename_from_url($file));
} else {
$new_value[$key] = $file;
}
}
if ($needs_update) {
$new_value = serialize($new_value);
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_key = %s, meta_value = %s WHERE meta_id = %d", '_downloadable_files', $new_value, $existing_file_path->meta_id));
}
}
}
}
<div class="wc-metabox closed">
<h3 class="fixed">
<button type="button" rel="<?php
echo absint($download->product_id) . ',' . esc_attr($download->download_id);
?>
" class="revoke_access button"><?php
_e('Revoke Access', 'woocommerce');
?>
</button>
<div class="handlediv" title="<?php
esc_attr_e('Click to toggle', 'woocommerce');
?>
"></div>
<strong>
<?php
echo '#' . absint($product->id) . ' — ' . apply_filters('woocommerce_admin_download_permissions_title', $product->get_title(), $download->product_id, $download->order_id, $download->order_key, $download->download_id) . ' — ' . sprintf(__('%s: %s', 'woocommerce'), $file_count, wc_get_filename_from_url($product->get_file_download_path($download->download_id))) . ' — ' . sprintf(_n('Downloaded %s time', 'Downloaded %s times', absint($download->download_count), 'woocommerce'), absint($download->download_count));
?>
</strong>
</h3>
<table cellpadding="0" cellspacing="0" class="wc-metabox-content">
<tbody>
<tr>
<td>
<label><?php
_e('Downloads Remaining', 'woocommerce');
?>
:</label>
<input type="hidden" name="product_id[<?php
echo $loop;
?>
]" value="<?php
/**
* Parse product
* @param array $item
* @param integer $merge_empty_cells
* @return array
*/
public function parse_product($item, $merge_empty_cells = 0)
{
global $WC_CSV_Product_Import, $wpdb;
$this->row++;
$terms_array = $postmeta = $product = array();
$attributes = $default_attributes = $gpf_data = null;
// Merging
$merging = !empty($_GET['merge']) && $_GET['merge'] ? true : false;
// Is variation
$is_variation = false;
if (isset($_GET['import_page']) && 'woocommerce_variation_csv' === $_GET['import_page']) {
$is_variation = true;
}
// Post ID field mapping
$post_id = !empty($item['id']) ? $item['id'] : 0;
$post_id = !empty($item['post_id']) ? $item['post_id'] : $post_id;
if ($merging) {
$product['merging'] = true;
WC_Product_CSV_Import_Suite::log(sprintf(__('> Row %s - preparing for merge.', 'woocommerce-product-csv-import-suite'), $this->row));
// Required fields
if (!$post_id && empty($item['sku'])) {
WC_Product_CSV_Import_Suite::log(__('> > Cannot merge without id or sku. Importing instead.', 'woocommerce-product-csv-import-suite'));
$merging = false;
} else {
// Check product exists
if (!$post_id) {
// Check product to merge exists
$found_product_id = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\tSELECT {$wpdb->posts}.ID\n\t\t\t\t\t FROM {$wpdb->posts}\n\t\t\t\t\t LEFT JOIN {$wpdb->postmeta} ON ( {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id )\n\t\t\t\t\t WHERE {$wpdb->posts}.post_type = '" . $this->post_type . "'\n\t\t\t\t\t AND {$wpdb->posts}.post_status IN ( 'publish', 'private', 'draft', 'pending', 'future' )\n\t\t\t\t\t AND {$wpdb->postmeta}.meta_key = '_sku' AND {$wpdb->postmeta}.meta_value = '%s'\n\t\t\t\t\t ", $item['sku']));
if ($is_variation && !$found_product_id && empty($item['post_title'])) {
$merging = false;
} else {
if (!$found_product_id && empty($item['post_title'])) {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Skipped. Cannot find product with sku %s.', 'woocommerce-product-csv-import-suite'), $item['sku']));
return new WP_Error('parse-error', __('Skipped. Cannot find product with sku.', 'woocommerce-product-csv-import-suite'));
} elseif (!$found_product_id) {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Skipped. Cannot find product with sku %s. Importing instead.', 'woocommerce-product-csv-import-suite'), $item['sku']));
$merging = false;
} else {
$post_id = $found_product_id;
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Found product with ID %s.', 'woocommerce-product-csv-import-suite'), $post_id));
}
}
}
}
}
if (!$merging) {
$product['merging'] = false;
WC_Product_CSV_Import_Suite::log(sprintf(__('> Row %s - preparing for import.', 'woocommerce-product-csv-import-suite'), $this->row));
// Required fields
if ($this->post_type == 'product' && empty($item['post_title'])) {
WC_Product_CSV_Import_Suite::log(__('> > Skipped. No post_title set for new product.', 'woocommerce-product-csv-import-suite'));
return new WP_Error('parse-error', __('No post_title set for new product.', 'woocommerce-product-csv-import-suite'));
}
}
$product['post_id'] = $post_id;
// Get post fields
foreach ($this->post_defaults as $column => $default) {
if (isset($item[$column])) {
$product[$column] = $item[$column];
}
}
// Get custom fields
foreach ($this->postmeta_defaults as $column => $default) {
if (isset($item[$column])) {
$postmeta[$column] = (string) $item[$column];
} elseif (isset($item['_' . $column])) {
$postmeta[$column] = (string) $item['_' . $column];
}
// Check custom fields are valid
if (isset($postmeta[$column]) && isset($this->postmeta_allowed[$column]) && !in_array($postmeta[$column], $this->postmeta_allowed[$column])) {
$postmeta[$column] = $this->postmeta_defaults[$column];
}
}
if (!$merging) {
// Merge post meta with defaults
$product = wp_parse_args($product, $this->post_defaults);
$postmeta = wp_parse_args($postmeta, $this->postmeta_defaults);
}
// Handle special meta fields
// price
if ($merging) {
if (!isset($postmeta['regular_price'])) {
$postmeta['regular_price'] = WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_regular_price');
}
if (!isset($postmeta['sale_price'])) {
$postmeta['sale_price'] = WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_sale_price');
}
}
// Sale dates
if (isset($postmeta['sale_price_dates_from'])) {
$postmeta['sale_price_dates_from'] = empty($postmeta['sale_price_dates_from']) ? '' : strtotime($postmeta['sale_price_dates_from']);
}
if (isset($postmeta['sale_price_dates_to'])) {
$postmeta['sale_price_dates_to'] = empty($postmeta['sale_price_dates_to']) ? '' : strtotime($postmeta['sale_price_dates_to']);
}
// Set price to sale price
if (isset($postmeta['regular_price']) && isset($postmeta['sale_price']) && $postmeta['sale_price'] !== '' && (empty($postmeta['sale_price_dates_from']) || current_time('timestamp') >= $postmeta['sale_price_dates_from']) && (empty($postmeta['sale_price_dates_to']) || current_time('timestamp') < $postmeta['sale_price_dates_to'])) {
$price = min($postmeta['sale_price'], $postmeta['regular_price']);
$postmeta['price'] = $price;
} elseif (isset($postmeta['regular_price'])) {
$postmeta['price'] = $postmeta['regular_price'];
}
// Format prices
if (isset($postmeta['regular_price'])) {
$postmeta['regular_price'] = wc_format_decimal($postmeta['regular_price']);
}
if (isset($postmeta['sale_price'])) {
$postmeta['sale_price'] = wc_format_decimal($postmeta['sale_price']);
}
if (isset($postmeta['price'])) {
$postmeta['price'] = wc_format_decimal($postmeta['price']);
}
// Reset dynamically generated meta
$postmeta['min_variation_price'] = $postmeta['max_variation_price'] = $postmeta['min_variation_regular_price'] = $postmeta['max_variation_regular_price'] = $postmeta['min_variation_sale_price'] = $postmeta['max_variation_sale_price'] = '';
// upsells
if (isset($postmeta['upsell_ids']) && !is_array($postmeta['upsell_ids'])) {
$ids = array_filter(array_map('trim', explode('|', $postmeta['upsell_ids'])));
$postmeta['upsell_ids'] = $ids;
}
// crosssells
if (isset($postmeta['crosssell_ids']) && !is_array($postmeta['crosssell_ids'])) {
$ids = array_filter(array_map('trim', explode('|', $postmeta['crosssell_ids'])));
$postmeta['crosssell_ids'] = $ids;
}
// variation description
if (isset($postmeta['variation_description'])) {
$postmeta['variation_description'] = esc_textarea($postmeta['variation_description']);
}
// Relative stock updates
if ($merging) {
if (isset($postmeta['stock'])) {
$postmeta['stock'] = trim($postmeta['stock']);
$mode = substr($postmeta['stock'], 0, 3);
if ($mode == '(+)') {
$old_stock = absint(WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_stock'));
$amount = absint(substr($postmeta['stock'], 3));
$new_stock = $old_stock + $amount;
$postmeta['stock'] = $new_stock;
}
if ($mode == '(-)') {
$old_stock = absint(WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_stock'));
$amount = absint(substr($postmeta['stock'], 3));
$new_stock = $old_stock - $amount;
$postmeta['stock'] = $new_stock;
}
}
}
// Format post status
if (!empty($product['post_status'])) {
$product['post_status'] = strtolower($product['post_status']);
if ('product' === $this->post_type) {
if (!in_array($product['post_status'], array('publish', 'private', 'draft', 'pending', 'future', 'inherit', 'trash'))) {
$product['post_status'] = 'publish';
}
} else {
if (!in_array($product['post_status'], array('private', 'publish'))) {
$product['post_status'] = 'publish';
}
}
}
// Put set core product postmeta into product array
foreach ($postmeta as $key => $value) {
$product['postmeta'][] = array('key' => '_' . esc_attr($key), 'value' => $value);
}
/**
* Handle other columns
*/
foreach ($item as $key => $value) {
if ($this->post_type == 'product' && !$merge_empty_cells && $value == "") {
continue;
}
/**
* File path handling
*/
if ($key == 'file_paths' || $key == 'downloadable_files') {
$file_paths = explode('|', $value);
$_file_paths = array();
foreach ($file_paths as $file_path) {
// 2.1
if (function_exists('wc_get_filename_from_url')) {
$file_path = array_map('trim', explode('::', $file_path));
if (sizeof($file_path) === 2) {
$file_name = $file_path[0];
$file_path = $file_path[1];
} else {
$file_name = wc_get_filename_from_url($file_path[0]);
$file_path = $file_path[0];
}
$_file_paths[md5($file_path)] = array('name' => $file_name, 'file' => $file_path);
} else {
$file_path = trim($file_path);
$_file_paths[md5($file_path)] = $file_path;
}
}
$value = $_file_paths;
$product['postmeta'][] = array('key' => '_' . esc_attr($key), 'value' => $value);
} elseif (strstr($key, 'meta:attribute_pa_')) {
// Get meta key name
$meta_key = isset($WC_CSV_Product_Import->raw_headers[$key]) ? $WC_CSV_Product_Import->raw_headers[$key] : $key;
$meta_key = trim(str_replace('meta:', '', $meta_key));
// Convert to slug
$value = sanitize_title($value);
// Add to postmeta array
$product['postmeta'][] = array('key' => esc_attr($meta_key), 'value' => $value);
} elseif (strstr($key, 'meta:')) {
// Get meta key name
$meta_key = isset($WC_CSV_Product_Import->raw_headers[$key]) ? $WC_CSV_Product_Import->raw_headers[$key] : $key;
$meta_key = trim(str_replace('meta:', '', $meta_key));
// Decode JSON
$json = json_decode($value, true);
if (is_array($json) || is_object($json)) {
$value = (array) $json;
}
// Add to postmeta array
$product['postmeta'][] = array('key' => esc_attr($meta_key), 'value' => $value);
} elseif (strstr($key, 'tax:')) {
// Get taxonomy
$taxonomy = trim(str_replace('tax:', '', $key));
// Exists?
if (!taxonomy_exists($taxonomy)) {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Skipping taxonomy "%s" - it does not exist.', 'woocommerce-product-csv-import-suite'), $taxonomy));
continue;
}
// Product type check
if ('product_type' === $taxonomy) {
$term = strtolower($value);
if (!array_key_exists($term, $this->allowed_product_types)) {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > > Product type "%s" not allowed - using simple.', 'woocommerce-product-csv-import-suite'), $term));
$term_id = $this->allowed_product_types['simple'];
} else {
$term_id = $this->allowed_product_types[$term];
}
// Add to array
$terms_array[] = array('taxonomy' => $taxonomy, 'terms' => array($term_id));
continue;
}
// Get terms - ID => parent
$terms = array();
$raw_terms = explode('|', $value);
$raw_terms = array_map('trim', $raw_terms);
// Handle term hierachy (>)
foreach ($raw_terms as $raw_term) {
if (strstr($raw_term, '>')) {
$raw_term = explode('>', $raw_term);
$raw_term = array_map('trim', $raw_term);
$raw_term = array_map('esc_html', $raw_term);
$raw_term = array_filter($raw_term);
$parent = 0;
$loop = 0;
foreach ($raw_term as $term) {
$loop++;
$term_id = '';
if (isset($this->inserted_terms[$taxonomy][$parent][$term])) {
$term_id = $this->inserted_terms[$taxonomy][$parent][$term];
} elseif ($term) {
/**
* Check term existance
*/
$term_may_exist = term_exists($term, $taxonomy, absint($parent));
WC_Product_CSV_Import_Suite::log(sprintf(__('> > (' . __LINE__ . ') Term %s (%s) exists? %s', 'woocommerce-product-csv-import-suite'), sanitize_text_field($term), esc_html($taxonomy), $term_may_exist ? print_r($term_may_exist, true) : '-'));
if (is_array($term_may_exist)) {
$possible_term = get_term($term_may_exist['term_id'], $taxonomy);
if ($possible_term->parent == $parent) {
$term_id = $term_may_exist['term_id'];
}
}
if (!$term_id) {
// Create appropriate slug
$slug = array();
for ($i = 0; $i < $loop; $i++) {
$slug[] = $raw_term[$i];
}
$slug = sanitize_title(implode('-', $slug));
$t = wp_insert_term($term, $taxonomy, array('parent' => $parent, 'slug' => $slug));
if (!is_wp_error($t)) {
$term_id = $t['term_id'];
} else {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > (' . __LINE__ . ') Failed to import term %s, parent %s - %s', 'woocommerce-product-csv-import-suite'), sanitize_text_field($term), sanitize_text_field($parent), sanitize_text_field($taxonomy)));
break;
}
}
$this->inserted_terms[$taxonomy][$parent][$term] = $term_id;
}
if (!$term_id) {
break;
}
// Add to product terms, ready to set if this is the final term
if (sizeof($raw_term) == $loop) {
$terms[] = $term_id;
}
$parent = $term_id;
}
} else {
$term_id = '';
$raw_term = esc_html($raw_term);
if (isset($this->inserted_terms[$taxonomy][0][$raw_term])) {
$term_id = $this->inserted_terms[$taxonomy][0][$raw_term];
} elseif ($raw_term) {
// Check term existance
$term_exists = term_exists($raw_term, $taxonomy, 0);
$term_id = is_array($term_exists) ? $term_exists['term_id'] : 0;
if (!$term_id) {
$t = wp_insert_term(trim($raw_term), $taxonomy, array('parent' => 0));
if (!is_wp_error($t)) {
$term_id = $t['term_id'];
} else {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Failed to import term %s %s', 'woocommerce-product-csv-import-suite'), esc_html($raw_term), esc_html($taxonomy)));
break;
}
}
$this->inserted_terms[$taxonomy][0][$raw_term] = $term_id;
}
// Store terms for later insertion
if ($term_id) {
$terms[] = $term_id;
}
}
}
// Any defined?
if (sizeof($terms) == 0) {
continue;
}
// Add to array
$terms_array[] = array('taxonomy' => $taxonomy, 'terms' => $terms);
} elseif (strstr($key, 'attribute:')) {
$attribute_key = sanitize_title(trim(str_replace('attribute:', '', $key)));
$attribute_name = str_replace('attribute:', '', $WC_CSV_Product_Import->raw_headers[$key]);
if (!$attribute_key) {
continue;
}
// Taxonomy
if (substr($attribute_key, 0, 3) == 'pa_') {
$taxonomy = $attribute_key;
// Exists?
if (!taxonomy_exists($taxonomy)) {
$nicename = strtolower(sanitize_title(str_replace('pa_', '', $taxonomy)));
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Attribute taxonomy "%s" does not exist. Adding it. Nicename: %s', 'woocommerce-product-csv-import-suite'), $taxonomy, $nicename));
$exists_in_db = $wpdb->get_var("SELECT attribute_id FROM " . $wpdb->prefix . "woocommerce_attribute_taxonomies WHERE attribute_name = '" . $nicename . "';");
if (!$exists_in_db) {
// Create the taxonomy
$wpdb->insert($wpdb->prefix . "woocommerce_attribute_taxonomies", array('attribute_name' => $nicename, 'attribute_label' => $nicename, 'attribute_type' => 'select', 'attribute_orderby' => 'menu_order'));
} else {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Attribute taxonomy %s already exists in DB.', 'woocommerce-product-csv-import-suite'), $taxonomy));
}
// Register the taxonomy now so that the import works!
register_taxonomy($taxonomy, array('product', 'product_variation'), array('hierarchical' => true, 'show_ui' => false, 'query_var' => true, 'rewrite' => false));
}
// Get terms
$terms = array();
$raw_terms = explode('|', $value);
$raw_terms = array_map('esc_html', $raw_terms);
$raw_terms = array_map('trim', $raw_terms);
if (sizeof($raw_terms) > 0) {
foreach ($raw_terms as $raw_term) {
if (empty($raw_term) && 0 != $raw_term) {
continue;
}
// Check term existance
$term_exists = term_exists($raw_term, $taxonomy, 0);
$term_id = is_array($term_exists) ? $term_exists['term_id'] : 0;
if (!$term_id) {
$t = wp_insert_term(trim($raw_term), $taxonomy);
if (!is_wp_error($t)) {
$term_id = $t['term_id'];
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Inserted Raw Term %s ID = %s', 'woocommerce-product-csv-import-suite'), esc_html($raw_term), $term_id));
} else {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Failed to import term %s %s', 'woocommerce-product-csv-import-suite'), esc_html($raw_term), esc_html($taxonomy)));
break;
}
} else {
WC_Product_CSV_Import_Suite::log(sprintf(__('> > Raw Term %s ID = %s', 'woocommerce-product-csv-import-suite'), esc_html($raw_term), $term_id));
}
if ($term_id) {
$terms[] = $term_id;
}
}
}
// Add to array
$terms_array[] = array('taxonomy' => $taxonomy, 'terms' => $terms);
// Ensure we have original attributes
if (is_null($attributes) && $merging) {
$attributes = array_filter((array) WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_product_attributes'));
} elseif (is_null($attributes)) {
$attributes = array();
}
// Set attribute
if (!isset($attributes[$taxonomy])) {
$attributes[$taxonomy] = array();
}
$attributes[$taxonomy]['name'] = $taxonomy;
$attributes[$taxonomy]['value'] = null;
$attributes[$taxonomy]['is_taxonomy'] = 1;
if (!isset($attributes[$taxonomy]['position'])) {
$attributes[$taxonomy]['position'] = 0;
}
if (!isset($attributes[$taxonomy]['is_visible'])) {
$attributes[$taxonomy]['is_visible'] = 1;
}
if (!isset($attributes[$taxonomy]['is_variation'])) {
$attributes[$taxonomy]['is_variation'] = 0;
}
} else {
if (!$value || !$attribute_key) {
continue;
}
// Set attribute
if (!isset($attributes[$attribute_key])) {
$attributes[$attribute_key] = array();
}
$attributes[$attribute_key]['name'] = $attribute_name;
$attributes[$attribute_key]['value'] = $value;
$attributes[$attribute_key]['is_taxonomy'] = 0;
if (!isset($attributes[$attribute_key]['position'])) {
$attributes[$attribute_key]['position'] = 0;
}
if (!isset($attributes[$attribute_key]['is_visible'])) {
$attributes[$attribute_key]['is_visible'] = 1;
}
if (!isset($attributes[$attribute_key]['is_variation'])) {
$attributes[$attribute_key]['is_variation'] = 0;
}
}
} elseif (strstr($key, 'attribute_data:')) {
$attribute_key = sanitize_title(trim(str_replace('attribute_data:', '', $key)));
if (!$attribute_key) {
continue;
}
$values = explode('|', $value);
$position = isset($values[0]) ? (int) $values[0] : 0;
$visible = isset($values[1]) ? (int) $values[1] : 1;
$variation = isset($values[2]) ? (int) $values[2] : 0;
// Ensure we have original attributes
if (!isset($attributes[$attribute_key])) {
if ($merging) {
$existing_attributes = array_filter((array) WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_product_attributes'));
$attributes[$attribute_key] = isset($existing_attributes[$attribute_key]) ? $existing_attributes[$attribute_key] : array();
} else {
$attributes[$attribute_key] = array();
}
}
$attributes[$attribute_key]['position'] = $position;
$attributes[$attribute_key]['is_visible'] = $visible;
$attributes[$attribute_key]['is_variation'] = $variation;
} elseif (strstr($key, 'attribute_default:')) {
$attribute_key = sanitize_title(trim(str_replace('attribute_default:', '', $key)));
if (!$attribute_key) {
continue;
}
// Ensure we have original attributes
if (is_null($default_attributes) && $merging) {
$default_attributes = array_filter((array) WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_default_attributes'));
} elseif (is_null($default_attributes)) {
$default_attributes = array();
}
$default_attributes[$attribute_key] = $value;
} elseif (strstr($key, 'gpf:')) {
$gpf_key = trim(str_replace('gpf:', '', $key));
// Get original values
if (is_null($gpf_data) && $merging) {
$gpf_data = array_filter((array) WC_Product_CSV_Import_Suite::get_meta_data($post_id, '_woocommerce_gpf_data'));
} elseif (is_null($gpf_data)) {
$gpf_data = array('availability' => '', 'condition' => '', 'brand' => '', 'product_type' => '', 'google_product_category' => '', 'gtin' => '', 'mpn' => '', 'gender' => '', 'age_group' => '', 'color' => '', 'size' => '', 'delivery_label' => '', 'size' => '', 'custom_label_0' => '', 'custom_label_1' => '', 'custom_label_2' => '', 'custom_label_3' => '', 'custom_label_4' => '');
}
$gpf_data[$gpf_key] = $value;
} elseif (strstr($key, 'parent_sku')) {
if ($value) {
$possible_parent_ids = $wpdb->get_col($wpdb->prepare("SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key='_sku' AND meta_value = %s", $value));
if ($possible_parent_ids) {
foreach ($possible_parent_ids as $possible_parent_id) {
if ('product' === get_post_type($possible_parent_id) && in_array(get_post_status($possible_parent_id), array('publish', 'private', 'draft'))) {
$product['post_parent'] = $possible_parent_id;
break;
}
}
}
}
} elseif (strstr($key, 'upsell_skus')) {
if ($value) {
$skus = array_filter(array_map('trim', explode('|', $value)));
$product['upsell_skus'] = $skus;
}
} elseif (strstr($key, 'crosssell_skus')) {
if ($value) {
$skus = array_filter(array_map('trim', explode('|', $value)));
$product['crosssell_skus'] = $skus;
}
}
}
// Remove empty attribues
if (!empty($attributes)) {
foreach ($attributes as $key => $value) {
if (!isset($value['name'])) {
unset($attributes[$key]);
}
}
}
/**
* Handle images
*/
if (!empty($item['images'])) {
$images = array_map('trim', explode('|', $item['images']));
} else {
$images = '';
}
$product['postmeta'][] = array('key' => '_default_attributes', 'value' => $default_attributes);
$product['attributes'] = $attributes;
$product['gpf_data'] = $gpf_data;
$product['images'] = $images;
$product['terms'] = $terms_array;
$product['sku'] = !empty($item['sku']) ? $item['sku'] : '';
$product['post_title'] = !empty($item['post_title']) ? $item['post_title'] : '';
unset($item, $terms_array, $postmeta, $attributes, $gpf_data, $images);
return $product;
}
