Import Product Master Data

Overview

Select the Upload icon located in the top right-hand corner of the View Product Master Data screen.

Upload CSV files and import data elements for a product's master data.

Import Product Master Data

  • CSV File – The correctly formatted CSV file with the Master Data.

The element headers below are all required in the CSV file, in order, and separated by commas. See Edit Product for country requirements. For the definitions and formats of identifiers and item codes, see Identifier and Item Code Types.

  • ProductGroupCode – An internal code defined by the user's company that identifies products in the same product classification, e.g. group code for all products related to oncology (value optional). The View Product Master Data screen uses this code to search for all products in the same classification entered into Product Master Data.
  • ItemStatus – The product's commercial status.
    • Released – The company approved the product for commercial release.
    • Alternate items available – The company has alternate items that can take the place of this product.
    • Phase out – The company phased out this product from production and sale.
    • Items no longer stocked – The company does not currently stock this product.
    • Withdrawn – The company removed this product from the market.
  • DataStatus – Whether the product data is active within TraceLink.
    • Active – The data can be used in messages and UI functions, and TraceLink pulls the data when necessary.
    • Inactive – The data cannot be pulled for other functions within TraceLink.
  • EffectiveDate – The date that the product master data takes effect (value optional).
  • ItemCodeType – The unique item code that identifies this product. Products require an item code for every target market. Each item code type can only be used once for each product, except for Internal Material Number.
  • ItemCodeValue – The value of the ItemCodeType. The value must be unique within the ItemCodeType, and special characters (e.g. -, ., /. \) are removed from this value.
  • ItemCodePrimary – Indicate the primary item code used by this company by entering Yes. TraceLink uses the primary item code to identify the correct product when the user updates the product master data by importing a CSV file or with an asynchronous message.
  • CountryMarket – Two-letter ISO 3166-1alpha-2:1997 Country Code of the Target Market's country.

    At least one Target Market is required. All fields are optional by default. See Edit Product for country requirements.

  • CountryMarketProductType – Type of product value (optional).
    • Bulk Pharmaceutical – A product that is the main active ingredient in one or more pharmaceutical formulas (e.g. antibiotics).
    • Derivative Product – A product derived from another chemical compound.
    • Food Supplement – A medicine available over the counter that is used for health and nutritional benefits.
    • Medical Device – A device developed and used for a medical purpose.
    • Nutritional Product – A specific class of over-the-counter product use for health and nutrition benefit.
    • OTC Drug – A medicine available over the counter.
    • Prescription Drug – A medicine available by prescription only.
  • CountryMarketPointOfDispenseVerification – Whether or not the product requires verification at or just prior to the dispensation to a patient (value optional).
    • Not Required – Verification is not required at or just prior to dispensation to a patient.
    • Required – Verification is required at or just prior to dispensation to a patient.
  • CountryMarketTraceabilityRequired – Indicates whether the product legally needs to be traced through the pharmaceutical supply chain (value optional).
  • CountryMarketProductOrigin – How the company acquires the product (value optional).
    • Direct Purchase from Exclusive Distributor – The company purchased the product from the sole distributor of the product.
    • Direct Purchase from Manufacturer – The company purchased the product from the manufacturer.
    • Direct Purchase from Repackager – The company purchased the product from a repackager.
    • Indirect Purchase – The company purchased the product from a wholesale distributor.
    • Originator (Exclusive Distributor) – The company, as a wholesale distributor, directly purchased the product from the manufacturer and serves as the sole distributor of the product. This option only applies if the CountryMarket is United States.
    • Originator (Manufacturer) – The company manufactures the product.
  • CountryMarketScheduledDrug – Indicates whether the product is classified in one of the schedules assigned to controlled substances (value optional).
    • Yes – The target market considers the product a scheduled drug.
    • No – The target market does not consider the product a scheduled drug.
  • CountryMarketProductImage – Image file displaying the product's appearance or packaging. The View Product Details screen displays the image, and reports for some compliance organizations might include the image (value optional).
  • CountryMarketManufacturedBy – The type of organization manufacturing the product (value optional).
    • MAH – (Marketing Authorization Holder) The company is registered as the product's MAH for this Target Market.
    • CMO – (Contract Manufacturer Organization) The company contracts a third-party organization to manufacture the product for this Target Market.
  • CountryMarketPCID – Medicinal Product Package Identifier (PCID) determines the EU Hub's Article 57 Code on Master Data Compliance Reports (value optional).
  • CountryMarketProductCategoryIdentifier – The commodity tariff code that classifies the product when determining its customs value (value optional).
  • CountryMarketReportingItemCode – The product's Item Code that is used in a specific Target Market instead of the Target Markets default Item Code for compliance reporting (value optional).
  • CountryMarketReportingItemCodeType – The type of item code used for the CountryMarketReportingItemCode (value required if CountryMarketReportingItemCode is present).
  • CountryMarketProductionType – Where the product is manufactured relative to the country defined in the Target Market (value optional).
    • Imported – The company manufactures the product outside the target market.
    • Imported and Repackaged Locally – The company manufactures the product outside of the target market but packages it in the target market.
    • Locally Manufactured – The company manufactures the product in the target market.
  • CountryMarketMAHId – The company or location identifier of the MAH, which must exist in Company or Partner Master Data (value required ifCountryMarketManufacturedBy is MAH ).
  • CountryMarketMAHIdType – The type of identifier used for the CountryMarketMAHId (value required if CountryMarketMAHId is present).
  • CountryMarketMAHInternalMaterialCode – The Internal Material Code used by the MAH for the product (value optional). This is used in Transfer Shipment workflow from CMO to MAH.
  • CountryMarketManufacturingCMOId – The company ID for the CMO manufacturing the product (value optional).
  • CountryMarketManufacturingCMOIdType – The type of identifier used for the CountryMarketManufacturingCMOId (required if CountryMarketManufacturingCMOId is present).
  • CountryMarketCMOInternalMaterialCode – The Internal Material Code used by the CMO that manufactured the product (value optional).
  • CountryMarketVirtualCMOId – The identifier for a third-party contracted to oversee the CMO (value optional).
  • CountryMarketVirtualCMOIdType – The type of identifier used for the CountryMarketVirtualCMOId (required if CountryMarketVirtualCMOId is present).
  • CountryMarketVCMOInternalMaterialCode – The Internal Material Code used by the Virtual CMO for the product (value optional).
  • DistributionPartnerID – The trade partner companies or internal locations that the MAH uses to distribute the product in the Target Market (e.g. 3PL). This company must exist in Partner Master Data or as a location in Company Master Data (value optional). Limit of 100 identifiers in the CSV import per target market.
  • DistributionPartnerType – The type of identifier used for the DistributionPartnerID (required if DistributionPartnerID present).
  • ExportMarketFromCountry – Two-letter ISO 3166-1alpha-2:1997 Country Code for the country that the company exports the product from (value optional).
  • ExportMarketToCountry – Two-letter ISO 3166-1alpha-2:1997 Country Code of the country that the company exports the product to (value optional).
  • ExportMarketUnitPrice – The price that each unit of the product sells for (value optional).
  • ExportMarketUnitPriceCurrencyCode – The currency code for the product's ExportMarketUnitPrice (value optional).
  • ExportMarketTargetMarketExemption – Indicates whether the product is exempt from regulatory compliance in the ExportMarketToCountry (value optional).
    • True – The product is exempt from the export market's regulatory compliance.
    • False – The product is not exempt from the export market's regulatory compliance.
  • ExportMarketExportCountryExemptionCode – The reason for the product's exemption, specific to India (value optional).
    • IN - Consignment – Consignments that contain products for export to countries that are eligible for exemption from India's bar-coding law.
    • IN - Manufacturer – Products that need bar-coding for the import countries' bar-coding requirements, rather than India's.
  • ExportMarketTargetMarketExemptionReference – The reference to the serialization or compliance exemption granted by the government (value optional).
  • ExportMarketTargetMarketExemptionDate – The date that the government granted the exemption (value optional).
  • ExportMarketManufacturedBy – The type of organization manufacturing the product (value optional).
    • MAH – (Marketing Authorization Holder) The company registered as the product's marketing authorization holder for this export market.
    • CMO – (Contract Manufacturer Organization) The company contracts a third-party organization to manufacture the product for this export market.
  • ExportMarketManufacturerId – The unique value associated with the MAH or CMO (value optional).
  • ExportMarketManufacturerIdType – The type of identifier used for the ExportMarketManufacturerId (required if ExportMarketManufacturerId is present).
  • ItemInfoLanguageCode – Language for the item information.
  • ItemInfoProductDescription – Typically includes the product name, dosage, form, and the number of doses.
  • ItemInfoComposition – The chemical composition of the product (value optional).
  • ItemInfoRemarks – Product-related instructions or comments not described in the previous fields (value optional).
  • ItemInfoProductCode – Regulatory product code associated with the product in China, or an additional product code in other Target Markets (value optional).
  • ItemInfoDrugName – The name of the product.
  • ItemInfoGenericName – The chemical or non-proprietary name of the product (value optional).
  • ItemInfoManufacturer – The name of the manufacturer or re-packager as it appears on the product label.
  • ItemInfoManufacturerId – The Manufacturer's ID, which must be entered into the Partner or Company Master Data to populate in the type-ahead field (value optional).
  • ItemInfoStrength – The strength of the product, e.g. 100 mg (value optional).
  • ItemInfoDosageForm – The form the product is dispensed in, e.g. tablet or pill (value optional).
  • ItemInfoEMVSDosageForm – The form the product is dispensed in according to the EU's standard set of values (value optional).
  • ItemInfoPackageSize – The number of individual doses in the pack (value optional).
  • ItemInfoEMVSPackCode – The way the product is packaged to be sold according to the EU's standard set of values (value optional).
  • PackagingCodeType – The serial numbers for the product are generated according to the packaging code type. If necessary, define a packaging code for each packaging unit of measure that needs to be tracked.
    • CN-ResCode – This packaging code type is specific to China (must be 5 digits).
    • GTIN-14 – (Global Trade Item Number) This packaging code type is accepted in any country (must be 14 digits).
    • NTIN – (National Trade Item Number) This packaging code type is specific to a single country (must be 14 digits).
  • PackagingCode – The unique value of the PackagingCodeType.
  • PackagingUOM – (Packaging Unit of Measure) Determines the level of the packaging hierarchy for this packaging code. If multiple packaging codes are defined, serial numbers can be generated for each level of the packaging hierarchy.
    • Primary – The level of packaging that physically touches the product, i.e. blister packs (not available for CN-ResCodes).
    • Each – The smallest salable unit of the product.
    • Inner Pack/Bundle – A grouping of eaches.
    • Case/Shipper – A grouping of inner packs/bundles or a grouping of eaches if the packaging hierarchy does not include inner packs/bundles.
    • Pallet – The level of packaging with cases grouped together on a pallet (not available for CN-ResCodes).
    • None – Available only for CN-Rescodes.
  • PackagingContainerAggregationQty – Number of children contained in this level of shipment. E.g. for a Case, the PackagingContainerAggregationQty would list the number of Inner Packs contained in each Case (value optional).
  • PackagingRatio – The ratio of the packaging levels included within this packaging code, e.g. 1:5:10 refers to one large Case, with 5 smaller Inner Packs/Bundles inside, each of which contains 2 Eaches for a total of 10 Eaches(required for CN-Rescodes).
  • BatchSizeMaximum – The maximum size of the batch (value optional).
  • AcceptableYield – The acceptable size of the batch determined by percent (required if BatchSizeMaximum is present). Numeric value between 1-100 only.
  • MinimumYield – The absolute minimum size the batch can be determined by percent (required if BatchSizeMaximum is present). Numeric value between 1-100 only.
  • PackagingSerializationType – The type of pattern used to generate serial numbers (value optional).
    • None – The packaging code does not generate serial numbers.
    • Random – The pattern generates serial numbers at random.
    • Sequential –The pattern generates serial numbers in sequential order.
  • PackagingRequiresAggregation – Whether each UOM requires serial numbers (value optional).
    • Aggregated – Each UOM requires serial numbers.
    • Not Aggregated – Not every UOM requires serial numbers.
  • PackagingFilterValue – Control information that allows an RFID reader to select only the packaging code for this packaging level, out of many other levels of packaging codes (value optional). Only numeric values from 0-7 allowed.
  • PackagingGS1CompanyPrefix – Prefix included in the packaging code, assigned by the GS1 organization (required if the PackagingCodeType is GTIN-14).
  • PackagingCodeVersion – The Rescode version number, e.g. 81, 88 (required if the PackagingCodeType is CN-Rescode).
  • PackagingCodeLevel – The packaging level associated with this ResCode (required if the PackagingCodeType is CN-Rescode). Only numeric values 1-9 allowed, with 1 the innermost packaging level.
  • PackagingDataStatus – Whether the packaging information data is active or inactive within TraceLink.
    • Active – The data can be used in messages and UI functions, and TraceLink pulls the data when necessary.
    • Inactive – The data cannot be pulled for other functions within TraceLink.
  • ItemInfoMinTemp – The coldest temperature the product can be exposed without compromising its quality and safety (value optional). If both the ItemInfoMinTemp and ItemInfoMaxTemp are present, the ItemInfoMinTemp must be less than or equal to the ItemInfoMaxTemp.
  • ItemInfoMaxTemp – The hottest temperature the product can be exposed without compromising its quality and safety (value optional). If both the ItemInfoMinTemp and ItemInfoMaxTemp are present, the ItemInfoMaxTemp must be greater than or equal to the ItemInfoMinTemp.

  • ItemInfoTempScale – The temperature scale that the ItemInfoMinTemp and ItemInfoMaxTemp are entered in (required if either ItemInfoMaxTemp or ItemInfoMaxTemp are present):

    • Celsius
    • Fahrenheit
    • Kelvin
  • ItemInfoLightSensitive – Indicates whether exposure to light can compromise the product's quality and safety (value optional):
    • Yes – Exposure to light can compromise the product's quality and safety.
    • No – Exposure to light does not compromise the product's quality and safety.
  • ItemInfoMarketDosageForm – The form the product is dispensed according to a specific Target Market's set of values (value optional).
  • ItemInfoLightSensitive – Indicates whether exposure to light can compromise the product's quality and safety (value optional):
    • Yes – Exposure to light can compromise the product's quality and safety.
    • No – Exposure to light does not compromise the product's quality and safety.
  • ItemInfoShelfLifeUOT – Indicates the unit of time that the ItemInfoShelfLife is entered in (required if ItemInfoShelfLife is present):
    • Days (default)
    • Months
    • Years
  • ItemInfoShelfLife – The length of time that a product remains consumable for (value optional, must be a number between 1-9999).

  • CountryMarketRegistrationClassification – The type of medicine that a product is registered as (value optional):

    • Biological – A medicine that is manufactured in a living system such as a microorganism, or plant or animal cells.
    • Chemical – A medicine that is typically manufactured through chemical synthesis.
    • Patent Medicine – A traditional or herbal medicine with a standardized formula that is packaged into pill or tablet form and sold over the counter.
  • CountryMarketPrescriptionDrugType – The medicine classification for a product (value optional).
  • CountryMarketPermanentImportLicenseNumber – The license number granted to import product that cannot be exported and will remain in the country permanently (value optional).
  • CountryMarketPermanentImportLicenseEndDate – The date on which the CountryMarketPermanentImportLicenseNumber expires (value optional).
  • CountryMarketTemporaryImportLicenseNumber – The license number granted to import product that will remain in the country temporarily before being re-exported (value optional).
  • CountryMarketTemporaryImportLicenseEndDate – The date on which the CountryMarketTemporaryImportLicense expires (value optional).
  • CountryMarketImporterID – The identifier value of the company that is importing the product into the Target Market (value optional).
  • CountryMarketImporterIDType – The identifier type of the company that is importing the product into the Target Market (value optional).
  • CountryMarketDrugRepackagingLicenseNumber – The license number granted to repackage a product (value optional).
  • CountryMarketRepackagingLicenseEndDate – The date on which the CountryMarketDrugRepackagingLicenseNumber expires (value optional).
  • CountryMarketRepackagerID – The identifier value of the company that repackages the product (value optional).
  • CountryMarketRepackagerIDType – The identifier type of the company that repackages the product (value optional).
  • CountryMarketMarketingAuthorizationNumber – The product’s authorization number issued by a government agency (value optional).
  • If multiple item codes are specified, the one specified in the first row must be the ItemCodePrimary.
  • Due to the possibility of multiple item codes, the CSV import adds new item codes found in the import file and does not replace existing item codes (e.g. TraceLink cannot differentiate between changing a value and adding a value).
  • Do not represent a null value in a CSV file with any type of character or empty space; simply enter a comma to move to the next value.
  • Multiple selections (if applicable) can be made within the CSV file, but they must be separated by a pipe (|) symbol and not a comma.
  • Some information can have more than one instance in the CSV file. If the following information is provided multiple times for one product (e.g. more than one item code is provided), the second instance (and beyond) must be entered in the rows directly below the main row:
    • Item Code
    • Target Market

      • Distribution Partner IDs

    • Export Markets
    • Item Information
    • Packaging Information

    Additional rows cannot contain a ProductGroupCode, CountryMarket, ItemStatus, or DataStatus.

