Historic Price Showing Zero?

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.

Here is another example

• https://www.playstoresales.com/app/wall-of-insanity/

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

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

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

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.

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

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 1 year, 10 months ago by dlynch027.

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

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 1 year, 10 months ago by dlynch027.

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?

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

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

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!