Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Top Ten products sold not working


Guest

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...