CStoreOffice® Support & Learning

Main Workflows Overview

Generally, the process of setting up a Price Book with the Import Tool includes the following main steps:

Steps Corresponding menu Example
Step 1: Select a Price Book
element to be configured.
Go to Operational Menu > Price Book - The Items element is selected.
Step 2: Take a draft. Go to Operational Menu > DRAFTS - The New_Items draft is created and selected for further editing.
Step 3: Populate the draft with the relevant data. Go to Working Area - All Price Book items from the selected location are uploaded to the draft's buffer.
- Valid items only are selected and saved to the New_Items draft.
Step 4: Copy data from the draft to the location or a file. Go to Data Sources panel - The data from the New Items draft are imported to your location.

To create a Price Book from scratch on your account, you can use any of the following scenarios:

How to Import Price Book from Account or Station

Steps

  1. Select a price book element. Go to Price Book, and then click Items.
  2. Take a draft. Go to Drafts, and then do the following:
  3. Create a new items draft. For details, see Working with Drafts List.
  4. Select the newly created draft.

  5. Populate the selected draft with the relevant data. Do the following:
  6. Go to the Data Sources panel, and then click Add More.
  7. Depending on the import source you want to use, click Account Price Book or Location Price Book.
  8. Specify the importing criteria. For details, see one of the following sections:
  9. Importing Items from Account Price Book
  10. Importing Data from Location Price Book
  11. Click Load Data Source.

  12. Wait until the data is uploaded to the Items (Buffer) table.
  13. (Optional) Edit data in the Items (Buffer) table. For details, see Editing Data in Buffer.
  14. Select the items you need. To select all items, click Select All.
  15. Save selected items from the buffer to your draft. For details, see Saving Data from Buffer to Draft.

  16. Copy data from the draft to your location. For details, see Exporting Draft Data.

How to Import Price Book from Cash Register Dump File

Steps

  1. Select a price book element. Go to Price Book, and then click Items.
  2. Take a draft. Go to Drafts, and then do the following:
  3. Create a new items draft. For details, see Working with Drafts List.
  4. Select the newly created draft.

  5. Populate the selected draft with the relevant data. Do the following:
  6. Go to the Data Sources panel, and then click Add More.
  7. Click Location Cash Register.
  8. In the Locations list, select the location with the connected cash register from which you want to import data.
  9. Click Browse, and then select the cash register's dump file.
  10. Click Load Data Source.

  11. Wait until the data is uploaded to the Items (Buffer) table.
  12. (Optional) Edit data in the Items (Buffer) table. For details, see Editing Data in Buffer.
  13. Select the items you need. To select all items, click Select All.
  14. Save selected items from the buffer to your draft. For details, see Saving Data from Buffer to Draft.

  15. Copy data from the draft to your location. For details, see Exporting Draft Data.

How to Import Price Book from a File

Steps

  1. Select a price book element. Go to Price Book, and then click Items.
  2. Take a draft. Go to Drafts, and then do the following:
  3. Create a new items draft. For details, see Working with Drafts List.
  4. Select the newly created draft.

  5. Populate the selected draft with the relevant data. Do the following:
  6. Go to the Data Sources panel, and then click Add More.
  7. Click From File.
  8. Click Browse, and then select the cash register's dump file.
  9. Click Load Data Source.

  10. Wait until the data is uploaded to the Items (Buffer) table.
  11. (Optional) Edit data in the Items (Buffer) table. For details, see Editing Data in Buffer.
  12. Select the items you need. To select all items, click Select All.
  13. Save selected items from the buffer to your draft. For details, see Saving Data from Buffer to Draft.

  14. Copy data from the draft to your location. For details, see Exporting Draft Data.

How to Import Price Book from Handheld Inventory File

Steps

  1. Select a price book element. Go to Price Book, and then click Items.
  2. Take a draft. Go to Drafts, and then do the following:
  3. Create a new items draft. For details, see Working with Drafts List.
  4. Select the newly created draft.

  5. Populate the selected draft with the relevant data. Do the following:
  6. Go to the Data Sources panel, and then click Add More.
  7. Click Handheld.
  8. Items to load - displays the number of items to be uploaded to the buffer.
  9. To upload less items, enter your number manually. In this case the most popular and frequently used items will be uploaded.

  10. Location - start typing the location's name or select one or several locations from the list.
  11. Files - select the handheld inventory file from the list.
  12. Click Load Data Source.

  13. Wait until the data is uploaded to the Items (Buffer) table.
  14. (Optional) Edit data in the Items (Buffer) table. For details, see Editing Data in Buffer.
  15. Select the items you need. To select all items, click Select All.
  16. Save selected items from the buffer to your draft. For details, see Saving Data from Buffer to Draft.

  17. Copy data from the draft to your location. For details, see Exporting Draft Data.