Dealer List Auto-Sync

If your system easily exports a dealer list file or you have a shared document that can be uploaded on dropbox or FTP, auto-sync is ideal.

Your dealer list file must contain the following required fields: 

  • Vendor ID: this is a unique code you generate for each location

  • Store Name

  • Address 1

  • Address 2

  • Zip

  • Phone

  • Country

Optional:

  • Categories

Column headers must match our column header name or alias


Field Name

Alias Names

name 

store, company_name, company, vendor_name, storename, account_name, company_name_-_store_finder, dba/ship to name, name 1, customer: customer name, customer name

address

address_1, addr, address1, address_line_1, address_1_-_store_finder, street, addr1

address_2

addr_2, addr2, address2, address_line_2, address_2_-_store_finder

city

town, city_-_store_finder

state

province, statecode, state/province, state/province__-_store_finder, state_prov, st

zip

zip_code, postal_code, postalcode, zipcode, zip/postal_code, zip_-_store_finder, postal

country 

country_code, countrycode, store_finder_-_country, country_-_store_finder, ctry



url

website, link, companyurl, web_address

phone

ph, phonenumber, store phone, phone_number





categories

category, cats, cat, specialty, category name

vendor_id

id, bp_code, company_number, no., vendor id/ uid, internal_id, uuid/vendor id, location code, address number


Syncing your file with Locally

Locally can sync with your dealer list file at most online destinations. The most popular are Dropbox or SFTP. 

  • Dropbox: setup a new Dropbox folder and title it “Locally.” Share the folder with dropbox@locally.com and notify your Client Success Manager. Drop your file in the folder. Locally will link our system to scan this folder nightly and absorb any changes. 

  • SFTP: to push your file to us via FTP/SFTP, please request FTP credentials from your Locally Client Success Manager. Once provided, drop your file in the folder. Locally will set-up our system to poll this path nightly and absorb any changes. 

Making Automatic Updates

If you’re generating this list from an internal CRM that is automatically uploading the spreadsheet at a pre-determined frequency, Locally will scan your file nightly. Updates will appear every morning. Outlier data (incorrect or new store data) is reconciled within 48 hours during the business week.  

Additional details:

  • File Name: either ensure the file name is the same, or provide a file name scheme that includes a date or time-stamp that Locally can write an adaptor for. Contact your Client Success Manager for setup assistance and approval. 

  • Frequency: Locally syncs your data nightly (appx. midnight Eastern Time, UTC -5)

Making Updates

If you’re making periodic manual changes to a dealer list, simply save your updated spreadsheet to your shared Dropbox folder or FTP destination. Ensure the file name is the same so it overwrites the previous file. If you change the file name, our system will not sync with the new file. 



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.