My store version is 6.0.5. I have tested in my local pc with 3 items purchased so I should see 3 items in the best seller.
The best seller page is using a VIEW named v_Sales. I have executed the VIEW and get the correct 3 items. However in the bestsellers.aspx.vb with the following extracted statement I got 12 items showing all the variants for the 3 items:
Code:
select top 20 v_Sales.*, Product.ProductID, Product.SKU, ProductVariant.SKUSuffix, Product.Name, Product.SEName, ProductVariant.Name as VariantName
from v_Sales , Product , ProductVariant
where v_Sales.ProductID=Product.ProductID and Product.ProductID=ProductVariant.ProductID
and Product.Deleted=0 and Product.Published=1 and ProductVariant.Published=1 and ProductVariant.Deleted=0
order by NumDollars desc, NumSales desc
The problem now is I do not want to compile the code because it is in production. So if I cannot amend from the v_Sales then my final option would be implementing "Xml.BestSellersPage.xml.config".
I have copied Xml.BestSellersPage.xml.config file from version 7.1 into XmlPackages folder. I have this license too but no time to do the migration. I have registered Xml.BestSellersPage into the AppConfig as well. I went to best seller page and got the following error:
Unable to load XmlPackage: C:\inetpub\wwwroot\softheware\EntityHelper\Xml.Bes tSellersPage.xslt
I could not find this file from version 7.1. Could you help me on this? Send me this file and show me how to continue from here.
Appreciate if you could help. Thank you.