Augmentation of Seed Data for PIES XML File

[MasterHardik]

Overview

This issue addresses the need to augment the seed data for the PIES(Product Information Exchange Standard) XML file by adding new identification types that currently do not exist. This will resolve foreign key constraint errors encountered during execution.

Requirements

• Add the following GoodIdentificationTypeId and description values to the GoodIdentificationType entity in the file located at: applications/datamodel/data/seed/ProductSeedData.xml

  <GoodIdentificationType description="GTIN-12" goodIdentificationTypeId="UP" hasTable="N"/>
  <GoodIdentificationType description="GTIN-13" goodIdentificationTypeId="EN" hasTable="N"/>

  • This addition is to be done manually using OFBiz's Webtools, as per the requirements of the PIES file data.
  • Ensure these additions satisfy foreign key constraints to prevent errors during processing, and also resolve issues for a few other values as well.

Additional Changes

Also consider augmenting the following entries to enhance product feature, content, and pricing information with their respective code line :

• ProductFeatureType

  <ProductFeatureType description="Extended Product Information" hasTable="N" productFeatureTypeId="EXPI"/>

• ProductContentType

  <ProductContentType description="Digital Assets" hasTable="N" productContentTypeId="DA"/>
  <ProductContentType description="Digital File Information" hasTable="N" productContentTypeId="DFI"/>

• ProductPriceType

<ProductPriceType description="Standard Price" productPriceTypeId="AC1"/>

Ensure that the added entries do not violate existing foreign key constraints.

Next Steps

• Run the below command to properly load the entity data.

  ./gradlew loadall

• Validate the augmented seed data against the PIES XML schema.
• Test to ensure no foreign key constraint issues occur while parsing the PIES xml file consisting the Items data.
• cna check the sample test file in InputXMLFile folder in.

[MasterHardik]

Progress Update

• Updated the progress, but it's at the ofbiz-framework root folder, so skipping to push changes coz it contains only my plugin data.

File Path :

 ofbiz-framework/applications/datamodel/data/seed/ProductSeedData.xml

[MasterHardik]

Points to Consider on Installation & Setup

• On installing it for the First Time few more issue need to fix if they still persist !
• In the ProductCategoryType entity create three values : BRAND, VMRS, SUBBRAND, AAIA
• In the GoodIdentificationType entity from webtools add values : [goodIdentificationTypeId : UP , description : GTIN-12 ] & [goodIdentificationTypeId : EN , description : GTIN-13 ]

Note: Just see path above in applications/datamodel/data/seed/ just add the data first to resolve.

[MasterHardik]

• Remember to extend field named facilityGroup in the in the productPrice table if its not created on load command Path: HotWax-Systems-Training/entitydef/entitymodel.xml

  <field name="facilityGroupId" type="id"><description>Extended Field for Facility Group Id</description></field>

[MasterHardik]

• Add the value facilityGroupTypeId = PRICE_REGION & Description = Price by region in entity FacilityGroupType
• Add the value in ProductPriceType entity as B2C_OFFER_PRICE & Description Business to Customer Offer Price