We are based in Europe with a GMT+1/GMT+2 time zone - support replies may be delayed due to time zone differences with your country.
- This topic has 20 replies, 2 voices, and was last updated 6 years, 5 months ago by
.
-
Posts
-
Hi
I have two issues.
1. We copied some posts and now they show up as paid. How do I remove this so they are unpaid again without creating a new posts.
2. I would love to show the reference for the payment number / date on the Post Pay Counter Stats page. Instead of just the link to the pay history. How do I do this?
David
Hi David,
1. We copied some posts and now they show up as paid. How do I remove this so they are unpaid again without creating a new posts.
Have a look at: https://postpaycounter.com/posts-never-marked-as-paid-show-up-as-paid/
2. I would love to show the reference for the payment number / date on the Post Pay Counter Stats page. Instead of just the link to the pay history. How do I do this?
This is not possible out of the box. It would require some custom code to be possible 🙂
Have a nice day,
StefanoThanks Stefano
For #2, how do I get that custom code done?
David
And for #1 – I follow the following….
To fix the issue for existing posts, you need to delete/overwrite the _ppcp_payment_history meta. This will most likely require direct database access or an advanced custom field editor.
Is there a way to check in the database which posts are marked paid but don’t have a payment reference against them?
David
Is there a way to check in the database which posts are marked paid but don’t have a payment reference against them?
I am not sure I understand – all posts that show up as paid do have a payment reference (i.e. a payment history record) associated to them.
Either – if there are light instructions I could build this myself, or if you want to provide a quote I am happy to contract. I’d prefer to build it myself with other plugins often there are instructions that devs can follow that won’t break future updates?
David
For the custom column, I just published this small tutorial: https://postpaycounter.com/add-custom-column-stats-table/ 🙂
Perfect thanks – I added a comment, which file do we edit for this? I want to show the payment reference ID, what is the field name for that?
You should wrap that into a new custom plugin, or put it into your theme functions.php file. This will ensure that it will keep working even with future updates of Post Pay Counter. What do you mean with payment reference ID? Each author can be paid multiple times, so it’s not clear what you ID you would like to see 🙂
I have replied to your comment as well, but let’s keep the conversation here please 🙂
It’s this field here that I want to include, the tracking id for the payment
…..tracking id: e.g. 5174245435be1b5e5463c2
TRANSACTION DETAILS
Date: 6th November 2018 15:40:21
Payment note: None
Payment method: Mark as paid#1 – I am really struggling with this, and it is quite urgent
I’ve reviewed the postmeta table, and searched the posts for any ppc metadata and it is blank. I really appreciate your help so far today. I have access to the database but I need to know which table to access and which rows to delete or fields to edit to make this work. Thanks – sorry payroll is depending on it so i’m a bit anxious.
It’s this field here that I want to include, the tracking id for the payment
In this case, you may want to have a look at the function
PPCP_payment_history::get_author_payment_history().I’ve reviewed the postmeta table, and searched the posts for any ppc metadata and it is blank. I really appreciate your help so far today. I have access to the database but I need to know which table to access and which rows to delete or fields to edit to make this work.
The table in which this stuff is stored is wp_postmeta. You should look for _ppcp_payment_history entries with the post_id related to the posts you would like to clear payments of. To fetch the data, a sample query would be
SELECT * FROM wp_postmeta WHERE post_id = 34.Before deleting any data, I’d advise backing up your database 🙂
The table in which this stuff is stored is wp_postmeta. You should look for _ppcp_payment_history entries with the post_id related to the posts you would like to clear payments of. To fetch the data, a sample query would be SELECT * FROM wp_postmeta WHERE post_id = 34.
Before deleting any data, I’d advise backing up your database ?
It comes up blank – any other ideas?
No.
Where can I find out more about the function PPCP_payment_history::get_author_payment_history()?
Please help Stefano. No response from you today. The author remains unpaid for work done until this is resolved.
Please help Stefano. No response from you today. The author remains unpaid for work done until this is resolved.
Sorry for the delay, I was away. I honestly don’t have much more to advise. You say that the post that shows up as paid has not payment record associated with it in the wp_postmeta table. This looks impossible, since a post is shown as paid IF it has a payment record, so there must be something wrong. I can try to have a look with a temp admin account on your site, but that is honestly all that I can do at this point, I am afraid 🙂
Where can I find out more about the function PPCP_payment_history::get_author_payment_history()?
In the related class file, located in post-pay-counter-pro/classes/ppcp_payment_history_class.php 😉
This reply has been marked as private.
- The topic ‘2 questions: mark post as unpaid & pay history view’ is closed to new replies.