AdminProductMgr (KonaKartAdmin API Documentation)

java.lang.Object
- com.konakartadmin.bl.AdminBaseMgr
- - com.konakartadmin.bl.AdminProductMgr

All Implemented Interfaces:

AdminProductMgrIf

Direct Known Subclasses:

AdminProductMgrEE
```
public class AdminProductMgr
extends AdminBaseMgr
implements AdminProductMgrIf
```
The AdminProductMgr - for Managing Product Objects for the Admin Application

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`protected class`	`AdminProductMgr.AttributeSortOrderComparator` Used to sort the AdminProductAttribute objects based on option id and then option value id
`protected class`	`AdminProductMgr.OptionSortOrderComparator` Used to sort the Option objects based on option id
`protected class`	`AdminProductMgr.StaticData` Static Data Object

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ACCESSORY` Accessories
`static int`	`BOOKABLE_PRODUCT_TYPE` Bookable product
`static int`	`BUNDLED_PRODUCTS` Bundled products
`protected static int`	`CAT_PRICE_ATTR` Used by insertProductPriceForCatalog
`protected static int`	`CAT_PRICE_PROD` Used by insertProductPriceForCatalog
`protected static int`	`CAT_PRICE_TIER` Used by insertProductPriceForCatalog
`protected static int`	`CAT_PRICE_VARIANT` Used by insertProductPriceForCatalog
`protected static int`	`CAT_PROD_READ_LIMIT` Used by insertProductPriceForCatalog
`static int`	`CROSS_SELL` Cross Sell related products
`static java.lang.Boolean`	`customAttrAnOracleCLOB` is Oracle CLOB used for custom_attrs column on the products table?
`static int`	`DEPENDENT_ITEM` Dependent items, such as warranties
`static int`	`DIGITAL_DOWNLOAD` Digital download product
`static int`	`DONT_INCLUDE` Used to not include values in the query
`static int`	`GIFT_CERTIFICATE_PRODUCT_TYPE` Gift Certificate product
`protected static org.apache.commons.logging.Log`	`log` the log
`protected static java.lang.String`	`mutex` Mutex for this manager
`protected static java.util.Map<java.lang.String,AdminProductMgr.StaticData>`	`staticDataHM` Hash Map that contains the static data
`static int`	`UP_SELL` Up Sell related products
`static int`	`VIRTUAL_PRODUCT_TYPE` Virtual product

Fields inherited from class com.konakartadmin.bl.AdminBaseMgr
adminEng, baseMgrMutex, baseStaticDataHM, cDataEnd, cDataStart, debugStackTraceExclusions, kkAdminPropsFilePath, kkConf, kkInstanceId, mgrFactory, STORE_ID, templateBaseDir

Constructor Summary

Constructors
Constructor and Description

AdminProductMgr(KKAdminIf eng)
Constructor

Constructors
Constructor and Description
`AdminProductMgr(KKAdminIf eng)` Constructor

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addCatalogRules(java.lang.String catalogId, AdminCatalogRule[] rules)` The purpose of this method is to add an array of rules to a catalog so that it can be created automatically by the `createCatalogPricesFromRules()` method.
`protected void`	`addDigitalDownloadOrderBy(com.konakart.db.KKCriteria c, AdminDigitalDownloadSearch search)`
`protected int`	`addDigitalDownloadSearchCriteria(com.konakart.db.KKCriteria c, AdminDigitalDownloadSearch search)`
`protected void`	`addProductImageFields(com.konakart.db.KKCriteria c)`
`protected void`	`addProductOptionOrderBy(com.konakart.db.KKCriteria c, AdminProductOptionSearch search)` Add order by constraints for ProductOptions
`protected int`	`addProductOptionSearchCriteria(com.konakart.db.KKCriteria c, AdminProductOptionSearch search, int langId)` Add search criteria for ProductOptions
`void`	`addRelatedProducts(AdminProduct[] products, int productId, int relationType)` Add the array of products to the product defined by productId.
`void`	`addRelatedProductsWithOptions(AdminProduct[] products, int productId, int relationType, AdminProductMgrOptions mgrOptions)` Add the array of products to the product defined by productId.
`protected java.util.List<AdminProductAttribute>`	`convertProdAttrArrayToOrderedList(AdminProductAttribute[] prodAttrs)`
`protected void`	`copyProductPrices(AdminProduct prodFrom, AdminProduct prodTo)` This copies the prices between two identical products.
`int`	`copyProductToStore(int productId, java.lang.String storeIdFrom, java.lang.String storeIdTo, AdminCopyProductOptions options)` Copies a product from the store referenced by storeIdFrom to the store referenced by storeIdTo .
`AdminCreateCatalogPricesResult`	`createCatalogPricesFromRules(java.lang.String catalogId, AdminCreateCatalogPriceOptions options)` This method populates a catalog with product prices based on rules that have been previously added using the `addCatalogRules()` method.
`protected java.lang.String`	`createEncodedProductIdFromProductQuantityEncodedKey(int productId, java.lang.String productQuantityEncodedKey)` Takes in a productQuantityEncodedKey and a productId and returns an encoded product Id.
`protected java.lang.String`	`createProductQuantityEncodedKeyFromOptions(AdminOption[] opts)` Takes in an an array of options and returns an encoded key for the products_quantity table
`protected java.lang.String`	`decodeVariantCodeFromOptionAndValue(java.lang.String encodedOptionValue, java.sql.Connection con)` Used to process an encoded option value used in KonaKart to get a piece of variant code string
`protected java.lang.String`	`decodeVariantCodeFromOptionsAndValues(java.lang.String encodedOptionValues, java.sql.Connection con)` Used to process the encoded option values used in KonaKart to get the variant code string.
`void`	`deleteCatalog(int catalogId)` Delete a Catalog definition from the database
`void`	`deleteCatalogPrices(java.lang.String catalogName)` Delete all the prices in the specified catalog
`void`	`deleteCatalogWithOptions(int catalogId, AdminDeleteCatalogOptions options)` Delete a Catalog definition from the database with Options
`void`	`deleteDirectProductsPerCategory(int categoryId)` If the category has any products directly associated with it, then they are deleted.
`protected void`	`deleteExtPrice(int productId, int prodAttrId, int tierPriceId, java.lang.String catalogId, java.lang.String productOptions, com.konakart.db.KKCriteria deleteC, java.sql.Connection con)` Used to delete a price in the external price table.
`protected void`	`deleteExtQuantity(int productId, java.lang.String encodedOptionValues, java.lang.String catalogId, com.konakart.db.KKCriteria deleteC, java.sql.Connection con)` Used to delete and external quantity record
`void`	`deleteProduct(int productId)` Delete the product referenced to by productId.
`void`	`deleteProductAttribute(int productAttributeId)` Delete the productAttribute
`void`	`deleteProductAttributesPerProduct(int productId)` Delete the productAttributes Per product
`void`	`deleteProductOptions(int productOptionId)` Delete a product option record for all languages and all of its records in the options values to options table and all of its values
`void`	`deleteProductOptionValues(int productOptionValueId)` Delete a product option value record for all languages and all of its records in the options values to options table
`void`	`deleteProducts(AdminCommonOptions options)` Delete the products referenced by the options parameter.
`void`	`deleteProductsPerCategory(int categoryId)` Products are deleted for the category and sub category.
`void`	`deleteProductsPerManufacturer(int manufacturerId)` If the manufacturer has any products directly associated with it, then they are deleted.
`void`	`deleteSpecial(int specialId)` Delete the special referenced to by specialId.
`protected boolean`	`doesExtPriceExist(int productId, int prodAttrId, int tierPriceId, java.lang.String catalogId, java.lang.String productOptions, com.konakart.db.KKCriteria selectC)` Returns true if the external price record exists
`protected boolean`	`doesExtPriceExist(int productId, int prodAttrId, int tierPriceId, java.lang.String catalogId, java.lang.String productOptions, com.konakart.db.KKCriteria selectC, java.sql.Connection con)` Returns true if the external price record exists
`protected boolean`	`doesExtQuantityExist(int productId, java.lang.String encodedOptionValues, java.lang.String catalogId, com.konakart.db.KKCriteria selectC)` Returns true if the external quantity record exists
`protected boolean`	`doesExtQuantityExist(int productId, java.lang.String encodedOptionValues, java.lang.String catalogId, com.konakart.db.KKCriteria selectC, java.sql.Connection con)` Returns true if the external quantity record exists
`boolean`	`doesProductExist(int productId)` Return true if the product exists.
`boolean`	`doesProductExist(int productId, java.sql.Connection con)` Return true if the product exists.
`protected boolean`	`doesSpecialExist(int productId)` Determines whether a special exists for this product
`protected boolean`	`doesSpecialExist(int productId, java.sql.Connection con)` Determines whether a special exists for this product
`protected void`	`editCustAttrTemplates(AdminProduct product, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC)` protected method to edit the product template links
`protected void`	`editExtPrice(AdminProduct product, java.lang.String catalogId, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria updateC, java.sql.Connection con)` Used to edit a price in the external price table.
`protected void`	`editExtProdAttrPrice(AdminProductAttribute prodAttr, java.lang.String catalogId, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria updateC, java.sql.Connection con)` Used to edit a product attribute price in the external price table.
`protected void`	`editExtQuantity(AdminProductQuantity prodQ, java.lang.String catalogId, boolean setQuantity, boolean setDate, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria updateC, java.sql.Connection con)` Used to edit a quantity in the external quantity table.
`protected void`	`editExtTierPrice(AdminTierPrice tierPrice, java.lang.String catalogId, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria updateC, java.sql.Connection con)` Used to edit a product tier price in the external price table.
`protected void`	`editExtVariantPrice(AdminVariantPrice variantPrice, java.lang.String catalogId, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria updateC, java.sql.Connection con)` Used to edit a product variant prices in the external price table.
`protected void`	`editMiscPrices(AdminProduct product, java.sql.Connection con)` Edit the Misc prices within the Transaction.
`void`	`editProduct(AdminProduct product)` Edit a product and its product description objects
`void`	`editProductAttribute(AdminProductAttribute prodAttr)` Edits the product attribute
`protected java.util.HashMap<java.lang.String,java.lang.String>`	`editProductAttributes(AdminProduct product, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog)` protected method to edit the product attribute records
`protected void`	`editProductDescriptions(AdminProduct product, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC, AdminProductMgrOptions mgrOptions)` protected method to edit the product descriptions
`void`	`editProductOption(AdminProductOption productOption)` Edit a product option
`void`	`editProductOptionValue(AdminProductOptionValue productOptionValue)` Edit a product option value
`protected void`	`editProductQuantities(AdminProduct product, java.util.HashMap<java.lang.String,java.lang.String> prodAttrMap, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC, AdminProductMgrOptions mgrOptions)` protected method to edit the product quantity records
`protected void`	`editProductToCategory(AdminProduct product, java.sql.Connection con)` Edit the product to category records
`void`	`editProductWithOptions(AdminProduct product, AdminProductMgrOptions mgrOptions)` Edit a product and its product description objects.
`protected void`	`editProductWithOptions(AdminProduct product, AdminProductMgrOptions mgrOptions, boolean setMasterDate, boolean allStores, boolean manageSolr, java.sql.Connection conIn)` Edit a product and its product description objects.
`void`	`editSpecial(AdminSpecial special)` Edit a special
`protected void`	`editSpecial(AdminSpecial special, java.sql.Connection con)` Edit a special using a transaction already open
`protected void`	`editTierPrices(AdminProduct product, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog)` protected method to edit the tier price records
`protected void`	`editVariantPrices(AdminProduct product, java.util.HashMap<java.lang.String,java.lang.String> prodAttrMap, java.sql.Connection con, com.konakart.db.KKCriteria selectC, com.konakart.db.KKCriteria deleteC, com.konakart.db.KKCriteria updateC, com.konakart.db.KKCriteria insertC, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog)` protected method to edit the variant price records
`protected java.lang.String`	`encodeOptionsAndValuesFromVariantCode(java.lang.String variantCode, java.sql.Connection con)` Used to process the variant code from ESP to get an encoded options values used in KonaKart
`protected void`	`formatProductPrices(AdminProduct product)` Format the prices of the product object
`AdminProductOption[]`	`getAllProductOptions(int languageId)` Returns a list of product options.
`AdminProductOptionValue[]`	`getAllProductOptionValues(int languageId)` Get an array of all the product option value objects for the specified language
`AdminProducts`	`getAllSpecials(AdminDataDescriptor dataDesc, int languageId)` Return all products with a special price
`AdminProduct`	`getBundleProductDetails(int bundleId, AdminProduct[] bundledProductsArray, AdminDiscount discount)` This method is used to calculate some attributes of a bundle product based on the products that the bundle contains.
`AdminProduct`	`getBundleProductDetails(int bundleId, AdminProduct[] bundledProductsArray, AdminDiscount discount, java.sql.Connection con)` This method is used to calculate some attributes of a bundle product based on the products that the bundle contains.
`AdminCatalog`	`getCatalogById(int catalogId)` Fetch a catalog from the database referenced by the catalog id
`protected int`	`getCatalogCount(com.konakart.db.KKCriteria c)` Get the number of catalogs
`AdminCatalogRule[]`	`getCatalogRules(java.lang.String catalogId)` Fetches an array of catalog rules for a given catalog.
`AdminCatalogSearchResult`	`getCatalogs(AdminCatalogSearch search, int offset, int size)` Get an array of catalogs matching the search criteria from the database
`protected KKAdminException`	`getCombinedExceptionStack(java.lang.String msg, KKAdminException currentStack, java.lang.Exception e)` If there's a previous exception we convert that to a String and create a new exception using that String representation of the previous exception and this exception with it's current stack.
`protected int`	`getCount(com.konakart.db.KKCriteria c, boolean fixQuery)` This method is mainly used for paging.
`protected int`	`getCount(com.konakart.db.KKCriteria c, boolean fixQuery, java.sql.Connection con)` This method is mainly used for paging.
`protected java.lang.String`	`getCustomAttrs(int productId)` Get the custom_attrs for the product with the specified Id.
`protected java.lang.String`	`getCustomAttrs(int productId, java.sql.Connection con)` Get the custom_attrs for the product with the specified Id.
`protected AdminDigitalDownload`	`getDigitalDownload(int customerId, int productId)` Returns a Digital Download object for the customerId and productId passed in as parameters.
`protected java.util.Date`	`getExpiryDate(int maxDownloadDays)` Common code to get the expiry date
`protected java.lang.String`	`getFuturePriceCatalogId(java.lang.String catalogId, java.util.Date futureRoundedDate, java.lang.String futureDateFormat)` Create the id of the catalog used to store future prices
`protected int`	`getMappedProductId(int idFrom, java.lang.String storeIdTo)` Returns the idTo if the product exists in storeIdTo.
`protected int`	`getMaxDownloadDays(AdminProduct prod)` Common code to get the maximum number of download days
`protected int`	`getMaxNumDownloads(AdminProduct prod)` Common code to get the maximum number of downloads
`AdminMiscItem[]`	`getMiscItems(AdminSearch search)` Get the MiscItems associated with the specified search criteria
`AdminMiscItem[]`	`getMiscItems(AdminSearch search, java.sql.Connection con)` Get the MiscItems associated with the specified search criteria
`AdminMiscItem[]`	`getMiscItems(int productId)` Get the MiscItems associated with the specified productId
`AdminMiscItem[]`	`getMiscItems(int productId, java.sql.Connection con)` Get the MiscItems associated with the specified productId
`java.util.HashMap<java.lang.Integer,java.util.ArrayList<AdminMiscItem>>`	`getMiscItemsHash(AdminSearch search)` Get the MiscItems associated with the specified search criteria
`AdminMiscPrice[]`	`getMiscPrices(int productId)` Get the Misc Prices associated with the specified productId
`AdminMiscPrice[]`	`getMiscPrices(int productId, java.sql.Connection con)` Get the Misc Prices associated with the specified productId
`protected int`	`getNewQuantity(int currentQuantity, int newQuantity, int operation)` Utility method used by setProductQuantity()
`int`	`getNextProductOptionId()` Get the next id to use when inserting a ProductOption record
`int`	`getNextProductOptionValuesId()` Get the next id to use when inserting a ProductOptionValue record
`protected java.lang.String`	`getP2PHash(AdminProductToProduct p2p)` Returns a unique value for the productToProduct so that we can compare them
`protected java.lang.String`	`getPriceCatalogToUse(AdminProductMgrOptions mgrOptions)` If we are inserting a price for a future date then we insert it into a different catalog which may already exist.
`protected java.math.BigDecimal[]`	`getPriceFromEncodedOptions(int productId, java.lang.String encodedOptionValues)` For a product and a string containing encoded option values, this method returns an array of BigDecimal objects for price0 to price3.
`AdminProduct`	`getProduct(int productId)` Gets a product object with full details
`protected AdminProduct`	`getProduct(int productId, boolean getBundleQuantity)` Gets a product object with full details
`AdminProduct`	`getProduct(int productId, boolean getBundleQuantity, AdminProductMgrOptions mgrOptions, boolean allStores)` Gets a product object with full details.
`AdminProduct`	`getProduct(int productId, boolean getBundleQuantity, AdminProductMgrOptions mgrOptions, boolean allStores, java.sql.Connection con)` Gets a product object with full details.
`protected AdminProduct`	`getProduct(int productId, boolean getBundleQuantity, java.sql.Connection con)` Gets a product object with full details
`AdminProduct`	`getProduct(int productId, java.sql.Connection con)` Gets a product object with full details
`protected AdminProductAttribute`	`getProductAttribute(int productId, int optionId, int optionValueId)` Gets the product attributes object for the parameters.
`AdminProductAttribute[]`	`getProductAttributesPerProduct(int productId)` Gets all of the product attributes for the product
`AdminProductAttribute[]`	`getProductAttributesPerProduct(int productId, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog)` Gets all of the product attributes for the product
`AdminProductAttribute[]`	`getProductAttributesPerProduct(int productId, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog, java.sql.Connection con)` Gets all of the product attributes for the product
`AdminProductAttribute[]`	`getProductAttributesPerProduct(int productId, java.sql.Connection con)` Gets all of the product attributes for the product
`java.util.Calendar`	`getProductAvailability(java.lang.String sku, int id)` A method that directly returns the date when a product will be available.
`java.util.Calendar`	`getProductAvailabilityWithOptions(java.lang.String sku, int id, AdminProductMgrOptions mgrOptions)` A method that directly returns the date when a product will be available.
`int[]`	`getProductCategoryIds(int prodId)` Get an array of categoryIds defined for the specified product
`int[]`	`getProductCategoryIds(int prodId, boolean allStores)`
`int[]`	`getProductCategoryIds(int prodId, boolean allStores, java.sql.Connection con)`
`int[]`	`getProductCategoryIds(int prodId, java.sql.Connection con)`
`com.konakart.db.KKCriteria`	`getProductCriteria()` Gets a new KKCriteria object and sets the Database name.
`java.util.Set<java.lang.Integer>`	`getProductDescriptionLanguageIds(int productId)` Retrieve the complete set of languages used by the product descriptions of the specified product Id
`java.util.Set<java.lang.Integer>`	`getProductDescriptionLanguageIds(int productId, java.sql.Connection con)` Retrieve the complete set of languages used by the product descriptions of the specified product Id
`protected int`	`getProductIdFromUUIDAndStore(java.lang.String uuid, java.lang.String storeId)` Get the id of a product in a store based on its UUID
`int[]`	`getProductIdsPerManufacturer(AdminDataDescriptor dataDesc, int manufacturerId)` Get product Ids for the manufacturer referenced by manufacturerId.
`int[]`	`getProductIdsPerManufacturer(AdminDataDescriptor dataDesc, int manufacturerId, java.sql.Connection con)` Get product Ids for the manufacturer referenced by manufacturerId.
`AdminProduct`	`getProductImageFields(int productId)` Gets a product object with just the image-related fields retrieved
`com.konakart.app.ProductImages`	`getProductImages(com.konakart.appif.ProductImagesOptionsIf options)` Get the image file names associated with the product whose id is specified.
`com.konakart.app.ProductImages`	`getProductImagesForProduct(AdminProduct prod, com.konakart.appif.ProductImagesOptionsIf options)` Get the image file names associated with the product specified.
`protected int`	`getProductOptionCount(AdminProductOptionSearch search, int languageId)` Returns a count of the number of ProductOptions
`protected int`	`getProductOptionIdPerCode(java.lang.String code)` Given the code of a product options return the correspondent id.
`protected int`	`getProductOptionIdPerCode(java.lang.String code, java.sql.Connection con)` Given the code of a product options return the correspondent id.
`AdminProductOptionSearchResult`	`getProductOptions(AdminProductOptionSearch search, int offset, int size)` This returns an AdminProductOptionSearchResult object.
`java.lang.String`	`getProductOptionsCodePerId(int productOptionId, java.sql.Connection con)` Used to get the code of a product option with a given id
`AdminProductOption[]`	`getProductOptionsPerId(int productOptionId)` Returns an array of productOptions.
`AdminProductOption[]`	`getProductOptionsPerId(int productOptionId, java.sql.Connection con)` Returns an array of productOptions.
`AdminProductOption[]`	`getProductOptionsPerName(java.lang.String name, int langId)` Returns an array of productOptions with the specified name and languageId
`protected java.lang.String`	`getProductOptionValueCodePerProductOptionId(int productOptionValueId, java.sql.Connection con)` Used to get the code of a product option value with a given id
`protected int`	`getProductOptionValueIdPerCodeAndProductOptionId(java.lang.String code, int productOptionId, java.sql.Connection con)` Used to get the id of a product option value with a given a code and a product option id
`AdminProductOptionValue[]`	`getProductOptionValuesPerId(int productOptionValueId)` Returns an array of productOptionValues.
`AdminProductOptionValue[]`	`getProductOptionValuesPerId(int productOptionValueId, java.sql.Connection con)` Returns an array of productOptionValues.
`AdminProductOptionValue[]`	`getProductOptionValuesPerName(java.lang.String name, int languageId)` Get an array of product option value objects with the specified name and language
`AdminProductOptionValue[]`	`getProductOptionValuesPerOption(int productOptionId, int languageId)` Get an array of product option value objects for a product option object
`protected AdminProductOptionValue[]`	`getProductOptionValuesPerOption(int productOptionId, int languageId, java.sql.Connection con)` Get an array of product option value objects for a product option object
`AdminProdOptionValToProdOption[]`	`getProductOptionValueToProductOptions(AdminProdOptionValToProdOption prodOptValToProdOpt)` Gets an array of AdminProdOptionValToProdOption objects that have the specified optionId and OptionValueId.
`protected AdminProductQuantity[]`	`getProductQuantitiesPerProduct(int productId, AdminProductAttribute[] prodAttrs, AdminProductMgrOptions mgrOptions)` Create an array of AdminProductQuantity objects with zero quantity for all combinations of options.
`protected AdminProductQuantity[]`	`getProductQuantitiesPerProduct(int productId, AdminProductAttribute[] prodAttrs, AdminProductMgrOptions mgrOptions, java.sql.Connection con)` Create an array of AdminProductQuantity objects with zero quantity for all combinations of options.
`protected AdminProductQuantity[]`	`getProductQuantitiesPerSKU(java.lang.String sku, int rule)` Get a list of productQuantity objects for an SKU
`int`	`getProductQuantity(java.lang.String sku, int id)` A method that allows you to directly retrieve the quantity of a product.
`int`	`getProductQuantityWithOptions(java.lang.String sku, int id, AdminProductMgrOptions mgrOptions)` A method that allows you to directly retrieve the quantity of a product.
`protected AdminProducts`	`getProductsAllCasesWithOptions(AdminDataDescriptor dataDesc, int categoryId, int languageId, int manufacturerId, AdminProductMgrOptions mgrOptions)` This protected method gets called by various flavours of public methods to get an array of products with differing criteria.
`AdminProducts`	`getProductsPerCategory(AdminDataDescriptor dataDesc, int categoryId, int languageId)` Get products for the category referenced by categoryId.
`AdminProducts`	`getProductsPerCategoryWithOptions(AdminDataDescriptor dataDesc, int categoryId, int languageId, AdminProductMgrOptions mgrOptions)` Get products for the category referenced by categoryId.
`AdminProducts`	`getProductsPerManufacturer(AdminDataDescriptor dataDesc, int manufacturerId, int languageId)` Get products for the manufacturer referenced by manufacturerId.
`AdminProducts`	`getProductsPerManufacturerWithOptions(AdminDataDescriptor dataDesc, int manufacturerId, int languageId, AdminProductMgrOptions mgrOptions)` Get products for the manufacturer referenced by manufacturerId.
`AdminProductToStore[]`	`getProductsToStores(AdminDataDescriptor dataDesc, AdminSearch search)` Returns an array of AdminProductToStore objects for the specified store
`AdminProducts`	`getProductsToSynchronize(java.lang.String storeIdFrom, java.lang.String storeIdTo, AdminDataDescriptor dataDescIn, int languageId, AdminSynchProductsOptions options, AdminProductMgrOptions mgrOptions)` This API call is used to get a list of products that are out of sync between two stores.
`AdminProduct`	`getProductWithOptions(int productId, AdminProductMgrOptions mgrOptions)` Gets a product object with full details.
`AdminProduct`	`getProductWithOptions(int productId, AdminProductMgrOptions mgrOptions, java.sql.Connection con)` Gets a product object with full details.
`AdminProducts`	`getRelatedProducts(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId)` Find products related to the product defined by the productId parameter.
`AdminProducts`	`getRelatedProducts(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId, java.sql.Connection con)` Find products related to the product defined by the productId parameter.
`AdminProducts`	`getRelatedProductsWithOptions(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId, AdminProductMgrOptions mgrOptions)` Find products related to the product defined by the productId parameter.
`AdminProducts`	`getRelatedProductsWithOptions(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId, AdminProductMgrOptions mgrOptions, java.sql.Connection con)` Find products related to the product defined by the productId parameter.
`protected AdminProducts`	`getRelatedProductsWithOptions(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId, java.util.HashMap<java.lang.String,AdminProduct> bundleProductMap, int loopCounter, int quantity, AdminProductMgrOptions mgrOptions)` A protected version of getRelatedProducts with a hash map passed in for recursion
`protected AdminProducts`	`getRelatedProductsWithOptions(AdminDataDescriptor dataDesc, int productId, int relationType, int languageId, java.util.HashMap<java.lang.String,AdminProduct> bundleProductMap, int loopCounter, int quantity, AdminProductMgrOptions mgrOptions, java.sql.Connection con)` A protected version of getRelatedProducts with a hash map passed in for recursion
`java.lang.String`	`getSku(AdminOrderProduct orderProd)` Get the SKU for an orderProduct object.
`java.lang.String`	`getSku(int productId)` Gets the SKU for a product directly from the product table.
`java.lang.String[]`	`getSkus(AdminOrderProduct[] orderProds)` Get the SKUs for an array orderProduct objects.
`AdminSpecial`	`getSpecial(int specialId)` Gets a special object for a specialId
`AdminSpecial`	`getSpecial(int specialId, java.sql.Connection con)` Gets a special object for a specialId
`protected AdminSpecial`	`getSpecialForProductId(int productId)` Gets a special object for a productId
`protected AdminSpecial`	`getSpecialForProductId(int productId, java.sql.Connection con)` Gets a special object for a productId
`protected AdminSpecial`	`getSpecialForSpecialOrProductId(int specialId, int productId)` Gets a special object for a specialId or productId.
`protected AdminSpecial`	`getSpecialForSpecialOrProductId(int specialId, int productId, java.sql.Connection con)` Gets a special object for a specialId or productId.
`AdminProducts`	`getSpecialsPerCategory(AdminDataDescriptor dataDesc, int categoryId, boolean searchInSubCats, int languageId)` Return all products with a special price for a category referenced by categoryId
`AdminProducts`	`getSpecialsPerCategory(AdminDataDescriptor dataDesc, int categoryId, boolean searchInSubCats, int languageId, java.sql.Connection con)`
`AdminTierPrice[]`	`getTierPricesPerProduct(int productId, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog)` Gets all of the tier prices for the product
`AdminTierPrice[]`	`getTierPricesPerProduct(int productId, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog, java.sql.Connection con)` Gets all of the tier prices for the product
`protected AdminVariantPrice[]`	`getVariantPricesPerProduct(int productId, AdminProductMgrOptions mgrOptions, java.lang.String priceCatalog, java.sql.Connection con)` Gets all of the variant prices for the product
`int`	`importDigitalDownload(AdminDigitalDownload digDownload)` Import a new digital download record.
`int`	`insertCatalog(AdminCatalog catalog)` Insert a new catalog
`void`	`insertCatalogPrices(AdminProductPrice[] prices, AdminInsertCatalogPriceOptions options)` This API call is intended to provide a fast way to load catalog prices.
`protected void`	`insertCustAttrTemplates(AdminProduct prod, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Insert links to templates while inserting the product
`void`	`insertDigitalDownload(int customerId, int productId)` Create and insert a digital download record for the product identified by the productId and the customer identified by the customerId.
`protected void`	`insertExtPrice(AdminProduct product, java.lang.String catalogId, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Used to insert a price in the external price table.
`protected void`	`insertExtProdAttrPrice(AdminProductAttribute prodAttr, java.lang.String catalogId, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Used to insert a product attribute price in the external price table.
`protected void`	`insertExtQuantity(AdminProductQuantity prodQ, java.lang.String catalogId, boolean setQuantity, boolean setDate, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Used to insert a quantity in the external quantity table.
`protected void`	`insertExtTierPrice(AdminTierPrice tierPrice, java.lang.String catalogId, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Used to insert a product tier price in the external price table.
`protected void`	`insertExtVariantPrice(AdminVariantPrice variantPrice, java.lang.String catalogId, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` Used to insert a product variant price in the external price table.
`int`	`insertGiftCertificateDigitalDownload(int customerId, int productId, java.lang.String filePath)` Create and insert a digital download record for the product identified by the productId and the customer identified by the customerId.
`int`	`insertProduct(AdminProduct product)` Insert a product
`int`	`insertProductAttribute(AdminProductAttribute prodAttr)` Inserts the product attribute
`boolean`	`insertProductCategory(int prodId, int catId)` Inserts a new product category record into the database if it doesn't already exist.
`protected void`	`insertProductIntoExternalSystems(AdminProduct product, boolean manageSolr)` Insert the product into external systems
`void`	`insertProductOption(AdminProductOption productOption)` Insert a product option
`int`	`insertProductOptions(AdminProductOption[] productOptions)` Inserts an array of product options which will all have the same id but different languages.
`void`	`insertProductOptionValue(AdminProductOptionValue productOptionValue, int productOptionId)` Insert a product option value for a product option
`int`	`insertProductOptionValues(AdminProductOptionValue[] productOptionValues, int productOptionId)` Inserts an array of product option values which will all have the same id but different languages.
`int`	`insertProductsOptionsValuesToProductsOptions(AdminProdOptionValToProdOption prodOptValToProdOpt)` Insert a product option value to product option record
`void`	`insertProductsToStores(AdminProductToStore[] productToStores)` Inserts an array of AdminProductToStore objects
`int`	`insertProductWithOptions(AdminProduct product, AdminProductMgrOptions mgrOptions)` Insert a product
`protected int`	`insertProductWithOptions(AdminProduct product, AdminProductMgrOptions mgrOptions, boolean setMasterDate, boolean manageSolr, java.lang.String storeId, java.sql.Connection conIn)` Insert a product.
`int`	`insertSpecial(AdminSpecial special)` Insert a special
`protected int`	`insertSpecial(AdminSpecial special, java.sql.Connection con)` Insert a special using a transaction already open
`protected void`	`insertVariantPrice(AdminVariantPrice variantPrice, int productId, com.konakart.db.KKCriteria insertC, java.sql.Connection con)` protected method to insert new variant price records
`static boolean`	`isCustomAttrAnOracleCLOB()` Is the custom_attrs column is an Oracle CLOB? We only check once and save the result in a static variable.
`protected boolean`	`isEnhancedVariantHandlingModeEnabled()` Check in the static data if enhanced variant handling mode is enabled.
`protected void`	`manageDataDescriptor(AdminDataDescriptor dataDesc, com.konakart.db.KKCriteria c, org.apache.torque.map.ColumnMap colMap)` Provides common code to deal with the management of the DataDescriptor.
`protected void`	`manageDataDescriptor(AdminDataDescriptor dataDesc, com.konakart.db.KKCriteria c, java.lang.String price)` Provides common code to deal with the management of the DataDescriptor.
`protected void`	`manageProductToStoreDataDescriptor(AdminDataDescriptor dataDesc, com.konakart.db.KKCriteria c)` Provides common code to deal with the management of the DataDescriptor for ProductToStore calls.
`protected void`	`processQuantity(AdminProductQuantity productQuantity, java.sql.Connection con)` This method is used to process the product quantity in order to encode the variantCode received from ESP or to decode the productOptionsValue from KonaKart into variantCode useful when we should transmit an order to MAGO.
`boolean`	`productCategoryExists(int prodId, int catId)` Returns true if the ProducstToCategories table contains a record for the specified productId and categoryId
`void`	`refreshConfigs()` Retrieve some commonly-used properties and set the velocity log file location
`void`	`removeProductFromCatalog(int productId, java.lang.String catalogId)` Removes product prices and quantities from the catalog referenced by catalogId for the product referenced by productId.
`protected void`	`removeProductFromExternalSystems(int productId)` Remove the product from external systems
`protected void`	`removeProductsToCatgeories(int productId)` Remove records for the specified productId from products_to_categories.
`void`	`removeProductsToStores(AdminProductToStore[] productToStores)` Removes an array of AdminProductToStore objects
`void`	`removeRelatedProduct(int productIdFrom, int productIdTo, int relationType)` Remove any existing relation of type == relationType between product with id == productIdFrom and product with id == productIdTo.
`void`	`removeRelatedProducts(int productId, int relationType)` Removes any existing relation of type == relationType defined on the product with id == productId.
`protected void`	`removeRelatedProductShared(int productIdFrom, int productIdTo, int relationType)` Remove any existing relation of type == relationType defined between product with id == productIdFrom and product with id == productIdTo.
`protected java.util.Date`	`roundDate(java.util.Calendar calendar, java.lang.String granularity)` Method used to round a date to second, minute or hour precision
`AdminDigitalDownloadSearchResult`	`searchDigitalDownloads(AdminDigitalDownloadSearch search, int offset, int size)` Retrieve the Digital Download records matching the search criteria
`AdminProducts`	`searchForProducts(AdminDataDescriptor dataDesc, AdminProductSearch prodSearch, int languageId)` Search for products
`protected AdminProducts`	`searchForProductsPrivateWithOptions(AdminDataDescriptor dataDesc, AdminProductSearch prodSearch, java.util.ArrayList<java.lang.Integer> prodIdList, int languageId, AdminProductMgrOptions mgrOptions)` Returns products matching the search criteria in the format defined by the data descriptor.
`protected AdminProducts`	`searchForProductsPrivateWithOptions(AdminDataDescriptor dataDesc, AdminProductSearch prodSearch, java.util.ArrayList<java.lang.Integer> prodIdList, int languageId, AdminProductMgrOptions mgrOptions, java.sql.Connection con)` Returns products matching the search criteria in the format defined by the data descriptor.
`AdminProducts`	`searchForProductsWithOptions(AdminDataDescriptor dataDesc, AdminProductSearch prodSearch, int languageId, AdminProductMgrOptions mgrOptions)` Search for products
`protected void`	`setBundleQuantity(AdminProduct prod)` Calculates the quantity if this product is a bundle and sets the quantity of the product
`protected void`	`setBundleQuantity(AdminProduct prod, java.sql.Connection con)` Calculates the quantity if this product is a bundle and sets the quantity of the product
`protected void`	`setCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c, int languageId, AdminProductMgrOptions options, java.lang.String priceCatalog, AdminDataDescriptor dataDesc)` Initializes the criteria with the standard attributes for the product.
`protected void`	`setCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c, int languageId, boolean manuOuterJoin, boolean catOuterJoin, AdminProductMgrOptions options, java.lang.String priceCatalog, AdminDataDescriptor dataDesc)` Initializes the criteria with the standard attributes for the product.
`void`	`setDigitalDownloadCriteria(com.konakart.db.KKCriteria c)` Sets the criteria with the standard attributes so as not to have to repeat this code many times.
`protected void`	`setExtPriceProductCriteria(com.konakart.db.KKCriteria c, AdminProductMgrOptions options, java.lang.String priceCatalog)` Add criteria for getting the prices from another table based on the catalog id .
`protected void`	`setExtQuantityProductCriteria(com.konakart.db.KKCriteria c, AdminProductMgrOptions options)` Add criteria for getting the quantity from another table based on the catalog id .
`protected void`	`setProductAttributeCriteria(com.konakart.db.KKCriteria c, int langId)` Sets the product attribute criteria with standard attributes
`void`	`setProductAvailability(java.lang.String sku, int id, java.util.Calendar dateAvailable)` Sets the date when the product will be available
`void`	`setProductAvailabilityWithOptions(java.lang.String sku, int id, java.util.Calendar dateAvailable, AdminProductMgrOptions mgrOptions)` Sets the date when the product will be available
`protected void`	`setProductOptionCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c)` Add product option attributes to Criteria
`protected void`	`setProductOptionValueCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c)` Add product option value attributes to Criteria
`void`	`setProductQuantity(java.lang.String sku, int id, int quantity, int operation)` Sets the quantity of the product.
`void`	`setProductQuantityWithOptions(java.lang.String sku, int id, int quantity, int operation, AdminProductMgrOptions mgrOptions)` Sets the quantity of the product in an external table if the catalogId has a non null value.
`void`	`setProductQuantityWithOptions(java.lang.String sku, int id, int quantity, int operation, java.lang.String variantCode, AdminProductMgrOptions mgrOptions)` Sets the quantity of the product in an external table if the catalogId has a non null value.
`void`	`setProductsSharedCriteria(com.konakart.db.KKCriteria c)` Add criteria to get shared products from the database
`void`	`setProductsSharedCriteria(com.konakart.db.KKCriteria c, boolean addSelectPriceId)` Add criteria to get shared products from the database
`void`	`updateCatalog(AdminCatalog catalog)` Update an existing catalog
`void`	`updateProductImageFields(AdminProduct prod)` Updates the image-related fields for the product.
`protected void`	`updateProductInExternalSystems(AdminProduct product, boolean manageSolr, boolean insert)` Update the product in external systems
`void`	`updateProductReviewInfo(int productId)` The product referenced by the `productId` parameter is updated with information regarding the average rating and the number of reviews present for the product.
`protected boolean`	`useExternalPrices(AdminProductMgrOptions mgrOptions)` Utility method for determining whether to use external prices
`protected boolean`	`useExternalQuantity(AdminProductMgrOptions mgrOptions)` Utility method for determining whether to use external quantity
`protected AdminProduct`	`validateDigitalDownload(int productId)` Validate the digital download productId
`protected void`	`validateProdOptionValToProdOption(AdminProdOptionValToProdOption productOptionValueToProductOption)` Used to validate a AdminProdOptionValToProdOption object before editing or inserting
`protected void`	`validateProduct(AdminProduct product)` Used to validate a product before editing or inserting
`protected void`	`validateProduct(AdminProduct product, java.sql.Connection con)` Used to validate a product before editing or inserting
`protected void`	`validateProductAttribute(AdminProductAttribute productAttr, boolean testProdId)` Used to validate a productAttribute before editing or inserting
`protected void`	`validateProductAttribute(AdminProductAttribute productAttr, boolean testProdId, java.sql.Connection con)` Used to validate a productAttribute before editing or inserting
`protected void`	`validateProductOption(AdminProductOption productOption)` Used to validate a productOption before editing or inserting
`protected void`	`validateProductOptionValue(AdminProductOptionValue productOptionValue)` Used to validate a productOptionValue before editing or inserting
`protected void`	`validateProductQuantity(AdminProductQuantity productQuantity)` Used to validate a productQuantity before editing or inserting
`protected void`	`validateSpecial(AdminSpecial special, boolean checkProduct)` Used to validate a special before editing or inserting
`protected void`	`validateSpecial(AdminSpecial special, boolean checkProduct, java.sql.Connection con)` Used to validate a special before editing or inserting
`protected void`	`validateTierPrices(AdminTierPrice[] tierPrices)` Used to validate TierPrices before editing or inserting
`protected void`	`validateVariantPrices(AdminVariantPrice[] variantPrices, java.sql.Connection con)` Used to validate AdminVariantPrices before editing or inserting

Methods inherited from class com.konakartadmin.bl.AdminBaseMgr
addInsertAttr, addInsertAttr, addStringRuleConstraint, addStringRuleConstraint, checkAPICallEnabled, checkIntInRange, checkIntIsSet, checkRequired, executeQuery, executeQuery, getAdminAddressMgr, getAdminAuditMgr, getAdminBillingMgr, getAdminBookableProductMgr, getAdminCatMgr, getAdminConfigMgr, getAdminContentMgr, getAdminCurrMgr, getAdminCustMgr, getAdminCustPwdHistMgr, getAdminCustTagMgr, getAdminEmailMgr, getAdminEng, getAdminEngineCacheMgr, getAdminEventMgr, getAdminExecuteMgr, getAdminFileMgr, getAdminFilterMgr, getAdminHtmlMgr, getAdminImportMgr, getAdminLanguageMgr, getAdminManuMgr, getAdminMessageMgr, getAdminMiscItemMgr, getAdminMiscPriceMgr, getAdminModulesMgr, getAdminMultiStoreMgr, getAdminOrderMgr, getAdminPdfMgr, getAdminProdAttrMgr, getAdminProdMgr, getAdminPromMgr, getAdminReviewMgr, getAdminSearchRuleMgr, getAdminSecMgr, getAdminServletMgr, getAdminShipmentMgr, getAdminSolrMgr, getAdminStoreMgr, getAdminSuggestionMgr, getAdminTagMgr, getAdminTaxMgr, getAdminValidationMgr, getAdminVelocityContextMgr, getAdminWishListMgr, getBooleanFromString, getDebugStackTraceExclusions, getEmailThreadGracefulShutdownTimeout, getExportMgr, getExportMgr, getExportXMLData, getIntFromString, getKkAdminPropsFilePath, getKkConfig, getKkInstanceId, getMode, getModeString, getMqMgr, getNewCriteria, getNewCriteria, getNewCriteria, getNewCriteria, getOtherModuleByName, getPostSearchText, getPreSearchText, getProductsToCategoresCriteria, getPropertyValue, getPropertyValue, getPropertyValueAsBool, getPropertyValueAsInt, getPropertyValueAsLong, getRecordCount, getRecordCount, getRewardPointMgr, getSingleIntResult, getStoreId, getTemplate, getTemplateBase, getXml_io, init, insertKKEvent, insertKKEvent, isBusiness, isBusinessOrEnterprise, isCommunity, isConfigSet, isEnterprise, isMultiStoreLanguagesShared, isMultiStoreMode, isMultiStoreShareCategories, isMultiStoreShareCustomers, isMultiStoreShareCustomersOrProducts, isMultiStoreShareProducts, isMultiStoreSingleDBCSMode, isMultiStoreSingleDBMode, isMultiStoreSingleDBNonCSMode, isUnix, isWindows, manageException, manageThrowable, removeCData, sendMQMessages, setAdminEng, setDebugStackTraceExclusions, setKkAdminPropsFilePath, setupWildCardRules, setWildCardAfter, setWildCardBefore, shutdownGracefully, shutdownGracefully, timestampStr, updateStaticVariablesNow

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - log
```
protected static org.apache.commons.logging.Log log
```
    the log
  - DONT_INCLUDE
```
public static final int DONT_INCLUDE
```
    Used to not include values in the query
    
    See Also:
    
    Constant Field Values
  - UP_SELL
```
public static final int UP_SELL
```
    Up Sell related products
    
    See Also:
    
    Constant Field Values
  - CROSS_SELL
```
public static final int CROSS_SELL
```
    Cross Sell related products
    
    See Also:
    
    Constant Field Values
  - ACCESSORY
```
public static final int ACCESSORY
```
    Accessories
    
    See Also:
    
    Constant Field Values
  - DEPENDENT_ITEM
```
public static final int DEPENDENT_ITEM
```
    Dependent items, such as warranties
    
    See Also:
    
    Constant Field Values
  - BUNDLED_PRODUCTS
```
public static final int BUNDLED_PRODUCTS
```
    Bundled products
    
    See Also:
    
    Constant Field Values
  - DIGITAL_DOWNLOAD
```
public static final int DIGITAL_DOWNLOAD
```
    Digital download product
    
    See Also:
    
    Constant Field Values
  - GIFT_CERTIFICATE_PRODUCT_TYPE
```
public static final int GIFT_CERTIFICATE_PRODUCT_TYPE
```
    Gift Certificate product
    
    See Also:
    
    Constant Field Values
  - BOOKABLE_PRODUCT_TYPE
```
public static final int BOOKABLE_PRODUCT_TYPE
```
    Bookable product
    
    See Also:
    
    Constant Field Values
  - VIRTUAL_PRODUCT_TYPE
```
public static final int VIRTUAL_PRODUCT_TYPE
```
    Virtual product
    
    See Also:
    
    Constant Field Values
  - CAT_PRICE_PROD
```
protected static final int CAT_PRICE_PROD
```
    Used by insertProductPriceForCatalog
    
    See Also:
    
    Constant Field Values
  - CAT_PRICE_ATTR
```
protected static final int CAT_PRICE_ATTR
```
    Used by insertProductPriceForCatalog
    
    See Also:
    
    Constant Field Values
  - CAT_PRICE_TIER
```
protected static final int CAT_PRICE_TIER
```
    Used by insertProductPriceForCatalog
    
    See Also:
    
    Constant Field Values
  - CAT_PRICE_VARIANT
```
protected static final int CAT_PRICE_VARIANT
```
    Used by insertProductPriceForCatalog
    
    See Also:
    
    Constant Field Values
  - CAT_PROD_READ_LIMIT
```
protected static final int CAT_PROD_READ_LIMIT
```
    Used by insertProductPriceForCatalog
    
    See Also:
    
    Constant Field Values
  - customAttrAnOracleCLOB
```
public static java.lang.Boolean customAttrAnOracleCLOB
```
    is Oracle CLOB used for custom_attrs column on the products table?
  - mutex
```
protected static java.lang.String mutex
```
    Mutex for this manager
  - staticDataHM
```
protected static java.util.Map<java.lang.String,AdminProductMgr.StaticData> staticDataHM
```
    Hash Map that contains the static data
- Constructor Detail
  - AdminProductMgr
```
public AdminProductMgr(KKAdminIf eng)
                throws java.lang.Exception
