Technical Requirements for SKU-Based Inventory Services.pdf
PDF 964 KB Posted
- Attached to
- SKU-Based Inventory Services
- Solicitation number
- HQC005-25-RFI-0002
- Issued by
-
Defense Commissary Agency
About this file
This is a technical requirements document detailing the file formats and data structures for SKU-based inventory services at Defense Commissary Agency (DeCA) locations. The document specifies requirements for both fixed weight and random weight items across front-of-store and back room inventory management.
The requirements outline four key inventory file types: front-of-store fixed weight items, back room fixed weight items, front-of-store random weight items, and back room random weight items. Each file type requires specific data fields including item descriptions from the DeCA Master Catalog, SKU codes (including UPC-A, EAN, JPN, and PLU formats), and cost/pricing information. For random weight items, the document provides detailed formulas for calculating extended prices and converting between price per pound and total package costs. The contractor must provide inventory files back to DeCA with specific formats for both fixed weight and random weight items, including total quantities and costs for front-of-store and back room inventory.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| STATEMENT OF WORK SKU Based Inventory.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Technical Requirements DeCA SKU-Based Inventory Services
1. Technical Requirements
A. Catalog file format from DeCA to Contractor: DeCA will provide the item catalog in the following file format to the contractor for each store:
I. Front of the Store Inventory file - Fixed weight items
Item Description Item SKU Code Item Cost by each This column will have the DeCA description of the item from the Master Catalog
This column will include the following:
UPC-A (12 digits with check digit) EAN ( 13 digits with check digit) UPC Compressed (6/7/8 with check digit) JPN (8 with check digit) PLU ( 4 or 5 – no check digits required) the cost of each item by each
Sample Grocery Items with UPCs/EAN and JPNs
II. Back room inventory file for UPC coded items - Fixed weight Items
Item Description Item SKU Code Item Cost by each or
Price per Pound This column will have the DeCA description of the item from the Master Catalog
This column will include the following:
UPC-A (12 digits with check digit) EAN ( 13 digits with check digit) UPC Compressed (6/7/8 with check digit) JPN (8 with check digit) PLU ( 4 or 5 – no check digits required) the cost of each item by each
Case Label for Bush’s Baked Beans Original – Fixed Weight UPC on the label and “12” is the Unit quantity within the case
Case Label for Salmon Curry Paste Original – Fixed Weight UPC on the label and “42” is the Unit quantity within the case
Salmon Curry Paste
III. Front of the store inventory file for Random Weighted Items
Item Description Item SKU Code Item Cost - Price per Pound
This column will have the DeCA description of the item from the Master Catalog
This column will include the following:
Random weight UPCs which starts with a
“2”, followed by the PLU and six “0”s for the extended price of the product
This column will have price per pound for random weight items
Random Weighted Items (Front of the Store)
IV. Back room inventory file for Random Weighted Items
Item Description UPC of Random weighted items Price per Pound the DeCA description of the item from the Master Catalog
This column will include the following:
• Random weight UPCs which starts with a “2”, followed by the PLU and six “0”s for the extended price of the product
This column will include the price per pound for random weight items
Random Weight Case Label Chicken Drumsticks- “39.2” is the number of pounds
39.2
B. File format from Contractor to DeCA : The contractor shall provide the following file with fixed weight items back to DeCA:
Item Description
Item SKU Code Item Quantity Total Cost by item
This contractor shall provide the DeCA description of the item from the Master Catalog
This column will include the following:
UPC-A (12 digits with check digit) EAN ( 13 digits with check digit) UPC Compressed (6/7/8 with check digit) JPN (8 with check digit) PLU ( 4 or 5 – no check digits required) Other SKUs based on the
GS1 standard will need to be included
This column will include the total quantity by each in front of the store and back room of the store
This column will include the total cost by each in front of the store and the back room
C. File format from Contractor to DeCA : The contractor shall also provide the following file for random weight items back to DeCA:
Item Description
Item SKU Code Item Quantity Total Cost by item
This contractor shall provide the DeCA description of the item from the Master Catalog
This column will include the following:
Random weight UPCs which starts with a “2”, followed by
For Random weight items this column include the weight of the back room cases and the calculation of the random weight items in front of the store as shown below
For Random weight items this column include the “Extended price” by Random weight item plus the total cost for the back room random weight cases
Formula to be used for final inventory file back to DeCA for Random weight items:
Extended price = The last 5 digits on the Random weight label =$14.33
Price per pound will be provided in the Item catalog = $4.37
Number of pounds per package = Extended price / Price per pound = 14.33/4.37 = 3.28 pounds
| Technical Requirements |
| DeCA SKU-Based Inventory Services |
File details come from the government source that posted it. Updated .