function autoProcessNewReport()
 {
     global $wpdb;
     $table = $wpdb->prefix . self::TABLENAME;
     if (!$this->id) {
         return;
     }
     // skip empty reports
     if ($this->ReportProcessingStatus == '_DONE_NO_DATA_') {
         $wpdb->update($table, array('success' => 'empty'), array('id' => $this->id));
         return;
     }
     if ($this->ReportProcessingStatus == '_CANCELLED_') {
         $wpdb->update($table, array('success' => 'empty'), array('id' => $this->id));
         return;
     }
     // _GET_AFN_INVENTORY_DATA_
     if ($this->ReportType == '_GET_AFN_INVENTORY_DATA_') {
         $rows = $this->get_data_rows();
         WPLA_ImportHelper::processFBAReportPage($this, $rows, null, null);
         $wpdb->update($table, array('success' => 'yes'), array('id' => $this->id));
         return;
     }
     // inventory report - only process if daily report option is enabled
     // _GET_MERCHANT_LISTINGS_DATA_
     if ($this->ReportType == '_GET_MERCHANT_LISTINGS_DATA_') {
         if (get_option('wpla_autofetch_inventory_report') != 1) {
             return;
         }
         $rows = $this->get_data_rows();
         WPLA_ImportHelper::processInventoryReportPage($this, $rows, null, null);
         $wpdb->update($table, array('success' => 'yes'), array('id' => $this->id));
         return;
     }
     // FBA shipping report - only process if multichannel fulfillment is enabled
     // _GET_AMAZON_FULFILLED_SHIPMENTS_DATA_
     if ($this->ReportType == '_GET_AMAZON_FULFILLED_SHIPMENTS_DATA_') {
         if (get_option('wpla_fba_autosubmit_orders') != 1) {
             return;
         }
         $rows = $this->get_data_rows();
         WPLA_ReportProcessor::processAmazonShipmentsReportPage($this, $rows, null, null);
         $wpdb->update($table, array('success' => 'yes'), array('id' => $this->id));
         return;
     }
     // _GET_MERCHANT_LISTINGS_DEFECT_DATA_
     if ($this->ReportType == '_GET_MERCHANT_LISTINGS_DEFECT_DATA_') {
         $rows = $this->get_data_rows();
         WPLA_ImportHelper::processQualityReportPage($this, $rows, null, null);
         $wpdb->update($table, array('success' => 'yes'), array('id' => $this->id));
         return;
     }
 }
                            <input id="wpla_current_page" type="hidden" value="1" />
                            <input id="wpla_total_pages" type="hidden" value="<?php 
echo intval(count($wpl_report_summary->report_skus) / 100);
?>
" />
                            <a id="wpla_prev_page" class="button button-small" title="previous page">&laquo;</a>
                            <a id="wpla_next_page" class="button button-small" title="next page">&raquo;</a>
                            <input id="wpla_import_preview_search_box" type="text" placeholder="Filter by SKU, ASIN or name..." style="font-size: 12px; font-weight: normal; width:200px;">
                            <a href="#" id="wpla_btn_filter" class="button button-small" title="apply filter">Search</a>
                        </div>
                    </h3>
					<div class="inside">

                        <div id="wpla_import_preview_table_container">
                            <?php 
WPLA_ImportHelper::render_import_preview_table($wpl_data_rows, $wpl_report_summary);
?>
                        </div>

						<!-- <p> -->
							<!-- Note: This preview shows a maxmimum of 100 rows only. -->
						<!-- </p> -->

                        <?php 
