ilscipio/scipio-erp

View on GitHub
framework/webtools/config/ExcelImport.properties

Summary

Maintainability
Test Coverage
# ###############################
# EXCEL IMPORT TEMPLATE DEFINITIONS
# ##############################
#
# Assign field name to service or entity - the rest will be taken from context
# if services are set, the entity entry in combination with parameters will be used to determine if a value already
# exists and needs to be extended, otherwise the create service will be used.
#
# if no create and update service is set, the entity itself will be modified.
# fields marked by "primary" are used as primary fields for subsequent lookups and calls
#
# Special vars:
# * null = set to null
# * cellValue = cell value
# * locale = set to current locale as defined via "-${locale}" in excelsheet, i.e. "metaDescription-de_DE" or "metaDescription-en" - currency is treated as a locale
# * now = now timestamp
# * today = timestamp from start of day
# * xlsxTemplateName = name for this template (rendered in import/export screen), can be label
# * xlsxReference = file location of a file that can be downloaded as a reference


# Category
xlsx.category.xlsxTemplateName=ProductProductCategory
xlsx.category.xlsxReference=/common/static/category_content_example.xlsx

xlsx.category.productCategoryId.entity=ProductCategory
xlsx.category.productCategoryId.primary=true

xlsx.category.altUrl.entity=ProductCategoryContentAndElectronicText
xlsx.category.altUrl.entity.parameter.prodCatContentTypeId=ALTERNATIVE_URL
xlsx.category.altUrl.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.altUrl.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.altUrl.create.parameters.prodCatContentTypeId=ALTERNATIVE_URL
xlsx.category.altUrl.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.altUrl.create.parameters.contentTypeId=DOCUMENT
xlsx.category.altUrl.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.altUrl.create.parameters.localeString=${locale}
xlsx.category.altUrl.create.parameters.text=${cellValue}
xlsx.category.altUrl.create.parameters.prodCatContentFromDate=${now}
xlsx.category.altUrl.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.altUrl.update.parameters.prodCatContentTypeId=ALTERNATIVE_URL
xlsx.category.altUrl.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.altUrl.update.parameters.mainContentId=${contentId}
xlsx.category.altUrl.update.parameters.localeString=${locale}
xlsx.category.altUrl.update.parameters.text=${cellValue}
xlsx.category.altUrl.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.altUrl.update.parameters.thruDate=${thruDate}

xlsx.category.metaTitle.entity=ProductCategoryContentAndElectronicText
xlsx.category.metaTitle.entity.parameter.prodCatContentTypeId=PAGE_TITLE
xlsx.category.metaTitle.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.metaTitle.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaTitle.create.parameters.prodCatContentTypeId=PAGE_TITLE
xlsx.category.metaTitle.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaTitle.create.parameters.contentTypeId=DOCUMENT
xlsx.category.metaTitle.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.metaTitle.create.parameters.localeString=${locale}
xlsx.category.metaTitle.create.parameters.text=${cellValue}
xlsx.category.metaTitle.create.parameters.prodCatContentFromDate=${now}
xlsx.category.metaTitle.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaTitle.update.parameters.prodCatContentTypeId=PAGE_TITLE
xlsx.category.metaTitle.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaTitle.update.parameters.mainContentId=${contentId}
xlsx.category.metaTitle.update.parameters.localeString=${locale}
xlsx.category.metaTitle.update.parameters.text=${cellValue}
xlsx.category.metaTitle.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.metaTitle.update.parameters.thruDate=${thruDate}

