LIFOPro has completed the annual updates to the Excel file used by LIFOPro clients for populating BLS PPI Table 9 category names via VLOOKUP formulas in their inventory detail files. LIFOPro clients should use the email received containing the Complete Table 9 PPI Category Name file download link to obtain the updated file (feel free to call or email us to obtain the download link if needed). LIFOPro clients can use the download link provided to them to obtain the updated file. The changes represent the cumulative set of added, deleted (discontinued) and recode PPI categories/codes that have been published over the last year (BLS publishes these changes tri-annually; LIFOPro updates the PPI Table 9 Category Name File annually). The LIFOPro software’s PPI category name file (catname.ppi) has also been updated to include these changes and LIFOPro software users that have automatic downloads enabled will have this file updated automatically upon entering the IPIC module. LIFOPro software users that manually download their PPI LIFOPro software files from the “Other Downloads & Resources” tab of our downloads page will need to download the updated catname.ppi file to replace their old file.
How & Why the BLS Changes PPI Table 9 Categories
How and why the BLS changes PPI categories are dependent on the type of the change; they are as follows:
- Additions- These changes represent PPI categories that the BLS begun collecting price surveys and publishing price indexes on for the first time. Common reasons why additions are made relate to new products being produced that never existed before as a result of technological advances. Examples include plastic products that used to only be produced using metal and new types of carbonated and non-carbonated beverages that were previously unavailable but are now produced on a large scale
- Deletions (discontinuations)- These changes represent PPI categories that the BLS has published price indexes for in the past but will no longer collect price surveys nor publish indexes for in the future. Common reasons why deletions occur include commodities becoming obsolete (i.e., windmills or typewriters) or an insufficient amount of price surveys being available to merit index publication (this often happens with products that used to be but are no longer made in the United States due to production facilities being moved to foreign countries; examples include certain children’s toys and many consumers electronics products).
- Recoded – These changes represent PPI categories that the BLS has and will continue to publish price indexes for under a different – numbered PPI commodity code. For the 2026 work, none fell into the recoded category.
How The Changes Impact IPIC PPI LIFO Calculations for LIFO-PRO Clients
Clients are largely unaffected by these changes as the LIFOPro software automatically reassigns the appropriate replacement codes to discontinued and recoded PPI categories. We do encourage them to review the list of new PPI categories in order to determine if PPI category assignments should change for items that the new code applies to (see list below). Please reach out if you’d like to discuss.
Notable BLS PPI Table 9 Category Changes
- New Codes:
| PPI Code | PPI Category Description |
|---|---|
| 02890121 | Spoon-type salad dressing incl. mayonnaise and sandwich spreads |
| 02890122 | Pourable type salad dressing |
| 03810446 | Fur and leather apparel, made from purchased materials |
| 10220191 | Copper, zinc and other primary nonferrous metals (excluding aluminum) |
| 102301041 | Other copper and brass scrap |
| 12410301 | Household refrigeration equipment |
- Discontinued Codes:
| PPI Code | PPI Category Description |
|---|---|
| 03810428 | Leather and sheep-lined apparel, made from purchased materials |
| 10230104 | Other copper and brass scrap |
| 123101013 | Carpets and rugs, tufted |
| 159705011 | Brooms |
| 159705012 | Mops and dusters, including refills |
| 159705021 | Paint and varnish brushes |
| 159705022 | Paint holders, pads, roller frames, and rollers |
| 159705031 | Personal brushes |
| 159705032 | Brushes, other than personal |
