Working with Lottery Games

With the Import Tool, you can import lottery games data, adjust and manage it just like regular Price Book items data. For lottery games items, import from the following data sources is supported:

• Account Price Book
• Location Price Book
• File (for more details, see Preparing a File for Data Import)
• Draft

Importing Lottery Games Data

Lottery games data is imported using the Items section in the Import Tool. In general, the workflow for lottery games data import is the same as for regular Price Book items. You can perform similar activities with the lottery games data, including copying data between accounts, importing data to a station (location) from supported sources, exporting data to a file and so on. For more details, see Working with Price Book Items.

To import lottery games data, follow the steps:

1. Import lottery games data from a source to the draft. Do the following:
1. Go to Operational Menu > Price Book and then click Items.
2. Go to Drafts and create a new draft. For details, see Working with Drafts List.
3. Go to Data Sources panel and then click the Add More button.
4. Expand the section of a supported source from which you want to import data.
5. In the Lottery list, select the necessary option for data import:

• Exclude Lottery Items: select this option to import only the Price Book items data.
• Include Lottery Items: select this option to import the lottery games data together with the Price Book items data.
• Lottery Items Only: select this option to import only the lottery games data.

6. Select the criteria for uploading items. For details, see Importing Data from Different Sources.
7. Click the Load Data Source button.
8. Wait until all items are uploaded to the Items (Buffer) table.
9. Select the items that you want to import:
10. To select all items, click Select All.
11. To deselect all items, click Select None

10. Save the selected items from the buffer to your draft. For details, see Saving Data from Buffer to Draft.
2. Copy the items from the saved draft to one or several locations. For details, see Exporting Draft Data to Location.
3. Make sure the items are copied successfully. To do this, go to Home Page > Items Updates and then open the Updates Manager for your station (location) you've just imported items in.

Preparing a File for Data Import

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

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

Field Name	Mandatory (Yes/No)	Description
SKU	Yes	Item code in one of supported formats: - PLU - UPCA - UPCE - EAN8 - EAN13 - GTIN
SKU Type	Yes	SKU code type for the SKU code in the previous field. Possible values: - 0: UPCA - 1: UPCE - 2: EAN8 - 3: EAN13 - 4: PLU - 5: GTIN
Description	Yes	Item name as it appears in the CStoreOffice® Price Book.
CR Description	Yes	Item name as it appears at the cash register and in customer receipts. Must be no longer than 20 symbols. Longer values will be cropped.
Size	No	Item size and units of measurements, for example: 20 oz.
Measure Type	No	Type of measurement units. Provided for QwickServe. Possible values: - Piece - Weight - Volume
Length	No	Length of the item pack.
Width	No	Width of the item pack.
Height	No	Height of the item pack.
Retail	No	Retail price for the item.
Recommended Retail	No	Recommended retail price for the item.
Min Recommended Retail	No	Minimum recommended retail price for the item.
Max Recommended Retail	No	Maximum recommended retail price for the item.
Vendor ID	No	Vendor identifier in CStoreOffice®.
Vendor	No	Vendor name for the specified Vendor ID.
Units in Case	No	How many item units are available in a case. Is used for invoices.
VIN	No	Item code assigned by the vendor.
Cost	No	The last invoice cost.
Negotiated Cost	No	Standard item cost for Vendor ID, may be configured as postpone cost change if combined with the next two fields.
Apply Negotiated Cost from	No	Date when the postpone negotiated cost will be applied, for example, 2017-12-23. The date format is YYYY-mm-dd.
Apply Negotiated Cost to	No	Date when the negotiated cost will be removed. The date format is YYYY-mm-dd. Please note that these values can be only imported, but not exported from the Import Tool: - Apply Negotiated Cost from - Apply Negotiated Cost to In the Items file which is downloaded from the Import Tool, these two fields are always empty.
Category ID	Yes	Category ID in CStoreOffice®.
Category	No	Category name for the specified Category ID.
Department ID	Yes	Department ID in CStoreOffice®.
Department	No	Department name for the specified Department ID.
Price Group ID	No	Price Group ID in CStoreOffice®.
Price Group	No	Price Group name for the specified Price Group ID.
Promo Group ID	No	Promo Group number in CStoreOffice®.
Promo Group	No	Promo Group name for the specified Promo Group ID.
Manufacturer ID	No	Manufacturer ID in CStoreOffice®.
Manufacturer	No	Manufacturer name for the specified Manufacturer ID.
Is Recipe Item	No	Flag to mark the item as a QwickServe recipe item. Possible values: - 1: yes - 0: no
Is Ingredient Item	No	Flag to mark the item as a QwickServe ingredient. Possible values: - 1: yes - 0: no
Min Stock	No	Minimum quantity of items in stock.
Inactive on Account	No	Flag to mark the item as inactive at the account level. Possible values - 1: yes - 0: no
Inactive on Station	No	Flag to mark the item as inactive at the station (location) level. Possible values - 1: yes - 0: no
Is Not For Sale	No	Flag to mark the item as not for sale. Possible values - 1: yes - 0: no
Lottery State ID	No	Lottery state: state code specified in CStoreOffice®.
Lottery State	No	Lottery state name for the specified Lottery State ID.
Wash Expiry In Days	No	Not applicable.
Car Wash Controller Code	No	Not applicable.
Wash Type	No	Not applicable.
Wash Package Code	No	Not applicable.
Tax Default from Department	No	Flag to indicate if taxes for the item should be taken from the department taxes for the station (location). Possible values:  - 1: yes - 0: no The default value is 1. The field value should not be set to 1 if at least one of the following four fields (Tax 1-Tax 4) has the 1 value.
Tax 1	No	Flag to indicate if tax 1 is applied for the item. Possible values: - 1: yes - 0: no The default value is 0.
Tax 2	No	Flag to indicate if tax 2 is applied for the item. Possible values: - 1: yes - 0: no The default value is 0.
Tax 3	No	Flag to indicate if tax 3 is applied for the item. Possible values: - 1: yes - 0: no The default value is 0.
Tax 4	No	Flag to indicate if tax 4 is applied for the item. Possible values: - 1: yes - 0: no The default value is 0.
Product Code default from Department	No	Flag to indicate if the product code for the item should be taken from the department's product code set for the station. Possible values: - 1:yes - 0: no The default value is. The field value should not be set to 1 if the Product Code field contains any value (not empty).
Product Code	No	Product code value. Only numeric values are supported.

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 csvItemsTemplate tab, fill data the for lottery games items that you want to import.

4. Once the file is ready, switch to the csvItemsTemplate tab and save the file in the CSV or XLSX format.
   Result: You can use the saved file for import.