// $max_num_pages = intval( count($wpl_report_summary->report_skus) / 100 );
// $page = 1;
// echo paginate_links( array(
//     // 'base'    => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ),
//     // 'format'  => '?paged=%#%',
//     'current' => max( 1, $page ),
//     'total'   => $max_num_pages
 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;
 }
 public function updateProductFromItem($item, $report_row)
 {
     global $woocommerce;
     WPLA()->logger->info("==============================================================================");
     //WPLA()->logger->info( "updateProductFromItem() - ID: ".$data['asin'] );
     // some shortcuts
     $asin = $item->asin;
     $product_id = $item->post_id;
     $amazon_name = $item->listing_title;
     $amazon_price = $item->price;
     $amazon_quantity = $item->quantity;
     $report_quantity = $report_row['quantity'];
     $updated = false;
     // get WC product for reference
     $product = $this->getProduct($product_id);
     if (!$product) {
         return;
     }
     // echo "<pre>";print_r($product);echo"</pre>";#die();
     // get options
     $reports_update_woo_stock = get_option('wpla_reports_update_woo_stock', 1) == 1 ? true : false;
     $reports_update_woo_price = get_option('wpla_reports_update_woo_price', 1) == 1 ? true : false;
     $reports_update_woo_condition = get_option('wpla_reports_update_woo_condition', 1) == 1 ? true : false;
     //
     // update item-condition - if enabled
     //
     if ($reports_update_woo_condition) {
         $amazon_condition_type = WPLA_ImportHelper::convertNumericConditionIdToType($report_row['item-condition']);
         update_post_meta($product_id, '_amazon_condition_type', $amazon_condition_type);
         $amazon_condition_note = WPLA_ListingsModel::convertToUTF8($report_row['item-note']);
         update_post_meta($product_id, '_amazon_condition_note', $amazon_condition_note);
         WPLA()->logger->info("updated condition for product {$product_id}: {$amazon_condition_type} / " . $amazon_condition_note);
         // WPLA()->logger->info( "stored condition note: " . get_post_meta( $product_id, '_amazon_condition_note', true ) );
     }
     //
     // update price - if enabled
     //
     if ($reports_update_woo_price) {
         // if this item has a profile, we need to apply the price modifiers to the product price
         $product_price = $product->price;
         $profile = $item->profile_id ? new WPLA_AmazonProfile($item->profile_id) : false;
         if ($profile) {
             $product_price = $profile->processProfilePrice($product_price);
             $amazon_price = $profile->reverseProfilePrice($amazon_price);
         }
         // update price - unless custom amazon price is set
         if ($product_price != $amazon_price) {
             if (!get_post_meta($product_id, '_amazon_price', true)) {
                 update_post_meta($product_id, '_price', $amazon_price);
                 update_post_meta($product_id, '_regular_price', $amazon_price);
                 WPLA()->logger->info("updated price for product {$product_id} - new price: " . $amazon_price);
                 $updated = true;
             }
         }
     }
     // if update price
     //
     // update stock - if enabled and the report quantity column is not empty
     //
     if ($reports_update_woo_stock && $report_quantity !== '' && $report_quantity !== false) {
         if ($product->stock != $amazon_quantity) {
             update_post_meta($product_id, '_stock', $amazon_quantity);
             WPLA()->logger->info("updated stock for product {$product_id} - new stock: " . $amazon_quantity);
             $updated = true;
         }
         // update out of stock attribute
         if ($amazon_quantity > 0) {
             $stock_status = 'instock';
         } elseif ($item->product_type == 'variable') {
             $stock_status = 'instock';
         } else {
             $stock_status = 'outofstock';
         }
         update_post_meta($product_id, '_stock_status', $stock_status);
     }
     if ($updated) {
         // $woocommerce->clear_product_transients( $product_id );
         if (function_exists('wc_delete_product_transients')) {
             wc_delete_product_transients($product_id);
         }
         WPLA()->logger->info("updated product {$product_id} ({$asin}): {$amazon_name} ");
         $this->updated_count++;
     }
     return $product_id;
 }
 public function jobs_run_task()
 {
     // quit if no job name provided
     if (!isset($_REQUEST['job'])) {
         return false;
     }
     if (!isset($_REQUEST['task'])) {
         return false;
     }
     $job = $_REQUEST['job'];
     $task = $_REQUEST['task'];
     // register shutdown handler
     global $wpla_shutdown_handler_enabled;
     $wpla_shutdown_handler_enabled = true;
     register_shutdown_function(array($this, 'shutdown_handler'));
     WPLA()->logger->info('running task: ' . print_r($task, 1));
     // handle job name
     switch ($task['task']) {
         // update listing from Amazon (current used for new listings without ASIN)
         case 'updateProduct':
             // init
             $lm = new WPLA_ListingsModel();
             $listing = $lm->getItem($task['id']);
             $account = WPLA_AmazonAccount::getAccount($listing['account_id']);
             $api = new WPLA_AmazonAPI($account->id);
             // get product attributes
             // $product = $api->getProduct( $listing['asin'] );
             $result = $api->getMatchingProductForId($listing['sku'], 'SellerSKU');
             // echo "<pre>";print_r($product);echo"</pre>";#die();
             // echo "<pre>";print_r($product);echo"</pre>";die();
             if ($result->success) {
                 if (!empty($result->product->ASIN)) {
                     // update listing attributes
                     $listing_id = $listing['id'];
                     // $lm->updateItemAttributes( $product, $listing_id );
                     // $listing = $lm->getItem( $listing_id ); // update values
                     $lm->updateWhere(array('id' => $listing_id), array('asin' => $result->product->ASIN));
                     WPLA()->logger->info('new ASIN for listing #' . $listing['id'] . ': ' . $result->product->ASIN);
                     // update product
                     // $woo = new WPLA_ProductBuilder();
                     // $woo->updateProducts( array( $listing ) );
                     $success = true;
                     $errors = '';
                 } else {
                     $errors = sprintf(__('There was a problem fetching product details for %s.', 'wpla'), $listing['asin']);
                     $errors .= ' The product data received from Amazon was empty.';
                     $success = false;
                 }
             } elseif ($result->Error->Message) {
                 $errors = sprintf(__('There was a problem fetching product details for %s.', 'wpla'), $listing['asin']) . '<br>Error: ' . $result->Error->Message;
                 $success = false;
             } else {
                 $errors = sprintf(__('There was a problem fetching product details for %s.', 'wpla'), $listing['asin']);
                 $success = false;
             }
             // build response
             $response = new stdClass();
             $response->job = $job;
             $response->task = $task;
             $response->errors = empty($errors) ? array() : array(array('HtmlMessage' => $errors));
             $response->success = $success;
             $this->returnJSON($response);
             exit;
             // create new WooCommerce product from imported listing
         // create new WooCommerce product from imported listing
         case 'createProduct':
             // init
             $lm = new WPLA_ListingsModel();
             // $listing = $lm->getItem( $task['id'] );
             $listing_id = $task['id'];
             // create product
             $ProductsImporter = new WPLA_ProductsImporter();
             $success = $ProductsImporter->createProductFromAmazonListing($listing_id);
             $error = $ProductsImporter->lastError;
             $delay = $ProductsImporter->request_count * 1000;
             // ms
             // build response
             $response = new stdClass();
             $response->job = $job;
             $response->task = $task;
             $response->errors = empty($error) ? array() : array(array('HtmlMessage' => $error));
             $response->success = $success;
             $response->delay = $delay;
             $this->returnJSON($response);
             exit;
             // fetch full product description from Amazon and update WooCommerce product
         // fetch full product description from Amazon and update WooCommerce product
         case 'fetchFullProductDescription':
             $webHelper = new WPLA_AmazonWebHelper();
             $webHelper->loadListingDetails($task['id']);
             // echo "<pre>";print_r($webHelper->images);echo"</pre>";#die();
             $lm = new WPLA_ListingsModel();
             $item = $lm->getItem($task['id']);
             if (!empty($webHelper->description)) {
                 // update product
                 $post_id = $item['post_id'];
                 $post_data = array('ID' => $post_id, 'post_content' => trim($webHelper->description));
                 wp_update_post($post_data);
                 $success = true;
                 $errors = '';
             } else {
                 $errors = sprintf(__('There was a problem fetching product details for %s.', 'wpla'), $item['asin']);
                 $errors .= ' The product description received from Amazon was empty.';
                 $success = false;
             }
             // build response
             $response = new stdClass();
             $response->job = $job;
             $response->task = $task;
             $response->errors = empty($errors) ? array() : array(array('HtmlMessage' => $errors));
             $response->success = $success;
             $this->returnJSON($response);
             exit;
             // process Merchant or FBA Report and create / update listings
         // process Merchant or FBA Report and create / update listings
         case 'processReportPage':
             // process report page - both Merchant and FBA reports
             $response = WPLA_ImportHelper::ajax_processReportPage($job, $task);
             $this->returnJSON($response);
             exit;
             // process single row (SKU) Merchant or FBA Report - and create / update listings
         // process single row (SKU) Merchant or FBA Report - and create / update listings
         case 'processSingleSkuFromReport':
             // process report page - both Merchant and FBA reports
             $response = WPLA_ImportHelper::ajax_processReportPage($job, $task, true);
             $this->returnJSON($response);
             exit;
         default:
             // echo "unknown task";
             // exit();
     }
 }
