We need a developer to build out two features of our eCommerce website.
- 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.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
[url removed, login to view] LRG_LOGO IMAGE - store in server
[url removed, login to view] RETAILER_EMAIL - long text
[url removed, login to view] RETAILER_WEB_URL - long text
Uploaded new Home Page design as an FYI. Mockup's to illustrate the above process to follow.