| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Bestsellers without Advanced Statistics (4.4.3 Gold) | ||||
|
|
Thread Tools | Search this Thread |
#11
|
|||||||
|
|||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
I wish I could be more help, but I really don't know what else could be different between your version and 4.4.3. I did check and I don't think XC_TIME was used in older versions. So you would want to change that to time(). Some servers require you to define a time zone in order to use PHP time functions. So that's something else you should look into. As far as order of products, the final order is alphabetical, not in order of number ordered. The func_search_products function that is used to actually retrieve the bestsellers does not recognize the orders or order_details tables. The $salesprod_data query does retrieve items based on their number ordered, date of order, etc., so the resulting array of product IDs will contain the correctly sorted IDs. However, the final bestsellers are simply products whose IDs that are in that array, but they are sorted alphabetically by product name. As far as products not showing up, make sure they truly were ordered within the timeframe you've specified and you have designated a high enough number of bestsellers to select. Otherwise, I would say there must be other differences between the current existing X-Cart functions and queries and those in your version.
__________________
X-Cart Gold 4.1.8 (Live) BCSE Shipping Estimator for FLC Mod BCSE Shipping Methods per Product Mod BCSE Customer Review Management Mod BCSE Catalog Order Form Mod X-Cart Gold 4.5.2 (Building/Testing) USA |
|||||||
#12
|
|||||||
|
|||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
I did change XC_Time to time() and it didn't seem to help but it may have. I was looking for the items to be sorted by number sold, not alphabetical.
So if I understand correctly now I need to select more items for the best sellers to get them to show on the category pages as well? Please go to my site and let me know if this is working correctly. http://www.bmkdesigns.net I have 5 items on the home page which is what I want. On the category pages the only ones that show are the same 5 items in their respective category. The 4 carbon items in carbonfiber and the servo in servos. I was under the assumption that 5 items would show in all categories if 5 items had been sold in the selected time frame. So I may be chasing my own tail trying to fix what is not broke. Thanks, Mike
__________________
X-Cart 4.3.1 Buy Together Module, AlteredCart CDSEO Pro One Page Checkout, AlteredCart Smart Search, AlteredCart On Sale, AlteredCart |
|||||||
#13
|
|||||||
|
|||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
Your assumption is correct, but I have had it working that way for 4.4.3. Not knowing what your actual sales are, I can't tell if the module is working correctly on your site. I'm thinking that the change in the categories table between older versions and the 4.4.x branch is causing problems for you. The number of bestsellers chosen by you under admin will be the LIMIT in the MySQL query used to retrieve product IDs from the order data tables, which means it will select up to that limit. So, yes, you would need at least that many items sold in each category during your chosen timeframe in order for that number of bestsellers to display on every category page. If you have only sold 2 items from a certain category during your timeframe, then only 2 items will appear for that category. This mod does not take product views into account as the original Bestsellers mod does. It is based purely on products actually sold during a chosen timeframe.
__________________
X-Cart Gold 4.1.8 (Live) BCSE Shipping Estimator for FLC Mod BCSE Shipping Methods per Product Mod BCSE Customer Review Management Mod BCSE Catalog Order Form Mod X-Cart Gold 4.5.2 (Building/Testing) USA |
|||||||
#14
|
|||||||||
|
|||||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
I get this error...Nit sure how to solve it though
INVALID SQL: 1054 : Unknown column 'lpos' in 'field list' SQL QUERY FAILURE:SELECT categoryid, lpos FROM xcart_categories USE INDEX (PRIMARY) WHERE categoryid = '3692' So i removed lpos and then I got INVALID SQL: 1054 : Unknown column 'rpos' in 'field list' SQL QUERY FAILURE:SELECT categoryid, rpos FROM xcart_categories USE INDEX (PRIMARY) WHERE categoryid = '3692' Not sure how to solve that one
__________________
Paul Wallace X-Cart Gold 4.3.2 Php5.3.8 MySQL 5.1.56 Backorder/PreOrder SEO All in one CDSEO Wholesale Option Pricing Gift Cert Recovery Password Recovery CompanyLogo Alt Tag Smart Search - ALtered Cart On Sale - Altered Cart Sitemap MM One page checkout order page emailer Remember Anomymous Carts Website CM Speed Opitmisation iartsupplies.co.uk |
|||||||||
#15
|
|||||||
|
|||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
I assume you are using 4.3.2 as your signature indicates. lpos and rpos didn't exist in the products table for that version. I'm not sure exactly how to make this mod work in earlier versions, and I would have no way of testing in those versions. See my reply above (http://forum.x-cart.com/showpost.php?p=326357&postcount=7) for information. I don't think it's perfect, but it's a start.
__________________
X-Cart Gold 4.1.8 (Live) BCSE Shipping Estimator for FLC Mod BCSE Shipping Methods per Product Mod BCSE Customer Review Management Mod BCSE Catalog Order Form Mod X-Cart Gold 4.5.2 (Building/Testing) USA |
|||||||
#16
|
|||||||||
|
|||||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
Yes I thought that the version Im using may have something to do with it but just thought I would try it as Mike seemed to have got it to work for 4.3.2 I have a look at that link though
__________________
Paul Wallace X-Cart Gold 4.3.2 Php5.3.8 MySQL 5.1.56 Backorder/PreOrder SEO All in one CDSEO Wholesale Option Pricing Gift Cert Recovery Password Recovery CompanyLogo Alt Tag Smart Search - ALtered Cart On Sale - Altered Cart Sitemap MM One page checkout order page emailer Remember Anomymous Carts Website CM Speed Opitmisation iartsupplies.co.uk |
|||||||||
#17
|
|||||||
|
|||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
I have it working OK, here is my bestsellers.php file.
Mike Code:
__________________
X-Cart 4.3.1 Buy Together Module, AlteredCart CDSEO Pro One Page Checkout, AlteredCart Smart Search, AlteredCart On Sale, AlteredCart |
|||||||
|
#18
|
|||||||||
|
|||||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
Thanks for the thats stopped the errors, so hopefully this will work now for me thanks
__________________
Paul Wallace X-Cart Gold 4.3.2 Php5.3.8 MySQL 5.1.56 Backorder/PreOrder SEO All in one CDSEO Wholesale Option Pricing Gift Cert Recovery Password Recovery CompanyLogo Alt Tag Smart Search - ALtered Cart On Sale - Altered Cart Sitemap MM One page checkout order page emailer Remember Anomymous Carts Website CM Speed Opitmisation iartsupplies.co.uk |
|||||||||
#19
|
|||||||||
|
|||||||||
Re: Bestsellers without Advanced Statistics (4.4.3 Gold)
Quote:
Working Now thanks!
__________________
Paul Wallace X-Cart Gold 4.3.2 Php5.3.8 MySQL 5.1.56 Backorder/PreOrder SEO All in one CDSEO Wholesale Option Pricing Gift Cert Recovery Password Recovery CompanyLogo Alt Tag Smart Search - ALtered Cart On Sale - Altered Cart Sitemap MM One page checkout order page emailer Remember Anomymous Carts Website CM Speed Opitmisation iartsupplies.co.uk |
|||||||||
|
|||
X-Cart forums © 2001-2020
|