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), 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
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
- Click Choose File button
- Select the 3rd party inventory file from your PC
*Be sure to back date if using Realtime inventory - 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 From Attachments window will display
- Select CSV file for import
- Click OK
The inventory file will import and display results in the SKU Inventory Editing page