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

I'll PM you with a PDF.

DivaVocals:

They are indeed one of the coolest new features..:smile:

Our goal with EVERYTHING we did with Super Orders v3.0 was to remain true to the modules original purpose and expand upon that. We also wanted to provide features that would be useful for a majority of shopowners.. That said as with anything, there are some features that some shopowners will fiind more useful than others, and other features shopowners would like to see tweaked in a particular way. This is one of those features for you:smile:..

After a fair bit of discussion on the merits of including/excluding the pricing information on the PDF packingslip/invoices amongst the developers of v3.0, it was a deliberate design desicion to include the pricing data on the PDF packingslip/invoice. This way whether you needed a invoice or packing list you could use one form.. BTW, this is not an unusual design either.. There are companies who's packingslips include pricing information (Amazon.com being one of them)

IF we decide to update this, in the spirit of keeping this module useful for a WIDE variety of shopowners, it would probably be done as an admin controlled option.
If you can show me an example of what this looks like I can work on correcting it.. Can you upload a sample PDF packingslip here?? (using the post attachments option)

Diva and the gang,

Great job on the trifecta mod upgrades around SO v3. I upgraded my TY Tracker, installed Edit Orders v3, and installed Super Orders v3 and everything worked like a champ. Some of the readme files said to update YOUR_TEMPLATE but the folders needing to be renamed were titled custom_template. Just a little thing, I knew what you meant.

Just have one small question in the Order Details. What does Amount Applied value refer to? Is this the refund amount or an amount from a customer credit? Perhaps this is an Edit Orders item but I did not find a match in that support thread.

How is the starbucks ice coffee treating you this holiday season? :D

Cheers! :clap:

BSHRC:

Diva and the gang,

Great job on the trifecta mod upgrades around SO v3. I upgraded my TY Tracker, installed Edit Orders v3, and installed Super Orders v3 and everything worked like a champ. Some of the readme files said to update YOUR_TEMPLATE but the folders needing to be renamed were titled custom_template. Just a little thing, I knew what you meant.Thanks!!! We're pretty happy!!

I will try and find some time to update the filesset and re-upload with the corrections.. (Thanks for pointing out the mis-step there!:smile:)

BSHRC:

Just have one small question in the Order Details. What does Amount Applied value refer to? Is this the refund amount or an amount from a customer credit? Perhaps this is an Edit Orders item but I did not find a match in that support thread.If you use the Super Orders payment system, and add a payment record for your order, the Amount Applied will reflect the amount of the payment applied against the order total.

BSHRC:

How is the starbucks ice coffee treating you this holiday season? :D

Cheers! :clap:VERY WELL thank you!!:laugh:

stevelucky:

