CStoreOffice® Support & Learning

Importing Linked Items

During the setup process of the first location on the account, all items are imported into CStoreOffice® together with all linked items for the following cash registers:

  • Verifone Sapphire
  • Verifone Commander
  • Bulloch BT9000, Esso
  • Gilbarco Passport

For all next locations on the account, linked items are imported from the cash register only for those items that did not have linked items before. All linked items that were imported during first location setup process are not overwritten by new values, if any.

If you need to import only linked items, use the information described in this section as a reference.

The procedure for importing items from the file is described in the Importing Items to a Station (Location) section.

A file for linked items has the same format as the one used for regular items import. The file of such type allows to:

  • Import links only
  • Import both links and items with all parameters

The file structure used for the regular items import is described in the Preparing a File for Data Import section.

If items already exist on the account and it is needed to import only links between them, one can use only next fields for the file:

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/No Item name as it appears in the CStoreOffice® Price Book. This field is required if the CR Description value is not provided.
CR Description Yes/No Item name that will appear at the cash register and in customer receipts. Must be no longer than 20 symbols. Longer values will be cropped. This field is required if the Description value is not provided.
Linkable Optional Flag indicating that this item is linkable. Possible values:
- 1: Yes
- 0: No
This field must be populated to transfer linkable items and items to which they are linked.
CRV Item Optional Linked item SKU without a check digit. Must be populated for items that have linked items (and the Linkable value is 0).