/** * Gets the estimated fees and costs of a listing for eBay * */ private function getEstimatedListingCostsAction() { $productOptions = $_POST['productOptions']; $productCount = (int)$_POST['productCount']; $templateId = (int)$_POST['templateId']; $listingDate = $_POST['listingDate']; $scheduleDate = $_POST['scheduleDate']; $testProduct = array( 'productid' => 0, 'prodname' => 'Test Product', 'proddesc' => 'Description', 'prodcode' => 'SKU', 'prodprice' => 50.00, 'prodcondition' => 'New', 'prodweight' => 5, 'prodwidth' => 5, 'prodheight' => 5, 'proddepth' => 5, 'prodvariationid' => 0, ); try { $template = new ISC_ADMIN_EBAY_TEMPLATE($templateId); if ($listingDate == 'schedule') { $isoScheduleDate = date('c', $scheduleDate); $template->setScheduleDate($isoScheduleDate); } $result = ISC_ADMIN_EBAY_LIST_PRODUCTS::verifyListItem($testProduct, $template); // was there item level errors? we want to display those. if (!$result->isValid()) { $errorMessage = implode('<br />', $result->getErrors()); throw new Exception($errorMessage); } } catch (Exception $ex) { ISC_JSON::output(isc_html_escape($ex->getMessage()), false); } $firstFee = current($result->getFees()); $currencyCode = $firstFee['currency']; $currency = GetCurrencyByCode($currencyCode); $estimatedTotal = 0; $perItem = 0; $fees = array(); foreach ($result->getFees() as $fee) { if ($fee['fee'] == 0 || $fee['name'] == 'ListingFee') { continue; } $fees[] = array( 'name' => GetLang('EbayFee' . $fee['name']), 'fee' => $this->formatFee($fee['fee'], $currency) ); $perItem += $fee['fee']; } $quantityPerProduct = 1; if ($template->getSellingMethod() == ISC_ADMIN_EBAY::CHINESE_AUCTION_LISTING) { $quantityPerProduct = $template->getQuantityToSell(); } $this->template->assign('quantity', $quantityPerProduct); $itemCount = $productCount * $quantityPerProduct; // estimated total fees $itemsTotal = $perItem * $productCount; $grandTotal = $itemsTotal * $quantityPerProduct; $this->template->assign('fees', $fees); $this->template->assign('currencyCode', $currencyCode); $this->template->assign('itemsTotal', $this->formatFee($itemsTotal, $currency)); $this->template->assign('grandTotal', $this->formatFee($grandTotal, $currency)); $this->template->assign('perItem', $this->formatFee($perItem, $currency)); $this->template->assign('productCount', $productCount); $this->template->assign('itemCount', $itemCount); // build description of extra fees $extraFeesString = GetLang('EbayListingEstimatedCostsExtraFees'); $extraFees = array(); if ($template->getQuantityToSell() > $template->getTrueQuantityToSell()) { $extraFees[] = GetLang('EbayListingEstimatedCostsAuctionWarning', array('quantity' => $template->getQuantityToSell())); } $extraFees[] = GetLang('EbayListingEstimatedCostsFinalValueFee'); foreach ($extraFees as $x => $fee) { $extraFeesString .= "\n\n" . ($x + 1) . '. ' . $fee; } $out = array( 'html' => $this->template->render('ebay.listproducts.estimatedcosts.tpl'), 'extraFees' => $extraFeesString, ); ISC_JSON::output('', true, $out); }
public function perform() { // validate the listing if (!$this->_validateListing()) { $this->_logDebug('Listing validation failed.'); $this->_removeListing(); return; } $templateId = $this->_getListingData('templateid'); $where = $this->_getListingData('where'); $offset = $this->_getListingData('offset'); $listingDate = $this->_getListingData('listing_date'); $scheduleDate = $this->_getListingData('schedule_date'); $this->_logDebug('listing template Id ' . $templateId . ' starting from row ' . $offset . ' with batch size ' . self::BATCH_SIZE); // get the template object try { $template = new ISC_ADMIN_EBAY_TEMPLATE($templateId); } catch (Exception $ex) { $error = GetLang('Ebay_Listing_Log_TemplateNotFound', array('id' => $templateId)); $this->_logError($error); $this->_errorListing($error); $this->_endListing(); return; } $primaryOptions = $template->getPrimaryCategoryOptions(); $secondaryOptions = $template->getSecondaryCategoryOptions(); // did the user choose to schedule the listing for a future date? if ($listingDate == 'schedule') { $template->setScheduleDate($scheduleDate); } // query for the products to export $query = ISC_ADMIN_EBAY_LIST_PRODUCTS::getListQuery($where, self::BATCH_SIZE, $offset); $this->_logDebug('query', $query); $res = $this->_db->Query($query); if (!$res) { $error = GetLang('Ebay_Listing_Log_JobDatabaseError'); $this->_logError($error); $this->_errorListing($error); $this->_endListing(); return; } $successCount = 0; $warningCount = 0; $errorCount = 0; $connectFailCount = 0; // nothing left to list? $resultCount = $this->_db->CountResult($res); if ($resultCount == 0) { $this->_logDebug('no more items to list'); $this->_endListing(); return; } $productsToList = array(); while ($row = $this->_db->Fetch($res)) { // does this product have a variation? if ($row['prodvariationid']) { $variationError = ''; // if the primary category or selling method doesn't support them? if ((empty ($primaryOptions['variations_supported']) || (isset ($secondaryOptions['variations_supported']) && $secondaryOptions['variations_supported'] == 0)) || $template->getSellingMethod() == ISC_ADMIN_EBAY::CHINESE_AUCTION_LISTING) { $variationError = GetLang('EbayListingVariationsNotSupported'); } // does the product have more than 120 combinations (eBay max)? elseif (($totalCombinations = Store_Variations::getCombinationsCount($row['productid'], $row['prodvariationid'])) > 120) { $variationError = GetLang('EbayListingVariationCombinationsExceeded', array('totalCombinations' => $totalCombinations)); } // log error and skip this product if ($variationError) { $error = array( 'prodname' => $row['prodname'], 'time' => time(), 'message' => $variationError, ); $this->_keystore->set($this->_prefix . 'error:' . md5($row['productid'] . uniqid('', true)), ISC_JSON::encode($error)); $errorCount++; continue; } } // add any custom fields and configurable fields to the product ISC_ADMIN_EBAY_LIST_PRODUCTS::addCustomAndConfigurableFields($row); $productsToList[$row['productid']] = $row; } $itemsToAdd = 1; // for chinese auctions if we're selling more than one item, then create multiple items if ($template->getSellingMethod() == ISC_ADMIN_EBAY::CHINESE_AUCTION_LISTING && $template->getQuantityToSell() > 1) { $itemsToAdd = $template->getQuantityToSell(); } $thisBatchSize = $resultCount; $actualProcessed = $thisBatchSize * $itemsToAdd; $actualListed = count($productsToList) * $itemsToAdd; // don't have any products to list for this batch (would be due to disallowed variations)? if (empty($productsToList)) { $this->_keystore->increment($this->_prefix . 'error_count', $errorCount); $this->_keystore->increment($this->_prefix . 'actual_processed', $actualProcessed); $this->_keystore->increment($this->_prefix . 'offset', $thisBatchSize); $this->_logDebug('processed 0 items'); $this->_repeatListing(); return; } $this->_logDebug($actualListed . ' items to list', '<pre>' . var_export($productsToList, true) . '</pre>'); try { // list the items on eBay $results = array(); for ($x = 0; $x < $itemsToAdd; $x++) { $results = array_merge($results, ISC_ADMIN_EBAY_LIST_PRODUCTS::listItems($productsToList, $template)); } foreach ($results as /** @var ISC_ADMIN_EBAY_LIST_ITEM_RESULT */$result) { if (!$result->isValid()) { // log error $error = array( 'prodname' => $result->getProductName(), 'time' => time(), 'message' => implode('<br />', $result->getErrors()), ); $this->_keystore->set($this->_prefix . 'error:' . md5($result->getProductId() . uniqid('', true)), ISC_JSON::encode($error)); $errorCount++; continue; } // valid listing, but has errors if ($result->hasErrors()) { // log warning $error = array( 'prodname' => $result->getProductName(), 'time' => time(), 'message' => implode('<br />', $result->getErrors()), ); $this->_keystore->set($this->_prefix . 'warning:' . md5($result->getProductId() . uniqid('', true)), ISC_JSON::encode($error)); $warningCount++; } // ensure template has correct data set so we can calculate prices for the DB $template->setProductData($result->getProductData()); // add the new item to our local database $insertItem = array( 'product_id' => $result->getProductId(), 'ebay_item_id' => $result->getItemId(), 'title' => $result->getProductName(), 'start_time' => $result->getStartTimeISO(), 'end_time' => $result->getEndTimeISO(), 'datetime_listed' => time(), 'listing_type' => $template->getSellingMethod(), 'listing_status' => 'pending', // this will be updated to 'Active' when we receive ItemListed notification 'current_price_currency' => $template->getCurrencyCode(), 'current_price' => $template->getStartPrice(), 'buyitnow_price' => $template->getBuyItNowPrice(), 'buyitnow_price_currency' => $template->getCurrencyCode(), 'bid_count' => 0, 'quantity_remaining' => $template->getTrueQuantityToSell(), 'site_id' => $template->getSiteId(), ); $dbItemId = $this->_db->InsertQuery('ebay_items', $insertItem); // process the listing fees foreach ($result->getFees() as $fee) { $insertFee = array( 'item_id' => $dbItemId, 'name' => $fee['name'], 'amount' => $fee['fee'], 'currency_code' => $fee['currency'] ); $this->_db->InsertQuery('ebay_item_fees', $insertFee); } $successCount++; } } catch (ISC_EBAY_API_CONNECTION_EXCEPTION $ex) { // connection failed $connectFailCount++; // more than one connection failure? abort the listing if ($connectFailCount > 1) { $this->_abortListing(); } // did the entire request fail? $this->logBatchException($productsToList, $ex); $errorCount += $actualListed; } catch (ISC_EBAY_API_REQUEST_EXCEPTION $ex) { // did the entire request fail? $this->logBatchException($productsToList, $ex); $errorCount += $actualListed; } $this->_keystore->increment($this->_prefix . 'success_count', $successCount); $this->_keystore->increment($this->_prefix . 'warning_count', $warningCount); $this->_keystore->increment($this->_prefix . 'error_count', $errorCount); $this->_keystore->increment($this->_prefix . 'actual_processed', $actualProcessed); $this->_keystore->increment($this->_prefix . 'actual_listed', $actualListed); $this->_keystore->increment($this->_prefix . 'offset', $thisBatchSize); $this->_logDebug('processed ' . $actualListed . ' items'); $this->_repeatListing(); }