only specific city related products show to the customer when customer select specific city

Please suggest me how the products will fetch in category.
and where to write the queries for products fetching in category  
only specific city related products show to the customer when customer select specific city
please suggest me early as possible.

dipakmahalley wrote:


You will find the following file ==>
~\Nop.Services\Catalog\ProductService.cs

And Methods:

[code]
/// <summary>
      
        public virtual IPagedList<Product> SearchProducts(
            out IList<int> filterableSpecificationAttributeOptionIds,
            bool loadFilterableSpecificationAttributeOptionIds = false,
            int pageIndex = 0,
            int pageSize = int.MaxValue,
            IList<int> categoryIds = null,
            int manufacturerId = 0,
            int storeId = 0,
            int vendorId = 0,
            int warehouseId = 0,
            ProductType? productType = null,
            bool visibleIndividuallyOnly = false,
            bool markedAsNewOnly = false,
            bool? featuredProducts = null,
            decimal? priceMin = null,
            decimal? priceMax = null,
            int productTagId = 0,
            string keywords = null,
            bool searchDescriptions = false,
            bool searchManufacturerPartNumber = true,
            bool searchSku = true,
            bool searchProductTags = false,
            int languageId = 0,
            IList<int> filteredSpecs = null,
            ProductSortingEnum orderBy = ProductSortingEnum.Position,
            bool showHidden = false,
            bool? overridePublished = null)
        {
            
                       .............

        }

//For city, you have to customize code to get this feature.

Sir you have suggest this solution but this solution can not fulfill my requirements. So give me more suggestion
please early as possible.

Using the multi-store feature you could create a store for each city

Eduardo's suggestion is a good approach.  How else would "customer select specific city"?

Tecnofin wrote:.

You can do as Eduardo said earlier message.

Apart from this,

As my opinion this is one too many relationship.

So, you can provide multi-select in the product detail page which load all city.

Based on this customization you have to slightly change in search product store procedure.

Some customization also needed in front side.

Hope you will understand..!!

Sir Thanks for, you have suggest me multi-store feature but this feature is not fulfill my requirements. So this suggestion is helpful for my requirements.So please give me any other solution for only specific city related products show to the customer when customer select specific city.

Sir Thanks for, you have suggest me multi-store feature but this feature is not fulfill my requirements. So this suggestion is helpful for my requirements.So please give me any other solution for only specific city related products show to the customer when customer select specific city.

Sir Thanks for, you have suggest me multi-store feature but this feature is not fulfill my requirements. So this suggestion is helpful for my requirements.So please give me any other solution for only specific city related products show to the customer when customer select specific city.

dipakmahalley wrote:

I'm not taking about multi store.

I just told you that way you can do.

I also explain another way how you can achieve.

Hope you will understand..!!