Hi Simon,

The problem is with the methods available in 2.1.0 we don't have a way to query across multiple collections and without that DB query, the performance is going to be really bad assuming you have more than a few products per collection (which I assume you do since you're interested in paging).

Here is main query method I wrote for 2.3.0 https://github.com/rustyswayne/Merchello/blob/mdev-230/src/Merchello.Core/Persistence/Repositories/ProductRepository.cs#L943

To give you an idea - but you'll have to follow it through to the service layer which I've implemented as internal methods since the plan for 2.3.0 to only expose those through new MerchelloHelper methods.

I should have the majority of this working in the mdev-230 branch later this week but we're not planning on releasing that version until mid to late September as there are a few more things we have planned to get into it.

As an interim solution you could do the page query directly again the database using PetaPoco using the KeyDto class (you just need the GUIDs) and then fetch each result through the MerchelloHelper class. This will normally get the construct the full IProductContent from the Examine index. We will be releasing Merchello 2.2.0 this week which I would recommend upgrading to as we've include quite a few performance enhancements for the IProductContent retrieval ...

We just released version 2.2.0 today and the code I've been working on to get this feature into the core has now been merged into the merchello-dev branch. I'm continuing to work on the back office UI today and likely through midday Thursday.

Once the back office and API integration points are in the core, you could grab a pre-release version by either building the merchello-dev branch or from the MyGet feed (but I'd suggest the first if your not comfortable working with the source since we're constantly pushing dev code which has not been fully tested). Of course we also appreciate pull requests if you want to get in there and help with the API bits.

After that is complete, we still need to come up with a high level API implementation and do some experiments (which we're doing in a separate actual site build).

Unfortunately, I can't promise anything more - we are pretty strapped resource wise and are obligated to get certain features done - luckily this one is a priority and is in progress and I'd be happy to answer any questions you might have as we work through the feature =)

TBH - I've never tried to install an upgrade over an existing package (for any package) but I would say to be conservative don't because of the PackageActions.

This may change with the Umbraco version 8 package updates and as we start concentrating more on Migration based installs.

I've included a zip file (NOT A PACKAGE) here:

Download that, UNZIP it locally and merge the contents into your solution.

It contains two directories - Merchello has the updated Merchello files, and FastTrack which respectively contains the updated FastTrack files (which you won't need if your not using a starter kit).

If you don't have any reason not to upgrade to Umbraco 7.5.2, I'd do that upgrade first ... but I did run the build on Umbraco 7.4.3.

Hi Simon,

I merged the current code into the merchello-dev branch at the end of the day yesterday. The back office is essentially done (but not thoroughly tested).

I'll be working on the exposing some extension methods over the next few days to query the multiple collections.

Will do!

Hey Simon,

Regarding filters:

Filters are essentially attributes that can be tagged onto an entity. We've only implemented filters for products, but the underlying structures are there to extend to invoices and customers as well ...

Unlike product options, they do not really have any physical characteristics, meaning they won't generate variants and are not intended to be used to convey any information about a purchase to the store owner. Instead, filters are used to quickly place products into logical sub sets to make it easier to find products.

Example:

I went to the historical fiction "Category" on Amazon and found that I could refine my list by a descriptive time period (Ancient, Medieval, Renaissance ...).

In Merchello, to replicate this, you can now create a ProductCollection named "Historical Fiction" and a ProductFilterGroup named "Historical Time Period" which contains the ProductFilters -> Ancient, Medieval ...

We are a ways out for version 2.3.0 to be final - shooting for the end of the month. The code has been merged into the merchello-dev branch if you want to build it and see if it works for you ... but again, that's sort of use at your own risk =)

Here is the latest build from AppVeyor - https://ci.appveyor.com/project/rustyswayne34779/merchello/build/2.3.0.604/artifacts

Sorry for asking again Rusty.

But which one should I download and how should I install it?

Thank you

Hey Simon,

That sort of depends on how you have your solution setup.

If your using source control, I'd do it in another branch =)

You may consider setting up a quick test site (download Umbraco and install the package in that one) and then play around in App_Code to see if it works.

Or - backup your /bin/Merchello*.dll in the project you are working on and grab the ones from that install.

Hey Simon

Here is a link to the agile board for 2.3.0 so you can track the progress http://issues.merchello.com/youtrack/rest/agile/Merchello-1/sprint/2.3.0

Yep - sorry about that. That's a minor breaking change that I was hoping to get away with =)

I've moved that method to an Extension method.

Add

 using Merchello.Web;

To your file.

Hi Rusty,

I have already Merhcello.Web.. but it is not working :/

I am accessing it just through the MerhcelloHelper:

var merchelloHelper = new MerchelloHelper();

 IProductContent product = merchelloHelper.TypedProductContentBySlug(productSlug);

Hi Rusty,

Any feedback on this error?

I am just copying the 5 Merhcello.*dll files in my bin folder and that's it.

Then it throws the above error.

I already have Merhcello.Web.. and don't know exactly how I can refer to TypedproductContentBySlug...

Thank you in advance.

You must not have all of your dependencies sorted. Are you sure all references to Merchello binaries are the same version?

Here is the method:

https://github.com/Merchello/Merchello/blob/merchello-dev/src/Merchello.Web/MerchelloHelperExtensions.cs#L83

Firstly, I installed Merhcello via Nuget.

Then I had downloaded the Merchello.2.2.0.upgrade.zip and eveything is working fine.

Now I want to test the new search that we have talked about.

All I am doing is :

1) Downloading the merhcello dev branch 2) Open it in visual studio. 3) Rebuild Solution 4) Then copy the 5 Merhcello.*dll files from the respective project to my bin folder (Core, Providers, Web, Web.Store and Examine).

