3rd Party Audit Information

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.

Import 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), the 3rd Party Audit Company must convert them to full 12 digit format.

To import a 3rd party file go to Inventory > SKU Inventory and click the search button

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

The SKU Inventory Editing page will open

Complete the required fields:
1. Select Store
2. Select Recon (Inventory) Date
*Be sure to back date if using Realtime inventory
3. Click Save

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

The attachments window will open

  1. Click Choose File button
  2. Select the 3rd party inventory file from your PC
  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

The Import window will display

  1. Select CSV file for import
  2. Click OK

The inventory file will import to display results

Once the file is imported, please proceed through the processing steps to book your audit: Processing Take Inventory From Import