```
    Constructor
    
    Parameters:
    
    eng - KKAdmin engine
    
    Throws:
    
    java.lang.Exception - an unexpected exception
- Method Detail
  - insertProduct
```
public int insertProduct(AdminProduct product)
                  throws java.lang.Exception
```
    Insert a product
    
    Specified by:
    
    insertProduct in interface AdminProductMgrIf
    
    Parameters:
    
    product - the product
    
    Returns:
    
    Returns the product Id
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductWithOptions
```
public int insertProductWithOptions(AdminProduct product,
                                    AdminProductMgrOptions mgrOptions)
                             throws java.lang.Exception
```
    Insert a product
    
    Specified by:
    
    insertProductWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    product - the product
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Returns the product Id
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductWithOptions
```
protected int insertProductWithOptions(AdminProduct product,
                                       AdminProductMgrOptions mgrOptions,
                                       boolean setMasterDate,
                                       boolean manageSolr,
                                       java.lang.String storeId,
                                       java.sql.Connection conIn)
                                throws java.lang.Exception
```
    Insert a product. Allows you to insert it within a transaction.
    
    Parameters:
    
    product - the product
    
    mgrOptions - the mgrOptions
    
    setMasterDate - When set to true, the master date of the product is set. If a product is being copied from one store to another then we don't want to change this since it shows the last modified date of the master data.
    
    manageSolr - If false, then inserts are not replicated in SOLR
    
    storeId - The store where to insert the product
    
    conIn - database Connection
    
    Returns:
    
    Returns the product Id
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductIntoExternalSystems
```
protected void insertProductIntoExternalSystems(AdminProduct product,
                                                boolean manageSolr)
                                         throws java.lang.Exception
