Dear Sir / Madam,
I have a overview about your application. Recently, I was support to improve an application like your app.
As I understand, we need something to do:
- Create a migrate to merge two table State and City data to a new one Location.
- Make a relationship between two table Production and Location. (as you said, it's product location)
- Create a migrate to fill location to exists products via State and City.
- Make a function to allow Admin (User) to change Location for the Shop. And then, Products of this shop will change location too. (on Admin page).
- Update search product by location instead state and city.
- Update select field to autocomplete field. When User input some keywords. The application will be list on this field suggestion.
- Test application after implement new update.
Please let me know when I got an mistake.
Thanks