Ejemplo n.º 6
0
 public function displayPreviewImportPage($step)
 {
     // analyse report content
     $report = new WPLA_AmazonReport($_REQUEST['report_id']);
     $account = new WPLA_AmazonAccount($report->account_id);
     $report_summary = WPLA_ImportHelper::analyzeReportForPreview($report);
     $status_summary = WPLA_ListingsModel::getStatusSummary();
     // skip step 3 if no products are to be imported
     // if ( $step == 3 && count($report_summary->products_to_import) == 0 ) {
     if ($step == 3 && intval(@$status_summary->imported) == 0) {
         return $this->displayFinishedImportPage();
     }
     $aData = array('plugin_url' => self::$PLUGIN_URL, 'message' => $this->message, 'step' => $step, 'report_summary' => $report_summary, 'status_summary' => $status_summary, 'account' => $account, 'report_id' => $report->id, 'data_rows' => $report->get_data_rows(), 'reports_update_woo_stock' => get_option('wpla_reports_update_woo_stock', 1), 'reports_update_woo_price' => get_option('wpla_reports_update_woo_price', 1), 'reports_update_woo_condition' => get_option('wpla_reports_update_woo_condition', 1), 'form_action' => 'admin.php?page=' . self::ParentMenuId . '-import');
     $this->display('import/preview_import_page', $aData);
 }