Kryptronic Software Support Forum

I got rid of the extra addresses, and ran it again - set a product to 11, added it to the cart, ordered it, did  the update so it would be 'pending shipment' and then post order update for inventory then confirmed inventory dropped to 10, but still no email. Any clues?

if ($inv <= 10) {
                   $to = "james@mysite.com";
                   $subject = 'PRODUCT AT 10 OR LESS --- ' . $row['id'];
              $body = 'https://www.mysite.com/admin.php?app=ccp0&ns=manageprod&func=dbupdate&funcid=' . $row['id'];
                   mail($to, $subject, $body);
}

               if ($inv <= 0) {$inv = '0';
                   $to = "james@mysite.com";
                   $subject = 'PRODUCT OUT OF STOCK--- ' . $row['id'];
              $body = 'https://www.mysite.com/admin.php?app=ccp0&ns=manageprod&func=dbupdate&funcid=' . $row['id'];
                   mail($to, $subject, $body);
}

I then bought 10 items so it would drop to zero, followed same steps above, confirmed inventory was 0, but no emails.

Last edited by wyattea (09-19-2008 21:57:28)

Well the only variable being used is $inv so you could add a print 'Inventory level is ' . $inv; in there to see what it is.

Yes.  From the PHP manual:

to

    Receiver, or receivers of the mail.

    The formatting of this string must comply with RFC 2822. Some examples are:

    user@example.com
    user@example.com, anotheruser@example.com
    User <user@example.com>
    User <user@example.com>, Another User <anotheruser@example.com>

PHP itself may be configured to use something other than it's built in method for sending mail which may be why it is working for you.  Using a comma will work in any situation.

I use the pay by check gateway with it's post order update set to true which will complete an order as being complete and do the updates. Even though it is seen by all customers I have only had one person in 3 years even use it and you could always set it to pending payment if they did.

John

what web page? I'd be in admin when I submit the post order update...?

"CCP - every day, you learn something new!"

that's the new Kryptronic tagline...

Ok, added a couple of print statements, did my thing, and nothing was displayed on the admin screen when I clicked on submit after checking the box for update product inventory. I confirmed that the inventory amount was reduced for that particular product. Damn this is getting annoying...

if (!(empty($result))) {

          foreach ($result as $num => $row) {

               $inv = $row['inventory'] - $cartinv_opt[$row['id']];


print '<p>Inventory level is ' . $inv . '</p>';

              if ($inv <= '10') {
                   $to = "james@mysite.com";
                   $subject = 'PRODUCT AT 10 OR LESS --- ' . $row['id'];
              $body = 'https://www.mysite.com/admin.php?app=ccp0&ns=manageprod&func=dbupdate&funcid=' . $row['id'];
                   mail($to, $subject, $body);
}


print '<p>Inventory level is ' . $inv . '</p>';

               if ($inv <= '0') {$inv = '0';
                   $to = "james@mysite.com";
                   $subject = 'PRODUCT OUT OF STOCK--- ' . $row['id'];
              $body = 'https://www.mysite.com/admin.php?app=ccp0&ns=manageprod&func=dbupdate&funcid=' . $row['id'];
                   mail($to, $subject, $body);
}

Last edited by wyattea (09-23-2008 07:59:54)

In the product array the invlevel key (column) contains the inventory level of the product.  $inv is specific to the 0300_inventory.php code.

a customer got this error message:

Fatal error: Class 'CCP_Order_inventory-LATEST-TEMP' not found in /home/wyattea/mysite.com/khxc-private/core/KHXC/KHXC.php on line 1753

It might have been when I was uploading the 0300_inventory.php file so she couldn't access it. I never renamed a class with that name, but I've renamed filenames with -LATEST-TEMP.php at the end as a backup. What could this be?

UPDATED: don't have a backup file in the ext dir - it was a 0300_inventory.php file I had renamed as a backup called 0300_inventory-LATEST-TEMP.php that was the offending file.

Last edited by wyattea (09-23-2008 21:42:40)

yes, i remember it happening before but I didn't remember which dir couldn't have backup files. I've had that file there since last week so every customer was getting that error...finally someone told me about the error otherwise i never would have known.

uhm, don't forget my "don't get the emails" issue

I don't understand what you mean? When you mention order status, it made me remember that I did a mod from John that made the order status automatically 'Pending Shipment' when they returned to the site from the payment gateway.

Then again, I don't remember exactly what I did but when I read the thread, it made sense and I implemented. It had something to do with adding a 'NC' status code for some reason. I'm not sure if it's a completely new code or just added to a specific point in the order process. I know I'm being vague, maybe you have a clue what I'm talking about? I just found the thread:

https://forum.kryptronic.com/viewtopic.php?id=17782 - post #25 says what I did (add a ccp0.orderstatus.NC option referred to as Not Completed)

where would I look at the column for post order inventory?