We need a developer to build out two features of our eCommerce website.

First feature
– Use IP detection to Customize Website

1 Display Matching Local Retailer Logos
1.1 Detect IP address
1.1.1 Use IP2Location OR Maxmind to determine visitor STATE and COUNTRY
Query COUNTRY and STATE value detected with MySql DB of RETAILERS

IF no STATE exists, label visitor in session INTERNET CUSTOMER and record STATE, COUNTRY and IP address in VISITORS DB table

ELSE IF STATE exists then query unique RETAILER records from RETAILERS table that match the state. Display small image logos on home page of each unique retailer in database table.

AFTER matching STATE logos displayed, continue to display unique records NOT EQUAL to STATE matched IP address in order to display all retailers small image logos.

SECOND FEATURE – Maintain visitor STATE/COUNTRY and Suggest Local Retailer to purchase / pickup product @ Checkout

2.1 Display list of retailers in STATE for customer to choose as pickup location

2.1.1 Provide search box under above list as alternative ZIP CODE lookup to display stores by zip code in case initial IP detection at logon incorrect.

Send user onto eCommerce process using our developer suggested eCommerce platform that integrates with Drupal and can be programmed to maintain a custom field of store pickup through eCommerce, email notification process.
An email should be sent to RETAILER via lookup of RETAILERS table to notify of sale.

THIRD – DATABASE TABLES

3.1 RETAILERS

3.1.1 STATE – long text
3.1.2 RETAILER_NAME – long text
3.1.3 STREET ADDRESS – long text
3.1.4 CITY – long text
3.1.5 COUNTRY – long text
3.1.6 POSTAL CODE – long text
3.1.7 REGION – long text
3.1.8 TELEPHONE – text
3.1.9 SML_LOGO IMAGE – store in server
3.1.10 LRG_LOGO IMAGE – store in server
3.1.11 RETAILER_EMAIL – long text
3.1.12 RETAILER_WEB_URL – long text

3.2 VISITORS

3.2.1 COUNTRY
3.2.2 CITY
3.2.3 IP_ADDRESS
3.2.4 STATE

Tags: address, block ip address website, completely restrict website access ip address, display, eCommerce, fiddler find website ip address, find ip address accesses website, find ip address website, image, ip address website access script, restricing website ip address php, restrict access website ip address, restrict website ip address, retailer, state, text3, website ip address generator