```
    Insert the product into external systems
    
    Parameters:
    
    product - the product to insert
    
    manageSolr - If false, then inserts are not replicated in SOLR
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertSpecial
```
public int insertSpecial(AdminSpecial special)
                  throws java.lang.Exception
```
    Insert a special
    
    Specified by:
    
    insertSpecial in interface AdminProductMgrIf
    
    Parameters:
    
    special - the special
    
    Returns:
    
    Returns the special Id
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertSpecial
```
protected int insertSpecial(AdminSpecial special,
                            java.sql.Connection con)
                     throws java.lang.Exception
```
    Insert a special using a transaction already open
    
    Parameters:
    
    special - the special
    
    con - the con
    
    Returns:
    
    Primary key of new special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editSpecial
```
public void editSpecial(AdminSpecial special)
                 throws java.lang.Exception
```
    Edit a special
    
    Specified by:
    
    editSpecial in interface AdminProductMgrIf
    
    Parameters:
    
    special - the special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editSpecial
```
protected void editSpecial(AdminSpecial special,
                           java.sql.Connection con)
                    throws java.lang.Exception
```
    Edit a special using a transaction already open
    
    Parameters:
    
    special - the special
    
    con - the con
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProduct
```
public void editProduct(AdminProduct product)
                 throws java.lang.Exception
```
    Edit a product and its product description objects
    
    Specified by:
    
    editProduct in interface AdminProductMgrIf
    
    Parameters:
    
    product - the product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductWithOptions
```
public void editProductWithOptions(AdminProduct product,
                                   AdminProductMgrOptions mgrOptions)
                            throws java.lang.Exception
```
    Edit a product and its product description objects. Options defines whether to use prices and quantity per catalog.
    
    Specified by:
    
    editProductWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    product - the product
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductWithOptions
```
protected void editProductWithOptions(AdminProduct product,
                                      AdminProductMgrOptions mgrOptions,
                                      boolean setMasterDate,
                                      boolean allStores,
                                      boolean manageSolr,
                                      java.sql.Connection conIn)
                               throws java.lang.Exception
```
    Edit a product and its product description objects. Options defines whether to use prices and quantity per catalog. This internal version of the method allows you to call it within a transaction.
    
    Parameters:
    
    product - the product
    
    mgrOptions - the mgrOptions
    
    setMasterDate - When set to true, the master date of the product is set. If a product is being copied from one store to another then we don't want to change this since it shows the last modified date of the master data.
    
    allStores - When set to true we don't check that the product exists in this store. It has to exist but in shared products mode it could be attached to any store
    
    manageSolr - If false, then inserts are not replicated in SOLR
    
    conIn - database Connection
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductQuantities
```
protected void editProductQuantities(AdminProduct product,
                                     java.util.HashMap<java.lang.String,java.lang.String> prodAttrMap,
                                     java.sql.Connection con,
                                     com.konakart.db.KKCriteria selectC,
                                     com.konakart.db.KKCriteria deleteC,
                                     com.konakart.db.KKCriteria updateC,
                                     com.konakart.db.KKCriteria insertC,
                                     AdminProductMgrOptions mgrOptions)
                              throws java.lang.Exception
```
    protected method to edit the product quantity records
    
    Parameters:
    
    product - the product
    
    prodAttrMap - Contains a hash map of strings, each containing the encoded optId{optValId} for the product attributes
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editMiscPrices
```
protected void editMiscPrices(AdminProduct product,
                              java.sql.Connection con)
                       throws java.lang.Exception
```
    Edit the Misc prices within the Transaction.
    
    Parameters:
    
    product - the product
    
    con - the con
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editTierPrices
```
protected void editTierPrices(AdminProduct product,
                              java.sql.Connection con,
                              com.konakart.db.KKCriteria selectC,
                              com.konakart.db.KKCriteria deleteC,
                              com.konakart.db.KKCriteria updateC,
                              com.konakart.db.KKCriteria insertC,
                              AdminProductMgrOptions mgrOptions,
                              java.lang.String priceCatalog)
                       throws java.lang.Exception
```
    protected method to edit the tier price records
    
    Parameters:
    
    product - the product
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductAttributes
```
protected java.util.HashMap<java.lang.String,java.lang.String> editProductAttributes(AdminProduct product,
                                                                                     java.sql.Connection con,
                                                                                     com.konakart.db.KKCriteria selectC,
                                                                                     com.konakart.db.KKCriteria deleteC,
                                                                                     com.konakart.db.KKCriteria updateC,
                                                                                     com.konakart.db.KKCriteria insertC,
                                                                                     AdminProductMgrOptions mgrOptions,
                                                                                     java.lang.String priceCatalog)
                                                                              throws java.lang.Exception
```
    protected method to edit the product attribute records
    
    Parameters:
    
    product - the product
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    Returns:
    
    Returns a hash map of strings, each containing the encoded optId{optValId} for the product attributes
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductToCategory
```
protected void editProductToCategory(AdminProduct product,
                                     java.sql.Connection con)
                              throws java.lang.Exception
```
    Edit the product to category records
    
    Parameters:
    
    product - the product
    
    con - the con
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductDescriptionLanguageIds
```
public java.util.Set<java.lang.Integer> getProductDescriptionLanguageIds(int productId)
                                                                  throws java.lang.Exception
```
    Retrieve the complete set of languages used by the product descriptions of the specified product Id
    
    Specified by:
    
    getProductDescriptionLanguageIds in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    a Set of language Ids for which there are product description records for the specified Id. If there aren't any, an empty set is returned.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductDescriptionLanguageIds
```
public java.util.Set<java.lang.Integer> getProductDescriptionLanguageIds(int productId,
                                                                         java.sql.Connection con)
                                                                  throws java.lang.Exception
```
    Retrieve the complete set of languages used by the product descriptions of the specified product Id
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    a Set of language Ids for which there are product description records for the specified Id. If there aren't any, an empty set is returned.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductDescriptions
```
protected void editProductDescriptions(AdminProduct product,
                                       java.sql.Connection con,
                                       com.konakart.db.KKCriteria selectC,
                                       com.konakart.db.KKCriteria deleteC,
                                       com.konakart.db.KKCriteria updateC,
                                       com.konakart.db.KKCriteria insertC,
                                       AdminProductMgrOptions mgrOptions)
                                throws java.lang.Exception
```
    protected method to edit the product descriptions
    
    Parameters:
    
    product - the product
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editCustAttrTemplates
```
protected void editCustAttrTemplates(AdminProduct product,
                                     java.sql.Connection con,
                                     com.konakart.db.KKCriteria selectC,
                                     com.konakart.db.KKCriteria deleteC,
                                     com.konakart.db.KKCriteria updateC,
                                     com.konakart.db.KKCriteria insertC)
                              throws java.lang.Exception
```
    protected method to edit the product template links
    
    Parameters:
    
    product - the product
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - updateProductInExternalSystems
```
protected void updateProductInExternalSystems(AdminProduct product,
                                              boolean manageSolr,
                                              boolean insert)
                                       throws java.lang.Exception
```
    Update the product in external systems
    
    Parameters:
    
    product - the product to update
    
    manageSolr - If false, then updates are not replicated in SOLR
    
    insert - true if this is an insert of a new product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProduct
```
protected void validateProduct(AdminProduct product)
                        throws java.lang.Exception