Files used for importing data must contain the correct formatting in order to be accepted. Uploaded files must provide the correct series of columns, in order, as in the example files.

  1. Download the sample file by selecting ProductsSample.csv on the Import Product Master Data screen.
  2. If prompted, select Save, not Open.

  3. View the CSV file in a text editor or in Microsoft Excel.

    If opening in Excel, follow the procedure in Opening Exported CSV Reports with Excel.

Available Actions

For information about formatting CSV files and instructions for downloading a sample file, see Troubleshooting.

  1. Select Choose File.
  2. Browse for and select the desired CSV File (see Formatting the CSV for more information).
  3. Select Submit.

    The View Product Master Data screen displays, and TraceLink begins asynchronously processing the product information.

Error Messages

All error messages are preceded by the "line [file line number]" identifier.

Error Messages Descriptions
Only values from 1 to 100 permitted. If the Acceptable Yield field is not a valid numeric value (1-100), the error results.
Only values between 1 and the value in the Acceptable Yield field permitted. If the Minimum Yield field is not a valid numeric value (1-Acceptable Yield value), the error results.
Acceptable Yield is required if Batch Size Maximum is entered. If the Acceptable Yield field is not provided and a Batch Size Maximum is present, the error results.
Minimum Yield is required if Batch Size Maximum is entered. If the Minimum Yield field is not provided and a Batch Size Maximum is present, the error results.
Found no lines with comma-separated values to process. If the file is not a text file or cannot parse as a .csv, the error results.
Invalid file format - header must contain the columns "ProductGroupCode","ItemStatus", "DataStatus", "EffectiveDate","ItemCodeType", "ItemCodeValue", "ItemCodePrimary", "CountryMarket", " CountryMarketProductType", "CountryMarketPointOfDispenseVerification", "CountryMarketTraceabilityRequired","CountryMarketProductOrigin", "CountryMarketScheduledDrug", "CountryMarketProductImage", "CountryMarketManufacturedBy", "CountryMarketPCID", "CountryMarketProductCategoryIdentifier", "CountryMarketReportingItemCode", "CountryMarketReportingItemCodeType", "CountryMarketProductionType", "CountryMarketMAHId", "CountryMarketMAHIdType", "CountryMarketMAHInternalMaterialCode", "CountryMarketManufacturingCMOId", "CountryMarketManufacturingCMOIdType", "CountryMarketCMOInternalMaterialCode", "CountryMarketCountryMarketVirtualCMOId", "CountryMarketVirtualCMOIdType", "CountryMarketVCMOInternalMaterialCode", "ExportMarketFromCountry", "ExportMarketToCountry", "ExportMarketUnitPrice", "ExportMarketUnitPriceCurrencyCode", "ExportMarketTargetMarketExemption", "ExportMarketExportCountryExemptionCode", "ExportMarketTargetMarketExemptionReference", "ExportMarketTargetMarketExemptionDate", "ExportMarketManufacturedBy", "ExportMarketManufacturerId", "ExportMarketManufacturerIdType", "ItemInfoLanguageCode", "ItemInfoProductDescription", "ItemInfoComposition", "ItemInfoRemarks", "ItemInfoProductCode", "ItemInfoDrugName", "ItemInfoGenericName", "ItemInfoManufacturer", "ItemInfoManufacturerId", "ItemInfoStrength", "ItemInfoDosageForm", "ItemInfoEMVSDosageForm", "ItemInfoPackageSize", "ItemInfoEMVSPackCode", "PackagingCodeType", "PackagingCode", "PackagingUOM", PackagingContainerAggregationQty", "PackagingRatio", "PackagingSerializationType", "PackagingRequiresAggregation", "PackagingFilterValue", "PackagingGS1CompanyPrefix", "PackagingCodeVersion", "PackagingCodeLevel", "PackagingDataStatus" and no spaces. If the file header is incorrect, the error results.
[field] may not contain < > or \. If any field has bad characters, the error results.
[field] may not be empty. The file is missing a required field (excluding the packaging fields which are conditionally required based on the packaging item code).
Invalid value for [field]. The error is thrown when a field must be from a list of valid enumerated values (Long lists).
Invalid value for ItemCodeType. Valid values are AT - PZN, BE - ABP Code, BR - Anvisa Registration Number, CA - DIN, CH - Swissmedic, CN - Subtype Code, DE - PPN, DE - PZN, EAN13, ES - Codigo National, FR - CIP-13 Code, GR - EOF Code, HR - Crotia National Code, IN - Product Code, IT - Bollino, Internal Material Number, KR - KFDA Code, LU – Luxembourg National Number, NL - KNMP, NRD - Nordic VNR Drug Code, PT - AIM Number, SA - Saudi Drug Code, UK - AMPP, US - NDC442, US - NDC532, US - NDC541 and US - NDC542 The error is thrown when a field must be from a list of valid enumerated values (for ItemCodeType).
ItemStatus must either be "Active" or "Inactive". The error is thrown when a field must be from a list of valid enumerated values (short lists).
Product must have a primary item code specified when ProductGroupCode, ItemStatus or DataStatus are specified. The error is thrown if the first line for a specified product doesn't have a "Yes" in the primary item code field.
[field] may not be empty when ProductGroupCode, ItemStatus or DataStatus are specified. The error is thrown if any of the item fields are specified then they must all have a value.
First line must specify a ProductGroupCode, ItemStatus and DataStatus. The error is thrown if the first line of the file doesn't have a value in the first 3 columns.
[field] must be specified when PackagingItemCodeType is [item code type]. Based upon the value of the packaging item code, if any of the conditionally-required fields are not specified, the error results.
[field] cannot be specified when PackagingItemCodeType is [item code type]. The error is thrown if a value is specified when it should not be based upon the item code type.
CN-Subtype Code not defined in ItemCodeType for CN-ResCode [field]. If a CN-ResCode is specified as a PackagingItemCodeType, but the CN-Subtype is not specified as an associated ItemCodeType, the error results.
Invalid value for CountryMarketProductType. Valid values are "Derivative Product", "Medical Device", "Nutritional Product", "OTC Drug" and "Prescription Drug". CountryMarketProductType (if entered) must be one of the valid values.
Base64 representation of the selected image exceeds 2 KB. If the CountryMarketProduct​Image URL points to an image in Base64 representation > 2 KB, the error results.
File type must be BMP, JPG, GIF or PNG. If CountryMarketProduct​Image is of the wrong file type, the error results.
Production Type is optional and value(s) must be "Imported" or "Locally Manufactured". If Production Type is specified, value(s) must be "Imported" or "Locally Manufactured"or the error results.
Reporting Item Code value may not be the same as an Item Code Value. The CountryMarketReportingItemCode type and value cannot already be entered as the product's CountryMarketItemCode type and value.
Country Markets MAH ID Type value must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE". If Country Market MAH ID is specified, Country Market MAH ID Type value must be specified and must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE" or the error results.
Country Market MAH ID value not found for specified [Country Market MAH ID Type]. If Country Market MAH ID is specified, it must be valid for the specified Country Market MAH ID Type value or the error results.
Country Market Manufacturing CMO ID Type value must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE". If the Country Market Manufacturing CMO ID is specified, Country Market Manufacturing CMO ID Type value must be specified and must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE" or an error results.
Country Market Manufacturing CMO ID value not found for specified [Country Market Manufacturing CMO ID Type]. If Country Market Manufacturing CMO ID is specified, it must be valid for the specified Country Market Manufacturing CMO ID Type value or the error results.
Country Market Virtual CMO ID Type value must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE". If the Country Market Virtual CMO ID is specified, Country Market Virtual CMO ID Type value must be specified and must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE" or the error results.
Country Market Virtual CMO ID value not found for specified [Country Market Virtual CMO ID Type]. If the Country Market Virtual CMO ID is specified, it must be valid for the specified Country Market Virtual CMO ID Type value or the error results.
Submit up to 100 Distribution Partner ID (S), but no more. Only 100 Distribution Partner IDs can be defined for a single product.
Currency Code must be provided for Unit Price. ExportMarketUn​itPriceCurrencyCode must be provided if ExportMarketUnitPric​e is not blank or the error results.
Invalid value for ExportMarketExportCountr​yExemptionCode. Valid values are "IN - Consignment" and "IN - Manufacturer". If ExportMarketExportCountr​yExemptionCode if left blank or contains invalid values the error results.
Export Markets Manufacturing CMO ID Type value must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE". If Export Markets Manufacturing CMO ID is specified, Export Markets Manufacturing CMO ID Type value must be specified and must be "AR_CUIT", "BR_CNPJ", "BR_CPF", "BR_CNES", "BR_PROF_REG", "CN_CHINA_ID", "COMPANYID", "DUNS", "DUNS4", "GCP", "GLN", "SGLN", "COMPANYSITEID", "DEA", "HIN", "IN_COMPANY_ID", "IN_IEC", "IN_PAN", "IN_TIN", "KR_BUS_REG_NUMBER", "KR_PROVIDER_CODE" or the error results.
Export Markets Manufacturing CMO ID value not found for specified [Export Markets Manufacturing CMO ID Type]. If Export Markets Manufacturing CMO ID is specified, it must be valid for the specified Export Markets Manufacturing CMO ID Type value or the error results.
Invalid ItemInfoManufacturerId %s since it does not exist in Company Master Data or Partner Master Data. If ItemInfoManufacturerId is specified, it must exist in Company or Location Master Data or Partner Master or Partner Location Master Data or the error results.
Found no lines with comma-separated values to process. The error is thrown if the file is not a text file or cannot parse as a .csv, the error results.
Only positive integer values are allowed. If the Batch Size Maximum field is not a valid numeric value, the error results.
Only values from 1 to 100 permitted. If the Acceptable Yield field is not a valid numeric value (1-100), the error results.
Only values between 1 and the value in the Acceptable Yield field permitted. If the Minimum Yield field is not a valid numeric value (1-Acceptable Yield value), the error results.
Acceptable Yield is required if Batch Size Maximum is entered. If the Acceptable Yield field is not provided and a Batch Size Maximum is present, the error results.
Minimum Yield is required if Batch Size Maximum is entered. If the Minimum Yield field is not provided and a Batch Size Maximum is present, the error results.
Error Messages Descriptions
An IN-Product Code is required for India. ItemCodeType IN-Product Code is required if India is a Target Market, if not provided the error is thrown.
ScheduledDrug field is required if CountryMarket is India and value must be "Yes" or "No". If India specified as Country Market, CountryMarketScheduledDrug cannot be blank and must contain value "Yes" or "No".
ProductImage field must contain a URL to a product image that is retrievable or the text IMAGE SET. If India specified as the CountryMarket, and CountryMarketProduct​Image is specified, the field must contain a URL for an image to be retrieved, or the field must contain the text "IMAGE SET". Following the term IMAGE SET, the file name may or may not be included.
Country Market Manufactured By field is required if Country Market is India and the value must be "MAH" or "CMO". If India specified as a CountryMarket, then CountryMarketManufacturedBy cannot be blank and must contain value "MAH" or "CMO".
Country Market Manufacturing CMO ID field is required to be set to GS1 Company Prefix if Country Market is India and Country Market Manufactured By is "CMO". If India is specified as a Country Market and "CMO" is specified as Country Market Manufactured By, the Manufacturing CMO ID must be GS1 Prefix or the error results.
Export To Country is required for Export From Country IN. If ExportMarketFromCoun​try is IN, then ExportMarketToCountr​y must be specified or the error results.
Unit Price must be in the range of 0.50 – 9999999.99 for Export From Country IN. The value entered is outside of this range. If ExportMarketFromCoun​try is India, and ExportMarketUnitPric​e is specified, the range of allowable values must 0.50 – 9999999.99.
ExportMarketExportCountr​yExemptionCode must be provided for Export From Country IN if Target Market Exemption is "Yes". If ExportMarketFromCoun​try is IN and ExportMarketTargetMarketExemption = "Yes", then ExportMarketExportCountr​yExemptionCode must be specified or the error results.
Exemption Reference must be provided for Export From Country IN if Target Market Exemption is Yes. If ExportMarketFromCoun​try is IN and ExportMarketTargetMa​rketExemption = "Yes", then ExportMarketTargetMa​rketExemptionReferen​ce must be specified or the error results.
Exemption Date must be provided for Export From Country IN if Target Market Exemption is Yes. If ExportMarketFromCoun​try is IN and ExportMarketTargetMa​rketExemption = "Yes", then ExportMarketTargetMa​rketExemptionDate must be specified or the error results.
Another row with this Export From and Export To Country Codes already exists. There should be unique combination for each Export From and Export To country codes pairing, i.e. IN / US cannot be listed more than once or the error results.
Export Markets Manufactured By field is required if Export From Country is India and value must be "MAH" or "CMO". If India specified as a Export From Country, then Export Markets Manufactured By can not be blank and must contain value "MAH" or "CMO" or the error results.
Export Markets Manufacturing CMO ID field is required to be set to GS1 Company Prefix if Export From Country is India and Country Market Manufactured By is "CMO". If India specified as a Export From Country and "CMO" is specified as Export Markets Manufactured By, Manufacturing CMO ID must be GS1 Prefix or the error results.
Product must have an Item Information row with a language of "English". If US or IN is specified as a CountryMarket, an ItemInfoLanguageCode with a value corresponding to English must be entered or the error results.
ItemInfoGenericNa​me may not be empty. If IN is specified as a CountryMarket, ItemInfoGenericName must be provided or the error results.
ItemInfoCompositi​on may not be empty. If IN is specified as a CountryMarket, ItemInfoComposition must be provided or the error results.
ItemInfoManufacturerId must be of type GCP (GS1 Global Company Prefix). If IN is specified as a CountryMarket, ItemInfoManufacturerId must be of type GCP (GS1 Global Company Prefix), i.e. "GCP (GS1 Global Company Prefix) [6- to 12-digit number]" or the error results.
PackagingContaine​rAggregationQty is required for PackagingUOM = "Each" when Country Market = IN or Export From Country = IN. PackagingContainerAg​gregationQty is required for PackagingUOM = "Each" when CountryMarket = IN or ExportFromCountry = IN or the error results.
ScheduledDrug required for Product [CountryDrugCode type] [CountryDrugCode]. The error is thrown if the Country Market = IN OR ExportFromCountry = IN and ScheduledDrug is not found.
Enter a Container Aggregation Quantity. The error is thrown if the PackagingContainerAggregationQty is required for PackagingUOM = "Each" when CountryMarket = IN or ExportFromCountry = IN.

