CStoreOffice® Support & Learning

Site Trading Hours

The Import Tool allows you to import and work with site trading hours of locations (stations) on your current account. The imported data include the site name and ID, information about work days and trading hours set for the station.

With the Import Tool, you can perform the following actions with the stations trading hours:

Updating Trading Hours for Account Stations

To update the trading hours for the stations on your current account, follow the steps:

  1. Go to Operational Menu > Import Data Station and then click Site Trading Hours.
  2. Go to DRAFTS and create a new draft. For details, see Working with Drafts List.
  3. Go to Data Sources Panel and then do the following:
  4. Click the Add More button.
  5. Click Account Stations.
  6. In the Location list, select one or several locations, which data you want to update.
  7. Click Load Data Source.

  8. Edit the trading hours for the stations you need in the draft table. For details, see Editing Draft Manually.
  9. Select the updated stations and then in the Data Sources Panel, click Save To.
  10. Make sure the trading hours for the stations on your account updated successfully on your account:
  11. Go to CStoreOffice® Settings > General > Locations.
  12. In the Locations list, select the station you need to check and then click Edit.
  13. In the General stations settings, go to the Working Hours section.

Importing Trading Hours for Account Stations

You can import the trading hours for the stations on your account from the existing draft or from a file.

To import the trading hours for the stations on your account from a draft or a file, follow the steps:

  1. Go to Operational Menu > Import Data Station and then click Site Trading Hours.
  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. Depending on which source you are going to use for importing stations data, expand one of the following sections:
  5. Drafts - expand this section if you want to import stations data from the existing draft:
  6. Drafts - select the draft saved and shared by another user.
  7. My drafts - select this option to display your own saved drafts in the Drafts list.

  8. From File - expand this section if you want to import stations data from a file:
  9. Make sure the file you want to import data from has a correct data structure. To see the data structure example, click Download Example.
  10. Select the file by clicking Browse.
  11. In the Type field, select the file type.

  12. Click Load Data Source.
  13. You can import trading hours only for the stations that already exist on your current account. Non existing stations are highlighted in red in the draft.

  14. In the draft, select the stations the trading hours of which you need to import to your account and then in the Data Sources Panel, click Save To.

  15. Make sure the general stations data are updated successfully on your account:
  16. Go to CStoreOffice® Settings > General > Locations.
  17. In the Locations list, select the station you need to check and then click Edit.
  18. In the General stations settings, go to the Working Hours section.

Managing Trading Hours for Account Stations

You can manage the information about the trading hours for the stations on your account in the draft and then save this draft to your account.

For more information on how to update the trading hours for your account stations in the draft, see Editing Draft Manually.

Preparing File with Stations Trading Hours for Importing

To import the stations trading hours from a file, fill in this file with the stations data based on the template below.

You can import the data only for the stations already existing on your current account.

The file used for importing the stations trading hours has the following data structure:

  • External site ID
  • CSO Site ID
  • Site Name
  • Work Day
  • From Opening Hour
  • From Opening Min
  • To Opening Hour
  • To Opening Min