xlsx.category.metaKeyword.entity=ProductCategoryContentAndElectronicText
xlsx.category.metaKeyword.entity.parameter.prodCatContentTypeId=META_KEYWORD
xlsx.category.metaKeyword.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.metaKeyword.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaKeyword.create.parameters.prodCatContentTypeId=META_KEYWORD
xlsx.category.metaKeyword.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaKeyword.create.parameters.contentTypeId=DOCUMENT
xlsx.category.metaKeyword.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.metaKeyword.create.parameters.localeString=${locale}
xlsx.category.metaKeyword.create.parameters.text=${cellValue}
xlsx.category.metaKeyword.create.parameters.prodCatContentFromDate=${now}
xlsx.category.metaKeyword.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaKeyword.update.parameters.prodCatContentTypeId=META_KEYWORD
xlsx.category.metaKeyword.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaKeyword.update.parameters.mainContentId=${mainContentId}
xlsx.category.metaKeyword.update.parameters.localeString=${locale}
xlsx.category.metaKeyword.update.parameters.text=${cellValue}
xlsx.category.metaKeyword.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.metaKeyword.update.parameters.thruDate=${thruDate}

xlsx.category.metaDescription.entity=ProductCategoryContentAndElectronicText
xlsx.category.metaDescription.entity.parameter.prodCatContentTypeId=META_DESCRIPTION
xlsx.category.metaDescription.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.metaDescription.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaDescription.create.parameters.prodCatContentTypeId=META_DESCRIPTION
xlsx.category.metaDescription.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaDescription.create.parameters.contentTypeId=DOCUMENT
xlsx.category.metaDescription.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.metaDescription.create.parameters.localeString=${locale}
xlsx.category.metaDescription.create.parameters.text=${cellValue}
xlsx.category.metaDescription.create.parameters.prodCatContentFromDate=${now}
xlsx.category.metaDescription.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.metaDescription.update.parameters.prodCatContentTypeId=META_DESCRIPTION
xlsx.category.metaDescription.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.metaDescription.update.parameters.mainContentId=${contentId}
xlsx.category.metaDescription.update.parameters.localeString=${locale}
xlsx.category.metaDescription.update.parameters.text=${cellValue}
xlsx.category.metaDescription.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.metaDescription.update.parameters.thruDate=${thruDate}

xlsx.category.longDescription.entity=ProductCategoryContentAndElectronicText
xlsx.category.longDescription.entity.parameter.prodCatContentTypeId=LONG_DESCRIPTION
xlsx.category.longDescription.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.longDescription.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.longDescription.create.parameters.prodCatContentTypeId=LONG_DESCRIPTION
xlsx.category.longDescription.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.longDescription.create.parameters.contentTypeId=DOCUMENT
xlsx.category.longDescription.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.longDescription.create.parameters.localeString=${locale}
xlsx.category.longDescription.create.parameters.text=${cellValue}
xlsx.category.longDescription.create.parameters.prodCatContentFromDate=${now}
xlsx.category.longDescription.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.longDescription.update.parameters.prodCatContentTypeId=LONG_DESCRIPTION
xlsx.category.longDescription.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.longDescription.update.parameters.mainContentId=${contentId}
xlsx.category.longDescription.update.parameters.localeString=${locale}
xlsx.category.longDescription.update.parameters.text=${cellValue}
xlsx.category.longDescription.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.longDescription.update.parameters.thruDate=${thruDate}

xlsx.category.description.entity=ProductCategoryContentAndElectronicText
xlsx.category.description.entity.parameter.prodCatContentTypeId=DESCRIPTION
xlsx.category.description.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.description.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.description.create.parameters.prodCatContentTypeId=DESCRIPTION
xlsx.category.description.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.description.create.parameters.contentTypeId=DOCUMENT
xlsx.category.description.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.description.create.parameters.localeString=${locale}
xlsx.category.description.create.parameters.text=${cellValue}
xlsx.category.description.create.parameters.prodCatContentFromDate=${now}
xlsx.category.description.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.description.update.parameters.prodCatContentTypeId=DESCRIPTION
xlsx.category.description.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.description.update.parameters.mainContentId=${contentId}
xlsx.category.description.update.parameters.localeString=${locale}
xlsx.category.description.update.parameters.text=${cellValue}
xlsx.category.description.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.description.update.parameters.thruDate=${thruDate}

