Super Orders v3.0 Support Thread (for ZC v1.3.9)

Almost six months ago,

TonyBenedetti:

I think I may have stumbled across a buglet with SuperOrders 3.0 / EditOrders 3.0. When I edit an order to add a comment, I get a SQL error if I use an apostrophe. For example, the comment: "This isn't working" fails with the error below.

Got the response:

DivaVocals:

Will try and find time in the next day/week to fix this.

But I'm seeing this problem now. Did a fix ever get posted? If so, I need to find out where I'm using old versions!

Iain

I've recently installed Super Orders 3 onto a fairly old ZC installation. The client saw Super Orders on a brand new setup I've done for them, and understandably wanted it on on their old site too.

But the batch print / status update search screens were not loading. It seems to be due to the customer: dropdown in the super_batch_status.php and super_batch_orders.php pages.

When I look at the database, there are about 65,000 customers of the store, which may be why the pages weren't loading. I commented this field out of the query and now it works again.

Also, I've had to increase the memory_limit from 32M because the batch print function wasn't loafing.

I'm a little worried that there may be some old files left on the system somewhere. Could that be causing these problems, or is Super Orders likely to have these problems with an established store?

hairydog:

Almost six months ago,

Got the response:

But I'm seeing this problem now. Did a fix ever get posted? If so, I need to find out where I'm using old versions!

IainAlmost two days ago:
http://www.zen-cart.com/forum/showthread.php?t=170525&page=47

hairydog:

I'm a little worried that there may be some old files left on the system somewhere. Could that be causing these problems, or is Super Orders likely to have these problems with an established store?This question is far too broad to provide any kind of definitive answer..

Sorry, misthreaded reply

DivaVocals:

Almost two days ago:
http://www.zen-cart.com/forum/showthread.php?t=170525&page=47

I'll take that as a "no". Fair enough.

DivaVocals:

This question is far too broad to provide any kind of definitive answer..

OK, I'll narrow it:

In the two search pages for batch print and batch update, is there supposed to be a limit to the number of customer IDs returned, or is the page supposed to try to build a drop-down list of all the customers on the system?

Iain

DivaVocals:

I'm not sure I fully understand your question.. (highlighed in red)

As for "core edits" do you mean core ZEN CART files or edits to Super Orders files??

Edits to the core Zen cart files, not intention of interfering with the Super Orders documents.

:cool:

Hi guys.

We've been using Zen Cart for about 3 years. Finally thought it was about time we installed Super Orders 3.0. We're using 1.3.9h.

There are a few minor problems/queries I have. I've attached some screen shots to help.

1. £ syntax is showing up on PDF packing slips AND balance due is blank. See screen shot 1. This doesn't seem to happen if we generate print outs via the browser. Any ideas why this may be the case?

2. Printing order detail produces a slight error. See screen shot 2...
   "1054 Unknown column 'track_id1' in 'field list'
   in:
   [select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '17877' order by date_added]
   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."
   This problem is only on order detail printout pages, invoice/packing slip print out pages don't show this error.

3. Perhaps I'm being a bit stupid here but how do I access PDF invoice print outs? See screen shot 3.
   I can see there are PDF packing slip option and master packing list options on the Batch Form Printing page (although the generated PDF Packing Slip actually looks more like an invoice to me).
   But I can't see a specific option to creare a PDF invoice print out, is this correct?

Thanks

Answers in red..

Dunk:

Hi guys.

We've been using Zen Cart for about 3 years. Finally thought it was about time we installed Super Orders 3.0. We're using 1.3.9h.

There are a few minor problems/queries I have. I've attached some screen shots to help.

1. £ syntax is showing up on PDF packing slips AND balance due is blank. See screen shot 1. This doesn't seem to happen if we generate print outs via the browser. Any ideas why this may be the case?
   Dunno the answer why the currency symbols do not display as I didn't develop the PDF Packing Slip code.. All I can do is ask the original developer and see if he can/will fix this.. **As for the balance due, what displays in the balance due on the order detail???
   **

2. Printing order detail produces a slight error. See screen shot 2...
   "1054 Unknown column 'track_id1' in 'field list'
   in:
   [select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '17877' order by date_added]
   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."
   This problem is only on order detail printout pages, invoice/packing slip print out pages don't show this error.
   Ask & answered a fee times in this support thread. Please search for "super_data_sheet.php". There is a posted fix for this.

3. Perhaps I'm being a bit stupid here but how do I access PDF invoice print outs? See screen shot 3.
   I can see there are PDF packing slip option and master packing list options on the Batch Form Printing page (although the generated PDF Packing Slip actually looks more like an invoice to me).
   But I can't see a specific option to creare a PDF invoice print out, is this correct?
   As I've stated a few times in this thread, the PDF packing slip is a DETAILED packing slip not unlike those used by other large e-commerce sites. Therefore it has invoice-like aspects included. I don't know if this answers your question.

Thanks

In the two search pages for batch print and batch update, is there supposed to be a limit to the number of customer IDs returned, or is the page supposed to try to build a drop-down list of all the customers on the system?

hairydog:

In the two search pages for batch print and batch update, is there supposed to be a limit to the number of customer IDs returned, or is the page supposed to try to build a drop-down list of all the customers on the system?
I'd have to look at the query, but I assume given the issue you're reporting that it is the later.. Dunno when I'll have a chance to look at this and confirm for sure.. Maybe someone else can chime in..

I installed it on an existing store, and it worked for a little while, but then the client reported that they were just getting a blank page.

When I looked into it, I think that what had happened is that the number of customers had gone past 64k - whether there is a 64k limit, or it just happened that that's when the thing timed out, I'm not sure.

Because it was retro-fitted to an old store, I wasn't sure if it is a design bug, a coding error or an installation snafu.

Removing the customer id from the query got it working again. I wonder if it would be useful if the customer list was populated only if you specified a short date range.

DivaVocals:

1. £ syntax is showing up on PDF packing slips AND balance due is blank. See screen shot 1. This doesn't seem to happen if we generate print outs via the browser. Any ideas why this may be the case?
   Dunno the answer why the currency symbols do not display as I didn't develop the PDF Packing Slip code.. All I can do is ask the original developer and see if he can/will fix this.. As for the balance due, what displays in the balance due on the order detail???

2. Printing order detail produces a slight error. See screen shot 2...
   "1054 Unknown column 'track_id1' in 'field list'
   in:
   [select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '17877' order by date_added]
   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."
   This problem is only on order detail printout pages, invoice/packing slip print out pages don't show this error.
   Ask & answered a fee times in this support thread. Please search for "super_data_sheet.php". There is a posted fix for this.

3. Perhaps I'm being a bit stupid here but how do I access PDF invoice print outs? See screen shot 3.
   I can see there are PDF packing slip option and master packing list options on the Batch Form Printing page (although the generated PDF Packing Slip actually looks more like an invoice to me).
   But I can't see a specific option to creare a PDF invoice print out, is this correct?
   As I've stated a few times in this thread, the PDF packing slip is a DETAILED packing slip not unlike those used by other large e-commerce sites. Therefore it has invoice-like aspects included. I don't know if this answers your question.

1. Hmm... is this a known issue? I've noticed at least two other people in this thread are having the same problem but I can't see a resolution.
   Ignore what I said about balance due, of course it's meant to read 0.00 if we're taking payment upon placement of the order :blush:

2. Great, worked perfectly thanks.

3. OK. I understand that the packing slip is a detailed packing slip. But is there no way to generate a separate pdf INVOICE (regardless of how similar it may be to the packing slip)?
   Or do most people treat the pdf master packing list as their "packing list" and the detailed pdf packing list as the "invoice"?

A few other questions that I can't find an answer to...

4. We'd like PDF invoices and packing slips to be generated when one of the admin clicks the "invoice" or "packing slip" buttons via admin > customers > super orders (effectively removing access to the browser based invoices/packing slips). Is this something that anyone has attempted to do before?

5. Is there a guide to modifying the PDF output of the master packing slip and packing slip PDFs?

Thanks!

Just out of interest does the Super Orders PDF function replace the PDF order centre mod that is available.

I noticed PDF order centre hasn't been updated since 1.3.8 although we tested it briefly on 1.3.9h yesterday and it seemed fine.

No it does not replace the pdf order center. They work fine next to each other. I am us both myself on 1.39h
I use POC mainly for printing invoice, packing slip and shipping labels

Answers posted below..

Dunk:

1. Hmm... is this a known issue? I've noticed at least two other people in this thread are having the same problem but I can't see a resolution.
   **Yes it's a known issue. Doesn't change my answer though..

**"Dunno the answer why the currency symbols do not display as I didn't develop the PDF Packing Slip code.. All I can do is ask the original developer and see if he can/will fix this.. As for the balance due, what displays in the balance due on the order detail???"

Ignore what I said about balance due, of course it's meant to read 0.00 if we're taking payment upon placement of the order :blush:

2. Great, worked perfectly thanks.
   You're welcome.

3. OK. I understand that the packing slip is a detailed packing slip. But is there no way to generate a separate pdf INVOICE (regardless of how similar it may be to the packing slip)?
   Or do most people treat the pdf master packing list as their "packing list" and the detailed pdf packing list as the "invoice"?
   Master packing list is just what the name implies.A master list of packing slips. It's meant to be used as a pick list.** (and if you print it you can see this is what it is)
   
   The PDF packingslip (or packing list if you prefer) is a detailed packingslip which contains elements similar to an invoice.. You are free to use it as an invoice, a packingslip, or anything you like.. I think you are getting stuck on semantics versus the CONTENT of the PDF packingslip. If what you want is an INVOICE, and the PDF packingslip contains all the same data as an INVOICE, then you can use it as in invoice. OR you can treat it as a detailed packingslip.. It's kinda up to you..**

A few other questions that I can't find an answer to...

4. We'd like PDF invoices and packing slips to be generated when one of the admin clicks the "invoice" or "packing slip" buttons via admin > customers > super orders (effectively removing access to the browser based invoices/packing slips). Is this something that anyone has attempted to do before?
   Hopefully someone can chime in on this.. I've not seen any posts here covering this..

5. Is there a guide to modifying the PDF output of the master packing slip and packing slip PDFs?
   Nope.. Sorry..

Thanks!

Dunk:

Just out of interest does the Super Orders PDF function replace the PDF order centre mod that is available.As the lead post of this support thread and the readme states, Super Orders was only meant to "replace" the default Zen Cart orders management.. PDF Order Center is a completely separate module..

Thanks,

I ask because we need a detailed PDF packing list with no prices on it. 1 per order.
We also need a PDF invoice generating that contains prices and tax information.

As far as I can tell there's no way of producing both using the standartd install of Super Orders? Am I correct?

never mind....

I installed both order edit and super orders and then uninstalled Super Orders and now all I get in the admin is a blank screen (store side works fine).

I deleted all new SO new files and restored backups of edited core files. I ran the uninstall sql which broke at the point of "comment out the fax info...". I reran the sql at the point past that error, leaving the fax define in place.

This is very troubling because without any error messages, I can't troubleshoot. I have no idea why restoring my files to a pre-superorder/edit order configuration shouldn't fix the problem. Any ideas or thoughts? When I try to log into the admin from a fresh browser window and a cleared cache, it's still the same whit screen. Not even asking for my zencart admin id and password.

I'm stumped.