CStoreOffice® Support & Learning

Working with Price Book Departments

With the Import Tool, you can perform the following operations with the departments:

Copying Departments between Accounts

To copy the Price Book departments using the Import Tool, follow the same steps as for copying categories but for departments. For details, see Copying Categories between Accounts.

Please note that the departments are configured on the account level. So, in case the departments are exported to any location, the departments of the whole account are updated automatically as well.

Importing Departments to Current Account

To import the departments to the current account, follow the steps:

  1. Go to Operational Menu > Price Book and then click Departments.
  2. Go to DRAFTS and create a new draft. For details, see Working with Drafts List.
  3. Import departments to the draft from any of the available data sources:
  4. For more information on importing data to the draft, see Importing Data to Draft.

  1. Account Price Book
  2. GateKeeper - for more details, see Importing Data from GateKeeper.
  3. Location Cash Register
  4. Please note that you may need to adjust in the draft's table the names of the departments imported from the Location Cash Register as the names of the departments in the cash registers can be too long for the price book.

  5. Drafts
  6. From File
  7. For more information on working with the data sources, see Importing Data from Different Sources.

  8. Copy the draft's data to any of the current account's locations. For details, see Exporting Draft Data.
  9. The departments are configured on the account level. So, in case the departments are exported to any location, the categories of the whole account are updated automatically as well.

Exporting Departments from Current Account to a File

To export the departments from the current account to a file, follow the steps:

  1. Go to Operational Menu > Price Book and then click Departments.
  2. Go to DRAFTS and create a new draft. For details, see Working with Drafts List.
  3. Import departments to the draft from the Account Price Book source.
    For details, see Importing Data to Draft, Import Item Tags or Promotions from Account Price Book.
  4. Export the departments from the draft to a file. For details, see Exporting Draft Data.

Managing Account Departments

You can manage the account departments in the draft and then save this draft to any location to apply changes to the whole account. For more information on how to update the departments in the draft, see Editing Draft Manually.

Preparing a File for Data Import

You can use CSV or XLSX files to import data about Price Book departments and work with them in the Import Tool. In the file, you must provide data for all departments whose data you want to import. Each line in the file contains data for a separate Price Book department. Each entry in the line corresponds to a specific department field, and each comma indicates where one entry ends and another entry begins.


The file that you use for import of departments data must have the following structure. Non-mandatory fields can be omitted.

Field Name Mandatory (Yes/No) Description
Number Yes Unique department ID.
Name Yes Department name.
Source No Source of record, can contain custom text or be left empty.
Description No Department description.
Min Price No Minimum price amount that must be applied to direct sales at the cash register.
Max Price No Maximum price amount that must be applied to direct sales at the cash register.
Default Price No Default price amount that can be applied to direct sales at the cash register.
Matched Category ID No Category ID that must be connected with the department.
Matched Category No Category name that must be connected with the department.
Department Type ID No Department type code. Possible Values:
- 0 = Store
- 1 = Fuel
- 2 = Car Wash
- 3 = Not for Sale
- 4 = Money Orders
- 5 = Lottery Instant Sales
- 6 = Lottery Instant Payouts
- 7 = Lottery Online Net Sales
- 8 = Other Income
Department Type No Text representation of the department type, works in pair with the Department Type ID and must have a text value equal to a code or be left blank. The following values allowed:
- Store
- Fuel
- Car Wash
- Not for Sale
- Money Orders
- Lottery Instant Sales
- Lottery Instant Payouts
- Lottery Online Net Sales
- Other Income
Income ID No ID of income type. Allows a user to save income type from the file to the system list.
Income No Name of income type. Allows a user to save the income type name from the file to the system list.
Tax1 No Flag that allows a user to apply Tax 1 to items at the cash register. Possible values:
- "1" - tax is applied
- "0" - tax is not applied
Tax2 No Flag that allows a user to apply Tax 2 to items at the cash register. Possible values:
- "1" - tax is applied
- "0" - tax is not applied
Tax3 No Flag that allows a user to apply Tax 3 to items at the cash register. Possible values:
- "1" - tax is applied
- "0" - tax is not applied
Tax4 No Flag that allows a user to apply Tax 4 to items at the cash register. Possible values:
- "1" - tax is applied
- "0" - tax is not applied
Min Age No Minimum customer's age that is required to sell items.
NCR Sales Restriction Code No Specific for NCR (National Cash Register) sales restriction code.
Possible values:
- Prompt for price
Tender 1 Restricted
Tender 2 Restricted
Tender 3 Restricted
Tender 4 Restricted
Tender 5 Restricted
Tender 6 Restricted
Tender 7 Restricted
Tender 8 Restricted
Tender 9 Restricted
Non-discountable
Non-lockable
No Price Overrides
Food Stamp Allowed No Flag that allows a customer to use food stamps as a method of payment. Possible values:
- "1" - allowed
- "0" - not allowed
Neg No Flag that allows a user to set up the item price as payout from the cash register (for example, Lottery payments to the customer).
Blue Laws No Allows a user to manage flags at the cash register. Indicates the rule applied:
- "0" - No
- "1" - Yes
Blue Laws2 No
CMA No Flag that indicates the cost method of accounting for the department . Possible values: 
- "0" - No
- "1" - Yes
Default Sales Qty No Default sales quantity for the item.
Product Code No Product code for this department that is sent to the cash register. Applies to locations selected on export.
Check H.ID No Sign indicating that it is necessary to verify the buyer's ID before the sale. Possible values: 
- "1" - Yes
- "0" - No
Transaction Quantity Limit No The maximum quantity of items which can be sold in one transaction. Possible values:
- Empty
- Certain number
GL # No General Ledger number that is assigned to the department.
Ma Category No Department Matched Category

File Template

To construct a file for import, you can use a template provided by Petrosoft. To get the template and prepare the file, follow the steps: 

  1. In the Import Tool, on the Data Sources panel, select From file.
  2. Click the Download example link.

  3. The downloaded file is provided in the XLSX format:
  • On the Fields Description tab, get information about every entry that must be filled in the file.
  • On the csvDepartmentsDatasourceTemplate tab, fill data for the departments that you want to import.
  1. Once the file is ready, switch to the csvDepartmentsDatasourceTemplate tab and save the file in the CSV or XLSX format.
    Result: You can use the saved file for import.