xlsx.category.categoryName.entity=ProductCategoryContentAndElectronicText
xlsx.category.categoryName.entity.parameter.prodCatContentTypeId=CATEGORY_NAME
xlsx.category.categoryName.entity.parameter.productCategoryId=${productCategoryId}
xlsx.category.categoryName.create=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.categoryName.create.parameters.prodCatContentTypeId=CATEGORY_NAME
xlsx.category.categoryName.create.parameters.productCategoryId=${productCategoryId}
xlsx.category.categoryName.create.parameters.contentTypeId=DOCUMENT
xlsx.category.categoryName.create.parameters.drDataTemplateTypeId=NONE
xlsx.category.categoryName.create.parameters.localeString=${locale}
xlsx.category.categoryName.create.parameters.text=${cellValue}
xlsx.category.categoryName.create.parameters.prodCatContentFromDate=${now}
xlsx.category.categoryName.update=createUpdateProductCategorySimpleTextContentForAlternateLocale
xlsx.category.categoryName.update.parameters.prodCatContentTypeId=CATEGORY_NAME
xlsx.category.categoryName.update.parameters.productCategoryId=${productCategoryId}
xlsx.category.categoryName.update.parameters.mainContentId=${contentId}
xlsx.category.categoryName.update.parameters.localeString=${locale}
xlsx.category.categoryName.update.parameters.text=${cellValue}
xlsx.category.categoryName.update.parameters.prodCatContentFromDate=${fromDate}
xlsx.category.categoryName.update.parameters.thruDate=${thruDate}

# Product
xlsx.product.xlsxTemplateName=ProductProduct
xlsx.product.xlsxReference=/common/static/product_content_example.xlsx

xlsx.product.productId.entity=Product
xlsx.product.productId.primary=true

xlsx.product.altUrl.entity=ProductContentAndElectronicText
xlsx.product.altUrl.entity.parameter.productContentTypeId=ALTERNATIVE_URL
xlsx.product.altUrl.entity.parameter.productId=${productId}
xlsx.product.altUrl.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.altUrl.create.parameters.productContentTypeId=ALTERNATIVE_URL
xlsx.product.altUrl.create.parameters.productId=${productId}
xlsx.product.altUrl.create.parameters.contentTypeId=DOCUMENT
xlsx.product.altUrl.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.altUrl.create.parameters.localeString=${locale}
xlsx.product.altUrl.create.parameters.text=${cellValue}
xlsx.product.altUrl.create.parameters.productContentFromDate=${now}
xlsx.product.altUrl.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.altUrl.update.parameters.productContentTypeId=ALTERNATIVE_URL
xlsx.product.altUrl.update.parameters.productId=${productId}
xlsx.product.altUrl.update.parameters.mainContentId=${contentId}
xlsx.product.altUrl.update.parameters.localeString=${locale}
xlsx.product.altUrl.update.parameters.text=${cellValue}
xlsx.product.altUrl.update.parameters.productContentFromDate=${fromDate}
xlsx.product.altUrl.update.parameters.thruDate=${thruDate}

xlsx.product.metaTitle.entity=ProductContentAndElectronicText
xlsx.product.metaTitle.entity.parameter.productContentTypeId=PAGE_TITLE
xlsx.product.metaTitle.entity.parameter.productId=${productId}
xlsx.product.metaTitle.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaTitle.create.parameters.productContentTypeId=PAGE_TITLE
xlsx.product.metaTitle.create.parameters.productId=${productId}
xlsx.product.metaTitle.create.parameters.contentTypeId=DOCUMENT
xlsx.product.metaTitle.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.metaTitle.create.parameters.localeString=${locale}
xlsx.product.metaTitle.create.parameters.text=${cellValue}
xlsx.product.metaTitle.create.parameters.productContentFromDate=${now}
xlsx.product.metaTitle.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaTitle.update.parameters.productContentTypeId=PAGE_TITLE
xlsx.product.metaTitle.update.parameters.productId=${productId}
xlsx.product.metaTitle.update.parameters.mainContentId=${contentId}
xlsx.product.metaTitle.update.parameters.localeString=${locale}
xlsx.product.metaTitle.update.parameters.text=${cellValue}
xlsx.product.metaTitle.update.parameters.productContentFromDate=${fromDate}
xlsx.product.metaTitle.update.parameters.thruDate=${thruDate}

