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
- Select Criteria: End Date & Station
- 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:
- UPC#
- 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
- Click Choose File button
- Select the 3rd party inventory file from your PC
- 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
- Select CSV file for import
- 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