How yo display a best seller

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #279876

-- HikaShop version -- : Business 3.2.0
-- Joomla version -- : 3.8.1
-- PHP version -- : 7

Hi

With the mod_hikashop module I can't display the best seller product. I thought I had to select the PRODUCT_SALES filter but it doesn't seem to be what I expected.

What I want to achieve is very common : just display the top X products that are the most purchased.

thanks for your help

cyril

Please Log in or Create an account to join the conversation.

  • Posts: 4540
  • Thank you received: 612
  • MODERATOR
6 years 6 months ago #279877

Hello,

Can you provide a screenshot of your module configuration ?
Especially HikaShop Options tab and Advanced tab can able us to understand what's going on.
Can you precise the context where you want to display the module.

Awaiting news from you.
Regards

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #279936

Hi

in the front end I need to display a module that shows the best seller product.

here are the settings I use in the HikaShop Content Module

thanks

cyril

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81598
  • Thank you received: 13082
  • MODERATOR
6 years 6 months ago #279945

These settings look fine for what you want to do.
So there must be a problem with the rest of the settings of the module for which you didn't provide a screenshot, or the product_sales column of your products doesn't contain the correct values.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280004

Hi
you wouldn't see anything wrong even if I'd send you a screenshot for the display of the module is correct.

The issue is that the product that the module shows is NOT the product that has been sold the most.

I made a test: I deleted ALL the orders and just purchased a product. Theorically the module should display this very product (since no other has been sold!) but the module shows other products !

thanks

Cyril

Please Log in or Create an account to join the conversation.

  • Posts: 4540
  • Thank you received: 612
  • MODERATOR
6 years 6 months ago #280053

Hello,

"you wouldn't see anything wrong even if I'd send you a screenshot for the display of the module is correct."


The way data is displayed can leads to different results as restricted to main product category and/or don't include sub element for example, among lots of other possibilities.
If we can't see as asked your module HikaShop Options we are unable to check several points that you can ignore.

Regards

Last edit: 6 years 6 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280119

Hi

Here are the screeshots you requested (at least this is what I understood)

Cyril

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 4540
  • Thank you received: 612
  • MODERATOR
6 years 6 months ago #280144

Hello,

From all I can see, everything seems right, unless maybe your "Ordering direction Ascending" option that must be "Ascending" ?
I get what you need by doing same setting but with Ascending value.

If that don't solve your issue, can I have backend acces and process some tests ?
Note : You can use our Contact us form to provide important references, just add to your message an Url link to this topic.

Regards

Last edit: 6 years 6 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280161

Hi

I sent all the info on the contact form

thanks again

Cyril

Please Log in or Create an account to join the conversation.

  • Posts: 4540
  • Thank you received: 612
  • MODERATOR
6 years 6 months ago #280183

Hello,

I have a theory, it seems that you proceed a lots of order tests, but you have delete most of this in your backend order listing.
As results :
- If you use the top sale report
- Or if you just look your order listing
=> In the module display results won't be consistent with what you might expect.

The solution will be to reset ALL product sales with a Mass Action process.
- Go to Components => HikaShop => Configuration
- Then in System Dropdown select Mass Actions
- Click on New and reproduce this configuration :



Click on Process on the top of page, with this reset your module will have a more consistent result.
Hope this will solve your issue.

Regards

Last edit: 6 years 6 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280287

Hi

we did exactly as you wrote. We also deleted all the orders in the backoffice and purchased another product (which becomes the best seller since there is no other one). But the product shown on the best seller module is still not the one that is purchased


thanks

cyril

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280294

I must add I sent you on the contact form all the information needed to test it. I thank you for your time

Cyril

Please Log in or Create an account to join the conversation.

  • Posts: 26017
  • Thank you received: 4004
  • MODERATOR
6 years 6 months ago #280290

Hello,

Can you please take a look into your HikaShop product table (using PHPMyAdmin or a mass action) so you can see what is stored in the field "product_sales" ?
As Philippe explained via his previous message is that, the ordering is made on the value stored in that field.
It's purely MySQL and the result given by your database server will be regarding the values in that field and for items with the same value, it will order by the product id.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280342

HI

THe product_sales column of the product table is 0 for every record. This is weird since I performed some purchases and confirmed some of them in the backoffice.

Thanks

cyril

Please Log in or Create an account to join the conversation.

  • Posts: 81598
  • Thank you received: 13082
  • MODERATOR
6 years 6 months ago #280343

Hi,

The sales value will be incremented when the stock of the product is decreased. Was the stock updated in the product ?
If not, then there is an issue with the way the order statuses are configured in the menu System>Order statuses.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280355

Hi

yes the stock of the product is decreased when the order is confirmed but the best seller module still displays some other product !

Thanks

Cyril

Please Log in or Create an account to join the conversation.

  • Posts: 81598
  • Thank you received: 13082
  • MODERATOR
6 years 6 months ago #280414

Hi,

From what I can see on your backend, you set the "ordering direction" setting of your module to "ascending" so in that case it will display the product with the lowest product_sales value.
Please change it to "descending".

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280476

Hi

I get the same issue whith the parameter set as ascending or descending.

I sent you the credentials on the contact form but got no answer please

thanks

cyril

Please Log in or Create an account to join the conversation.

  • Posts: 81598
  • Thank you received: 13082
  • MODERATOR
6 years 6 months ago #280518

Hi,

I've checked and there were 2 additional issues on your website:
1 You've set the "sub element filter" setting of your module to "direct sub elements" so that means that it would only take into account the products directly in the category you selected in the module.
2 You had the "out of stock" setting deactivated in your module. However, the only two products with sales are products with a quantity of 0, so of course the module wouldn't take them into account.

Now I get in the module the product with the most sales in the module on your website...However it doesn't have any stock so I don't recommend leaving the module like that.

Please Log in or Create an account to join the conversation.

  • Posts: 202
  • Thank you received: 3
  • Hikashop Business
6 years 6 months ago #280527

Hi

thank you for your help. The current quantities are wrong so it 's not a real problem. Now the module works as hoped.

thanks again

cyril

Please Log in or Create an account to join the conversation.

Time to create page: 0.093 seconds
Powered by Kunena Forum