xlsx.product.metaKeyword.entity=ProductContentAndElectronicText
xlsx.product.metaKeyword.entity.parameter.productContentTypeId=META_KEYWORD
xlsx.product.metaKeyword.entity.parameter.productId=${productId}
xlsx.product.metaKeyword.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaKeyword.create.parameters.productContentTypeId=META_KEYWORD
xlsx.product.metaKeyword.create.parameters.productId=${productId}
xlsx.product.metaKeyword.create.parameters.contentTypeId=DOCUMENT
xlsx.product.metaKeyword.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.metaKeyword.create.parameters.localeString=${locale}
xlsx.product.metaKeyword.create.parameters.text=${cellValue}
xlsx.product.metaKeyword.create.parameters.productContentFromDate=${now}
xlsx.product.metaKeyword.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaKeyword.update.parameters.productContentTypeId=META_KEYWORD
xlsx.product.metaKeyword.update.parameters.productId=${productId}
xlsx.product.metaKeyword.update.parameters.mainContentId=${mainContentId}
xlsx.product.metaKeyword.update.parameters.localeString=${locale}
xlsx.product.metaKeyword.update.parameters.text=${cellValue}
xlsx.product.metaKeyword.update.parameters.productContentFromDate=${fromDate}
xlsx.product.metaKeyword.update.parameters.thruDate=${thruDate}

xlsx.product.metaDescription.entity=ProductContentAndElectronicText
xlsx.product.metaDescription.entity.parameter.productContentTypeId=META_DESCRIPTION
xlsx.product.metaDescription.entity.parameter.productId=${productId}
xlsx.product.metaDescription.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaDescription.create.parameters.productContentTypeId=META_DESCRIPTION
xlsx.product.metaDescription.create.parameters.productId=${productId}
xlsx.product.metaDescription.create.parameters.contentTypeId=DOCUMENT
xlsx.product.metaDescription.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.metaDescription.create.parameters.localeString=${locale}
xlsx.product.metaDescription.create.parameters.text=${cellValue}
xlsx.product.metaDescription.create.parameters.productContentFromDate=${now}
xlsx.product.metaDescription.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.metaDescription.update.parameters.productContentTypeId=META_DESCRIPTION
xlsx.product.metaDescription.update.parameters.productId=${productId}
xlsx.product.metaDescription.update.parameters.mainContentId=${contentId}
xlsx.product.metaDescription.update.parameters.localeString=${locale}
xlsx.product.metaDescription.update.parameters.text=${cellValue}
xlsx.product.metaDescription.update.parameters.productContentFromDate=${fromDate}
xlsx.product.metaDescription.update.parameters.thruDate=${thruDate}

xlsx.product.longDescription.entity=ProductContentAndElectronicText
xlsx.product.longDescription.entity.parameter.productContentTypeId=LONG_DESCRIPTION
xlsx.product.longDescription.entity.parameter.productId=${productId}
xlsx.product.longDescription.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.longDescription.create.parameters.productContentTypeId=LONG_DESCRIPTION
xlsx.product.longDescription.create.parameters.productId=${productId}
xlsx.product.longDescription.create.parameters.contentTypeId=DOCUMENT
xlsx.product.longDescription.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.longDescription.create.parameters.localeString=${locale}
xlsx.product.longDescription.create.parameters.text=${cellValue}
xlsx.product.longDescription.create.parameters.productContentFromDate=${now}
xlsx.product.longDescription.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.longDescription.update.parameters.productContentTypeId=LONG_DESCRIPTION
xlsx.product.longDescription.update.parameters.productId=${productId}
xlsx.product.longDescription.update.parameters.mainContentId=${contentId}
xlsx.product.longDescription.update.parameters.localeString=${locale}
xlsx.product.longDescription.update.parameters.text=${cellValue}
xlsx.product.longDescription.update.parameters.productContentFromDate=${fromDate}
xlsx.product.longDescription.update.parameters.thruDate=${thruDate}

