APQP: Bulk Package Import
New APQP/PPAP packages can be created either by selecting the Create APQP option on the main menu, or by clicking the "Add APQP" button located in the top-right of any APQP/PPAP list page.
Packages may be generated "In-Bulk" via the Bulk Import page where your company is listed as the customer. This means there are two options for bulk create:
- Internal packages generation where your company is the customer only
- Supplier packages
Select the appropriate package type (Supplier or Internal) then download the import Excel template. Please perform this action before every import as the template looks at your company's APQP configuration (as well as other) settings and updates the template accordingly. The below table highlights every column in the table, whether they are required or condition, their character limits or required formats, and options allowed for entry. If columns are not enabled within your account related to package requirements, the headers will be struck-through to indicate entries are not permitted.
Only one template may be uploaded at a time (but there is not a limit on the number of entries within the spreadsheet). Once the "Create" button is clicked, the system will process the request and send an update via email should there be any errors or once the work is completed.
| Column Name | Required or Conditional | Character Limits | Options Allowed |
| Part Number | Required | 100 | Free entry - may need to be validated against part list |
| Part Name | Required | 250 | Free entry - may need to be validated against part list |
| Part Revision | Not Required | 100 | N/A |
| Drawing Number | Not Required | 512 | N/A |
| Drawing Revision | Not Required | 512 | N/A |
| Program | Required | N/A - dropdown | Authorized programs against session user - cannot take into account part # |
| Checklist Template | Required | N/A - dropdown | Internal Package: Internal Only and All templates Supplier Packages: Supplier and All templates |
| Submission Level | Required | N/A - dropdown | From setting "Customer can Initiate the APQP/PPAP Process for the following Submission Levels" |
| Detail or Assembly | Required | N/A - dropdown | Detail, Assembly |
| Customer | Pre-Populated | N/A - dropdown | Session company name |
| Customer Division | Conditional | N/A - dropdown | Session company divisions authorized by user - may need to be validated against part list |
| Customer Package Owner(s) | Not Required | N/A - dropdown | Session company users but it does not filter by role. Includes departments |
| Supplier | Required | N/A - dropdown | Session company supplier list |
| Supplier Code | Not Required | N/A - dropdown | Session company supplier codes on supplier list page |
| Supplier Division | Conditional | N/A - dropdown | Selected supplier division |
| Pkg Start Date | Not Required | Format - MM/DD/YYY | N/A |
| Pkg Due Date | Not Required | Format - MM/DD/YYY | N/A |
| PO Number | Not Required | 50 | N/A |
| Project Name | Not Required | N/A - dropdown | Session company active project list |
| Is this a lead part in a part family? | Not Required | N/A - dropdown | No, Yes |
| Lead part package # | Not Required | Numerical | N/A |
| Comments | Not Required | 500 | N/A |
| Risk Level | Conditional | N/A - dropdown | Low, Medium, High |
| Design/Build Responsibility | Conditional | N/A - dropdown | Design and Build, Design Only, Build Only |
| APQP-Directed or PPAP? | Conditional | N/A - dropdown | APQP-Directed, PPAP |
| Reason for Change | Conditional | N/A - dropdown | Session company reason for change list |