EXISTING CLIENT - IMPORT SHEETS SETUP
- Under Locations > Locations:
- Add/Edit/Close Locations - Download the Export (Open) file
- Re-Open Locations - Download the Export (All) file
ADD Locations
- Navigate to a new row
- Leave "LocationID" field blank
- Fill out each required column (listed at end of article)
- Note: All new Locations will require a Store Number that has not been used for the Client/brand yet in LOCALACT
UPDATE Locations
- Update any information that needs to be modified
- NOTE: Do not remove a LocationID - this is critical to syncing information in LOCALACT
- To update a Location's store code, enter the new number in the Store Number column
- NOTE: There cannot be another Location with the same Store Number
CLOSE Locations
- To mark a Location as Closed, delete the Location's row from the sheet
RE-OPEN Locations
- Using the Export (All) sheet, change the Location's status to OPEN
____________________________________________________________________________
IMPORT PROCESS
- Navigate to Locations > Import tab
- Upload your import file
- Note: This must be in .CSV format
- Step through the import wizard
- If any issues are found, you must resolve these before completing your import
- Once all errors are resolved, re-upload your sheet and run the import process again
- Confirm the changes from the "Import" process
- Your Location changes will now be processed. Once saved, you can click View All Locations to view the Locations in the Location tab
____________________________________________________________________________
IMPORT FIELDS - Required fields are marked in bold with an asterisk*
A. LocationID*
B. Store Number*
C. Business Name*
D. Address 1*
E. Address 2
F. Address 3
G. Address 4
H. Address 5
I. City*
J. State*
K. Postal Code*
L. Country Code*
M. Latitude*
N. Longitude*
O. Phone Number*
P. Phone Number Extension
Q. Toll Free Number
R. Fax Number
S. Email Address
T. Display URL*
U. Destination URL*
V. Sunday Hours
W. Monday Hours
X. Tuesday Hours
Y. Wednesday Hours
Z. Thursday Hours
AA. Friday Hours
BB. Saturday Hours
AB. Business Description*
AC. Products And Services
AD. Brands Carried
AE. Slogan or Tagline
AF. Year Established
AG. Opening Date
AH. Language*
AI. Payment Methods
AJ. Menu URL
AK. Facebook Page URL
AL. Twitter Page URL
AM. Video URLS
AN. Company Logo URL
AO. Google Profile Photo URL
AP. Google Cover Photo URL
AQ. Image URLS
AR. Partner Id
AS. Google Labels
AT. Google Special Hours
AU. Google AdWords Extensions Phone
AV. Ownership*
AW. Labels
AX. Google Categories
AY. Bing Categories
AZ. Facebook Categories
BA. Opt-out Google Publication
BB. Opt-out Bing Publication
BC. Opt-out Facebook
BD. Opt-out Apple Publication
BE. All Publication
BF. Facebook Location Descriptor
BG. Re-Opening Date (*Required if Temporarily Closed (Column BH) is set to TRUE)
BH. Temporarily Closed
Comments
0 comments
Please sign in to leave a comment.