xlsx.product.description.entity=ProductContentAndElectronicText
xlsx.product.description.entity.parameter.productContentTypeId=DESCRIPTION
xlsx.product.description.entity.parameter.productId=${productId}
xlsx.product.description.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.description.create.parameters.productContentTypeId=DESCRIPTION
xlsx.product.description.create.parameters.productId=${productId}
xlsx.product.description.create.parameters.contentTypeId=DOCUMENT
xlsx.product.description.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.description.create.parameters.localeString=${locale}
xlsx.product.description.create.parameters.text=${cellValue}
xlsx.product.description.create.parameters.productContentFromDate=${now}
xlsx.product.description.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.description.update.parameters.productContentTypeId=DESCRIPTION
xlsx.product.description.update.parameters.productId=${productId}
xlsx.product.description.update.parameters.mainContentId=${contentId}
xlsx.product.description.update.parameters.localeString=${locale}
xlsx.product.description.update.parameters.text=${cellValue}
xlsx.product.description.update.parameters.productContentFromDate=${fromDate}
xlsx.product.description.update.parameters.thruDate=${thruDate}

xlsx.product.productName.entity=ProductContentAndElectronicText
xlsx.product.productName.entity.parameter.productContentTypeId=PRODUCT_NAME
xlsx.product.productName.entity.parameter.productId=${productId}
xlsx.product.productName.create=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.productName.create.parameters.productContentTypeId=PRODUCT_NAME
xlsx.product.productName.create.parameters.productId=${productId}
xlsx.product.productName.create.parameters.contentTypeId=DOCUMENT
xlsx.product.productName.create.parameters.drDataTemplateTypeId=NONE
xlsx.product.productName.create.parameters.localeString=${locale}
xlsx.product.productName.create.parameters.text=${cellValue}
xlsx.product.productName.create.parameters.productContentFromDate=${now}
xlsx.product.productName.update=createUpdateProductSimpleTextContentForAlternateLocale
xlsx.product.productName.update.parameters.productContentTypeId=PRODUCT_NAME
xlsx.product.productName.update.parameters.productId=${productId}
xlsx.product.productName.update.parameters.mainContentId=${contentId}
xlsx.product.productName.update.parameters.localeString=${locale}
xlsx.product.productName.update.parameters.text=${cellValue}
xlsx.product.productName.update.parameters.productContentFromDate=${fromDate}
xlsx.product.productName.update.parameters.thruDate=${thruDate}


# Product Price
xlsx.price.xlsxTemplateName=ProductPrice
xlsx.price.xlsxReference=/common/static/product_price_example.xlsx

xlsx.price.productId.entity=ProductPrice
xlsx.price.productId.primary=true

xlsx.price.productPriceTypeId.entity=ProductPrice
xlsx.price.productPriceTypeId.primary=true

xlsx.price.productPricePurposeId.entity=ProductPrice
xlsx.price.productPricePurposeId.primary=true

xlsx.price.currencyUomId.entity=ProductPrice
xlsx.price.currencyUomId.primary=true

xlsx.price.productStoreGroupId.entity=ProductPrice
xlsx.price.productStoreGroupId.primary=true