```
    Used to validate a product before editing or inserting
    
    Parameters:
    
    product - the product to validate
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProduct
```
protected void validateProduct(AdminProduct product,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    Used to validate a product before editing or inserting
    
    Parameters:
    
    product - the product to validate
    
    con - Connection for transaction
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateSpecial
```
protected void validateSpecial(AdminSpecial special,
                               boolean checkProduct)
                        throws java.lang.Exception
```
    Used to validate a special before editing or inserting
    
    Parameters:
    
    special - the special
    
    checkProduct - the checkProduct
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateSpecial
```
protected void validateSpecial(AdminSpecial special,
                               boolean checkProduct,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    Used to validate a special before editing or inserting
    
    Parameters:
    
    special - the special
    
    checkProduct - the checkProduct
    
    con - the con
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - doesProductExist
```
public boolean doesProductExist(int productId)
                         throws org.apache.torque.TorqueException,
                                KKAdminException
```
    Return true if the product exists. Otherwise false.
    
    Specified by:
    
    doesProductExist in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    Returns true if the product exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - doesProductExist
```
public boolean doesProductExist(int productId,
                                java.sql.Connection con)
                         throws org.apache.torque.TorqueException,
                                KKAdminException
```
    Return true if the product exists. Otherwise false.
    
    Parameters:
    
    productId - the productId
    
    con - the con
    
    Returns:
    
    Returns true if the product exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProduct
```
public AdminProduct getProduct(int productId)
                        throws java.lang.Exception
```
    Gets a product object with full details
    
    Specified by:
    
    getProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProduct
```
public AdminProduct getProduct(int productId,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    Gets a product object with full details
    
    Specified by:
    
    getProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductWithOptions
```
public AdminProduct getProductWithOptions(int productId,
                                          AdminProductMgrOptions mgrOptions)
                                   throws java.lang.Exception
```
    Gets a product object with full details. The MgrOptions object defines whether to use prices and quantity for the catalog defined by the catalogId.
    
    Specified by:
    
    getProductWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductWithOptions
```
public AdminProduct getProductWithOptions(int productId,
                                          AdminProductMgrOptions mgrOptions,
                                          java.sql.Connection con)
                                   throws java.lang.Exception
```
    Gets a product object with full details. The MgrOptions object defines whether to use prices and quantity for the catalog defined by the catalogId.
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    con - Connection for transaction
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProduct
```
protected AdminProduct getProduct(int productId,
                                  boolean getBundleQuantity)
                           throws java.lang.Exception
```
    Gets a product object with full details
    
    Parameters:
    
    productId - the productId
    
    getBundleQuantity - When set to true we calculate the quantity of a product if it is a bundle
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProduct
```
protected AdminProduct getProduct(int productId,
                                  boolean getBundleQuantity,
                                  java.sql.Connection con)
                           throws java.lang.Exception
```
    Gets a product object with full details
    
    Parameters:
    
    productId - the productId
    
    getBundleQuantity - When set to true we calculate the quantity of a product if it is a bundle
    
    con - Connection for transaction
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProduct
```
public AdminProduct getProduct(int productId,
                               boolean getBundleQuantity,
                               AdminProductMgrOptions mgrOptions,
                               boolean allStores)
                        throws java.lang.Exception
```
    Gets a product object with full details. Options defines whether to use prices and quantity per catalog.
    
    Specified by:
    
    getProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    getBundleQuantity - When set to true we calculate the quantity of a product if it is a bundle
    
    mgrOptions - the mgrOptions
    
    allStores - When set to true we don't put in the store constraints in multi store shared product mode
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProduct
```
public AdminProduct getProduct(int productId,
                               boolean getBundleQuantity,
                               AdminProductMgrOptions mgrOptions,
                               boolean allStores,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    Gets a product object with full details. Options defines whether to use prices and quantity per catalog.
    
    Parameters:
    
    productId - the productId
    
    getBundleQuantity - When set to true we calculate the quantity of a product if it is a bundle
    
    mgrOptions - the mgrOptions
    
    allStores - When set to true we don't put in the store constraints in multi store shared product mode
    
    con - Connection for transaction
    
    Returns:
    
    A product object with full details
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecial
```
public AdminSpecial getSpecial(int specialId)
                        throws java.lang.Exception
```
    Gets a special object for a specialId
    
    Specified by:
    
    getSpecial in interface AdminProductMgrIf
    
    Parameters:
    
    specialId - the specialId
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecial
```
public AdminSpecial getSpecial(int specialId,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    Gets a special object for a specialId
    
    Parameters:
    
    specialId - the specialId
    
    con - Connection for transaction
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialForProductId
```
protected AdminSpecial getSpecialForProductId(int productId)
                                       throws java.lang.Exception
```
    Gets a special object for a productId
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialForProductId
```
protected AdminSpecial getSpecialForProductId(int productId,
                                              java.sql.Connection con)
                                       throws java.lang.Exception
```
    Gets a special object for a productId
    
    Parameters:
    
    productId - the productId
    
    con - the con
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialForSpecialOrProductId
```
protected AdminSpecial getSpecialForSpecialOrProductId(int specialId,
                                                       int productId)
                                                throws java.lang.Exception
```
    Gets a special object for a specialId or productId. Used to avoid duplicating code.
    
    Parameters:
    
    specialId - Used if greater than 0
    
    productId - Used if greater than 0
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialForSpecialOrProductId
```
protected AdminSpecial getSpecialForSpecialOrProductId(int specialId,
                                                       int productId,
                                                       java.sql.Connection con)
                                                throws java.lang.Exception
```
    Gets a special object for a specialId or productId. Used to avoid duplicating code.
    
    Parameters:
    
    specialId - Used if greater than 0
    
    productId - Used if greater than 0
    
    con - Connection for transaction
    
    Returns:
    
    A special
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - doesSpecialExist
```
protected boolean doesSpecialExist(int productId)
                            throws java.lang.Exception
```
    Determines whether a special exists for this product
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    Returns true if a special already exists for the product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - doesSpecialExist
```
protected boolean doesSpecialExist(int productId,
                                   java.sql.Connection con)
                            throws java.lang.Exception
```
    Determines whether a special exists for this product
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    Returns true if a special already exists for the product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteSpecial
```
public void deleteSpecial(int specialId)
                   throws java.lang.Exception
```
    Delete the special referenced to by specialId.
    
    Specified by:
    
    deleteSpecial in interface AdminProductMgrIf
    
    Parameters:
    
    specialId - the specialId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProducts
```
public void deleteProducts(AdminCommonOptions options)
                    throws java.lang.Exception
```
    Delete the products referenced by the options parameter.
    
    Specified by:
    
    deleteProducts in interface AdminProductMgrIf
    
    Parameters:
    
    options - An AdminCommonOptions object. Set the ids of the products to delete in the ids attribute.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProduct
```
public void deleteProduct(int productId)
                   throws java.lang.Exception
```
    Delete the product referenced to by productId.
    
    Specified by:
    
    deleteProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - removeProductsToCatgeories
```
protected void removeProductsToCatgeories(int productId)
                                   throws java.lang.Exception
```
    Remove records for the specified productId from products_to_categories. This is only for Shared Products and Non-Shared Categories.
    
    Parameters:
    
    productId - the productId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - removeProductFromExternalSystems
```
protected void removeProductFromExternalSystems(int productId)
                                         throws KKAdminException
```
    Remove the product from external systems
    
    Parameters:
    
    productId - the Id of the product to remove
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getCombinedExceptionStack
```
protected KKAdminException getCombinedExceptionStack(java.lang.String msg,
                                                     KKAdminException currentStack,
                                                     java.lang.Exception e)
```
    If there's a previous exception we convert that to a String and create a new exception using that String representation of the previous exception and this exception with it's current stack.
    
    Parameters:
    
    msg - the msg
    
    currentStack - the currentStack
    
    e - the e
    
    Returns:
    
    Returns the new Exception
  - getProductsPerCategory
```
public AdminProducts getProductsPerCategory(AdminDataDescriptor dataDesc,
                                            int categoryId,
                                            int languageId)
                                     throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Get products for the category referenced by categoryId.
    
    Specified by:
    
    getProductsPerCategory in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    categoryId - the categoryId
    
    languageId - the languageId
    
    Returns:
    
    Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductsPerCategoryWithOptions
```
public AdminProducts getProductsPerCategoryWithOptions(AdminDataDescriptor dataDesc,
                                                       int categoryId,
                                                       int languageId,
                                                       AdminProductMgrOptions mgrOptions)
                                                throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Get products for the category referenced by categoryId.
    
    Specified by:
    
    getProductsPerCategoryWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    categoryId - the categoryId
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductsPerManufacturerWithOptions
```
public AdminProducts getProductsPerManufacturerWithOptions(AdminDataDescriptor dataDesc,
                                                           int manufacturerId,
                                                           int languageId,
                                                           AdminProductMgrOptions mgrOptions)
                                                    throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Get products for the manufacturer referenced by manufacturerId.
    
    Specified by:
    
    getProductsPerManufacturerWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    manufacturerId - the manufacturerId
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductsPerManufacturer
```
public AdminProducts getProductsPerManufacturer(AdminDataDescriptor dataDesc,
                                                int manufacturerId,
                                                int languageId)
                                         throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Get products for the manufacturer referenced by manufacturerId.
    
    Specified by:
    
    getProductsPerManufacturer in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    manufacturerId - the manufacturerId
    
    languageId - the languageId
    
    Returns:
    
    Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductIdsPerManufacturer
```
public int[] getProductIdsPerManufacturer(AdminDataDescriptor dataDesc,
                                          int manufacturerId)
                                   throws java.lang.Exception
```
    Get product Ids for the manufacturer referenced by manufacturerId.
    
    Specified by:
    
    getProductIdsPerManufacturer in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the data descriptor is only used for setting the offset and the limit
    
    manufacturerId - the manufacturerId
    
    Returns:
    
    an array of productIds with the specified manufaturerId or null if none are found.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductIdsPerManufacturer
```
public int[] getProductIdsPerManufacturer(AdminDataDescriptor dataDesc,
                                          int manufacturerId,
                                          java.sql.Connection con)
                                   throws java.lang.Exception
```
    Get product Ids for the manufacturer referenced by manufacturerId.
    
    Parameters:
    
    dataDesc - the data descriptor is only used for setting the offset and the limit
    
    manufacturerId - the manufacturerId
    
    con - the con
    
    Returns:
    
    an array of productIds with the specified manufaturerId or null if none are found.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductsAllCasesWithOptions
```
protected AdminProducts getProductsAllCasesWithOptions(AdminDataDescriptor dataDesc,
                                                       int categoryId,
                                                       int languageId,
                                                       int manufacturerId,
                                                       AdminProductMgrOptions mgrOptions)
                                                throws java.lang.Exception
```
    This protected method gets called by various flavours of public methods to get an array of products with differing criteria.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    categoryId - the categoryId
    
    languageId - the languageId
    
    manufacturerId - the manufacturerId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - searchForProducts
```
public AdminProducts searchForProducts(AdminDataDescriptor dataDesc,
                                       AdminProductSearch prodSearch,
                                       int languageId)
                                throws java.lang.Exception
```
    Search for products
    
    Specified by:
    
    searchForProducts in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    prodSearch - the prodSearch
    
    languageId - the languageId
    
    Returns:
    
    Return a Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - searchForProductsWithOptions
```
public AdminProducts searchForProductsWithOptions(AdminDataDescriptor dataDesc,
                                                  AdminProductSearch prodSearch,
                                                  int languageId,
                                                  AdminProductMgrOptions mgrOptions)
                                           throws java.lang.Exception
```
    Search for products
    
    Specified by:
    
    searchForProductsWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    prodSearch - the prodSearch
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Return a Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - searchForProductsPrivateWithOptions
```
protected AdminProducts searchForProductsPrivateWithOptions(AdminDataDescriptor dataDesc,
                                                            AdminProductSearch prodSearch,
                                                            java.util.ArrayList<java.lang.Integer> prodIdList,
                                                            int languageId,
                                                            AdminProductMgrOptions mgrOptions)
                                                     throws java.lang.Exception
```
    Returns products matching the search criteria in the format defined by the data descriptor. N.B.B:B When in Torque you use an outer join and inner join in the same query, it is very important to write the inner join using Criteria.INNER_JOIN, otherwise there is a risk of the query syntax being wrong.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    prodSearch - the prodSearch
    
    prodIdList - If not null, it must contain a list of productIds which will be added to an IN clause.
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Return a Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - searchForProductsPrivateWithOptions
```
protected AdminProducts searchForProductsPrivateWithOptions(AdminDataDescriptor dataDesc,
                                                            AdminProductSearch prodSearch,
                                                            java.util.ArrayList<java.lang.Integer> prodIdList,
                                                            int languageId,
                                                            AdminProductMgrOptions mgrOptions,
                                                            java.sql.Connection con)
                                                     throws java.lang.Exception
```
    Returns products matching the search criteria in the format defined by the data descriptor. N.B.B:B When in Torque you use an outer join and inner join in the same query, it is very important to write the inner join using Criteria.INNER_JOIN, otherwise there is a risk of the query syntax being wrong.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    prodSearch - the prodSearch
    
    prodIdList - If not null, it must contain a list of productIds which will be added to an IN clause.
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    con - the con
    
    Returns:
    
    Return a Products object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getCustomAttrs
```
protected java.lang.String getCustomAttrs(int productId)
                                   throws java.lang.Exception
```
    Get the custom_attrs for the product with the specified Id. Enterprise only feature.
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    the custom_attrs as a String
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getCustomAttrs
```
protected java.lang.String getCustomAttrs(int productId,
                                          java.sql.Connection con)
                                   throws java.lang.Exception
```
    Get the custom_attrs for the product with the specified Id. Enterprise only feature.
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    the custom_attrs as a String
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - setCriteriaWithStandardAttributes
```
protected void setCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c,
                                                 int languageId,
                                                 AdminProductMgrOptions options,
                                                 java.lang.String priceCatalog,
                                                 AdminDataDescriptor dataDesc)
                                          throws KKAdminException
```
    Initializes the criteria with the standard attributes for the product.
    
    Parameters:
    
    c - the c
    
    languageId - the languageId
    
    options - the options
    
    priceCatalog - Catalog used for future prices
    
    dataDesc - the dataDesc
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setCriteriaWithStandardAttributes
```
protected void setCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c,
                                                 int languageId,
                                                 boolean manuOuterJoin,
                                                 boolean catOuterJoin,
                                                 AdminProductMgrOptions options,
                                                 java.lang.String priceCatalog,
                                                 AdminDataDescriptor dataDesc)
                                          throws KKAdminException
```
    Initializes the criteria with the standard attributes for the product. Depending on the value of manuOuterJoin we do a normal or outer join with the manufacturers table.
    
    Parameters:
    
    c - the c
    
    languageId - the languageId
    
    manuOuterJoin - the manuOuterJoin
    
    catOuterJoin - the catOuterJoin
    
    options - the options
    
    priceCatalog - Catalog used for future prices
    
    dataDesc - the dataDesc
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setProductsSharedCriteria
```
public void setProductsSharedCriteria(com.konakart.db.KKCriteria c)
                               throws KKAdminException
```
    Add criteria to get shared products from the database
    
    Specified by:
    
    setProductsSharedCriteria in interface AdminProductMgrIf
    
    Parameters:
    
    c - the c
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setProductsSharedCriteria
```
public void setProductsSharedCriteria(com.konakart.db.KKCriteria c,
                                      boolean addSelectPriceId)
                               throws KKAdminException
```
    Add criteria to get shared products from the database
    
    Specified by:
    
    setProductsSharedCriteria in interface AdminProductMgrIf
    
    Parameters:
    
    c - the c
    
    addSelectPriceId - if true BaseProductToStoresPeer.PRICE_ID and custom fields will be added as select columns
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setExtPriceProductCriteria
```
protected void setExtPriceProductCriteria(com.konakart.db.KKCriteria c,
                                          AdminProductMgrOptions options,
                                          java.lang.String priceCatalog)
```
    Add criteria for getting the prices from another table based on the catalog id .
    
    Parameters:
    
    c - the c
    
    options - the options
    
    priceCatalog - Catalog used for future prices
  - setExtQuantityProductCriteria
```
protected void setExtQuantityProductCriteria(com.konakart.db.KKCriteria c,
                                             AdminProductMgrOptions options)
```
    Add criteria for getting the quantity from another table based on the catalog id .
    
    Parameters:
    
    c - the c
    
    options - the options
  - setProductAttributeCriteria
```
protected void setProductAttributeCriteria(com.konakart.db.KKCriteria c,
                                           int langId)
```
    Sets the product attribute criteria with standard attributes
    
    Parameters:
    
    c - the c
    
    langId - the langId
  - manageDataDescriptor
```
protected void manageDataDescriptor(AdminDataDescriptor dataDesc,
                                    com.konakart.db.KKCriteria c,
                                    org.apache.torque.map.ColumnMap colMap)
```
    Provides common code to deal with the management of the DataDescriptor. The price is passed in because in the case of specials, we use the specials price. In the case of products that may not have the special price set, we use a virtual column that is either set to the price or the special price if it exists.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    c - the c
    
    colMap - the colMap
  - manageDataDescriptor
```
protected void manageDataDescriptor(AdminDataDescriptor dataDesc,
                                    com.konakart.db.KKCriteria c,
                                    java.lang.String price)
```
    Provides common code to deal with the management of the DataDescriptor. The price is passed in because in the case of specials, we use the specials price. In the case of products that may not have the special price set, we use a virtual column that is either set to the price or the special price if it exists.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    c - the c
    
    price - the price
  - getCount
```
protected int getCount(com.konakart.db.KKCriteria c,
                       boolean fixQuery)
                throws org.apache.torque.TorqueException,
                       com.workingdogs.village.DataSetException,
                       KKAdminException
```
    This method is mainly used for paging.
    
    Parameters:
    
    c - the c
    
    fixQuery - the fixQuery
    
    Returns:
    
    The number of records present in the database matching the given criteria
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getCount
```
protected int getCount(com.konakart.db.KKCriteria c,
                       boolean fixQuery,
                       java.sql.Connection con)
                throws org.apache.torque.TorqueException,
                       com.workingdogs.village.DataSetException,
                       KKAdminException
```
    This method is mainly used for paging.
    
    Parameters:
    
    c - the c
    
    fixQuery - the fixQuery
    
    con - Connection for transaction
    
    Returns:
    
    The number of records present in the database matching the given criteria
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - deleteProductsPerCategory
```
public void deleteProductsPerCategory(int categoryId)
                               throws java.lang.Exception
```
    Products are deleted for the category and sub category. If the product belongs to multiple categories and one of these categories is outside of the category tree, it isn't deleted but the category is removed from its category array.
    
    Specified by:
    
    deleteProductsPerCategory in interface AdminProductMgrIf
    
    Parameters:
    
    categoryId - the categoryId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteDirectProductsPerCategory
```
public void deleteDirectProductsPerCategory(int categoryId)
                                     throws java.lang.Exception
```
    If the category has any products directly associated with it, then they are deleted. If the product belongs to multiple categories, it isn't deleted but the category is removed from its category array.
    
    Specified by:
    
    deleteDirectProductsPerCategory in interface AdminProductMgrIf
    
    Parameters:
    
    categoryId - the categoryId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProductsPerManufacturer
```
public void deleteProductsPerManufacturer(int manufacturerId)
                                   throws java.lang.Exception
```
    If the manufacturer has any products directly associated with it, then they are deleted.
    
    Specified by:
    
    deleteProductsPerManufacturer in interface AdminProductMgrIf
    
    Parameters:
    
    manufacturerId - the manufacturerId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getAllSpecials
```
public AdminProducts getAllSpecials(AdminDataDescriptor dataDesc,
                                    int languageId)
                             throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Return all products with a special price
    
    Specified by:
    
    getAllSpecials in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    languageId - the languageId
    
    Returns:
    
    Array of products
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialsPerCategory
```
public AdminProducts getSpecialsPerCategory(AdminDataDescriptor dataDesc,
                                            int categoryId,
                                            boolean searchInSubCats,
                                            int languageId)
                                     throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Return all products with a special price for a category referenced by categoryId
    
    Specified by:
    
    getSpecialsPerCategory in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    categoryId - the categoryId
    
    searchInSubCats - the searchInSubCats
    
    languageId - the languageId
    
    Returns:
    
    Return an array of products
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getSpecialsPerCategory
```
public AdminProducts getSpecialsPerCategory(AdminDataDescriptor dataDesc,
                                            int categoryId,
                                            boolean searchInSubCats,
                                            int languageId,
                                            java.sql.Connection con)
                                     throws java.lang.Exception
```
    Parameters:
    
    dataDesc - the dataDesc
    
    categoryId - the categoryId
    
    searchInSubCats - the searchInSubCats
    
    languageId - the languageId
    
    con - Connection for transaction
    
    Returns:
    
    Return an array of products
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getAllProductOptions
```
public AdminProductOption[] getAllProductOptions(int languageId)
                                          throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Returns a list of product options.
    
    Specified by:
    
    getAllProductOptions in interface AdminProductMgrIf
    
    Parameters:
    
    languageId - specifies that the product options should be returned for this language. Can specify AdminLanguageMgr.DEFAULT_LANG to specify the default language, or specify AdminLanguageMgr.ALL_LANGUAGES to specify all languages
    
    Returns:
    
    An array of all product options, each containing an array of product values
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptions
```
public AdminProductOptionSearchResult getProductOptions(AdminProductOptionSearch search,
                                                        int offset,
                                                        int size)
                                                 throws java.lang.Exception
```
    This returns an AdminProductOptionSearchResult object. Each ProductOption object may have an array of ProductOptionValues which are populated by this API call if the populateValues attribute of the search object is set.
    
    Specified by:
    
    getProductOptions in interface AdminProductMgrIf
    
    Parameters:
    
    search - The search parameters. The languageId determines in which language the product options are returned. It can be set to AdminLanguageMgr.DEFAULT_LANG to specify the default language, or to AdminLanguageMgr.ALL_LANGUAGES to specify all languages.
    
    offset - the offset in the db
    
    size - the number of records from the specified offset
    
    Returns:
    
    Returns an AdminProductOptionSearchResult object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getAllProductOptionValues
```
public AdminProductOptionValue[] getAllProductOptionValues(int languageId)
                                                    throws java.lang.Exception
```
    Get an array of all the product option value objects for the specified language
    
    Specified by:
    
    getAllProductOptionValues in interface AdminProductMgrIf
    
    Parameters:
    
    languageId - specifies that the product option values should be returned for this language. Can specify AdminLanguageMgr.DEFAULT_LANG to specify the default language, or specify AdminLanguageMgr.ALL_LANGUAGES to specify all languages
    
    Returns:
    
    Return an array of productOptionValue objects
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptionValuesPerOption
```
public AdminProductOptionValue[] getProductOptionValuesPerOption(int productOptionId,
                                                                 int languageId)
                                                          throws java.lang.Exception
```
    Get an array of product option value objects for a product option object
    
    Specified by:
    
    getProductOptionValuesPerOption in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionId - the productOptionId
    
    languageId - the languageId
    
    Returns:
    
    Return an array of productOptionValue objects
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptionValuesPerOption
```
protected AdminProductOptionValue[] getProductOptionValuesPerOption(int productOptionId,
                                                                    int languageId,
                                                                    java.sql.Connection con)
                                                             throws java.lang.Exception
```
    Get an array of product option value objects for a product option object
    
    Parameters:
    
    productOptionId - the productOptionId
    
    languageId - the languageId
    
    con - Connection for transaction
    
    Returns:
    
    Return an array of productOptionValue objects
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptionValuesPerName
```
public AdminProductOptionValue[] getProductOptionValuesPerName(java.lang.String name,
                                                               int languageId)
                                                        throws java.lang.Exception
```
    Get an array of product option value objects with the specified name and language
    
    Specified by:
    
    getProductOptionValuesPerName in interface AdminProductMgrIf
    
    Parameters:
    
    name - product option value name
    
    languageId - language id (can use AdminLanguageMgr.DEFAULT_LANG to get the default language)
    
    Returns:
    
    Return an array of productOptionValue objects
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAttributesPerProduct
```
public AdminProductAttribute[] getProductAttributesPerProduct(int productId)
                                                       throws java.lang.Exception
```
    Gets all of the product attributes for the product
    
    Specified by:
    
    getProductAttributesPerProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    Returns an array of AdminProductAttributes
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAttributesPerProduct
```
public AdminProductAttribute[] getProductAttributesPerProduct(int productId,
                                                              java.sql.Connection con)
                                                       throws java.lang.Exception
```
    Gets all of the product attributes for the product
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    Returns an array of AdminProductAttributes
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAttributesPerProduct
```
public AdminProductAttribute[] getProductAttributesPerProduct(int productId,
                                                              AdminProductMgrOptions mgrOptions,
                                                              java.lang.String priceCatalog)
                                                       throws java.lang.Exception
```
    Gets all of the product attributes for the product
    
    Specified by:
    
    getProductAttributesPerProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    Returns:
    
    Returns an array of AdminProductAttributes
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAttributesPerProduct
```
public AdminProductAttribute[] getProductAttributesPerProduct(int productId,
                                                              AdminProductMgrOptions mgrOptions,
                                                              java.lang.String priceCatalog,
                                                              java.sql.Connection con)
                                                       throws java.lang.Exception
```
    Gets all of the product attributes for the product
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    priceCatalog - the price Catalog
    
    con - Connection for Transaction
    
    Returns:
    
    Returns an array of AdminProductAttributes
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getTierPricesPerProduct
```
public AdminTierPrice[] getTierPricesPerProduct(int productId,
                                                AdminProductMgrOptions mgrOptions,
                                                java.lang.String priceCatalog)
                                         throws org.apache.torque.TorqueException,
                                                com.workingdogs.village.DataSetException,
                                                KKAdminException
```
    Gets all of the tier prices for the product
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    Returns:
    
    Returns an array of AdminTierPrice objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getTierPricesPerProduct
```
public AdminTierPrice[] getTierPricesPerProduct(int productId,
                                                AdminProductMgrOptions mgrOptions,
                                                java.lang.String priceCatalog,
                                                java.sql.Connection con)
                                         throws org.apache.torque.TorqueException,
                                                com.workingdogs.village.DataSetException,
                                                KKAdminException
```
    Gets all of the tier prices for the product
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    con - Connection for Transaction
    
    Returns:
    
    Returns an array of AdminTierPrice objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - deleteProductAttribute
```
public void deleteProductAttribute(int productAttributeId)
                            throws java.lang.Exception
```
    Delete the productAttribute
    
    Specified by:
    
    deleteProductAttribute in interface AdminProductMgrIf
    
    Parameters:
    
    productAttributeId - the productAttributeId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProductAttributesPerProduct
```
public void deleteProductAttributesPerProduct(int productId)
                                       throws java.lang.Exception
```
    Delete the productAttributes Per product
    
    Specified by:
    
    deleteProductAttributesPerProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductAttribute
```
public void editProductAttribute(AdminProductAttribute prodAttr)
                          throws java.lang.Exception
```
    Edits the product attribute
    
    Specified by:
    
    editProductAttribute in interface AdminProductMgrIf
    
    Parameters:
    
    prodAttr - the prodAttr
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductAttribute
```
public int insertProductAttribute(AdminProductAttribute prodAttr)
                           throws java.lang.Exception
```
    Inserts the product attribute
    
    Specified by:
    
    insertProductAttribute in interface AdminProductMgrIf
    
    Parameters:
    
    prodAttr - the prodAttr
    
    Returns:
    
    Returns the primary key of the new product attribute
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProductOptions
```
public void deleteProductOptions(int productOptionId)
                          throws java.lang.Exception
```
    Delete a product option record for all languages and all of its records in the options values to options table and all of its values
    
    Specified by:
    
    deleteProductOptions in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionId - the productOptionId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - deleteProductOptionValues
```
public void deleteProductOptionValues(int productOptionValueId)
                               throws java.lang.Exception
```
    Delete a product option value record for all languages and all of its records in the options values to options table
    
    Specified by:
    
    deleteProductOptionValues in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionValueId - the productOptionValueId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptionsPerId
```
public AdminProductOption[] getProductOptionsPerId(int productOptionId)
                                            throws com.workingdogs.village.DataSetException,
                                                   org.apache.torque.TorqueException,
                                                   KKAdminException
```
    Returns an array of productOptions. One for each language.
    
    Specified by:
    
    getProductOptionsPerId in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionId - the productOptionId
    
    Returns:
    
    An array of all product options, for each language
    
    Throws:
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductOptionsPerId
```
public AdminProductOption[] getProductOptionsPerId(int productOptionId,
                                                   java.sql.Connection con)
                                            throws com.workingdogs.village.DataSetException,
                                                   org.apache.torque.TorqueException,
                                                   KKAdminException
```
    Returns an array of productOptions. One for each language.
    
    Parameters:
    
    productOptionId - the productOptionId
    
    con - Connection object for transaction
    
    Returns:
    
    An array of all product options, for each language
    
    Throws:
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductOptionsPerName
```
public AdminProductOption[] getProductOptionsPerName(java.lang.String name,
                                                     int langId)
                                              throws KKAdminException
```
    Returns an array of productOptions with the specified name and languageId
    
    Specified by:
    
    getProductOptionsPerName in interface AdminProductMgrIf
    
    Parameters:
    
    name - Product Option Name
    
    langId - Language Id
    
    Returns:
    
    An array of all product options for the specified language with the specified name
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductOptionValuesPerId
```
public AdminProductOptionValue[] getProductOptionValuesPerId(int productOptionValueId)
                                                      throws org.apache.torque.TorqueException,
                                                             com.workingdogs.village.DataSetException,
                                                             KKAdminException
```
    Returns an array of productOptionValues. One for each language.
    
    Specified by:
    
    getProductOptionValuesPerId in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionValueId - the productOptionValueId
    
    Returns:
    
    Return an array of productOptionValues objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductOptionValuesPerId
```
public AdminProductOptionValue[] getProductOptionValuesPerId(int productOptionValueId,
                                                             java.sql.Connection con)
                                                      throws org.apache.torque.TorqueException,
                                                             com.workingdogs.village.DataSetException,
                                                             KKAdminException
```
    Returns an array of productOptionValues. One for each language.
    
    Parameters:
    
    productOptionValueId - the productOptionValueId
    
    con - Connection object for transaction
    
    Returns:
    
    Return an array of productOptionValues objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - insertProductOptions
```
public int insertProductOptions(AdminProductOption[] productOptions)
                         throws java.lang.Exception
```
    Inserts an array of product options which will all have the same id but different languages. It is assumed that the input array all have different languages. The next available id is found and used to insert all of the records.
    
    Specified by:
    
    insertProductOptions in interface AdminProductMgrIf
    
    Parameters:
    
    productOptions - the productOptions
    
    Returns:
    
    id of inserted options
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductOption
```
public void insertProductOption(AdminProductOption productOption)
                         throws java.lang.Exception
```
    Insert a product option
    
    Specified by:
    
    insertProductOption in interface AdminProductMgrIf
    
    Parameters:
    
    productOption - the productOption
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductOption
```
public void editProductOption(AdminProductOption productOption)
                       throws java.lang.Exception
```
    Edit a product option
    
    Specified by:
    
    editProductOption in interface AdminProductMgrIf
    
    Parameters:
    
    productOption - the productOption
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductOptionValues
```
public int insertProductOptionValues(AdminProductOptionValue[] productOptionValues,
                                     int productOptionId)
                              throws java.lang.Exception
```
    Inserts an array of product option values which will all have the same id but different languages. It is assumed that the input array all have different languages. The next available id is found and used to insert all of the records.
    
    Specified by:
    
    insertProductOptionValues in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionValues - the productOptionValues
    
    productOptionId - the productOptionId
    
    Returns:
    
    Id of inserted option values
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductsOptionsValuesToProductsOptions
```
public int insertProductsOptionsValuesToProductsOptions(AdminProdOptionValToProdOption prodOptValToProdOpt)
                                                 throws java.lang.Exception
```
    Insert a product option value to product option record
    
    Specified by:
    
    insertProductsOptionsValuesToProductsOptions in interface AdminProductMgrIf
    
    Parameters:
    
    prodOptValToProdOpt - a AdminProdOptionValToProdOption object to insert. The optionId and optionValueId defined in the object must be valid otherwise an exception is thrown.
    
    Returns:
    
    the key created for the inserted record
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductOptionValueToProductOptions
```
public AdminProdOptionValToProdOption[] getProductOptionValueToProductOptions(AdminProdOptionValToProdOption prodOptValToProdOpt)
                                                                       throws java.lang.Exception
```
    Gets an array of AdminProdOptionValToProdOption objects that have the specified optionId and OptionValueId.
    
    Specified by:
    
    getProductOptionValueToProductOptions in interface AdminProductMgrIf
    
    Parameters:
    
    prodOptValToProdOpt - the AdminProdOptionValToProdOption to look up. Only uses the optionId and OptionValueId in this object
    
    Returns:
    
    Returns an array of AdminProdOptionValToProdOption objects
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - editProductOptionValue
```
public void editProductOptionValue(AdminProductOptionValue productOptionValue)
                            throws java.lang.Exception
```
    Edit a product option value
    
    Specified by:
    
    editProductOptionValue in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionValue - the productOptionValue
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProductOption
```
protected void validateProductOption(AdminProductOption productOption)
                              throws java.lang.Exception
```
    Used to validate a productOption before editing or inserting
    
    Parameters:
    
    productOption - the productOption
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProductQuantity
```
protected void validateProductQuantity(AdminProductQuantity productQuantity)
                                throws java.lang.Exception
```
    Used to validate a productQuantity before editing or inserting
    
    Parameters:
    
    productQuantity - the productQuantity
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProductAttribute
```
protected void validateProductAttribute(AdminProductAttribute productAttr,
                                        boolean testProdId)
                                 throws java.lang.Exception
```
    Used to validate a productAttribute before editing or inserting
    
    Parameters:
    
    productAttr - the productAttr
    
    testProdId - the testProdId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProductAttribute
```
protected void validateProductAttribute(AdminProductAttribute productAttr,
                                        boolean testProdId,
                                        java.sql.Connection con)
                                 throws java.lang.Exception
```
    Used to validate a productAttribute before editing or inserting
    
    Parameters:
    
    productAttr - the productAttr
    
    testProdId - the testProdId
    
    con - if we're in a transaction
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateTierPrices
```
protected void validateTierPrices(AdminTierPrice[] tierPrices)
                           throws java.lang.Exception
```
    Used to validate TierPrices before editing or inserting
    
    Parameters:
    
    tierPrices - the tierPrices
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProductOptionValue
```
protected void validateProductOptionValue(AdminProductOptionValue productOptionValue)
                                   throws java.lang.Exception
```
    Used to validate a productOptionValue before editing or inserting
    
    Parameters:
    
    productOptionValue - the productOptionValue
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateProdOptionValToProdOption
```
protected void validateProdOptionValToProdOption(AdminProdOptionValToProdOption productOptionValueToProductOption)
                                          throws java.lang.Exception
```
    Used to validate a AdminProdOptionValToProdOption object before editing or inserting
    
    Parameters:
    
    productOptionValueToProductOption - the productOptionValueToProductOption
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getNextProductOptionId
```
public int getNextProductOptionId()
                           throws org.apache.torque.TorqueException,
                                  com.workingdogs.village.DataSetException,
                                  KKAdminException
```
    Get the next id to use when inserting a ProductOption record
    
    Specified by:
    
    getNextProductOptionId in interface AdminProductMgrIf
    
    Returns:
    
    The next id
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getNextProductOptionValuesId
```
public int getNextProductOptionValuesId()
                                 throws org.apache.torque.TorqueException,
                                        com.workingdogs.village.DataSetException,
                                        KKAdminException
```
    Get the next id to use when inserting a ProductOptionValue record
    
    Specified by:
    
    getNextProductOptionValuesId in interface AdminProductMgrIf
    
    Returns:
    
    The next id
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - formatProductPrices
```
protected void formatProductPrices(AdminProduct product)
                            throws java.lang.Exception
```
    Format the prices of the product object
    
    Parameters:
    
    product - the product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProducts
```
public AdminProducts getRelatedProducts(AdminDataDescriptor dataDesc,
                                        int productId,
                                        int relationType,
                                        int languageId)
                                 throws java.lang.Exception
```
    Find products related to the product defined by the productId parameter. The relationType defines the relation. Valid values for relationType are:
    - 1 Up Selling. Normally a superior version of the same product.
    - 2 Cross Selling. Normally similar or related products.
    - 3 Accessories
    - 4 Dependent Item. Normally cannot be sold independently such as a warranty.
    Specified by:
    
    getRelatedProducts in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProducts
```
public AdminProducts getRelatedProducts(AdminDataDescriptor dataDesc,
                                        int productId,
                                        int relationType,
                                        int languageId,
                                        java.sql.Connection con)
                                 throws java.lang.Exception
```
    Find products related to the product defined by the productId parameter. The relationType defines the relation. Valid values for relationType are:
    - 1 Up Selling. Normally a superior version of the same product.
    - 2 Cross Selling. Normally similar or related products.
    - 3 Accessories
    - 4 Dependent Item. Normally cannot be sold independently such as a warranty.
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    con - Connection for transaction
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProductsWithOptions
```
public AdminProducts getRelatedProductsWithOptions(AdminDataDescriptor dataDesc,
                                                   int productId,
                                                   int relationType,
                                                   int languageId,
                                                   AdminProductMgrOptions mgrOptions)
                                            throws java.lang.Exception
```
    Find products related to the product defined by the productId parameter. The relationType defines the relation. Valid values for relationType are:
    - 1 Up Selling. Normally a superior version of the same product.
    - 2 Cross Selling. Normally similar or related products.
    - 3 Accessories
    - 4 Dependent Item. Normally cannot be sold independently such as a warranty.
    Specified by:
    
    getRelatedProductsWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProductsWithOptions
```
public AdminProducts getRelatedProductsWithOptions(AdminDataDescriptor dataDesc,
                                                   int productId,
                                                   int relationType,
                                                   int languageId,
                                                   AdminProductMgrOptions mgrOptions,
                                                   java.sql.Connection con)
                                            throws java.lang.Exception
```
    Find products related to the product defined by the productId parameter. The relationType defines the relation. Valid values for relationType are:
    - 1 Up Selling. Normally a superior version of the same product.
    - 2 Cross Selling. Normally similar or related products.
    - 3 Accessories
    - 4 Dependent Item. Normally cannot be sold independently such as a warranty.
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    mgrOptions - the mgrOptions
    
    con - Connection for transaction
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProductsWithOptions
```
protected AdminProducts getRelatedProductsWithOptions(AdminDataDescriptor dataDesc,
                                                      int productId,
                                                      int relationType,
                                                      int languageId,
                                                      java.util.HashMap<java.lang.String,AdminProduct> bundleProductMap,
                                                      int loopCounter,
                                                      int quantity,
                                                      AdminProductMgrOptions mgrOptions)
                                               throws java.lang.Exception
```
    A protected version of getRelatedProducts with a hash map passed in for recursion
    
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    bundleProductMap - HashMap used to keep track of products during recursion.
    
    loopCounter - Used to stop recursion forever. Throws an exception if recursion occurs when a bundle product is set to be a product within the bundle.
    
    quantity - Used to multiply quantity during recursion. i.e. A bundled product may have a quantity of two and itself be a bundle. This means that all of the products in its bundle have to be multiplied by two.
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getRelatedProductsWithOptions
```
protected AdminProducts getRelatedProductsWithOptions(AdminDataDescriptor dataDesc,
                                                      int productId,
                                                      int relationType,
                                                      int languageId,
                                                      java.util.HashMap<java.lang.String,AdminProduct> bundleProductMap,
                                                      int loopCounter,
                                                      int quantity,
                                                      AdminProductMgrOptions mgrOptions,
                                                      java.sql.Connection con)
                                               throws java.lang.Exception
```
    A protected version of getRelatedProducts with a hash map passed in for recursion
    
    Parameters:
    
    dataDesc - the dataDesc
    
    productId - the productId
    
    relationType - the relationType
    
    languageId - the languageId
    
    bundleProductMap - HashMap used to keep track of products during recursion.
    
    loopCounter - Used to stop recursion forever. Throws an exception if recursion occurs when a bundle product is set to be a product within the bundle.
    
    quantity - Used to multiply quantity during recursion. i.e. A bundled product may have a quantity of two and itself be a bundle. This means that all of the products in its bundle have to be multiplied by two.
    
    mgrOptions - the mgrOptions
    
    con - Connection for transaction
    
    Returns:
    
    AdminProducts
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - createEncodedProductIdFromProductQuantityEncodedKey
```
protected java.lang.String createEncodedProductIdFromProductQuantityEncodedKey(int productId,
                                                                               java.lang.String productQuantityEncodedKey)
```
    Takes in a productQuantityEncodedKey and a productId and returns an encoded product Id. for the products_quantity table
    The format of the encoded product id is 1{2}3{4}5 where the product id = 1, the first optionId / valueId pair have ids of 2,3 and the 2nd optionId / valueId pair have ids of 4,5.
    The format of the encoded key for the products_quantitytable is 3{4}4{6} which means product_options of id==3 and product_options_values of id==4 followed by product_options of id==4 and product_options_values of id==6. The order is very important since the product option ids must be in ascending order.
    
    Parameters:
    
    productId - the productId
    
    productQuantityEncodedKey - the productQuantityEncodedKey
    
    Returns:
    
    Returns the encoded productId
  - removeRelatedProduct
```
public void removeRelatedProduct(int productIdFrom,
                                 int productIdTo,
                                 int relationType)
                          throws java.lang.Exception
```
    Remove any existing relation of type == relationType between product with id == productIdFrom and product with id == productIdTo.
    
    Specified by:
    
    removeRelatedProduct in interface AdminProductMgrIf
    
    Parameters:
    
    productIdFrom - the productId the relation generates from
    
    productIdTo - the productId the relation points to
    
    relationType - the relationType ( see column: products_to_products.relation_type )
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - removeRelatedProducts
```
public void removeRelatedProducts(int productId,
                                  int relationType)
                           throws java.lang.Exception
```
    Removes any existing relation of type == relationType defined on the product with id == productId. If relationType == 0, then all existing relations on product with id == productId are removed.
    
    Specified by:
    
    removeRelatedProducts in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    relationType - the relationType
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - removeRelatedProductShared
```
protected void removeRelatedProductShared(int productIdFrom,
                                          int productIdTo,
                                          int relationType)
                                   throws java.lang.Exception
```
    Remove any existing relation of type == relationType defined between product with id == productIdFrom and product with id == productIdTo. If relationType == 0, then all types of relations from productIdFrom to productIdTo are removed. If productIdTo == 0 then all existing relations ( with type == relationType ) on productIdFrom are removed.
    
    Parameters:
    
    productIdFrom - the productId the relation generates from ( see column: products_to_products.id_from )
    
    productIdTo - the productId the relation points to ( see column: products_to_products.id_to )
    
    relationType - the relationType ( see column: products_to_products.relation_type )
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - addRelatedProducts
```
public void addRelatedProducts(AdminProduct[] products,
                               int productId,
                               int relationType)
                        throws org.apache.torque.TorqueException,
                               KKAdminException
```
    Add the array of products to the product defined by productId. The relation type is specified by relationType.
    
    Specified by:
    
    addRelatedProducts in interface AdminProductMgrIf
    
    Parameters:
    
    products - the products
    
    productId - the productId
    
    relationType - the relationType
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - addRelatedProductsWithOptions
```
public void addRelatedProductsWithOptions(AdminProduct[] products,
                                          int productId,
                                          int relationType,
                                          AdminProductMgrOptions mgrOptions)
                                   throws org.apache.torque.TorqueException,
                                          KKAdminException
```
    Add the array of products to the product defined by productId. The relation type is specified by relationType.
    
    Specified by:
    
    addRelatedProductsWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    products - the products
    
    productId - the productId
    
    relationType - the relationType
    
    mgrOptions - The options object allows you to set relationCustom1 and relationCustom2 attributes that are set on the product to product relationship. It may be set to null.
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductQuantitiesPerSKU
```
protected AdminProductQuantity[] getProductQuantitiesPerSKU(java.lang.String sku,
                                                            int rule)
                                                     throws org.apache.torque.TorqueException,
                                                            com.workingdogs.village.DataSetException,
                                                            KKAdminException
```
    Get a list of productQuantity objects for an SKU
    
    Parameters:
    
    sku - the sku
    
    rule - the rule
    
    Returns:
    
    A list of product quantity objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductQuantitiesPerProduct
```
protected AdminProductQuantity[] getProductQuantitiesPerProduct(int productId,
                                                                AdminProductAttribute[] prodAttrs,
                                                                AdminProductMgrOptions mgrOptions)
                                                         throws org.apache.torque.TorqueException,
                                                                com.workingdogs.village.DataSetException,
                                                                KKAdminException
```
    Create an array of AdminProductQuantity objects with zero quantity for all combinations of options. i.e. If we have Size S, M ,L and Colour Red, Blue we have to create 6 objects. Then we read from the products_quantity table and fill in the array with the real quantities. Where there isn't an entry we assume that the quantity is zero.
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    prodAttrs - the prodAttrs
    
    Returns:
    
    Array of Product Quantity objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductQuantitiesPerProduct
```
protected AdminProductQuantity[] getProductQuantitiesPerProduct(int productId,
                                                                AdminProductAttribute[] prodAttrs,
                                                                AdminProductMgrOptions mgrOptions,
                                                                java.sql.Connection con)
                                                         throws org.apache.torque.TorqueException,
                                                                com.workingdogs.village.DataSetException,
                                                                KKAdminException
```
    Create an array of AdminProductQuantity objects with zero quantity for all combinations of options. i.e. If we have Size S, M ,L and Colour Red, Blue we have to create 6 objects. Then we read from the products_quantity table and fill in the array with the real quantities. Where there isn't an entry we assume that the quantity is zero.
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    prodAttrs - the prodAttrs
    
    con - Connection for transaction
    
    Returns:
    
    Array of Product Quantity objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getSkus
```
public java.lang.String[] getSkus(AdminOrderProduct[] orderProds)
                           throws KKAdminException,
                                  org.apache.torque.TorqueException,
                                  com.workingdogs.village.DataSetException
```
    Get the SKUs for an array orderProduct objects. If a product has no options we look directly for the SKU in the product table. Otherwise we look in the productQuantities table. If we can't find it there, then we look in the product table.
    
    Specified by:
    
    getSkus in interface AdminProductMgrIf
    
    Parameters:
    
    orderProds - the orderProds
    
    Returns:
    
    Returns an array of SKUs for the OrderProduct array
    
    Throws:
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getSku
```
public java.lang.String getSku(AdminOrderProduct orderProd)
                        throws KKAdminException,
                               org.apache.torque.TorqueException,
                               com.workingdogs.village.DataSetException
```
    Get the SKU for an orderProduct object. If it has no options we look directly for the SKU in the product table. Otherwise we look in the productQuantities table. If we can't find it there, then we look in the product table.
    
    Specified by:
    
    getSku in interface AdminProductMgrIf
    
    Parameters:
    
    orderProd - the orderProd
    
    Returns:
    
    Returns the SKU for the OrderProduct
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getSku
```
public java.lang.String getSku(int productId)
                        throws org.apache.torque.TorqueException,
                               com.workingdogs.village.DataSetException,
                               KKAdminException
```
    Gets the SKU for a product directly from the product table.
    
    Specified by:
    
    getSku in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    Returns the SKU
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - createProductQuantityEncodedKeyFromOptions
```
protected java.lang.String createProductQuantityEncodedKeyFromOptions(AdminOption[] opts)
```
    Takes in an an array of options and returns an encoded key for the products_quantity table
    The format of the encoded key for the products_quantitytable is 3{4}4{6} which means product_options of id==3 and product_options_values of id==4 followed by product_options of id==4 and product_options_values of id==6. The order is very important since the product option ids must be in ascending order.
    
    Parameters:
    
    opts - the opts
    
    Returns:
    
    Returns the encoded key for the products_quantity table
  - insertDigitalDownload
```
public void insertDigitalDownload(int customerId,
                                  int productId)
                           throws java.lang.Exception
```
    Create and insert a digital download record for the product identified by the productId and the customer identified by the customerId. If the digital download already exists, then we overwrite it with the new one.
    
    Specified by:
    
    insertDigitalDownload in interface AdminProductMgrIf
    
    Parameters:
    
    customerId - the customerId
    
    productId - the productId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertGiftCertificateDigitalDownload
```
public int insertGiftCertificateDigitalDownload(int customerId,
                                                int productId,
                                                java.lang.String filePath)
                                         throws java.lang.Exception
```
    Create and insert a digital download record for the product identified by the productId and the customer identified by the customerId. The file path of the digital download will be used instead of the file path in the product object, to download the certificate.
    
    Specified by:
    
    insertGiftCertificateDigitalDownload in interface AdminProductMgrIf
    
    Parameters:
    
    customerId - the customerId
    
    productId - the productId
    
    filePath - the filePath
    
    Returns:
    
    Returns the key of the inserted Digital Download
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getMaxDownloadDays
```
protected int getMaxDownloadDays(AdminProduct prod)
                          throws org.apache.torque.TorqueException,
                                 com.workingdogs.village.DataSetException,
                                 KKAdminException,
                                 java.lang.Exception
```
    Common code to get the maximum number of download days
    
    Parameters:
    
    prod - the prod
    
    Returns:
    
    Returns the maximum number of download days
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getExpiryDate
```
protected java.util.Date getExpiryDate(int maxDownloadDays)
```
    Common code to get the expiry date
    
    Parameters:
    
    maxDownloadDays - the maxDownloadDays
    
    Returns:
    
    Returns the expiry date
  - getMaxNumDownloads
```
protected int getMaxNumDownloads(AdminProduct prod)
                          throws org.apache.torque.TorqueException,
                                 com.workingdogs.village.DataSetException,
                                 KKAdminException,
                                 java.lang.Exception
```
    Common code to get the maximum number of downloads
    
    Parameters:
    
    prod - the prod
    
    Returns:
    
    Returns the maximum number of downloads
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - validateDigitalDownload
```
protected AdminProduct validateDigitalDownload(int productId)
                                        throws java.lang.Exception
```
    Validate the digital download productId
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    returns the product with the specified productId
    
    Throws:
    
    java.lang.Exception - Returns an exception if the product does not exist or is not a digital download or gift certificate product.
  - getDigitalDownload
```
protected AdminDigitalDownload getDigitalDownload(int customerId,
                                                  int productId)
                                           throws org.apache.torque.TorqueException,
                                                  com.workingdogs.village.DataSetException,
                                                  KKAdminException
```
    Returns a Digital Download object for the customerId and productId passed in as parameters. Returns null if no object exists.
    
    Parameters:
    
    customerId - the customerId
    
    productId - the productId
    
    Returns:
    
    Returns an DigitalDownload object
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setDigitalDownloadCriteria
```
public void setDigitalDownloadCriteria(com.konakart.db.KKCriteria c)
```
    Sets the criteria with the standard attributes so as not to have to repeat this code many times.
    
    Specified by:
    
    setDigitalDownloadCriteria in interface AdminProductMgrIf
    
    Parameters:
    
    c - the c
  - getBundleProductDetails
```
public AdminProduct getBundleProductDetails(int bundleId,
                                            AdminProduct[] bundledProductsArray,
                                            AdminDiscount discount)
                                     throws org.apache.torque.TorqueException,
                                            com.workingdogs.village.DataSetException,
                                            java.lang.Exception
```
    This method is used to calculate some attributes of a bundle product based on the products that the bundle contains.
    - The price of a bundle product is calculated by summing the prices of the bundled products and applying a discount. If any of the bundled products has the "encodeOptionValues" attribute set, then the price is calculated, by also considering the product options.
    - The weight of a bundle product is calculated by summing the weights of the bundled products
    - The quantity of a bundle product is calculated by picking the lowest value from the quantities of the bundled products
    Specified by:
    
    getBundleProductDetails in interface AdminProductMgrIf
    
    Parameters:
    
    bundleId - If set to a positive value we search for all of the products in the bundle, starting from this id of the bundle product.
    
    bundledProductsArray - If bundleId is less than zero, we use the products in this array otherwise it is ignored.
    
    discount - The discount to apply which can be an amount or a percentage
    
    Returns:
    
    Returns an AdminProduct object which has calculated values for prices, weight and quantity.
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    java.lang.Exception - an unexpected exception
  - getBundleProductDetails
```
public AdminProduct getBundleProductDetails(int bundleId,
                                            AdminProduct[] bundledProductsArray,
                                            AdminDiscount discount,
                                            java.sql.Connection con)
                                     throws org.apache.torque.TorqueException,
                                            com.workingdogs.village.DataSetException,
                                            java.lang.Exception
```
    This method is used to calculate some attributes of a bundle product based on the products that the bundle contains.
    - The price of a bundle product is calculated by summing the prices of the bundled products and applying a discount. If any of the bundled products has the "encodeOptionValues" attribute set, then the price is calculated, by also considering the product options.
    - The weight of a bundle product is calculated by summing the weights of the bundled products
    - The quantity of a bundle product is calculated by picking the lowest value from the quantities of the bundled products
    Parameters:
    
    bundleId - If set to a positive value we search for all of the products in the bundle, starting from this id of the bundle product.
    
    bundledProductsArray - If bundleId is less than zero, we use the products in this array otherwise it is ignored.
    
    discount - The discount to apply which can be an amount or a percentage
    
    con - Connection for transaction
    
    Returns:
    
    Returns an AdminProduct object which has calculated values for prices, weight and quantity.
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    java.lang.Exception - an unexpected exception
  - setBundleQuantity
```
protected void setBundleQuantity(AdminProduct prod)
                          throws org.apache.torque.TorqueException,
                                 com.workingdogs.village.DataSetException,
                                 java.lang.Exception
```
    Calculates the quantity if this product is a bundle and sets the quantity of the product
    
    Parameters:
    
    prod - the prod
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - setBundleQuantity
```
protected void setBundleQuantity(AdminProduct prod,
                                 java.sql.Connection con)
                          throws org.apache.torque.TorqueException,
                                 com.workingdogs.village.DataSetException,
                                 java.lang.Exception
```
    Calculates the quantity if this product is a bundle and sets the quantity of the product
    
    Parameters:
    
    prod - the prod
    
    con - Connection for transaction
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscItems
```
public AdminMiscItem[] getMiscItems(int productId)
                             throws org.apache.torque.TorqueException,
                                    KKAdminException,
                                    com.workingdogs.village.DataSetException,
                                    java.lang.Exception
```
    Get the MiscItems associated with the specified productId
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscItems
```
public AdminMiscItem[] getMiscItems(int productId,
                                    java.sql.Connection con)
                             throws org.apache.torque.TorqueException,
                                    KKAdminException,
                                    com.workingdogs.village.DataSetException,
                                    java.lang.Exception
```
    Get the MiscItems associated with the specified productId
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscItems
```
public AdminMiscItem[] getMiscItems(AdminSearch search)
                             throws org.apache.torque.TorqueException,
                                    KKAdminException,
                                    com.workingdogs.village.DataSetException,
                                    java.lang.Exception
```
    Get the MiscItems associated with the specified search criteria
    
    Parameters:
    
    search - the search
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscItems
```
public AdminMiscItem[] getMiscItems(AdminSearch search,
                                    java.sql.Connection con)
                             throws org.apache.torque.TorqueException,
                                    KKAdminException,
                                    com.workingdogs.village.DataSetException,
                                    java.lang.Exception
```
    Get the MiscItems associated with the specified search criteria
    
    Parameters:
    
    search - the search
    
    con - Connection for transaction
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscItemsHash
```
public java.util.HashMap<java.lang.Integer,java.util.ArrayList<AdminMiscItem>> getMiscItemsHash(AdminSearch search)
                                                                                         throws org.apache.torque.TorqueException,
                                                                                                KKAdminException,
                                                                                                com.workingdogs.village.DataSetException,
                                                                                                java.lang.Exception
```
    Get the MiscItems associated with the specified search criteria
    
    Parameters:
    
    search - the search
    
    Returns:
    
    A HashMap mapped by the object Ids onto a list of MiscItems for each object Id.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscPrices
```
public AdminMiscPrice[] getMiscPrices(int productId)
                               throws org.apache.torque.TorqueException,
                                      KKAdminException,
                                      com.workingdogs.village.DataSetException,
                                      java.lang.Exception
```
    Get the Misc Prices associated with the specified productId
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getMiscPrices
```
public AdminMiscPrice[] getMiscPrices(int productId,
                                      java.sql.Connection con)
                               throws org.apache.torque.TorqueException,
                                      KKAdminException,
                                      com.workingdogs.village.DataSetException,
                                      java.lang.Exception
```
    Get the Misc Prices associated with the specified productId
    
    Parameters:
    
    productId - the productId
    
    con - Connection for transaction
    
    Returns:
    
    An array of MiscItems which could be null
    
    Throws:
    
    java.lang.Exception - an unexpected exception
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - getPriceFromEncodedOptions
```
protected java.math.BigDecimal[] getPriceFromEncodedOptions(int productId,
                                                            java.lang.String encodedOptionValues)
                                                     throws java.lang.NumberFormatException,
                                                            org.apache.torque.TorqueException,
                                                            com.workingdogs.village.DataSetException,
                                                            KKAdminException
```
    For a product and a string containing encoded option values, this method returns an array of BigDecimal objects for price0 to price3. The prices are fetched for each option / value pair and added to the previous prices.
    
    Parameters:
    
    productId - the productId
    
    encodedOptionValues - the encodedOptionValues
    
    Returns:
    
    Returns an array of prices
    
    Throws:
    
    java.lang.NumberFormatException - an unexpected NumberFormatException exception
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductAttribute
```
protected AdminProductAttribute getProductAttribute(int productId,
                                                    int optionId,
                                                    int optionValueId)
                                             throws org.apache.torque.TorqueException,
                                                    com.workingdogs.village.DataSetException,
                                                    KKAdminException
```
    Gets the product attributes object for the parameters.
    
    Parameters:
    
    productId - the productId
    
    optionId - the optionId
    
    optionValueId - the optionValueId
    
    Returns:
    
    Returns an AdminProductAttribute object
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - setProductQuantity
```
public void setProductQuantity(java.lang.String sku,
                               int id,
                               int quantity,
                               int operation)
                        throws java.lang.Exception
```
    Sets the quantity of the product.
    
    Specified by:
    
    setProductQuantity in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    quantity - the quantity
    
    operation - the operation
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - setProductQuantityWithOptions
```
public void setProductQuantityWithOptions(java.lang.String sku,
                                          int id,
                                          int quantity,
                                          int operation,
                                          java.lang.String variantCode,
                                          AdminProductMgrOptions mgrOptions)
                                   throws java.lang.Exception
```
    Sets the quantity of the product in an external table if the catalogId has a non null value.
    
    Specified by:
    
    setProductQuantityWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    quantity - the quantity
    
    operation - the operation
    
    variantCode - the variantCode
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - setProductQuantityWithOptions
```
public void setProductQuantityWithOptions(java.lang.String sku,
                                          int id,
                                          int quantity,
                                          int operation,
                                          AdminProductMgrOptions mgrOptions)
                                   throws java.lang.Exception
```
    Sets the quantity of the product in an external table if the catalogId has a non null value.
    
    Specified by:
    
    setProductQuantityWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    quantity - the quantity
    
    operation - the operation
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductQuantity
```
public int getProductQuantity(java.lang.String sku,
                              int id)
                       throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    A method that allows you to directly retrieve the quantity of a product. In the case of a simple product, an alternative way could be to find the product and read the quantity attribute. However, when the product has variations such as color and size, identified by different SKUs, the procedure for retrieving the quantity is more complicated and so this API call comes to the rescue. The product may be identified by the product id or the SKU. When set to a valid value, the SKU is used and the product id is ignored. When the SKU is set to null, the product id is used to identify the product. Note that the SKU should always be used in cases where a single product has many variations such as color and size.
    
    Specified by:
    
    getProductQuantity in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    Returns:
    
    Returns the product quantity
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductQuantityWithOptions
```
public int getProductQuantityWithOptions(java.lang.String sku,
                                         int id,
                                         AdminProductMgrOptions mgrOptions)
                                  throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    A method that allows you to directly retrieve the quantity of a product. In the case of a simple product, an alternative way could be to find the product and read the quantity attribute. However, when the product has variations such as color and size, identified by different SKUs, the procedure for retrieving the quantity is more complicated and so this API call comes to the rescue. The product may be identified by the product id or the SKU. When set to a valid value, the SKU is used and the product id is ignored. When the SKU is set to null, the product id is used to identify the product. Note that the SKU should always be used in cases where a single product has many variations such as color and size. The mgrOptions object allows you to define whether the quantity can have different values depending on the catalogId. It may be set to null.
    
    Specified by:
    
    getProductQuantityWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Returns the product quantity
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - setProductAvailability
```
public void setProductAvailability(java.lang.String sku,
                                   int id,
                                   java.util.Calendar dateAvailable)
                            throws java.lang.Exception
```
    Sets the date when the product will be available
    
    Specified by:
    
    setProductAvailability in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    dateAvailable - the dateAvailable
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - setProductAvailabilityWithOptions
```
public void setProductAvailabilityWithOptions(java.lang.String sku,
                                              int id,
                                              java.util.Calendar dateAvailable,
                                              AdminProductMgrOptions mgrOptions)
                                       throws java.lang.Exception
```
    Sets the date when the product will be available
    
    Specified by:
    
    setProductAvailabilityWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    dateAvailable - the dateAvailable
    
    mgrOptions - the mgrOptions
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAvailability
```
public java.util.Calendar getProductAvailability(java.lang.String sku,
                                                 int id)
                                          throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    A method that directly returns the date when a product will be available. In the case of a simple product, an alternative way could be to find the product and read the dateAvailable attribute. However, when the product has variations such as color and size, identified by different SKUs, the procedure for retrieving the date available is more complicated and so this API call comes to the rescue. The product may be identified by the product id or the SKU. When set to a valid value, the SKU is used and the product id is ignored. When the SKU is set to null, the product id is used to identify the product. Note that the SKU should always be used in cases where a single product has many variations such as color and size.
    
    Specified by:
    
    getProductAvailability in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    Returns:
    
    Returns the product availability date
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductAvailabilityWithOptions
```
public java.util.Calendar getProductAvailabilityWithOptions(java.lang.String sku,
                                                            int id,
                                                            AdminProductMgrOptions mgrOptions)
                                                     throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    A method that directly returns the date when a product will be available. In the case of a simple product, an alternative way could be to find the product and read the dateAvailable attribute. However, when the product has variations such as color and size, identified by different SKUs, the procedure for retrieving the date available is more complicated and so this API call comes to the rescue. The product may be identified by the product id or the SKU. When set to a valid value, the SKU is used and the product id is ignored. When the SKU is set to null, the product id is used to identify the product. Note that the SKU should always be used in cases where a single product has many variations such as color and size. The mgrOptions object allows you to define whether the availability date can have different values depending on the catalogId. It may be set to null.
    
    Specified by:
    
    getProductAvailabilityWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    sku - the sku
    
    id - the id
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    Returns the product availability date
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getNewQuantity
```
protected int getNewQuantity(int currentQuantity,
                             int newQuantity,
                             int operation)
```
    Utility method used by setProductQuantity()
    
    Parameters:
    
    currentQuantity - the currentQuantity
    
    newQuantity - the newQuantity
    
    operation - the operation
    
    Returns:
    
    Returns the result based on the operation
  - insertProductOptionValue
```
public void insertProductOptionValue(AdminProductOptionValue productOptionValue,
                                     int productOptionId)
                              throws java.lang.Exception
```
    Insert a product option value for a product option
    
    Specified by:
    
    insertProductOptionValue in interface AdminProductMgrIf
    
    Parameters:
    
    productOptionValue - the productOptionValue
    
    productOptionId - The product option id for inserting a record into the Products_Options_Values_To_Products_Options table. If this is set to -1, no such join record is inserted.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductsToStores
```
public AdminProductToStore[] getProductsToStores(AdminDataDescriptor dataDesc,
                                                 AdminSearch search)
                                          throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Returns an array of AdminProductToStore objects for the specified store
    
    Specified by:
    
    getProductsToStores in interface AdminProductMgrIf
    
    Parameters:
    
    dataDesc - Used to control the data offset, limit the number of items returned and set the sort order. You can specify any two of the following to define the sort order: AdminDataDescriptor.ORDER_BY_STOREID_ASCENDING, AdminDataDescriptor.ORDER_BY_STOREID_DESCENDING, AdminDataDescriptor.ORDER_BY_ID_ASCENDING, AdminDataDescriptor.ORDER_BY_ID_DESCENDING
    
    search - Defines the records to be returned. Populate the id with the productId (or set to KonaKartAdminConstant.NOT_SET to get all products or set an array of product Ids in the ids attribute to retrieve records for all of the products specified in the array) and the name with the storeId (or leave null for all stores).
    
    Returns:
    
    an array of AdminProductToStore objects for the specified store (or all records if the storeId is null). If no AdminProductToStore records exist for the specified store an empty array is returned.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - manageProductToStoreDataDescriptor
```
protected void manageProductToStoreDataDescriptor(AdminDataDescriptor dataDesc,
                                                  com.konakart.db.KKCriteria c)
```
    Provides common code to deal with the management of the DataDescriptor for ProductToStore calls.
    
    Parameters:
    
    dataDesc - the dataDesc
    
    c - the c
  - insertProductsToStores
```
public void insertProductsToStores(AdminProductToStore[] productToStores)
                            throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Inserts an array of AdminProductToStore objects
    
    Specified by:
    
    insertProductsToStores in interface AdminProductMgrIf
    
    Parameters:
    
    productToStores - an array of AdminProductToStore objects to insert into the database
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - removeProductsToStores
```
public void removeProductsToStores(AdminProductToStore[] productToStores)
                            throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Removes an array of AdminProductToStore objects
    
    Specified by:
    
    removeProductsToStores in interface AdminProductMgrIf
    
    Parameters:
    
    productToStores - an array of AdminProductToStore objects to delete from the database
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - searchDigitalDownloads
```
public AdminDigitalDownloadSearchResult searchDigitalDownloads(AdminDigitalDownloadSearch search,
                                                               int offset,
                                                               int size)
                                                        throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Retrieve the Digital Download records matching the search criteria
    
    Specified by:
    
    searchDigitalDownloads in interface AdminProductMgrIf
    
    Parameters:
    
    search - search definition for digital downloads
    
    offset - offset in results (for paging)
    
    size - maximum number of records to return from the offset (for paging)
    
    Returns:
    
    an AdminDigitalDownloadSearchResult object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - addDigitalDownloadSearchCriteria
```
protected int addDigitalDownloadSearchCriteria(com.konakart.db.KKCriteria c,
                                               AdminDigitalDownloadSearch search)
```
    Parameters:
    
    c - the c
    
    search - the search
    
    Returns:
    
    the number of constraints added
  - addDigitalDownloadOrderBy
```
protected void addDigitalDownloadOrderBy(com.konakart.db.KKCriteria c,
                                         AdminDigitalDownloadSearch search)
```
    Parameters:
    
    c - the c
    
    search - the search
  - importDigitalDownload
```
public int importDigitalDownload(AdminDigitalDownload digDownload)
                          throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Import a new digital download record. If the record already exists (a record exists with the same customerId and productId) the record is updated. Before inserting, the record is validated to ensure that the product referred to by the productId is indeed a Digital Download or Gift Certificate product.
    
    Specified by:
    
    importDigitalDownload in interface AdminProductMgrIf
    
    Parameters:
    
    digDownload - the Digital Download object to import
    
    Returns:
    
    returns the id of the newly inserted or updated record
    
    Throws:
    
    java.lang.Exception - an unexpected exception if the digital download record specified is invalid or there are database problems
  - doesExtPriceExist
```
protected boolean doesExtPriceExist(int productId,
                                    int prodAttrId,
                                    int tierPriceId,
                                    java.lang.String catalogId,
                                    java.lang.String productOptions,
                                    com.konakart.db.KKCriteria selectC)
                             throws org.apache.torque.TorqueException
```
    Returns true if the external price record exists
    
    Parameters:
    
    productId - the productId
    
    prodAttrId - the prodAttrId
    
    tierPriceId - the tierPriceId
    
    catalogId - the catalogId
    
    productOptions - the productOptions
    
    selectC - the selectC
    
    Returns:
    
    Return true if the external price record exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - doesExtPriceExist
```
protected boolean doesExtPriceExist(int productId,
                                    int prodAttrId,
                                    int tierPriceId,
                                    java.lang.String catalogId,
                                    java.lang.String productOptions,
                                    com.konakart.db.KKCriteria selectC,
                                    java.sql.Connection con)
                             throws org.apache.torque.TorqueException
```
    Returns true if the external price record exists
    
    Parameters:
    
    productId - the productId
    
    prodAttrId - the prodAttrId
    
    tierPriceId - the tierPriceId
    
    catalogId - the catalogId
    
    productOptions - the productOptions
    
    selectC - the selectC
    
    con - the con
    
    Returns:
    
    Return true if the external price record exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - insertExtPrice
```
protected void insertExtPrice(AdminProduct product,
                              java.lang.String catalogId,
                              com.konakart.db.KKCriteria insertC,
                              java.sql.Connection con)
                       throws org.apache.torque.TorqueException
```
    Used to insert a price in the external price table.
    
    Parameters:
    
    product - the product
    
    catalogId - the catalogId
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - insertExtProdAttrPrice
```
protected void insertExtProdAttrPrice(AdminProductAttribute prodAttr,
                                      java.lang.String catalogId,
                                      com.konakart.db.KKCriteria insertC,
                                      java.sql.Connection con)
                               throws org.apache.torque.TorqueException
```
    Used to insert a product attribute price in the external price table.
    
    Parameters:
    
    prodAttr - the prodAttr
    
    catalogId - the catalogId
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - insertExtTierPrice
```
protected void insertExtTierPrice(AdminTierPrice tierPrice,
                                  java.lang.String catalogId,
                                  com.konakart.db.KKCriteria insertC,
                                  java.sql.Connection con)
                           throws org.apache.torque.TorqueException
```
    Used to insert a product tier price in the external price table.
    
    Parameters:
    
    tierPrice - the tierPrice
    
    catalogId - the catalogId
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editExtPrice
```
protected void editExtPrice(AdminProduct product,
                            java.lang.String catalogId,
                            com.konakart.db.KKCriteria selectC,
                            com.konakart.db.KKCriteria updateC,
                            java.sql.Connection con)
                     throws org.apache.torque.TorqueException
```
    Used to edit a price in the external price table.
    
    Parameters:
    
    product - the product
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    updateC - the updateC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editExtProdAttrPrice
```
protected void editExtProdAttrPrice(AdminProductAttribute prodAttr,
                                    java.lang.String catalogId,
                                    com.konakart.db.KKCriteria selectC,
                                    com.konakart.db.KKCriteria updateC,
                                    java.sql.Connection con)
                             throws org.apache.torque.TorqueException
```
    Used to edit a product attribute price in the external price table.
    
    Parameters:
    
    prodAttr - the prodAttr
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    updateC - the updateC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editExtTierPrice
```
protected void editExtTierPrice(AdminTierPrice tierPrice,
                                java.lang.String catalogId,
                                com.konakart.db.KKCriteria selectC,
                                com.konakart.db.KKCriteria updateC,
                                java.sql.Connection con)
                         throws org.apache.torque.TorqueException
```
    Used to edit a product tier price in the external price table.
    
    Parameters:
    
    tierPrice - the tierPrice
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    updateC - the updateC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - deleteExtPrice
```
protected void deleteExtPrice(int productId,
                              int prodAttrId,
                              int tierPriceId,
                              java.lang.String catalogId,
                              java.lang.String productOptions,
                              com.konakart.db.KKCriteria deleteC,
                              java.sql.Connection con)
                       throws org.apache.torque.TorqueException
```
    Used to delete a price in the external price table.
    
    Parameters:
    
    productId - the productId
    
    prodAttrId - the prodAttrId
    
    tierPriceId - the tierPriceId
    
    catalogId - the catalogId
    
    productOptions - the productOptions
    
    deleteC - the deleteC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - deleteCatalogPrices
```
public void deleteCatalogPrices(java.lang.String catalogName)
                         throws org.apache.torque.TorqueException,
                                KKAdminException
```
    Delete all the prices in the specified catalog
    
    Specified by:
    
    deleteCatalogPrices in interface AdminProductMgrIf
    
    Parameters:
    
    catalogName - the catalogName
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - an unexpected exception in the Admin Engine
  - doesExtQuantityExist
```
protected boolean doesExtQuantityExist(int productId,
                                       java.lang.String encodedOptionValues,
                                       java.lang.String catalogId,
                                       com.konakart.db.KKCriteria selectC)
                                throws org.apache.torque.TorqueException
```
    Returns true if the external quantity record exists
    
    Parameters:
    
    productId - the productId
    
    encodedOptionValues - the encodedOptionValues
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    Returns:
    
    Return true if the external quantity record exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - doesExtQuantityExist
```
protected boolean doesExtQuantityExist(int productId,
                                       java.lang.String encodedOptionValues,
                                       java.lang.String catalogId,
                                       com.konakart.db.KKCriteria selectC,
                                       java.sql.Connection con)
                                throws org.apache.torque.TorqueException
```
    Returns true if the external quantity record exists
    
    Parameters:
    
    productId - the productId
    
    encodedOptionValues - the encodedOptionValues
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    con - the con
    
    Returns:
    
    Return true if the external quantity record exists
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - insertExtQuantity
```
protected void insertExtQuantity(AdminProductQuantity prodQ,
                                 java.lang.String catalogId,
                                 boolean setQuantity,
                                 boolean setDate,
                                 com.konakart.db.KKCriteria insertC,
                                 java.sql.Connection con)
                          throws org.apache.torque.TorqueException
```
    Used to insert a quantity in the external quantity table.
    
    Parameters:
    
    prodQ - the prodQ
    
    catalogId - the catalogId
    
    setQuantity - the setQuantity
    
    setDate - the setDate
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editExtQuantity
```
protected void editExtQuantity(AdminProductQuantity prodQ,
                               java.lang.String catalogId,
                               boolean setQuantity,
                               boolean setDate,
                               com.konakart.db.KKCriteria selectC,
                               com.konakart.db.KKCriteria updateC,
                               java.sql.Connection con)
                        throws org.apache.torque.TorqueException
```
    Used to edit a quantity in the external quantity table.
    
    Parameters:
    
    prodQ - the prodQ
    
    catalogId - the catalogId
    
    setQuantity - the setQuantity
    
    setDate - the setDate
    
    selectC - the selectC
    
    updateC - the updateC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - deleteExtQuantity
```
protected void deleteExtQuantity(int productId,
                                 java.lang.String encodedOptionValues,
                                 java.lang.String catalogId,
                                 com.konakart.db.KKCriteria deleteC,
                                 java.sql.Connection con)
                          throws org.apache.torque.TorqueException
```
    Used to delete and external quantity record
    
    Parameters:
    
    productId - the productId
    
    encodedOptionValues - the encodedOptionValues
    
    catalogId - the catalogId
    
    deleteC - the deleteC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - insertCustAttrTemplates
```
protected void insertCustAttrTemplates(AdminProduct prod,
                                       com.konakart.db.KKCriteria insertC,
                                       java.sql.Connection con)
                                throws org.apache.torque.TorqueException
```
    Insert links to templates while inserting the product
    
    Parameters:
    
    prod - the prod
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - useExternalPrices
```
protected boolean useExternalPrices(AdminProductMgrOptions mgrOptions)
```
    Utility method for determining whether to use external prices
    
    Parameters:
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    return true if external prices should be used
  - useExternalQuantity
```
protected boolean useExternalQuantity(AdminProductMgrOptions mgrOptions)
```
    Utility method for determining whether to use external quantity
    
    Parameters:
    
    mgrOptions - the mgrOptions
    
    Returns:
    
    return true if external quantities should be used
  - getPriceCatalogToUse
```
protected java.lang.String getPriceCatalogToUse(AdminProductMgrOptions mgrOptions)
                                         throws java.lang.Exception
```
    If we are inserting a price for a future date then we insert it into a different catalog which may already exist. If it doesn't exist then we create a new catalog. We either return the name of the catalog in the AdminProductMgrOptions object or the name of the catalog used to store the future price.
    
    Parameters:
    
    mgrOptions - product manager options
    
    Returns:
    
    Returns the catalog to use
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - roundDate
```
protected java.util.Date roundDate(java.util.Calendar calendar,
                                   java.lang.String granularity)
                            throws KKAdminException
```
    Method used to round a date to second, minute or hour precision
    
    Parameters:
    
    calendar - the date to round
    
    granularity - granularity
    
    Returns:
    
    Returns a date rounded to the second, minute or hour
    
    Throws:
    
    KKAdminException - an unexpected exception in the KKAdmin engine
  - getFuturePriceCatalogId
```
protected java.lang.String getFuturePriceCatalogId(java.lang.String catalogId,
                                                   java.util.Date futureRoundedDate,
                                                   java.lang.String futureDateFormat)
                                            throws KKAdminException
```
    Create the id of the catalog used to store future prices
    
    Parameters:
    
    catalogId - catalogId
    
    futureRoundedDate - future rounded date
    
    futureDateFormat - future date format
    
    Returns:
    
    Returns the id of the catalog - we make sure this doesn't have spaces in it
    
    Throws:
    
    KKAdminException - an unexpected exception in the KKAdmin engine
  - setProductOptionCriteriaWithStandardAttributes
```
protected void setProductOptionCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c)
```
    Add product option attributes to Criteria
    
    Parameters:
    
    c - the c
  - setProductOptionValueCriteriaWithStandardAttributes
```
protected void setProductOptionValueCriteriaWithStandardAttributes(com.konakart.db.KKCriteria c)
```
    Add product option value attributes to Criteria
    
    Parameters:
    
    c - the c
  - getProductOptionCount
```
protected int getProductOptionCount(AdminProductOptionSearch search,
                                    int languageId)
                             throws org.apache.torque.TorqueException,
                                    com.workingdogs.village.DataSetException,
                                    KKAdminException
```
    Returns a count of the number of ProductOptions
    
    Parameters:
    
    search - Search criteria
    
    languageId - the languageId
    
    Returns:
    
    A count of the number of ProductOptions
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - addProductOptionSearchCriteria
```
protected int addProductOptionSearchCriteria(com.konakart.db.KKCriteria c,
                                             AdminProductOptionSearch search,
                                             int langId)
```
    Add search criteria for ProductOptions
    
    Parameters:
    
    c - the c
    
    search - the search
    
    langId - the langId
    
    Returns:
    
    Returns the number of constraints added
  - addProductOptionOrderBy
```
protected void addProductOptionOrderBy(com.konakart.db.KKCriteria c,
                                       AdminProductOptionSearch search)
```
    Add order by constraints for ProductOptions
    
    Parameters:
    
    c - the c
    
    search - the search
  - deleteCatalog
```
public void deleteCatalog(int catalogId)
                   throws org.apache.torque.TorqueException,
                          KKAdminException,
                          java.lang.Exception
```
    Delete a Catalog definition from the database
    
    Specified by:
    
    deleteCatalog in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - the catalogId
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    java.lang.Exception - an unexpected Exception
  - deleteCatalogWithOptions
```
public void deleteCatalogWithOptions(int catalogId,
                                     AdminDeleteCatalogOptions options)
                              throws java.lang.Exception
```
    Delete a Catalog definition from the database with Options
    
    Specified by:
    
    deleteCatalogWithOptions in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - The numeric id of the catalog
    
    options - define whether or not to remove prices for this catalog as well.
    
    Throws:
    
    java.lang.Exception - an unexpected Exception
  - getCatalogs
```
public AdminCatalogSearchResult getCatalogs(AdminCatalogSearch search,
                                            int offset,
                                            int size)
                                     throws org.apache.torque.TorqueException,
                                            com.workingdogs.village.DataSetException,
                                            KKAdminException
```
    Get an array of catalogs matching the search criteria from the database
    
    Specified by:
    
    getCatalogs in interface AdminProductMgrIf
    
    Parameters:
    
    search - the search
    
    offset - the offset
    
    size - the size
    
    Returns:
    
    Returns an AdminCatalogSearchResult object
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - insertCatalog
```
public int insertCatalog(AdminCatalog catalog)
                  throws KKAdminException,
                         org.apache.torque.TorqueException
```
    Insert a new catalog
    
    Specified by:
    
    insertCatalog in interface AdminProductMgrIf
    
    Parameters:
    
    catalog - the catalog
    
    Returns:
    
    Returns the numeric id of the inserted catalog
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - updateCatalog
```
public void updateCatalog(AdminCatalog catalog)
                   throws java.lang.Exception
```
    Update an existing catalog
    
    Specified by:
    
    updateCatalog in interface AdminProductMgrIf
    
    Parameters:
    
    catalog - the catalog
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getCatalogById
```
public AdminCatalog getCatalogById(int catalogId)
                            throws java.lang.Exception
```
    Fetch a catalog from the database referenced by the catalog id
    
    Specified by:
    
    getCatalogById in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - the catalogId
    
    Returns:
    
    Returns an AdminCatalog object
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getCatalogCount
```
protected int getCatalogCount(com.konakart.db.KKCriteria c)
                       throws org.apache.torque.TorqueException,
                              com.workingdogs.village.DataSetException,
                              KKAdminException
```
    Get the number of catalogs
    
    Parameters:
    
    c - the c
    
    Returns:
    
    Returns the number of catalogs
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - isCustomAttrAnOracleCLOB
```
public static boolean isCustomAttrAnOracleCLOB()
```
    Is the custom_attrs column is an Oracle CLOB? We only check once and save the result in a static variable.
    
    Returns:
    
    the customAttrAnOracleCLOB
  - copyProductToStore
```
public int copyProductToStore(int productId,
                              java.lang.String storeIdFrom,
                              java.lang.String storeIdTo,
                              AdminCopyProductOptions options)
                       throws java.lang.Exception
```
    Copies a product from the store referenced by storeIdFrom to the store referenced by storeIdTo . This API call can only be used when in multi-store shared product and shared category mode.
    The options parameter defines the type of copy. Valid operations are:
    - com.konakartadmin.app.AdminCopyProductOptions.MODE_COPY_CREATING_NEW_PRODUCT - Insert a new product in the destination store by copying the source product. The source product remains in the database. If the destination product already exists then it is edited with new data from the source product.
    - com.konakartadmin.app.AdminCopyProductOptions.MODE_COPY_USING_PRODUCT_TO_STORES - A link is inserted to associate the source product to the destination store. The link with the source store is not removed.
    - com.konakartadmin.app.AdminCopyProductOptions.MODE_MOVE_USING_PRODUCT_TO_STORES - A link is inserted to associate the source product to the destination store. The link with the source store is removed.
    Specified by:
    
    copyProductToStore in interface AdminProductMgrIf
    
    Parameters:
    
    productId - The numeric id of the product to copy
    
    storeIdFrom - The id of the source store
    
    storeIdTo - The id of the destination store
    
    options - Options to configure the copy operation
    
    Returns:
    
    Returns the copied product id in mode MODE_COPY_CREATING_NEW_PRODUCT. Otherwise returns 0
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getP2PHash
```
protected java.lang.String getP2PHash(AdminProductToProduct p2p)
```
    Returns a unique value for the productToProduct so that we can compare them
    
    Parameters:
    
    p2p - the p2p
    
    Returns:
    
    a String representing a unique value for the productToProduct so that they can be compared
  - getProductIdFromUUIDAndStore
```
protected int getProductIdFromUUIDAndStore(java.lang.String uuid,
                                           java.lang.String storeId)
                                    throws org.apache.torque.TorqueException,
                                           com.workingdogs.village.DataSetException
```
    Get the id of a product in a store based on its UUID
    
    Parameters:
    
    uuid - the uuid
    
    storeId - the storeId
    
    Returns:
    
    Returns the id of the product. -1 if the product doesn't exist
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
  - getMappedProductId
```
protected int getMappedProductId(int idFrom,
                                 java.lang.String storeIdTo)
                          throws org.apache.torque.TorqueException,
                                 com.workingdogs.village.DataSetException
```
    Returns the idTo if the product exists in storeIdTo. Otherwise returns -1. We know it exists if there is a product in storeIdTo with the same UUID as the product with id = idFrom
    
    Parameters:
    
    idFrom - the idFrom
    
    storeIdTo - the storeIdTo
    
    Returns:
    
    Returns the idTo if the product exists in storeIdTo. Otherwise returns -1.
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
  - copyProductPrices
```
protected void copyProductPrices(AdminProduct prodFrom,
                                 AdminProduct prodTo)
                          throws KKAdminException
```
    This copies the prices between two identical products. It is used to transfer catalog prices from one product to another product once the products have been copied.
    
    Parameters:
    
    prodFrom - the prodFrom
    
    prodTo - the prodTo
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductsToSynchronize
```
public AdminProducts getProductsToSynchronize(java.lang.String storeIdFrom,
                                              java.lang.String storeIdTo,
                                              AdminDataDescriptor dataDescIn,
                                              int languageId,
                                              AdminSynchProductsOptions options,
                                              AdminProductMgrOptions mgrOptions)
                                       throws java.lang.Exception
```
    This API call is used to get a list of products that are out of sync between two stores. It can only be used when in multi-store shared product / shared category mode and is useful when stores are used as staging environments to display pre-production product information.
    The options parameter defines the the type of search which may be:
    - AdminSynchProductsOptions.GET_NEW_PRODUCTS - Products are returned that only exist in the source store and have never been copied to the destination store.
    - AdminSynchProductsOptions.GET_OUT_OF_SYNC_PRODUCTS - Products are returned that exist in both stores but are out of sync because the products have been modified in one of the stores but not in the other.
    It also allows you to define two search constraints to filter the returned products:
    - Product SKU
    - Product Id
    The dataDesc parameter is used to control the data offset, limit the number of items returned and set the sort order. The only sort orders used are:
    - AdminDataDescriptor.ORDER_BY_ID_ASCENDING
    - AdminDataDescriptor.ORDER_BY_ID_DESCENDING
    - AdminDataDescriptor.ORDER_BY_SKU_ASCENDING
    - AdminDataDescriptor.ORDER_BY_SKU_DESCENDING
    Specified by:
    
    getProductsToSynchronize in interface AdminProductMgrIf
    
    Parameters:
    
    storeIdFrom - The id of the source store
    
    storeIdTo - The id of the destination store
    
    dataDescIn - Used to control the data offset, limit the number of items returned and set the sort order. May be null.
    
    languageId - the language Id - or it could be com.konakartadmin.bl.AdminLanguageMgr.DEFAULT_LANG to use the default language
    
    options - Defines the type of search and constraints.
    
    mgrOptions - It defines whether to use prices and quantity for the catalog defined by the catalogId. May be null.
    
    Returns:
    
    Returns an AdminProducts object containing the products
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - updateProductReviewInfo
```
public void updateProductReviewInfo(int productId)
                             throws java.lang.Exception
```
    The product referenced by the productId parameter is updated with information regarding the average rating and the number of reviews present for the product.
    
    Specified by:
    
    updateProductReviewInfo in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertProductCategory
```
public boolean insertProductCategory(int prodId,
                                     int catId)
                              throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Inserts a new product category record into the database if it doesn't already exist.
    
    Specified by:
    
    insertProductCategory in interface AdminProductMgrIf
    
    Parameters:
    
    prodId - Product ID
    
    catId - Category ID
    
    Returns:
    
    true if the product category record was inserted, false if it already existed
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - productCategoryExists
```
public boolean productCategoryExists(int prodId,
                                     int catId)
                              throws java.lang.Exception
```
    Returns true if the ProducstToCategories table contains a record for the specified productId and categoryId
    
    Parameters:
    
    prodId - the prodId
    
    catId - the catId
    
    Returns:
    
    true if the record exists, otherwise false
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductCategoryIds
```
public int[] getProductCategoryIds(int prodId)
                            throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Get an array of categoryIds defined for the specified product
    
    Specified by:
    
    getProductCategoryIds in interface AdminProductMgrIf
    
    Parameters:
    
    prodId - the prodId
    
    Returns:
    
    an array of categoryIds
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductCategoryIds
```
public int[] getProductCategoryIds(int prodId,
                                   java.sql.Connection con)
                            throws java.lang.Exception
```
    Parameters:
    
    prodId - the prodId
    
    con - the con
    
    Returns:
    
    Returns an array of category ids
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductCategoryIds
```
public int[] getProductCategoryIds(int prodId,
                                   boolean allStores)
                            throws java.lang.Exception
```
    Parameters:
    
    prodId - the product Id whose categories we want to retrieve
    
    allStores - if set to true we retrieve categories for all stores.
    
    Returns:
    
    an array of category Ids associated with the specified product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductCategoryIds
```
public int[] getProductCategoryIds(int prodId,
                                   boolean allStores,
                                   java.sql.Connection con)
                            throws java.lang.Exception
```
    Parameters:
    
    prodId - the product Id whose categories we want to retrieve
    
    allStores - if set to true we retrieve categories for all stores.
    
    con - Connection for transaction
    
    Returns:
    
    an array of category Ids associated with the specified product
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getProductCriteria
```
public com.konakart.db.KKCriteria getProductCriteria()
                                              throws KKAdminException
```
    Gets a new KKCriteria object and sets the Database name. If no Engine Configuration is defined a default KKCriteria is returned.
    
    Specified by:
    
    getProductCriteria in interface AdminProductMgrIf
    
    Returns:
    
    Returns a new KKCriteria object for the correct database.
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductImageFields
```
public AdminProduct getProductImageFields(int productId)
                                   throws KKAdminException
```
    Description copied from interface: AdminProductMgrIf
    
    Gets a product object with just the image-related fields retrieved
    
    Specified by:
    
    getProductImageFields in interface AdminProductMgrIf
    
    Parameters:
    
    productId - the productId
    
    Returns:
    
    A product object with just the image-related fields retrieved. If the product doesn't exist a null is returned.
    
    Throws:
    
    KKAdminException - an unexpected exception in the KonaKart Admin engine
  - addProductImageFields
```
protected void addProductImageFields(com.konakart.db.KKCriteria c)
```
    Parameters:
    
    c - the c
  - updateProductImageFields
```
public void updateProductImageFields(AdminProduct prod)
                              throws KKAdminException
```
    Description copied from interface: AdminProductMgrIf
    
    Updates the image-related fields for the product.
    
    Specified by:
    
    updateProductImageFields in interface AdminProductMgrIf
    
    Parameters:
    
    prod - A product object with just the image-related fields set. The product must have its id set as well.
    
    Throws:
    
    KKAdminException - an unexpected exception in the KonaKart Admin engine
  - getProductImages
```
public com.konakart.app.ProductImages getProductImages(com.konakart.appif.ProductImagesOptionsIf options)
                                                throws KKAdminException
```
    Description copied from interface: AdminProductMgrIf
    
    Get the image file names associated with the product whose id is specified. Only return image file names that match the specified regular expression if specified and not null. If the file name filter is null, all file names associated with the product are returned. If no product exists with the specified productId null is returned. If no files are found for the product an empty array of image names is returned in the ProductImages return object.
    
    Specified by:
    
    getProductImages in interface AdminProductMgrIf
    
    Parameters:
    
    options - a ProductImagesOptions object for specifying the criteria used to define which product images should be returned. Within this search object you can specify productId and a file name filter (which is a regular expression).
    
    Returns:
    
    a ProductImages object that contains an array of image file names associated with the specified product and matching the (possibly) specified name filter regular expression. null is returned if the product cannot be found.
    
    Throws:
    
    KKAdminException - an unexpected exception in the KonaKart Admin engine if options is null or an unexpected error.
  - getProductImagesForProduct
```
public com.konakart.app.ProductImages getProductImagesForProduct(AdminProduct prod,
                                                                 com.konakart.appif.ProductImagesOptionsIf options)
                                                          throws KKAdminException
```
    Description copied from interface: AdminProductMgrIf
    
    Get the image file names associated with the product specified. Only the ImageDir attribute needs to be populated on the product specified. Only return image file names that match the specified regular expression if specified and not null. If the file name filter is null, all file names associated with the product are returned. If no product exists with the specified productId null is returned. If no files are found for the product an empty array of image names is returned in the ProductImages return object.
    
    Specified by:
    
    getProductImagesForProduct in interface AdminProductMgrIf
    
    Parameters:
    
    prod - An AdminProduct object with the ImageDir attribute specified.
    
    options - a ProductImagesOptions object for specifying the criteria used to define which product images should be returned. Within this search object you can specify productId and a file name filter (which is a regular expression).
    
    Returns:
    
    a ProductImages object that contains an array of image file names associated with the specified product and matching the (possibly) specified name filter regular expression. null is returned if the product cannot be found.
    
    Throws:
    
    KKAdminException - an unexpected exception in the KonaKart Admin engine if options is null or an unexpected error.
  - refreshConfigs
```
public void refreshConfigs()
                    throws KKAdminException
```
    Retrieve some commonly-used properties and set the velocity log file location
    
    Specified by:
    
    refreshConfigs in interface AdminProductMgrIf
    
    Overrides:
    
    refreshConfigs in class AdminBaseMgr
    
    Throws:
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - removeProductFromCatalog
```
public void removeProductFromCatalog(int productId,
                                     java.lang.String catalogId)
                              throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Removes product prices and quantities from the catalog referenced by catalogId for the product referenced by productId.
    
    Specified by:
    
    removeProductFromCatalog in interface AdminProductMgrIf
    
    Parameters:
    
    productId - The numeric id of the product to be removed
    
    catalogId - Id of the catalog from which the product prices and quantities will be removed
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - addCatalogRules
```
public void addCatalogRules(java.lang.String catalogId,
                            AdminCatalogRule[] rules)
                     throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    The purpose of this method is to add an array of rules to a catalog so that it can be created automatically by the createCatalogPricesFromRules() method. They are used to make price adjustments to products within selected categories and to include or exclude products from selected categories.
    
    Specified by:
    
    addCatalogRules in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - Id of the catalog to which the rules apply
    
    rules - An array of rules
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getCatalogRules
```
public AdminCatalogRule[] getCatalogRules(java.lang.String catalogId)
                                   throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    Fetches an array of catalog rules for a given catalog. The rules are used by createCatalogPricesFromRules() to make price adjustments to products within selected categories and to include or exclude products from selected categories.
    
    Specified by:
    
    getCatalogRules in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - The alphanumeric catalog identifier
    
    Returns:
    
    Returns an array of catalog rules sorted by category id ascending
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - createCatalogPricesFromRules
```
public AdminCreateCatalogPricesResult createCatalogPricesFromRules(java.lang.String catalogId,
                                                                   AdminCreateCatalogPriceOptions options)
                                                            throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    
    This method populates a catalog with product prices based on rules that have been previously added using the addCatalogRules() method. The rules are used to make price adjustments to products within selected categories and to include or exclude products from selected categories.
    
    Specified by:
    
    createCatalogPricesFromRules in interface AdminProductMgrIf
    
    Parameters:
    
    catalogId - Id of the catalog
    
    options - All products are read from the database in a loop to add to the catalog. This options object allows you to define the maximum number of records read at a time.
    
    Returns:
    
    Returns an object containing the number of products added to the catalog and the id of the catalog
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - insertCatalogPrices
```
public void insertCatalogPrices(AdminProductPrice[] prices,
                                AdminInsertCatalogPriceOptions options)
                         throws java.lang.Exception
```
    Description copied from interface: AdminProductMgrIf
    This API call is intended to provide a fast way to load catalog prices. In order to maximize for speed, a check isn't made to see whether the product, productAttr and tierPrice ids actually exist. For each price in the array, an attempt is first made to update the catalog price. If it doesn't already exist in the database, it is inserted.
    The options object allows you:
    - Manage the transaction. When the singleTransaction attribute is set to true, the prices are updated / inserted within a single database transaction and a rollback is performed if an exception is caught. When false, the API call terminates as soon as an exception is caught, but no rollback is performed. The default is false.
    - Decide whether to insert a product update event. When the insertKKEvent attribute is set to true, a product update event is inserted for all products which have had price changes. The event ensures that the product is removed from the cache in order to pick up the new prices. The default is false.
    Specified by:
    
    insertCatalogPrices in interface AdminProductMgrIf
    
    Parameters:
    
    prices - An array of AdminProductPrice objects
    
    options - Allows you to manage the transaction and events. May be left empty for default behaviour.
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - isEnhancedVariantHandlingModeEnabled
```
protected boolean isEnhancedVariantHandlingModeEnabled()
                                                throws KKAdminException
```
    Check in the static data if enhanced variant handling mode is enabled.
    
    Returns:
    
    true if is enabled
    
    Throws:
    
    KKAdminException - an unexpected KKAdminException exception
  - insertVariantPrice
```
protected void insertVariantPrice(AdminVariantPrice variantPrice,
                                  int productId,
                                  com.konakart.db.KKCriteria insertC,
                                  java.sql.Connection con)
                           throws org.apache.torque.TorqueException
```
    protected method to insert new variant price records
    
    Parameters:
    
    variantPrice - the variantPrice
    
    productId - the productId
    
    insertC - the insertC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editVariantPrices
```
protected void editVariantPrices(AdminProduct product,
                                 java.util.HashMap<java.lang.String,java.lang.String> prodAttrMap,
                                 java.sql.Connection con,
                                 com.konakart.db.KKCriteria selectC,
                                 com.konakart.db.KKCriteria deleteC,
                                 com.konakart.db.KKCriteria updateC,
                                 com.konakart.db.KKCriteria insertC,
                                 AdminProductMgrOptions mgrOptions,
                                 java.lang.String priceCatalog)
                          throws java.lang.Exception
```
    protected method to edit the variant price records
    
    Parameters:
    
    product - the product
    
    prodAttrMap - the prodAttrMap
    
    con - the con
    
    selectC - the selectC
    
    deleteC - the deleteC
    
    updateC - the updateC
    
    insertC - the insertC
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - validateVariantPrices
```
protected void validateVariantPrices(AdminVariantPrice[] variantPrices,
                                     java.sql.Connection con)
                              throws java.lang.Exception
```
    Used to validate AdminVariantPrices before editing or inserting
    
    Parameters:
    
    variantPrices - the variantPrices
    
    con - Connection for transaction
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - encodeOptionsAndValuesFromVariantCode
```
protected java.lang.String encodeOptionsAndValuesFromVariantCode(java.lang.String variantCode,
                                                                 java.sql.Connection con)
                                                          throws java.lang.Exception
```
    Used to process the variant code from ESP to get an encoded options values used in KonaKart
    
    Parameters:
    
    variantCode - the variantCode
    
    con - Connection for transaction
    
    Returns:
    
    the encoded options values
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - decodeVariantCodeFromOptionsAndValues
```
protected java.lang.String decodeVariantCodeFromOptionsAndValues(java.lang.String encodedOptionValues,
                                                                 java.sql.Connection con)
                                                          throws java.lang.Exception
```
    Used to process the encoded option values used in KonaKart to get the variant code string.
    
    Parameters:
    
    encodedOptionValues - the encodedOptionValues
    
    con - Connection for transaction
    
    Returns:
    
    the variant code string
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - decodeVariantCodeFromOptionAndValue
```
protected java.lang.String decodeVariantCodeFromOptionAndValue(java.lang.String encodedOptionValue,
                                                               java.sql.Connection con)
                                                        throws java.lang.Exception
```
    Used to process an encoded option value used in KonaKart to get a piece of variant code string
    
    Parameters:
    
    encodedOptionValue - the encodedOptionValue
    
    con - Connection for transaction
    
    Returns:
    
    a piece of variant code string
    
    Throws:
    
    java.lang.Exception - an unexpected exception
  - getVariantPricesPerProduct
```
protected AdminVariantPrice[] getVariantPricesPerProduct(int productId,
                                                         AdminProductMgrOptions mgrOptions,
                                                         java.lang.String priceCatalog,
                                                         java.sql.Connection con)
                                                  throws org.apache.torque.TorqueException,
                                                         com.workingdogs.village.DataSetException,
                                                         KKAdminException
```
    Gets all of the variant prices for the product
    
    Parameters:
    
    productId - the productId
    
    mgrOptions - the mgrOptions
    
    priceCatalog - Catalog used for future prices
    
    con - Connection for Transaction
    
    Returns:
    
    Returns an array of AdminVariantPrice objects
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
    
    com.workingdogs.village.DataSetException - an unexpected exception due to data in Torque (the database layer)
    
    KKAdminException - unexpected exception in the KonaKart Admin Engine
  - getProductOptionIdPerCode
```
protected int getProductOptionIdPerCode(java.lang.String code)
                                 throws java.lang.Exception
```
    Given the code of a product options return the correspondent id.
    
    Parameters:
    
    code - the code
    
    Returns:
    
    the productOptionId
    
    Throws:
    
    java.lang.Exception - unexpected exception
  - getProductOptionIdPerCode
```
protected int getProductOptionIdPerCode(java.lang.String code,
                                        java.sql.Connection con)
                                 throws java.lang.Exception
```
    Given the code of a product options return the correspondent id.
    
    Parameters:
    
    code - the code
    
    con - Connection for transaction
    
    Returns:
    
    the productOptionId
    
    Throws:
    
    java.lang.Exception - unexpected exception
  - getProductOptionValueIdPerCodeAndProductOptionId
```
protected int getProductOptionValueIdPerCodeAndProductOptionId(java.lang.String code,
                                                               int productOptionId,
                                                               java.sql.Connection con)
                                                        throws java.lang.Exception
```
    Used to get the id of a product option value with a given a code and a product option id
    
    Parameters:
    
    code - the code
    
    productOptionId - the productOptionId
    
    con - Connection for transaction
    
    Returns:
    
    the product option value id
    
    Throws:
    
    java.lang.Exception - unexpected exception
  - getProductOptionsCodePerId
```
public java.lang.String getProductOptionsCodePerId(int productOptionId,
                                                   java.sql.Connection con)
                                            throws java.lang.Exception
```
    Used to get the code of a product option with a given id
    
    Parameters:
    
    productOptionId - the productOptionId
    
    con - Connection for transaction
    
    Returns:
    
    the code of the product option
    
    Throws:
    
    java.lang.Exception - unexpected exception
  - getProductOptionValueCodePerProductOptionId
```
protected java.lang.String getProductOptionValueCodePerProductOptionId(int productOptionValueId,
                                                                       java.sql.Connection con)
                                                                throws java.lang.Exception
```
    Used to get the code of a product option value with a given id
    
    Parameters:
    
    productOptionValueId - the productOptionValueId
    
    con - Connection for transaction
    
    Returns:
    
    the code of the product option value
    
    Throws:
    
    java.lang.Exception - unexpected exception
  - insertExtVariantPrice
```
protected void insertExtVariantPrice(AdminVariantPrice variantPrice,
                                     java.lang.String catalogId,
                                     com.konakart.db.KKCriteria insertC,
                                     java.sql.Connection con)
                              throws org.apache.torque.TorqueException
```
    Used to insert a product variant price in the external price table.
    
    Parameters:
    
    variantPrice - the variantPrice
    
    catalogId - the catalogId
    
    insertC - the insertC
    
    con - the insertC
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - editExtVariantPrice
```
protected void editExtVariantPrice(AdminVariantPrice variantPrice,
                                   java.lang.String catalogId,
                                   com.konakart.db.KKCriteria selectC,
                                   com.konakart.db.KKCriteria updateC,
                                   java.sql.Connection con)
                            throws org.apache.torque.TorqueException
```
    Used to edit a product variant prices in the external price table.
    
    Parameters:
    
    variantPrice - the variantPrice
    
    catalogId - the catalogId
    
    selectC - the selectC
    
    updateC - the updateC
    
    con - the con
    
    Throws:
    
    org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)
  - convertProdAttrArrayToOrderedList
```
protected java.util.List<AdminProductAttribute> convertProdAttrArrayToOrderedList(AdminProductAttribute[] prodAttrs)
```
  - processQuantity
```
protected void processQuantity(AdminProductQuantity productQuantity,
                               java.sql.Connection con)
                        throws java.lang.Exception
```
    This method is used to process the product quantity in order to encode the variantCode received from ESP or to decode the productOptionsValue from KonaKart into variantCode useful when we should transmit an order to MAGO.
    
    Parameters:
    
    productQuantity - an AdminProductQuantity object
    
    con - Connection for transaction
    
    Throws:
    
    java.lang.Exception - an unexpected exception

Class AdminProductMgr

Nested Class Summary

Field Summary

Fields inherited from class com.konakartadmin.bl.AdminBaseMgr

Constructor Summary

Method Summary

Methods inherited from class com.konakartadmin.bl.AdminBaseMgr

Methods inherited from class java.lang.Object

Field Detail

log

DONT_INCLUDE

UP_SELL

CROSS_SELL

ACCESSORY

DEPENDENT_ITEM

BUNDLED_PRODUCTS

DIGITAL_DOWNLOAD

GIFT_CERTIFICATE_PRODUCT_TYPE

BOOKABLE_PRODUCT_TYPE

VIRTUAL_PRODUCT_TYPE

CAT_PRICE_PROD

CAT_PRICE_ATTR

CAT_PRICE_TIER

CAT_PRICE_VARIANT

CAT_PROD_READ_LIMIT

customAttrAnOracleCLOB

mutex

staticDataHM

Constructor Detail

AdminProductMgr

Method Detail

insertProduct

insertProductWithOptions

insertProductWithOptions

insertProductIntoExternalSystems

insertSpecial

insertSpecial

editSpecial

editSpecial

editProduct

editProductWithOptions

editProductWithOptions

editProductQuantities

editMiscPrices

editTierPrices

editProductAttributes

editProductToCategory

getProductDescriptionLanguageIds

getProductDescriptionLanguageIds

editProductDescriptions

editCustAttrTemplates

updateProductInExternalSystems

validateProduct

validateProduct

validateSpecial

validateSpecial

doesProductExist

doesProductExist

getProduct

getProduct

getProductWithOptions

getProductWithOptions

getProduct

getProduct

getProduct

getProduct

getSpecial

getSpecial

getSpecialForProductId

getSpecialForProductId

getSpecialForSpecialOrProductId

getSpecialForSpecialOrProductId

doesSpecialExist

doesSpecialExist

deleteSpecial

deleteProducts

deleteProduct

removeProductsToCatgeories

removeProductFromExternalSystems

getCombinedExceptionStack