This question has been flagged
1 Reply
6434 Views
Avatar
Luke Branch

I'm working on building a completely open-source boilerplate theme module for Odoo 8.0 that will feature a number of useful e-commerce features for B2B and B2C users out of the box. I'm trying to figure out how to pull certain lists/values from the database such as the following:

  • Recently viewed products (by the current user)
  • Top selling products (pulled from sales reports for that company/website)
  • Most viewed products (for product pages most often viewed overall)
  • Featured products (I think this can be acommplished in a similar manner to 'alternative products')
  • Products on sale (check all products that are on special as compared to the list price for that customer)
  • BOM Products (eg. parts connected to a given product that are published on the frontend)

however I am not sure where to start with a few of these (eg. recently viewed products for current user). Has anyone else figured out how to implement any of these?

I'm looking to build a few views for each item such as a slider using Owl Carousel (http://owlgraphic.com/owlcarousel/index.html), tabbed views, and normal list and grid views and will be building them into a module. Building the views is not a problem, however I am a little lost when it comes to calling some of this data/lists from the database or user's session data.

Avatar
Discard
Avatar
TidyWay
Best Answer

Hello Luke,

May be this hels you  http://tidyway.blogspot.in/2014/12/top-selling-products-fast-moving.html

Thanks

Rohan Nayani(www.tidyway.in)

Avatar
Discard
Luke Branch
Author

@Tidy Way, Thanks, I can't figure out how to enable this function in my Odoo instance though, or from your description in the blog post. Could you explain in a bit more detail how you have created this report? Once I have the report structure I believe I will be able to pull these figures quite easily into a module to allow me to create the top-selling, sale products, etc. required for the sliders that i'd like to create. Any suggestions or advice would be appreciated. I plan to release them as an open-source module here: http://github.com/odoocommunitywidgets

TidyWay

@Luke, thats customize report, not in odoo default.

TidyWay

@luke, you might be take decision from quants also, not 100% but prior judgement will take https://twitter.com/RohanNayani/status/534956213847326720

Luke Branch
Author

@Rohan, Thanks, i'll look into this.