Populating the Product
To populate the template, open the downloaded product template, which comprises input and output tabs. When populating, concentrate on the input tab as it requires user data input. Each template comprises an input and output tab, with the user's primary focus on populating the input tab. It's essential to note that each product template may function uniquely, with some templates containing their own specific set of instructions. However, the fundamental structure involves the input and output tabs. The output tab is automatically updated and is utilized for ingesting product variants into the P4D database. By following these steps, users can efficiently populate the template and ensure the seamless integration of product variants into the P4D system.
In the Input Tab user are required to provide the following information:
- Supplier Name: Enter the name of the company.
- Supplier ID: This unique identification is specific to each supplier and serves to differentiate product variants (e.g., product article number).
- Product Attributes: Populate the product attributes as per the requirements for each product variant. Each row in the input tab corresponds to a distinct product variant, ensuring that all necessary details are captured accurately.
- Data Validation: Each attribute within the product template is equipped with data validation properties to minimise discrepancies and enforce the input of reasonable values by users. A prompt will with error message will be provided to user if values do not meet the attributes requirement.
- Valid: The validity of the information provided will be indicated by a tick mark for valid options and a cross for missing entries. User can quickly check for any missing values.
- Columns in RED: depending on the specific template, certain product attributes may be highlighted in red, accompanied by their own set of instructions. It is crucial to adhere to these instructions meticulously to accurately populate the required fields and ensure the completeness of the product data.
Input Tab (1)
Input Tab (2)
Upon finishing the input tab, users can proceed to the output tab for a quick check. It is important to note that the output tab is protected, meaning users are not required to make any modifications to this section. The output tab serves as a reflection of the input data and ensures that the relevant product variants are accurately processed and ready for ingestion into the P4D database. User can proceed to save the file in preparation for import.
t
