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

[samar777]

Perhaps.. do you get a similar behavior with the default orders??

nope. just super orders

[DivaVocals]

nope. just super orders

What version of Zen Cart are you running??

[ericvanwenkop]

Is there any way to change the PDF packing list? I want to remove the prices on it and change the layout a bit...

[gfogleman]

running 1.3.9

[nagelkruid]

Hello,
When i click the "print" button in an order the super_data_sheet.php is invoked which generates error:
STATUS HISTORY 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 = '12696' order by date_added]

Looking at the code:

<!-- TY TRACKER 1 BEGIN, DISPLAY TRACKING ID IN COMMENTS TABLE------------------------------->
        <td class="dataTableHeadingContent smallText" align="left" valign="top" width="23%"><strong><?php echo TABLE_HEADING_TRACKING_ID; ?></strong></td>
<!-- END TY TRACKER  1 ------------------------------------------------------------>
        <td class="dataTableHeadingContent smallText" align="left" valign="top" width="40%"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
      </tr>
<?php // TY TRACKER 2 BEGIN, INCLUDE DATABASE FIELDS ------------------------------
    $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments
                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
                                    where orders_id = '" . zen_db_input($oID) . "'
                                    order by date_added");
// END TY TRACKER 2 -----------------------------------------------------------
    if ($orders_history->RecordCount() > 0) {
      while (!$orders_history->EOF) {
        echo '      <tr>' . "\n" .
             '        <td class="smal<etcetera_snip>

I think all of this code regarding to TY_tracker (which i do not have installed) should be evaluated through boolean TY_TRACKER first before it is executed like so:

if (TY_TRACKER == 'True') 

correct? or did i miss something?

[DivaVocals]

The answer is even simpler.. If you turned on the Ty Tracker fields and do not have Ty Package Tracker installed (or installed correctly), you would get this error.. The flag to turn off Ty Package SHOULD be in Admin > Ty Package Tracker..

Hello,
When i click the "print" button in an order the super_data_sheet.php is invoked which generates error:
STATUS HISTORY 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 = '12696' order by date_added]

Looking at the code:

<!-- TY TRACKER 1 BEGIN, DISPLAY TRACKING ID IN COMMENTS TABLE------------------------------->
        <td class="dataTableHeadingContent smallText" align="left" valign="top" width="23%"><strong><?php echo TABLE_HEADING_TRACKING_ID; ?></strong></td>
<!-- END TY TRACKER  1 ------------------------------------------------------------>
        <td class="dataTableHeadingContent smallText" align="left" valign="top" width="40%"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
      </tr>
<?php // TY TRACKER 2 BEGIN, INCLUDE DATABASE FIELDS ------------------------------
    $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments
                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
                                    where orders_id = '" . zen_db_input($oID) . "'
                                    order by date_added");
// END TY TRACKER 2 -----------------------------------------------------------
    if ($orders_history->RecordCount() > 0) {
      while (!$orders_history->EOF) {
        echo '      <tr>' . "\n" .
             '        <td class="smal<etcetera_snip>

I think all of this code regarding to TY_tracker (which i do not have installed) should be evaluated through boolean TY_TRACKER first before it is executed like so:

if (TY_TRACKER == 'True') 

correct? or did i miss something?

[DivaVocals]

Is there any way to change the PDF packing list? I want to remove the prices on it and change the layout a bit...

Short answer is it's software.. It can all be modified to do whatever you wish.. That said, as I have said here previously, it's a PITA to do. So I personally will not be able to help with this.. (got too much on my plate with paid and personal projects)

The PDF packingslip code was generously donated to the community for free, and apart from a few minor changes to align them functionally with the default packinglists/invoices they are as we got the code from the author.

I suppose it could be made a LOT more flexible so that everyone could have everything they might want, with admin controlled options, etc.. However, I will leave that to someone else to develop and contribute..

Feel free to search through this thread.. There's 1 or 2 people who've posted some of their modifications to the Super Orders PDF packing list..

Good luck..

[nagelkruid]

The answer is even simpler.. If you turned on the Ty Tracker fields and do not have Ty Package Tracker installed (or installed correctly), you would get this error.. The flag to turn off Ty Package SHOULD be in Admin > Ty Package Tracker..

did you read what i said about the boolean part at all?

[DivaVocals]

did you read what i said about the boolean part at all?

I did.. and I didn't see this was in reference to the super_data_sheet.php file..

A search of this thread would have turned up this post: http://www.zen-cart.com/forum/showpo...6&postcount=55

[nagelkruid]

I did.. and I didn't see this was in reference to the super_data_sheet.php file..

A search of this thread would have turned up this post: http://www.zen-cart.com/forum/showpo...6&postcount=55

thanks, that is indeed what i was referring to.
funny, i did search the thread and that post didn't come up in my results, and it is even a relative small thread yet....mmm