whitelamp

Sure, from your point of view it would mostly look like an invoice <grin>. But seriously, any half-decent programmer should be able to write a script based on the above description. (Hint: I’m at whitelamp.com). The only question really is whether to write a “real” cronjob and fiddle with the database directly or write a “proper” plugin that uses wordpress’s own cron functions and post status manipulation functions. I’d guess the second way would be more robust in the long run but possibly more expensive.

If it’s off-site then this is the one you need to comment out:

$merchantTransaction->set_transaction_details($merchantTransaction->purchase_id , 3 );

$note = “Payment completed”;
$data = array(
‘processed’ => WPSC_Purchase_Log::ACCEPTED_PAYMENT,
‘notes’ => $note,
‘transactid’ => $ticketnum,
‘date’ => time(),
);
$purchase_log = new WPSC_Purchase_Log( $_POST['SessID'], ‘sessionid’ );
$purchase_log->set( $data );
$purchase_log->save();

[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been permanently damaged by the forum’s parser.]

$ticketnum should be whatever makes the most sense out of what gets POSTed back to you.

OK, that’s great, though if you choose “PHP” from the syntax menu then it colours everything nicely to make it easier to read.

Which mode are you in? Do you take credit card details on your site or off-site?

There’s two places currently where the status is updated to “accepted payment”:
$this->set_transaction_details(substr($response,11,6), 3 );

Both places should be updated, although obviously you’ll only be using one.

Apart from that, that code scares me rigid. There’s no hashing or encryption to prevent people fiddling with the purchase details and there’s nothing I can see to prevent a spoofed acceptance.
That’s on top of handling credit card numbers which I really don’t think should be done on a wordpress site… even if you can get PCI compliance.

@misulicus – that should trigger the email, sure, but you do generally want to set ‘transactid’ and ‘date’ at the same time, as in my suggested code.

@nate – use pastebin.com to show us the code and we can have a quick look.

Nate,

no guarantees, but it’s worked for me.

That’s a nice interesting problem.

The simplest / quickest / cheapest way I can think of is to add a custom-meta called e.g. “visible_days” to relevant products and enter something like “YYNNNNN”. Then I would write a cronjob script to run at the start of the day that would use this data to “manually” change the post_status of the product to “published” or “draft” as needed.

Please have a look at the other thread
https://www.ads-software.com/support/topic/store-admin-email-not-being-sent-when-order-placed

Try adding an index to form_id on wp_wpsc_submited_form_data. I did this with phpmyadmin and found that the query ran about ten times faster.

Also, make sure you have a decent sized query cache running on your server.

Gary,

chances are you need to update your payment gateway as described here
https://getshopped.org/forums/topic/no-transaction-results-email/
by me (‘doml’ on that forum).