Profile: smoothumut

Thanks.

Hi,

Thanks for your return. Sorry, but our license is expired, so I can't open a ticket.

Our need is very simple actually. We need to change these two lines AND p.Published = 1' with this one AND ((p.Published = 1) OR (p.Published = 0 AND DATEDIFF(DAY, p.SoldDate, getdate()) <= 60))'. That's all.

Hope you'd help us.

Regards,
Y.

Hi,

Thanks for your return. Sorry, but our license is expired, so I can't open a ticket.

Our need is very simple actually. We need to change these two lines AND p.Published = 1 with this one AND ((p.Published = 1) OR (p.Published = 0 AND DATEDIFF(DAY, p.SoldDate, getdate()) <= 60))'. That's all.

Hope you'd help us.

Regards,
Y.

Hi,

We want to show sold products in category pages too. We'd altered ProductLoadAllPaged, and it works fine when we open a category page. But, after we go to page 2 or change order or change page size, these sold products are disappearing.

As we understand, ProductLoadAllPagedNopAjaxFilters is locked, so here is our question: Can we add WHERE clause to the seven_spikes_ajax_filters_product_sorting function?

Please help us about this matter.

Thanks.