Pricebook file for Auditors:

3rd party auditors will require a pricebook file from your back office system prior to audit. The report you will use in S2K is called ‘Product Export for Audit’.

In the Report List section located in the Home navigation toolbar, click Product Export for Audit Report available in the Non-Fuel Inventory section

The report criteria will display

  1. Select Criteria: End Date & Station
  2. Click Search

When the report opens, click the export button and select Excel

The file will download to your PC

Open the file on your computer and click Save As. Change the file type to CSV and save. Then just email this report to the inventory company.

Importing Take Inventory Data from 3rd Party

This feature allows you to import a take inventory file from a 3rd party inventory company. Once you import it you can process the take inventory like you normally would in S2k as if you used your own handheld.

3rd party Company Inventory/Audit files must be formatted as per the following specs:

  • Must be submitted in CSV format
  • Contain only the following two columns:
    1. UPC#
    2. Audit count

UPC# formatting

  • Items must be submitted with 12 digit UPC codes
  • If you have any UPC-e items (short codes), they must be converted to full 12 digit format

To import an inventory file go to Inventory > SKU Inventory and click the search button

The SKU Inventory listing page will display, click the new button

This image has an empty alt attribute; its file name is new-button.png

The SKU Inventory Editing page will open

Complete the required fields:
1. Select Store
2. Select Date of inventory
3. Click Save

To import the 3rd party file, click the attachments button

The attachments window will open

This image has an empty alt attribute; its file name is selecting-file-2-1024x439.png
  1. Click Choose File button
  2. Select the 3rd party inventory file from your PC
    *Be sure to back date if using Realtime inventory
  3. Click Open

The attachment window will update to show csv file available for import

Next, click the action button at the top of the window and select Import from Attachments

This image has an empty alt attribute; its file name is import-from-attachments.png

The Import From Attachments window will display

This image has an empty alt attribute; its file name is import-window.png
  1. Select CSV file for import
  2. Click OK

The inventory file will import and display results in the SKU Inventory Editing page