This is very common question asked in multiple Magento forums, but rarely answered or properly answered. With this expectation that may be I'm lucky and some one will show me the right way to achieve the following requirements -
1. Need a popup on startup of web site, allowing user to select his/her State and City (India Only). 2. Display products and their respective prices ONLY from selected state-city by user. 3. If user want then they can able to change their city from dropdown at the top left corner of the every page
I have 2-3 ideas for achieving my requirement, as a new to Magento may be my ideas are not feasible or viable, so I need suggestions /advises / guidance
Idea 1. Creating Multi View Store Idea 2. Creating Category Structure like this: State->City->Product_Category->Product->Sub_Product(if any) and then fetch state and cities to popup where both he value will be in drop down from where where user will select state and city, finally depending on the selections product and price attribute will filtered and displayed. Idea 3. Adding custom attribute for all the cities like this- key->City_State, value->Kolkata(WB) for each product, means suppose there are total 100 cities from all states, and 100 products, this means 100x100 records. Idea 4. Make the products configurable where, city is one of the configurable fields.
Now I request you all Magento experts to tell me whether my ideas are correct or garbage. Which one is the best and easy to implement for my situation, obviously also keep Performance of the site in mind.
Waiting for expert views.
Thank you all for participation.