Historic Price Showing Zero?

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    Thank you for reaching out.

    currently the graph only gets the lowest price during a single say which could explain why you are seeing only 1 value.

    Maybe this calls for a feature were you can control for how long timespans should be grouped together to get the lowest data point

    But we will investigate why the values are incorrect and get back to you.

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    Here is another example

    this went from $5.00 to $0.99, but the graph is showing it went from $0 to $5

    I believe the plugin is only taking the dollar amount into consideration when plotting the price history. which would be why sales listed at $1.49 are showing $1 in the price history graph and why sales listed at $0.99 are showing $0 in the price history graph

    Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    Thank you for the information and help with troubleshooting this issue.

    As you pointed out the plugin only supported whole values.
    We have now updated it with version 1.1.0 to support up to 2 decimals.

    However to update it correctly you have 2 options

    Either you will need to uninstall and then reinstall the plugin again from the plugin repository.

    This will also clear your current price history database tables so historic prices before this will be lost.

    Alternatively if you have access to your database you alter the Database tabel called (wp_prefix)_wp_totej_price_history and update the price column to be a decimal(5,2) data type

    If you go this route you only ned to update the plugin to 1.1.0, without uninstalling first.

    Sorry for the inconvenience

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    no need to be sorry, I’m happy to help out when I can. I don’t mind uninstalling the plugin and then installing it again so that it resets the price history.

    I will reply here later on this week when I can see how the new update changes things

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    Hey @totejmedia are you sure it’s set to display the price to up to 2 decimal spots? I’ve been testing it today and it looks like it’s rounding up now

    example https://www.playstoresales.com/app/dungeon-of-the-endless/

    this was brought back up to the $7.99 price and the price history graph is showing it as $8 when I hover the mouse over the graph point.

    Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    Do you have access to your db and can check the structure of the table that the plugin uses?

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    here is one of the entries that the plugin is using

    is that the information you’re looking for? if not, how can I check the structure?

    edit – also, I don’t think disabling the plugin removed the data that the plugin added from before. Before updating, I disabled the plugin, updated the plugin, and then re-enabled it.

    but I noticed the price history of the products that I had used in my examples were still set that way (which isn’t the worst thing, but wasn’t what you had described)

    • This reply was modified 2 years, 5 months ago by dlynch027.
    Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    Thank you for that
    It seems like the db table never was re-created

    Would you be able to manually drop the table from your DB and then reinstalling the plugin?

    Regards

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    I was able to manually drop the price history table (after I deactivated the plugin) and have now reactivated it. I will do some tests today and see how it goes

    edit – this ends up giving me “wpdb error: Table ‘playstoresales_com_Kz0ZrWNn.wp_totej_price_history’ doesn’t exist” errors on the page

    I even deleted the plugin completely and reinstalled it, still getting that error 🙁

    • This reply was modified 2 years, 5 months ago by dlynch027.
    Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    That weird, after activating the plugin, did it re-create the table?

    Did you only inactivate or did you completely re-install from the plugins-> add new dashboard?

    Plugin Author totejmedia

    (@totejmedia)

    2 years, 5 months ago

    I was able to identify the issue an release a 1.1.1 version that resolves this. It seems like the 1.1.0 version was unable to create the table when activating the plugin. This should now be resolved in version 1.1.1

    Regards

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    I appreciate the help! I just updated the plugin, activated it, and updated one of the app sales for the day and it seems to be working flawlessly! it even registers the price at $1.49 in the graph (like it’s supposed to)

    i’ll give it a day or two to see how the graphs look when prices continue to change. but it looks to be working great right now

    Thread Starter dlynch027

    (@dlynch027)

    2 years, 5 months ago

    I do find it interesting that the graph numbers seem to be extending to 3 decimal spots though.

    as seen here – https://www.playstoresales.com/app/deep-space-first-contact/

    I see this view on the desktop, but when viewing it on mobile, I only see the 2 decimal places (which is how it should be).

    not the biggest issue, but something that I noticed when checking on multiple devices

    thanks again for the work you’ve put into this plugin!

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Historic Price Showing Zero?’ is closed to new replies.