These error messages apply to EU and EU FMD countries.

Error Messages Descriptions
CountryMarketProductType may not be empty. CountryMarketProductType field is required for any EU Countries and Turkey (CountryMarket = "TR"), if not provided the error is thrown.
Country Market MAH ID value required for [Country Market]. If Country Market is an EU country AND the company owns an EU Compliance app, Country Market MAH ID is required. If not present, the error results.
Country Market PCID value required for [Country Market]. If Country Market is an EU Country, CountryMarketPCID is required.
CountryMarketPointOfDispenseVerification may not be empty. If any EU country is specified as a CountryMarket, same row must also contain value in CountryMarketPointOfDispenseVerification column or the error results.
Distribution Partner ID not found in Partner Master Data. If the DistributionPartnerID is specified, the value must be associated with a Company or Location in the Partner Master Data.
Product must have an Item Information row with a language of "English." If any EU country is specified as a CountryMarket, an ItemInfoLanguageCode with a value corresponding to English must be entered or the error results.
ItemInfoStrength may not be empty. If any EU country is specified as a CountryMarket, the ItemInfoLanguageCode row with a value corresponding to English must contain a value in the ItemInfoStrength field or the error results.
ItemInfoPackageSize may not be empty. If any EU country is specified as a CountryMarket, the ItemInfoLanguageCode row with a value corresponding to English must contain a value in the ItemInfoPackageSize field or the error results.
ItemInfoEMVSDosageForm may not be empty. If any EU country is specified as a CountryMarket, the ItemInfoLanguageCode with a value corresponding to English must contain a value in the ItemInfoEMVSDosageForm field or the error results.
ItemInfoEMVSPackCode may not be empty. If any EU country is specified as a CountryMarket, the ItemInfoLanguageCode with a value corresponding to English must contain a value in the ItemInfoEMVSPackCode field or the error results.
Error Messages Descriptions
CountryMarketProductType may not be empty. CountryMarketProductType field is required for any EU Countries and Turkey (CountryMarket = "TR"), if not provided the error is thrown.
Error Messages Descriptions
Invalid value for CountryMarketTraceabilityRequired. Valid values are "Required" and "Not Required". CountryMarketTraceabilityRequired field is required if US is the Target Market.
CountryMarketProductOrigin field is required if US is target market. If US specified as a CountryMarket, the same row must also contain value in CountryMarketProductOrigin column.
Another row with this Export From and Export To Country Codes already exists. There should be unique combination for each Export From and Export To country codes pairing, i.e. IN / US cannot be listed more than once or the error results.
Product must have an Item Information row with a language of "English". If US or IN is specified as a CountryMarket, an ItemInfoLanguageCode with a value corresponding to English must be entered or the error results.
ItemInfoStrength may not be empty. If US is specified as a CountryMarket, and the CountryMarketProductType is NOT one of "Medical Device", "OTC Drug", "Nutritional Product", or "Derivative Product", the ItemInfoLanguageCode row with a value corresponding to English must contain a value in the ItemInfoStrength field or the error results.
ItemInfoDosageForm may not be empty. If US specified as a CountryMarket, and the CountryMarketProductType is NOT one of "Medical Device", "OTC Drug", "Nutritional Product", or "Derivative Product", the ItemInfoLanguageCode row with a value corresponding to English must contain a value in the ItemInfoDosageForm field.
ItemInfoPackageSize may not be empty. If US is specified as a CountryMarket, and the CountryMarketProductType is NOT one of "Medical Device", "OTC Drug", "Nutritional Product", or "Derivative Product", the ItemInfoLanguageCode row with a value corresponding to English must contain a value in the ItemInfoPackageSize field or the error results.
Error Messages Descriptions
Product must have an Item Information row with a language of "Simplified Chinese. If CN is specified as a CountryMarket, an ItemInfoLanguageCode with a value corresponding to Simplified Chinese must be entered or the error results.
ItemInfoStrength may not be empty. If CN is specified as a CountryMarket, the ItemInfoLanguageCode row with a value corresponding to Simplified Chinese must contain a value in the ItemInfoStrength field or the error results.
ItemInfoPackageSize may not be empty. If CN is specified as a CountryMarket, the ItemInfoLanguageCode row with a value corresponding to Simplified Chinese must contain a value in the ItemInfoPackageSize field or the error results.
Error Messages Descriptions
Product must have an Item Information row with a language of "Portuguese". If BR (for Brazil) is specified as a CountryMarket, an ItemInfoLanguageCode with a value corresponding to Portuguese must be entered or the error results.