And Error is throwing up.

Ideally I think that I should update it via Nuget.. what do you think?

Or else I will wait a bit and installed via nuget once it is released. Hopefully in the coming days.

Any Idea rusty about this, why it does not worked? Because now I installed the nugetpackage, I will only install the Merhcello.Core, which I need.

But I do not know exactly why the error is being thrown since I have all references.

I can't think of any. I just moved a bunch of stray methods out of the MerchelloHelper into extensions as it was a better place for them. I was actually thinking I could squeak that one in under the radar ... but you caught it right off so I think it needs to be documented in the release notes =)

Hey Simon,

You can add the product name or SKU by adding another ConstrainBy

           merchello.ProductQueryBuilder()
             .Page(2) // defaults to 1
             .ItemsPerPage(20) // defaults to 10
             .ConstrainBy([productName])
             .ConstrainBy([IProductFilter])
             .ConstrainBy([IEnumerable<IProductFilter>])
             .ConstrainBy([IProductCollection])
             .ConstrainBy([IEnumerable<IProductCollection>])
             .ConstraintByCollectionKey([IEnumerable<Guid>]) 
             .ConstrainByCollectionKey([Guid])
             .OrderBy([ProductSortField], [SortDirection])  // defaults to Name, Ascending
             .Clusivity([FilterQueryClusivity])  // weird word - values are: ExistsInAllCollectionsAndFilters and DoesNotExistInAnyCollectionsAndFilters - defaults to ExistsInAllCollectionsAndFilters
             .Execute();

The result is a PagedCollection - see https://github.com/Merchello/Merchello/blob/merchello-dev/src/Merchello.Web/Models/PagedCollection.cs

Hi Rusty,

I cannot find a way how I can filter with my properties.

Can there be a solution for the ability to search by more properties, including custom ones, as described here: https://our.umbraco.org/projects/collaboration/merchello/merchello/81871-productcontentquery-order-by-product-document-type-properties-like-createdate?

Thanks

Hi Rusty,

Do you think of any other issues that I may encounter when overwriting the current version dll files with the new ones from the dev-branch please?

Thank you

Kind Regards

No - there are just some in progress features in there (product filters). I would not use those at the moment as we're still tweaking things.

Hi Rusty,

When do you think I would be able to try it out and start using it?

All I want is to filter products only by multiple collections and by product name, that's all.

Thanks Kind Regards

Any feedback Rusty?

Thank you

Kind Regards

You can pull from the merchello-dev branch anytime you'd like or grab one of the builds from appveyor (like https://ci.appveyor.com/project/rustyswayne34779/merchello/build/2.3.0.643/artifacts)

The actual release is still a ways out - here is the progress http://issues.merchello.com/youtrack/rest/agile/Merchello-1/sprint/2.3.0

Sorry bud - we're probably not going to be releasing 2.3.0 for a couple of weeks yet.

You can grab the packages from AppVeyor builds and load them locally through your NuGet manager if you'd like.

Here is the URL from last night: https://ci.appveyor.com/project/rustyswayne34779/merchello/build/2.3.0.665/artifacts

Hi Simon,

You should not need to instantiate a CustomerContext every time you want the current customer.

Have your controller inherit from MerchelloSurfaceController which itself inherits from Umbraco's SurfaceController and provides you with a property CurrentCustomer as well as a few other Merchello bits (like the MerchelloHelper).

If you don't want to do that, instantiate it once in the controller constructor and use at as a property in your controller.

We just had a conversation about making this a request singleton in an upcoming version to protect against multiple instances of the CustomerContext being used that are not in sync with one another based on execution order.

Ok I will try it out. I just have one customer instance so don't know why exactly it is happpening.

By any chance Rusty, do you have an alternative for my need please instead of having to install the latest one?

I have explained it here: https://our.umbraco.org/projects/collaboration/merchello/merchello/80405-get-products-from-multiple-collections

Thanks

Hi Rusty,

I have updated to 2.3.2 and now my Controller is taking from MerchelloRenderMvcController and still, when user is logged in, it is returning the following error:

A member with the name 'Key' already exists on 'Merchello.Core.Models.ICustomerAddress'. Use the JsonPropertyAttribute to specify another name.

on

var currentUserBasketItems = CurrentCustomer.Basket().Items;

I don't know what I am doing wrong.

Solved it by updating the newtonsoft to 9.0.0.0