@Override
  public Boolean executeCall() throws Exception {

    String[] cols = {
      "Category",
      "Manufacturer", // * fields marked with * are mandatory and MUST be filled in
      "Title", // *
      "Product Description", //
      "Link", // *
      "Image", //
      "SKU", // *
      "Stock", //  they only update the feed every 2-3 days
      "Condition", //  New, Open Box, Refurbished, OEM, Used
      "Shipping Weight", //  in pounds
      "Shipping Cost", //  expects lowest available, value not required but useful if free shipping
                       // offered
      "Bid",
      "Promotional Description",
      "EAN/UPC", //  only really applies to entertainment goods
      "Price" // *
    };
    List<String[]> rows = new ArrayList<String[]>();
    BeanDao realizedProductDao = new BeanDao(RealizedProduct.class);
    if (EcommerceConfiguration.getEcommerceSettingsStatic().isProductListGroupByColour()) {
      realizedProductDao.setWhereCriteria("bean.productInfo.defaultRealizedProduct.id=bean.id");
    }
    realizedProductDao.addWhereCriteria("bean.productInfo.product.isShowingOnWebsite=1");
    List<RealizedProduct> realizedProducts =
        realizedProductDao.setIsReturningActiveBeans(true).getAll();
    Map<ProductInfo, ArrayList<ProductColour>> coloursCovered =
        new HashMap<ProductInfo, ArrayList<ProductColour>>();
    for (RealizedProduct realizedProduct : realizedProducts) {
      if (!EcommerceConfiguration.getEcommerceSettingsStatic().isProductListGroupByColour()) {
        ArrayList<ProductColour> currentColours =
            coloursCovered.get(realizedProduct.getProductInfo());
        if (currentColours == null) {
          currentColours = new ArrayList<ProductColour>();
        }
        if (!currentColours.contains(realizedProduct.getProductColour())) {
          currentColours.add(realizedProduct.getProductColour());
          coloursCovered.put(realizedProduct.getProductInfo(), currentColours);
        } else {
          // we dont want multiple where there are several sizes for this
          // colour/p.info combination
          continue;
        }
      }
      List<ProductType> productTypes =
          realizedProduct.getProductInfo().getProduct().getProductTypes();
      String category = "Misc.";
      String typeForUrl = null;
      for (ProductType type : productTypes) {
        typeForUrl = type.getMapping();
        if (typeForUrl == null || typeForUrl.equals("")) {
          typeForUrl = type.getMapping();
          if (typeForUrl == null || typeForUrl.equals("")) {
            typeForUrl = CommonUtil.makeSafeUrlMapping(type.getName());
          }
        }
      }

      String manufacturerName;
      // ordinarily we would use something like 'menswear' or 'sportswear' here not brand but
      // we cant determine it here so need to improvise to keep correct format and still make sense
      // to a user (for seo)
      String manufacturerNameForUrl;
      if (realizedProduct.getProductInfo().getProduct().getProductBrand() != null) {
        manufacturerName =
            realizedProduct.getProductInfo().getProduct().getProductBrand().getMapping();
        if (manufacturerName == null || manufacturerName.equals("")) {
          manufacturerName =
              realizedProduct.getProductInfo().getProduct().getProductBrand().getName();
        }
        manufacturerNameForUrl = CommonUtil.makeSafeUrlMapping(manufacturerName);
      } else {
        manufacturerName = "";
        manufacturerNameForUrl = CommonUtil.makeSafeUrlMapping(websiteName);
      }
      String title = realizedProduct.getProductInfo().getProduct().getName();
      String productDescription =
          CommonUtil.getStringOrEmpty(realizedProduct.getProductInfo().getShortDescription());
      if (!serverUrl.startsWith("http")) {
        serverUrl = "http://" + serverUrl;
      }
      if (!serverUrl.endsWith("/")) {
        serverUrl = serverUrl + "/";
      }
      if (contextPath.startsWith("/")) {
        contextPath = contextPath.substring(1);
      }
      if (!contextPath.endsWith("/")) {
        contextPath = contextPath + "/";
      }
      String serverContext = serverUrl + contextPath;
      serverContext = serverContext.replaceAll("//", "/");
      serverContext = serverContext.replaceAll("http:/", "http://");
      String urlToProductView =
          serverContext
              + manufacturerNameForUrl
              + "/"
              + typeForUrl
              + "/"
              + realizedProduct.getProductInfo().getMappingOrId()
              + ".aplos?type=product";
      String imageDetailsId = "missing";
      FileDetails largeImage = realizedProduct.getImageDetailsByKey("LARGE_IMAGE");
      if (largeImage != null) {
        imageDetailsId = String.valueOf(largeImage.getId());
      } else if (realizedProduct.getDefaultImageDetails() != null) {
        imageDetailsId = String.valueOf(realizedProduct.getDefaultImageDetails().getId());
      } else if (realizedProduct.getImageDetailsList() != null
          && realizedProduct.getImageDetailsList().size() > 0) {
        imageDetailsId = String.valueOf(realizedProduct.getImageDetailsList().get(0).getId());
      }

      String urlToImage = "";
      if (!imageDetailsId.equals("missing")) {
        urlToImage =
            serverContext
                + "media/?filename=realizedProductImages/"
                + imageDetailsId
                + "_large.jpg&provideDefaultIfMissing=true";
      }

      String sku = realizedProduct.determineItemCode();
      if (sku == null || sku.equals("")) {
        // not all sites use item codes but we have to pass one, so invent one
        sku = realizedProduct.getProductInfo().getId() + "SKU";
        sku += realizedProduct.getId();
        if (!EcommerceConfiguration.getEcommerceSettingsStatic().isProductListGroupByColour()
            && realizedProduct.getProductColour() != null) {
          sku += "C" + realizedProduct.getProductColour().getId();
        }
      }
      String stock = "";
      String condition = "New";
      String shippingWeight = FormatUtil.formatTwoDigit(realizedProduct.determineWeight());
      // there's way too many factors to consider for shipping cost, so i'm only going to pass a
      // value
      String shippingCost = "";
      if (isFreeShippingAvailable(realizedProduct.getProductInfo())) {
        shippingCost = "0";
      }
      String bid = "";
      String promotionalDescription = "";
      String eanUpc =
          String.valueOf(
              realizedProduct
                  .getProductInfo()
                  .getId()); // we might want to use isbn etc if this were a book
      String price;
      if (realizedProduct.getSitewideDiscount() != null) {
        price =
            FormatUtil.formatTwoDigit(
                realizedProduct
                    .getPrice()
                    .subtract(
                        realizedProduct
                            .getPrice()
                            .divide(new BigDecimal(100))
                            .multiply(realizedProduct.getSitewideDiscount())));
      } else {
        price = realizedProduct.getPriceStr();
      }
      rows.add(
          new String[] {
            category,
            manufacturerName,
            title,
            productDescription,
            urlToProductView,
            urlToImage,
            sku,
            stock,
            condition,
            shippingWeight,
            shippingCost,
            bid,
            promotionalDescription,
            eanUpc,
            price
          });
    }
    try {
      // this is relative to webroot - so that it can be accessed as a feed
      String filename = "tab-delimited-feed.txt";
      FileIoUtil.generateTabDelimitedFile(filename, cols, rows);
    } catch (InputMismatchException ime) {
      ime.printStackTrace();
    }
    return true;
  }
 private boolean isFreeShippingAvailable(ProductInfo productInfo) {
   return EcommerceConfiguration.getEcommerceSettingsStatic().isEverythingFreeShipping()
       || (productInfo.getIsFreePostage() == true
           || (productInfo.getProduct().getProductBrand() != null
               && productInfo.getProduct().getProductBrand().getIsFreePostage() == true));
 }