Guest Posted February 24, 2006 Posted February 24, 2006 Hi there, Right at the beginning of implementing my site I installed a template which removed the box that shows the top 10 products sold. Now I want it back and I cant get it working. I downloaded the scrolling best sellers and tried to implement it but there was nothing shown. Now I dont know wether this is the problem BUT.... In my Admin panel, when I click Reports> products purchased , I have nothing displayed in the list!! Its like its not returning any data for some reason. Ive sold over 30 thngs already so theres tonnes of data on sales. Anyone know why Best Products Purchased bit of admin isnt working? Anyway was just thinking if I can get that bit working then getting the top ten best sellers bit will work okay too! Thanks!! Jon.
Guest Posted February 24, 2006 Posted February 24, 2006 check your database, in the products table to see how many are showing as sold. Could be that when you isntalled the template it overworte or moodified the bit of code which tells the db to add 1 to the number of items sold for each product. If your db shows 0's next to items you know you have sold, then this is the most likely candidate
Guest Posted February 24, 2006 Posted February 24, 2006 check your database, in the products table to see how many are showing as sold. Could be that when you isntalled the template it overworte or moodified the bit of code which tells the db to add 1 to the number of items sold for each product. If your db shows 0's next to items you know you have sold, then this is the most likely candidate Okies i will check that. Cheers!
Guest Posted February 25, 2006 Posted February 25, 2006 check your database, in the products table to see how many are showing as sold. Could be that when you isntalled the template it overworte or moodified the bit of code which tells the db to add 1 to the number of items sold for each product. If your db shows 0's next to items you know you have sold, then this is the most likely candidate Which field in products tells you how many is sold.?? the last field in products, is Products_Order, and everything has a 0 all the way down the column!!! Also products status has 1's and 0's Im thinking its products order and it hasnt been updated GRRRR How do I get it back!! damn! My site is highley modified too so it could be a right pain in the arse getting it working again and Im not redoing my whole site from scratch!! :( Bod.
Guest Posted February 25, 2006 Posted February 25, 2006 Which field in products tells you how many is sold.?? the last field in products, is Products_Order, and everything has a 0 all the way down the column!!! Also products status has 1's and 0's Im thinking its products order and it hasnt been updated GRRRR How do I get it back!! damn! My site is highley modified too so it could be a right pain in the arse getting it working again and Im not redoing my whole site from scratch!! :( Bod. Could it be this: When I sell something I dont delete the order and click restock quantity, i keep the order as despatched! Is that messing everything up? I dont want to delete orders because I may need them for future reference. Bod.
boxtel Posted February 25, 2006 Posted February 25, 2006 Could it be this: When I sell something I dont delete the order and click restock quantity, i keep the order as despatched! Is that messing everything up? I dont want to delete orders because I may need them for future reference. Bod. the field is products_ordered and yes, if you restock the ordered items, that field is adjusted with that amount and as such your products_ordered remains zero. still, in my installation, restock is only an option when deleting an order. Treasurer MFC
Guest Posted February 25, 2006 Posted February 25, 2006 Could it be this: When I sell something I dont delete the order and click restock quantity, i keep the order as despatched! Is that messing everything up? I dont want to delete orders because I may need them for future reference. Bod. Right ive manually entered the number of items sold into the "products_order" column. and bobs your uncle, the 10 products thingy is now working :angry: What coudl be stopping this from updating the column! any ideas? Bod.
Guest Posted February 25, 2006 Posted February 25, 2006 Right ive manually entered the number of items sold into the "products_order" column. and bobs your uncle, the 10 products thingy is now working :angry: What coudl be stopping this from updating the column! any ideas? Bod. Boxtel are you saying that because im keeping my orders as despatched and not deleting them (and clicking restock products quantity) I am not updating the column? Its just I like to keep the orders in there for reference. Bod.
Guest Posted February 25, 2006 Posted February 25, 2006 Boxtel are you saying that because im keeping my orders as despatched and not deleting them (and clicking restock products quantity) I am not updating the column? Its just I like to keep the orders in there for reference. Bod. Right my top ten sellers box is STILL not functioning. It just wont appear!! Ive adjusted the products sold column so i THOUGHT it would be getting its data from that. I have re enabled my column_right and all the boxes like shopping cart etc appear, but the best sellers doesnt. I checked the file it is in the right place and ive tried putting the old one back. Also the correct code is in column right include(dir_ws_boxes . best_sellers.php); Im at a loss here! Bod.
boxtel Posted February 25, 2006 Posted February 25, 2006 Right my top ten sellers box is STILL not functioning. It just wont appear!! Ive adjusted the products sold column so i THOUGHT it would be getting its data from that. I have re enabled my column_right and all the boxes like shopping cart etc appear, but the best sellers doesnt. I checked the file it is in the right place and ive tried putting the old one back. Also the correct code is in column right include(dir_ws_boxes . best_sellers.php); Im at a loss here! Bod. simple: when an order is placed for item x, that field is increased with the order quantity. if you then decide to delete the order + select restock items, then that field is decreased by the order quantity. + 10 - 10 = 0 Treasurer MFC
Guest Posted February 25, 2006 Posted February 25, 2006 simple: when an order is placed for item x, that field is increased with the order quantity. if you then decide to delete the order + select restock items, then that field is decreased by the order quantity. + 10 - 10 = 0 ive not deleted the order. Ive got it to show a list of the best products sold in ADMIN but it wont show the box on the index page even though ive put what i thought is the correct code back into index.php and column right.php.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.