xlsx.price.defaultPrice.entity=ProductPrice
xlsx.price.defaultPrice.entity.parameter.productPriceTypeId=DEFAULT_PRICE
xlsx.price.defaultPrice.entity.parameter.productPricePurposeId=PURCHASE
xlsx.price.defaultPrice.entity.parameter.productId=${productId}
xlsx.price.defaultPrice.entity.parameter.currencyUomId=${currencyUomId}
xlsx.price.defaultPrice.create=createProductPrice
xlsx.price.defaultPrice.create.parameters.price=${cellValue}
xlsx.price.defaultPrice.create.parameters.fromDate=${fromDate}
xlsx.price.defaultPrice.create.parameters.currencyUomId=${currencyUomId}
xlsx.price.defaultPrice.create.parameters.locale=null
xlsx.price.defaultPrice.create.parameters.productPricePurposeId=PURCHASE
xlsx.price.defaultPrice.create.parameters.productPriceTypeId=DEFAULT_PRICE
xlsx.price.defaultPrice.create.parameters.productStoreGroupId=_NA_
xlsx.price.defaultPrice.create.parameters.taxAuthGeoId=${taxAuthGeoId}
xlsx.price.defaultPrice.create.parameters.taxAuthPartyId=${taxAuthPartyId}
xlsx.price.defaultPrice.create.parameters.taxPercentage=${taxPercentage}
xlsx.price.defaultPrice.create.parameters.taxInPrice=${taxInPrice}
xlsx.price.defaultPrice.update=updateProductPrice
xlsx.price.defaultPrice.update.parameters.price=${cellValue}
xlsx.price.defaultPrice.update.parameters.fromDate=${fromDate}
xlsx.price.defaultPrice.update.parameters.currencyUomId=${currencyUomId}
xlsx.price.defaultPrice.update.parameters.locale=null
xlsx.price.defaultPrice.update.parameters.productPricePurposeId=PURCHASE
xlsx.price.defaultPrice.update.parameters.productPriceTypeId=DEFAULT_PRICE
xlsx.price.defaultPrice.update.parameters.productStoreGroupId=_NA_
xlsx.price.defaultPrice.update.parameters.taxAuthGeoId=${taxAuthGeoId}
xlsx.price.defaultPrice.update.parameters.taxAuthPartyId=${taxAuthPartyId}
xlsx.price.defaultPrice.update.parameters.taxPercentage=${taxPercentage}
xlsx.price.defaultPrice.update.parameters.taxInPrice=${taxInPrice}

xlsx.price.listPrice.entity=ProductPrice
xlsx.price.listPrice.entity.parameter.productPriceTypeId=LIST_PRICE
xlsx.price.listPrice.entity.parameter.productPricePurposeId=PURCHASE
xlsx.price.listPrice.entity.parameter.productId=${productId}
xlsx.price.listPrice.entity.parameter.currencyUomId=${currencyUomId}
xlsx.price.listPrice.create=createProductPrice
xlsx.price.listPrice.create.parameters.price=${cellValue}
xlsx.price.listPrice.create.parameters.fromDate=${fromDate}
xlsx.price.listPrice.create.parameters.currencyUomId=${currencyUomId}
xlsx.price.listPrice.create.parameters.locale=null
xlsx.price.listPrice.create.parameters.productPricePurposeId=PURCHASE
xlsx.price.listPrice.create.parameters.productPriceTypeId=LIST_PRICE
xlsx.price.listPrice.create.parameters.productStoreGroupId=_NA_
xlsx.price.listPrice.create.parameters.taxAuthGeoId=${taxAuthGeoId}
xlsx.price.listPrice.create.parameters.taxAuthPartyId=${taxAuthPartyId}
xlsx.price.listPrice.create.parameters.taxPercentage=${taxPercentage}
xlsx.price.listPrice.create.parameters.taxInPrice=${taxInPrice}
xlsx.price.listPrice.update=updateProductPrice
xlsx.price.listPrice.update.parameters.price=${cellValue}
xlsx.price.listPrice.update.parameters.fromDate=${fromDate}
xlsx.price.listPrice.update.parameters.currencyUomId=${currencyUomId}
xlsx.price.listPrice.update.parameters.locale=null
xlsx.price.listPrice.update.parameters.productPricePurposeId=PURCHASE
xlsx.price.listPrice.update.parameters.productPriceTypeId=LIST_PRICE
xlsx.price.listPrice.update.parameters.productStoreGroupId=_NA_
xlsx.price.listPrice.update.parameters.taxAuthGeoId=${taxAuthGeoId}
xlsx.price.listPrice.update.parameters.taxAuthPartyId=${taxAuthPartyId}
xlsx.price.listPrice.update.parameters.taxPercentage=${taxPercentage}
xlsx.price.listPrice.update.parameters.taxInPrice=${taxInPrice}