Help Documentation

Problem Statement: When attempting to import a single file from a collection of multiple files, particularly in the presence of files with multiple headers, users often encounter significant challenges and time-consuming hurdles

In the given scenario, you are tasked with importing a specific file named “Template” from the multiple files displayed in the image. The selected file “Template” contains three headers (first 3 rows). 

However, for the import process, you only wish to consider the header located at the second position or second row.

Custom Template Uploader serves as a valuable solution in this situation.

There are three key components to consider when using the Custom Template Uploader:

1. Sheet Number or Name: Specify the sheet number or name from which you want to import the file. This allows you to select the specific sheet within a workbook that contains the desired data.
2. Header Row Position: Determine the row position of the header that you want to consider during the import process. By specifying this, you can choose the appropriate row that contains the column names or field labels for your data.
3. Fixed Rows in that File: Enter your worksheet’s total number of rows. This parameter helps identify the total number of rows that should be considered while importing the file, excluding any rows that may contain irrelevant or extraneous information.

To determine the Sheet Number or Name, Header row position, and Fixed rows in the file, it is crucial to review the file shared by the client carefully. This requires attentiveness to identify hidden headers and ensure accurate Sheet Number or name entry.

Note 1: Multiple file formats such as CSV, xlsx, and xlsm are accepted.

Note 2: In Case (*)  is present in the header, that will be replaced with null.

Install Custom Template Uploader:

1. Navigate to the App Store
2. Search and click on Custom Template Uploader
3. Click on the install button

Import the file in PIM using Custom Template upload, adhere to the following step-by-step instructions:

1. Navigate to Imports
2. Click on the new import
3. Search and click on Custom Template Uploader
4. In the import details page, fill in the name for the import
5. Under Channel Detail, Select the Unbxd PIM box, and checkmark add additional 
6. Enter Sheet No Or Name, Header Row Position, and Fixed rows according to your sheet.
7. Click on Save & Proceed.
8. For Product ID, go through the file shared and check which is the unique field
9. In Configure all fields page, map all the properties
10. Click on Save and Import
11. In Case you want to save the mappings for future use, Check mark the box and give a name for the Template. This Template can be Seen in the Import Templates list.
12. Click on Save and Proceed to import

The final result looks like this: