PDF Order Center

I have just installed a fresh copy of PDF Order Center into Zen 1.3.0.1

I pasted the SQL code into the Install SQL Tool in the Admin interface. I then uploaded all of the corresponding files, etc.

When I access the PDF Order Center I am shown the full screen of options. However, a few links are not working. The top navigation:

Code:

---

<= Reset form|Pending|Processing|Delivered|Update

---

does not fully work. The only link that works from those above is the "Reset form" link. The others give an error such as the following when I click on "Pending":

Code:

---

1146 Table 'cart_db.orders' doesn't exist
in:
[select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id) where (ot.class = 'ot_total') and (o.orders_status = '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

---

Now, my tables are all prefixed with "zen_". I was under the impression that uploading the SQL via the Intsall Tool would automatically adjust for this, which the SQL import seems to have done. I have checked and the table "zen_orders" does exist. So how do I let the rest of the system to see that it should not look at "orders" but at "zen_orders"???

Thanks for any help/advice!
Kevin L.

Support thread for PDFOC: http://www.zen-cart.nl/forums/index.php?topic=1328.0

grayson,

Thanks for the link. I have moved my post to that forum.

Thanks again,
Kevin L.

Have just installed PDFOC without any problems and it is proving to be really useful and a real time saver. However, inadvertantly sent out 600 emails this evening to customers telling them we had despatched their order when in fact I had only meant to send out this message to a couple of customers.

Is there any way to make the system not send out emails if no boxes have been ticked rather than defaulting to every order receiving an email if nothing has been selected.

We have now set the default to not send out emails unless selected to prevent a repetition but it was a bit of an embarrassment nevertheless.

We had the same issue - it emailed all our customers from years ago....

We have now switched off emailing to avoid this happening again and rely on the email receipt that is sent when they order as confirmation.

Just happened to us as well - nearly 2000 orders :/ this needs fixing and quick support site doesnt exist anymore...

Quote:

---

Originally Posted by TPHoare

Have just installed PDFOC without any problems and it is proving to be really useful and a real time saver. However, inadvertantly sent out 600 emails this evening to customers telling them we had despatched their order when in fact I had only meant to send out this message to a couple of customers.

Is there any way to make the system not send out emails if no boxes have been ticked rather than defaulting to every order receiving an email if nothing has been selected.

We have now set the default to not send out emails unless selected to prevent a repetition but it was a bit of an embarrassment nevertheless.

---

LOL:laugh:

I think that anybody who has used this module has had the same problem you describe here. I know i did.
The selection method used is very vague.

Ronald.

After two years I have still have the odd senior moment when I inadvertently set everything 'processing', 'despatched' or even 'cancelled' but the fact is that even with this problem it's still a very useful tool - and one to which I haven't yet found any alternative.

I just think its wrong sitting back and saying "oh well what will happen will happen" I dont want to spent another morning replying to 47 emails of "unprofessionalism" , "remove my mail address", "who are you and what have I ordered" , "I'm calling my credit card company and blocking all payments from you".

I dont think its professional enough and I'd like to stop it, I will have a look and see what I need to do to code but I dont think I can fix it permanently. Perhaps I'll check to see if there are any orders older than a week and flag an error. Off work sick at the moment so I'll have a look later on in the week

No, you're quite right, of course. If I knew the first thing about PHP I would have a go myself - it can't be that difficult.