I'll PM you with a PDF.Got it.. I see the issue you are describing.. I'll try and find some time to correct this next week..

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.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't working')' at line 7
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) VALUES ('464', '2', now(), '1', 'This isn't working')]

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.Leave it to you.. My LOVEABLE :hug:exterminator to find the ONE THING I missed in all of my EXHAUSTIVE testing of the comments features..:laugh: One of those darn functions is actin' up:laugh:.. No biggie.. for now I think the workaround is obvious (it IS obvious right??:laugh:)

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

Speaking of workarounds.. Been spending some time looking at super_payments.php trying to figure out EXACTLY how the language support for payment types is SUPPOSED to work. (versus how it ACTUALLY works ) I will be posting one MONSTER of a workaround process.. It's not awful, just a little less straightforward than it should be.. We only made a small change to this file in SO v3.0 to fix a silly SQL error (that YOU would have found no doubt..:laugh:)

This is going to sound stupid (oh well) since updating my enails from the store have the following heading: STORE_NAME

I have looked but I have missed it somewhere.

Also I don't see PDF option as one poster has mentioned.
Something else I missed?

Rizla:

This is going to sound stupid (oh well) since updating my enails from the store have the following heading: STORE_NAMEDunno how this happened since the install Super Orders install SQL file doesn't touch this value in the configuration table. Check your setting for Configuration > My Store > Store Name. Sounds like it is missing..

Rizla:

Also I don't see PDF option as one poster has mentioned.
Something else I missed?All covered in the Super Orders readme file.. (which includes a nice screenprint of the new feature..

Please note there are a few errors in the file which will be corrected in the next upgrade. Most notably this line:

Other options for the PDF packing slips are configured in the Super Orders admin. **Admin > Configuration > Super Orders > Standard Packing Slips - Show Images**Should read:
Other options for the PDF packing slips are configured in the Super Orders admin. Admin > Configuration > Super Orders

Hi
Thanks for the reply...
I have checked everything in the settings before posting. Cant see any obviouse error in the Admin side but the DB is sending out that info.

If I go to Contact Us on my site, the email is sent but now get:
Message from STORE_NAME in the Subject field.

When opening the email it states from me (who ever I choose) and TO: STORE_NAME
It's only (apparently) ocurred since the DB change on SO.

Gotta be somthing I have overlooked!

Your right... Store name has vanished.
Checked agains my local server and indeed that table has now gone....

Hmmm... do I have to replace the DB with my last backup or is there a better option?

Rizla:

Hi
Thanks for the reply...
I have checked everything in the settings before posting. Cant see any obviouse error in the Admin side but the DB is sending out that info.

If I go to Contact Us on my site, the email is sent but now get:
Message from STORE_NAME in the Subject field.

When opening the email it states from me (who ever I choose) and TO: STORE_NAME
It's only (apparently) ocurred since the DB change on SO.

Gotta be somthing I have overlooked!And I honestly don't know what since Super Orders absolutely doesn't modify the value in the **Configuration > My Store > Store Name **setting. It only adds two values to Configuration > My Store (the store phone and fax numbers). Otherwise the core file edits made for Super Orders (in the Required Core Edits folder) do NOT make any edits which would cause the issue you are reporting.. You also did not say do you see your store name when you look at your **Configuration > My Store > Store Name **setting??

What other mods have you installed??? Perhps something you've installed has modified a core file in a way which is causing the issue you are having.. Either that or something went wrong when you applied the modifications needed for the core file edits required for Super Orders OR Super Orders is installed incorrectly.. The fact that this started after installing Super Orders is merely a coincidence I'm sure..

I suggest either try applying all the Super Order file changes again, and if that doesn't solve the issue for you, you should try rolling back to a pre-Super Orders version of your store.. Test to see if you still have the e-mail issue, if you do then try re-installing Super Orders again..

The Super Orders install is straight forward, and there's no reason this should be happening unless you've installed something incorrectly.. (and I don't know what since I cannot re-create this issue at all in my test store..)

Rizla:

Your right... Store name has vanished.
Checked agains my local server and indeed that table has now gone....This is what I thought.. sigh When I suggest things to look for, humor me, and take a look PLEASE..:smile: I PROMISE I'm not trying to make your life harder.. Just trying to get to the bottom of the issue..:smile:

Rizla:

Hmmm... do I have to replace the DB with my last backup or is there a better option?Best to restore the entire database from a backup, and try re-installing any mods you installed since your last backup (including Super Orders)

No prob... Will do but i'ts late here (UK) so I will look and report tomorrow (fresh head)
For the record... several mods but nothing since SO3 but we'll take the DB back and start afresh.

Cheers

Rizla:

No prob... Will do but i'ts late here (UK) so I will look and report tomorrow (fresh head)
For the record... several mods but nothing since SO3 but we'll take the DB back and start afresh.

CheersThe Super Order install is still a coincidence to the real issue.. Whatever happened to your configuration table (the table which store the STORE_NAME value) has little to do with the Super Orders install.. Super Orders makes one small update to the configuration table to add the store phone number and store fax number.. It does little else..

Let me know how the re-install goes..

Just wanted to say this is a great mod! Installs and works wonderfully!

dcwd:

Just wanted to say this is a great mod! Installs and works wonderfully!Awesome.. Glad you like it!!:smile:

Never being afraid of asking obvious questions, am I correct in thinking that SO3 is based on 1.3.9 code?
Thanks.
Philip

philip56:

Never being afraid of asking obvious questions, am I correct in thinking that SO3 is based on 1.3.9 code?
Thanks.
Philip
Yep....

Rizla:

No prob... Will do but i'ts late here (UK) so I will look and report tomorrow (fresh head)
For the record... several mods but nothing since SO3 but we'll take the DB back and start afresh.

Cheers

Hi Diva
Ok this is where I am at the moment....
Kind hosting peeps replaced DB back-up..
All 'looks' the same ie I have not as yet re-installed the mod but the images are being pulled ok and it certainly looks like v3,, but:

I had this error when I first installed:

1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '9']
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 is at the top of the page. Now concerning the DB and the
'Config-My Store- Store Name'

My store name got replaced by a field called Tax Exemption Number (similar)

The one other thing I was doing or did prior to v3 was install (regretably) the Big Royal Mail add-on

So don't know if this helps you or not but am I now safe to re-install the SQL part to clear this error?

Funny thing is that I applied all in the same manner on my local copy before the live copy and it works fine locally. Unles something got screwed in the FTP

Best regards

Glyn

Let me be perfectly honest.. I don't know what you could have possibly done with the Super Orders install to get the result you are reporting.. This is a very straight forward install with a few required core mods and a few optional core mods.. The SQL file that comes with Super Orders adds columns to exisiting tables, and creates a few new Super Orders specific tables.. NOTHING in the Super Orders SQL would remove exisiting tables or change values in exisiting table records. Your result is not the norm, and I can't reproduce it if I tried..

So to answer your question is it safe to install the SQL, it was never un-safe IMHO.. The error regarding the missing column will go away and the entire super_orders.php page will be seen if you do..

I assume you are running the Super Orders SQL using the Admin Install SQL Patch tool and you've not tried to modify it..

Rizla:

Hi Diva
Ok this is where I am at the moment....
Kind hosting peeps replaced DB back-up..
All 'looks' the same ie I have not as yet re-installed the mod but the images are being pulled ok and it certainly looks like v3,, but:

I had this error when I first installed:

1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '9']
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 is at the top of the page. Now concerning the DB and the
'Config-My Store- Store Name'

My store name got replaced by a field called Tax Exemption Number (similar)

The one other thing I was doing or did prior to v3 was install (regretably) the Big Royal Mail add-on

So don't know if this helps you or not but am I now safe to re-install the SQL part to clear this error?

Funny thing is that I applied all in the same manner on my local copy before the live copy and it works fine locally. Unles something got screwed in the FTP

Best regards

Glyn