Audit/Movement Imports from Large Retailers
Below you will find the columns that come directly from each retailer's portal into an Excel file that you can request and provide to us quarterly or semi-annually. If you have an account that is NOT on the list, review the "Other" section at the bottom of this article and request an excel file from your customer with the required data columns and send us a sample for us to add it to our suite of import tools.
KROGER
RPT_SHORT_DESC
RE_STO_NUM
UPC
ITEM_DESCRIPTION
STO_BANNER
STO_NAME
STO_ADDRESS
STO_PHONE
STO_CITY
STO_STATE
STO_ZIP
STO_CITY
Retail
Your finished report should look EXACTLY like this at the top (only with your information)
Wal-Mart
Store Nbr
Address
City
State
ZIp
Phone
UPC
Item Description
Category
POS Store Count
Avg Price
Your finished report should look EXACTLY like this at the top (only with your information)
Target
Location #
Phone
Address
City
State
Zip
Vendor
BPM Brand
Barcode
Your finished report should look EXACTLY like this at the top (only with your information)
OTHER
Store Name
*Store Number (if no phone)
*Store Phone (if no store number/abbreviation)
Address 1
City
State
Zip
Item UPC
Item Name
Item Description
Item Retail Price
Italicized fields are required.
*Both StoreNumber and Store Phone are helpful but one or the other is required to be able to map to the correct stores in your database.