CStoreOffice® Support & Learning

File Import

You can populate the Price Book by uploading a file with Price Book data to CStoreOffice®. This file must be a comma delimited file.

Make sure your departments are assigned to your categories. Otherwise your items will fall in the 'No Category' section in the Items Update Manager and will not be sent to the cash register.

The file must have the following format:

SKU Code, SKU Code TYPE, Description, Size, CR Department, Retail.

where:  

  • SKU Code (Stock Keeping Unit) - UPCA/E or EAN8/13 or PLU. All digits with check digit.
  • SKU Code Type meanings:
  • UPCA  = 0
  • UPCE  = 1
  • EAN8  = 2
  • EAN13 = 3
  • PLU   = 4
  • Description - item description.
  • Size - item size.
  • CR department - cash register department to which the item must belong.
  • Retail - retail price for the item.

File Sample

For example, you can upload a file with the following data to CStoreOffice®:

002410012243,0,"SUNSH CHZ-","N/A",7,3.49
7441001610295,3,"CARAMEL SUNDAE","Reg",40,10.43
002430083520,0,"CHOE MINI ","",7,0.50
002200015938,0,"ALTOIDS CI","",3,1.89
01006809,1,"ENCORE T-FOLD NAPKINS","",96,0.00