static function parseProductColumn($column, $item, $product, $profile)
{
wpla_logger_start_timer('parseProductColumn');
$profile_fields = $profile ? maybe_unserialize($profile->fields) : array();
$profile_details = $profile ? maybe_unserialize($profile->details) : array();
$variations_mode = isset($profile_details['variations_mode']) ? $profile_details['variations_mode'] : 'default';
$value = '';
// handle FBA mode / fallback
if (get_option('wpla_fba_enable_fallback') == 1) {
// fallback enabled
// if there is no FBA qty, FBA will be disabled
$fba_enabled = $item['fba_quantity'] > 0 ? true : false;
// if there is FBA qty, always enable FBA
} else {
// fallback disabled
$fba_enabled = $item['fba_fcid'] && $item['fba_fcid'] != 'DEFAULT';
// regard fba_fcid column - ignore stock
}
// if fulfillment_center_id is forced to AMAZON_NA in the listing profile,
// make sure to set fba_enabled to regarding this overwrite in ListingLoader feeds as well
if (isset($profile_fields['fulfillment_center_id']) && !empty($profile_fields['fulfillment_center_id'])) {
$fba_enabled = $profile_fields['fulfillment_center_id'] == 'DEFAULT' ? false : true;
}
// get custom product level feed columns - and merge with profile columns
$custom_feed_columns = get_post_meta($product->id, '_wpla_custom_feed_columns', true);
if ($custom_feed_columns && is_array($custom_feed_columns) && !empty($custom_feed_columns)) {
$profile_fields = array_merge($profile_fields, $custom_feed_columns);
}
// set correct post_id for variations
$post_id = $product->id;
if ($product->product_type == 'variation') {
$post_id = $product->variation_id;
}
// process hard coded fields
switch ($column) {
case 'external_product_id':
$value = get_post_meta($post_id, '_amazon_product_id', true);
break;
case 'external_product_id_type':
$value = get_post_meta($post_id, '_amazon_id_type', true);
// // leave id type empty if there is no product id (parent variations) (incompatible with amazon.in)
// $external_product_id = WPLA()->memcache->getColumnValue( $product->sku, 'external_product_id' );
// if ( empty( $external_product_id ) ) $value = '[---]';
break;
case 'sku':
// update feed
// update feed
case 'item_sku':
// new items feed
// $value = $product->sku;
$value = $item['sku'];
// we have to use the item SKU - or feed processing would fail if SKU is different in WooCommerce and WP-Lister
break;
case 'price':
// update feed
// $value = $product->get_price(); // WC2.1+
$value = $product->regular_price;
// WC2.0
$value = $profile ? $profile->processProfilePrice($value) : $value;
$value = apply_filters('wpla_filter_product_price', $value, $post_id, $product, $item, $profile);
if ($post_id != $product->id && ($product_value = get_post_meta($product->id, '_amazon_price', true))) {
// parent price
if ($product_value > 0) {
$value = $product_value;
}
}
if ($product_value = get_post_meta($post_id, '_amazon_price', true)) {
// variation price
if ($product_value > 0) {
$value = $product_value;
}
}
$value = $value ? round($value, 2) : $value;
// make sure price stays within min/max boundaries - prevent errors in PNQ feed
if ($item['min_price'] > 0) {
$value = max($value, $item['min_price']);
}
if ($item['max_price'] > 0) {
$value = min($value, $item['max_price']);
}
break;
case 'sale-price':
// update feed
// update feed
case 'sale_price':
// new items feed
// $value = $product->get_sale_price(); // WC2.1+
$value = $product->sale_price;
// WC2.0
$value = $profile ? $profile->processProfilePrice($value) : $value;
$value = apply_filters('wpla_filter_sale_price', $value, $post_id, $product, $item, $profile);
$value = $value ? round($value, 2) : $value;
// make sure sale_price is not higher than standard_price / price - Amazon might silently ignore price updates otherwise
$standard_price = self::getStandardPriceForRow($product->sku);
if ($standard_price && $value > $standard_price) {
$value = '';
}
// if no sale price is set, send regular price with sale end date in the past to remove previously sent sale prices
if (empty($value)) {
$value = $standard_price;
}
break;
case 'sale_from_date':
// new items feed
// new items feed
case 'sale-start-date':
// update feed
$date = get_post_meta($post_id, '_sale_price_dates_from', true);
if ($date) {
$value = date('Y-m-d', $date);
}
// if sale price exists but no start date, fill in 2011-01-01
$has_sale_price = self::hasActiveSalePrice($product->sku);
if (!$value && $has_sale_price) {
$value = '2011-01-01';
}
// fall back to default past date if standard price is set
$standard_price = self::getStandardPriceForRow($product->sku);
if (!$value && $standard_price) {
$value = '2000-01-01';
}
// default past date
// if sale price is intentionally left blank by [---] shortcode, leave sale date blank as well
$sale_price = self::getSalePriceForRow($product->sku);
if (!$sale_price) {
$value = '';
}
break;
case 'sale_end_date':
// new items feed
// new items feed
case 'sale-end-date':
// update feed
$date = get_post_meta($post_id, '_sale_price_dates_to', true);
if ($date) {
$value = date('Y-m-d', $date);
}
// if sale price exists but no end date, fill in 2029-12-31
$has_sale_price = self::hasActiveSalePrice($product->sku);
if (!$value && $has_sale_price) {
$value = '2029-12-31';
}
// fall back to default past date if standard price is set
$standard_price = self::getStandardPriceForRow($product->sku);
if (!$value && $standard_price) {
$value = '2000-01-02';
}
// default past date
// if sale price is intentionally left blank by [---] shortcode, leave sale date blank as well
$sale_price = self::getSalePriceForRow($product->sku);
if (!$sale_price) {
$value = '';
}
break;
case 'minimum-seller-allowed-price':
$value = get_post_meta($post_id, '_amazon_minimum_price', true);
break;
case 'maximum-seller-allowed-price':
$value = get_post_meta($post_id, '_amazon_maximum_price', true);
break;
case 'quantity':
if (!$fba_enabled) {
$value = $product->product_type == 'variable' ? '' : intval($product->get_total_stock());
if ($value < 0) {
$value = 0;
}
// amazon doesn't allow negative values
}
break;
case 'fulfillment_latency':
// if qty is empty, make sure fulfillment_latency is empty as well (prevent error 99006)
$quantity = WPLA()->memcache->getColumnValue($product->sku, 'quantity');
if ($quantity === '') {
$value = '[---]';
}
if ($quantity === false) {
$value = '[---]';
}
break;
case 'bullet_point1':
$value = get_post_meta($product->id, '_amazon_bullet_point1', true);
break;
case 'bullet_point2':
$value = get_post_meta($product->id, '_amazon_bullet_point2', true);
break;
case 'bullet_point3':
$value = get_post_meta($product->id, '_amazon_bullet_point3', true);
break;
case 'bullet_point4':
$value = get_post_meta($product->id, '_amazon_bullet_point4', true);
break;
case 'bullet_point5':
$value = get_post_meta($product->id, '_amazon_bullet_point5', true);
break;
case 'generic_keywords1':
$value = get_post_meta($product->id, '_amazon_generic_keywords1', true);
break;
case 'generic_keywords2':
$value = get_post_meta($product->id, '_amazon_generic_keywords2', true);
break;
case 'generic_keywords3':
$value = get_post_meta($product->id, '_amazon_generic_keywords3', true);
break;
case 'generic_keywords4':
$value = get_post_meta($product->id, '_amazon_generic_keywords4', true);
break;
case 'generic_keywords5':
$value = get_post_meta($product->id, '_amazon_generic_keywords5', true);
break;
// case 'standard_price':
// $value = $product->get_price();
// break;
// case 'sale_price':
// $value = $product->get_sale_price();
// break;
// case 'standard_price':
// $value = $product->get_price();
// break;
// case 'sale_price':
// $value = $product->get_sale_price();
// break;
case 'main_image_url':
// $value = $product->get_image('full');
$attachment_id = get_post_thumbnail_id($post_id);
$image_url = wp_get_attachment_image_src($attachment_id, 'full');
$value = @$image_url[0];
// maybe fall back to parent variation featured image
if (empty($value) && $product->product_type == 'variation') {
$attachment_id = get_post_thumbnail_id($product->id);
$image_url = wp_get_attachment_image_src($attachment_id, 'full');
$value = @$image_url[0];
}
// if main image is disabled, use first enabled gallery image
$disabled_images = explode(',', get_post_meta($product->id, '_wpla_disabled_gallery_images', true));
if (in_array($attachment_id, $disabled_images)) {
// $gallery_images = $product->get_gallery_attachment_ids();
$gallery_images = WPLA_ProductWrapper::getGalleryAttachmentIDs($product);
$gallery_images = array_values(array_diff($gallery_images, $disabled_images));
$gallery_images = apply_filters('wpla_product_gallery_attachment_ids', $gallery_images, $post_id);
if (isset($gallery_images[0])) {
$image_url = wp_get_attachment_image_src($gallery_images[0], 'full');
$value = @$image_url[0];
}
}
$value = apply_filters('wpla_product_main_image_url', $value, $post_id);
$value = self::convertImageUrl($value);
break;
case 'other_image_url1':
case 'other_image_url2':
case 'other_image_url3':
case 'other_image_url4':
case 'other_image_url5':
case 'other_image_url6':
case 'other_image_url7':
case 'other_image_url8':
if ('skip' == get_option('wpla_product_gallery_first_image')) {
$image_index = substr($column, -1);
// skip first image
} else {
$image_index = substr($column, -1) - 1;
// include first image
}
// build list of enabled gallery images (attachment_ids)
$disabled_images = explode(',', get_post_meta($product->id, '_wpla_disabled_gallery_images', true));
// $gallery_images = $product->get_gallery_attachment_ids();
$gallery_images = WPLA_ProductWrapper::getGalleryAttachmentIDs($product);
$gallery_images = array_values(array_diff($gallery_images, $disabled_images));
$gallery_images = apply_filters('wpla_product_gallery_attachment_ids', $gallery_images, $post_id);
if (isset($gallery_images[$image_index])) {
$image_url = wp_get_attachment_image_src($gallery_images[$image_index], 'full');
$value = @$image_url[0];
$value = self::convertImageUrl($value);
}
break;
/* Inventory Loader (delete) feed columns */
/* Inventory Loader (delete) feed columns */
case 'add-delete':
$value = $item['status'] == 'trash' ? 'x' : 'a';
break;
/* Listing Loader feed columns */
/* Listing Loader feed columns */
case 'product-id':
$value = get_post_meta($post_id, '_wpla_asin', true);
break;
case 'product-id-type':
if ($matched_asin = get_post_meta($post_id, '_wpla_asin', true)) {
$value = 'ASIN';
} elseif ($custom_id_type = get_post_meta($post_id, '_amazon_id_type', true)) {
$value = $custom_id_type;
} else {
$value = '';
}
break;
case 'condition-type':
// update feed (ListingLoader - no profile)
$value = get_post_meta($product->id, '_amazon_condition_type', true);
// if this item was imported but has no product level condition, use original report value
if (!$value && $item['source'] == 'imported') {
$report_row = json_decode($item['details'], true);
if (is_array($report_row) && isset($report_row['item-condition'])) {
$value = WPLA_ImportHelper::convertNumericConditionIdToType($report_row['item-condition']);
}
}
if (!$value && !isset($profile_fields[$column])) {
$value = 'New';
// avoid an empty value for Offer feeds without profile
}
break;
case 'condition_type':
// new items feed
$value = get_post_meta($product->id, '_amazon_condition_type', true);
// if ( ! $value ) $value = 'New';
break;
case 'condition-note':
case 'condition_note':
// new items feed
$value = get_post_meta($product->id, '_amazon_condition_note', true);
break;
/* FBA */
/* FBA */
case 'fulfillment-center-id':
// ListingLoader
// ListingLoader
case 'fulfillment_center_id':
// Category Feed
if ($fba_enabled) {
$value = $item['fba_fcid'];
}
break;
/* variation columns */
/* variation columns */
case 'parent-sku':
case 'parent_sku':
if ($item['parent_id']) {
$parent_product = get_product($item['parent_id']);
if ($parent_product) {
$value = $parent_product->sku;
}
}
if ($variations_mode == 'flat') {
$value = '';
}
break;
case 'parentage':
case 'parent_child':
if ($product->product_type == 'variable') {
$value = 'parent';
} elseif ($product->product_type == 'variation') {
$value = 'child';
}
if ($variations_mode == 'flat') {
$value = '';
}
break;
case 'relationship-type':
case 'relationship_type':
if ($product->product_type == 'variation') {
$value = 'Variation';
}
if ($variations_mode == 'flat') {
$value = '';
}
break;
case 'variation-theme':
case 'variation_theme':
$value = str_replace('-', '', $item['vtheme']);
$value = self::convertToEnglishAttributeLabel($value);
if (strtolower($value) == 'colour') {
$value = 'Color';
}
if (strtolower($value) == 'colorsize') {
$value = 'SizeColor';
}
if (strtolower($value) == 'coloursize') {
$value = 'SizeColor';
}
if ($variations_mode == 'flat') {
$value = '';
}
if (isset($profile_fields[$column]) && !empty($profile_fields[$column])) {
$value = $profile_fields[$column];
}
break;
default:
# code...
break;
}
// handle variation attribute values / attribute columns
if (in_array($product->product_type, array('variation', 'variable'))) {
// if ( ( strpos( $column, '_name') > 0 ) || ( strpos( $column, '_type') > 0 ) ) {
if (substr($column, -5) == '_name' || substr($column, -5) == '_type') {
wpla_logger_start_timer('parseVariationAttributeColumn');
$value = self::parseVariationAttributeColumn($value, $column, $item, $product);
wpla_logger_end_timer('parseVariationAttributeColumn');
}
}
// forced empty value (fulfillment_latency)
// (why is '[---]' == 0 true? should be false - be careful...)
if ('[---]' === $value) {
return '';
}
// process profile fields - if not empty
if (!isset($profile_fields[$column]) || empty($profile_fields[$column])) {
return $value;
}
// empty shortcode overrides default value
if ('[---]' === $profile_fields[$column]) {
return '';
}
// use profile value as it is - if $value is still empty (ie. there is no product level value for this column)
if (empty($value)) {
$value = $profile_fields[$column];
}
// find and parse all placeholders
if (preg_match_all('/\\[([^\\]]+)\\]/', $value, $matches)) {
foreach ($matches[0] as $placeholder) {
// echo "<pre>processing ";print_r($placeholder);echo"</pre>";
wpla_logger_start_timer('parseProfileShortcode');
$value = self::parseProfileShortcode($value, $placeholder, $item, $product, $post_id, $profile);
wpla_logger_end_timer('parseProfileShortcode');
// echo "<pre>";print_r($value);echo"</pre>";#die();
}
}
// parent variations should only have certain columns
// these three seem to work on Amazon CA / Automotive: item_sku, parent_child, variation_theme
// but on US and DE, more columns are required:
// $parent_var_columns = array('item_sku','parent_child','variation_theme'); // CA
$parent_var_columns = array('item_sku', 'parent_child', 'variation_theme', 'brand_name', 'item_name', 'department_name', 'product_description', 'item_type', 'feed_product_type', 'bullet_point1', 'bullet_point2', 'bullet_point3', 'bullet_point4', 'bullet_point5', 'special_features1', 'special_features2', 'special_features3', 'special_features4', 'special_features5', 'style_name', 'closure_type', 'lifestyle', 'material_type', 'material_type1', 'pattern_type', 'model_year', 'shoe_dimension_unit_of_measure');
if ($product->product_type == 'variable' && !in_array($column, $parent_var_columns)) {
$value = '';
}
wpla_logger_end_timer('parseProductColumn');
return $value;
}
function meta_box_images()
{
global $post;
$this->add_inline_js();
?>
<style type="text/css">
#wpla-amazon-images .wpla_gallery_thumb_link {
float: left;
margin-right: 1em;
border: 1px solid #ccc;
}
#wpla-amazon-images .wpla_gallery_thumb_link:hover,
#wpla-amazon-images .wpla_gallery_thumb_link.disabled:hover {
border: 1px solid #555;
}
#wpla-amazon-images .wpla_gallery_thumb_link.disabled {
border: 1px solid #eee;
}
#wpla-amazon-images .wpla_gallery_thumb_link.disabled img {
opacity: 0.33;
}
#wpla-amazon-images .wpla_gallery_thumb_img {
width:79px;
}
</style>
<?php
// get disabled images as array of attachment_ids
$disabled_images = get_post_meta($post->ID, '_wpla_disabled_gallery_images', true);
$disabled_images = explode(',', $disabled_images);
// get featured image
$featured_image_id = get_post_thumbnail_id($post->ID);
// get gallery images
$product = get_product($post->ID);
$attachment_ids = WPLA_ProductWrapper::getGalleryAttachmentIDs($product);
// use featured image first, and merge gallery images
$attachment_ids = array_unique(array_merge(array($featured_image_id), $attachment_ids));
// process gallery images
$gallery_images = array();
foreach ($attachment_ids as $attachment_id) {
$src = wp_get_attachment_image_src($attachment_id, 'thumbnail');
//getting image source
$image = new stdClass();
$image->id = $attachment_id;
$image->src = $src[0];
$gallery_images[] = $image;
}
// output thumbnails
foreach ($gallery_images as $image) {
$css_class = in_array($image->id, $disabled_images) ? 'disabled' : '';
echo '<a href="#" class="wpla_gallery_thumb_link ' . $css_class . '" data-attachment_id="' . $image->id . '" title="' . basename($image->src) . '"/>';
echo '<img src="' . $image->src . '" class="wpla_gallery_thumb_img" data-attachment_id="' . $image->id . '"/>';
echo '</a>';
}
echo '<p style="clear:both;">';
echo '<small>';
echo __('Click an image to disable / enable it to be used on Amazon.', 'wpla');
echo '</small></p>';
echo '<div id="amazon_result_info" class="updated" style="display:none"><p></p></div>';
// echo "<pre>";print_r($disabled_images);echo"</pre>";#die();
// echo "<pre>";print_r($gallery_images);echo"</pre>";#die();
}
