CStoreOffice® Support & Learning

HHD Files Structure

Depending on the HHD model, the downloaded and uploaded handheld files should have the following structure:

RGIS Inventory

The RGIS Inventory file should have the following structure or file headers:

Department ID Name Size Cost Retail Book Inventory SKU Code
             

CSO Inventory File Format

The CSO Inventory file should have the following structure or file headers:

Department ID Name Size Cost Retail Book Inventory SKU Code
             

CSO Inventory File Format with SKU Code Type

The CSO Inventory File with SKU Code type should have the following structure or file headers:

SKU Code SKU Code Type Quantity Category ID Retail Description Cost Date Time Section
                   

Scan Shark Inventory

The Scan Shark Inventory file should have the following structure or file headers:

UPC-A (SKU Code) Name Cost Retail Book Inventory Category ID Department ID
             

Washington Inventory

The Washington Inventory file should have the following structure or file headers:

UPC Name Cost Retail Book Inventory Category ID Department ID
             

00417802718 UTZ Ripple Chip Sour003280000449000005018007 is an example of a line in the Washington Inventory file. In this example, the values in the line have the following meaning:

  • 00417802718 – 11-digit UPC without check digit. Zeros are added left to the UPC to match length of 11 digits.
  • UTZ Ripple Chip Sour – 20-symbols item name. Two spaces are added before item name.
  • 0032800 – item cost. In this example, item cost is $3.28. The item cost is multiplied by 10000 and zeros are added left to the item cost to match length of 7 digits.
  • 00449 – item retail price. In this example, item retail is $4.49. The item retail price is multiplied by 100 and zeros are added left to the item retail price to match length of 5 digits.
  • 000005 – book inventory count. In this example, the book inventory count is 5. Zeros are added left to the book inventory count to match length of 6 digits.
  • 018 – category ID. In this example, category ID is 18. A zero is added left to the category ID match length of 3 digits.
  • 007 – department ID. In this example, department ID is 7. Zeros are added left to the department ID to match length of 3 digits.