-
Super Orders v3.0 Support Thread (for ZC v1.3.9)
MODERATOR NOTE:
IF YOU ARE LOOKING FOR SUPER ORDERS v4 see the new support thread at: http://www.zen-cart.com/showthread.p...for-ZC-v1-5-x)
The kids are moving out dad!:laugh:
Welcome to the new support thread for Super Orders v3.0.
Super Orders v3.0 is available for download here:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=257
The previous support threads can be found here:
Super Orders v2.0: http://www.zen-cart.com/forum/showthread.php?t=44668
Super Orders v1.0: http://www.zen-cart.com/forum/showthread.php?t=34981
First off a BIG THANK YOU goes to Blindside. Not only for creating this fabulous module for me an my partners in crime to work with, but for his support and encouragement for THIS upgrade effort.. (Yep that's right.. I spoke to 'DA MAN himself!! **faint**)
Blinside, your advice and insight was INVALUABLE and truly appreciated!!! :clap:
Muchos Gracias!!!!
BIG HUGE thanks to my co-contributors JTheed and tonyniemann.
BIG GINORMOUS thanks to our SUPER eagle eyed beta tester TonyBenedetti for finding all those very small and very BIG gotchas!!!
So on to the good stuff.. What's new, and what does Super Orders do..
Here's the answer to the most frequently asked question: "What does Super Orders do?"
(which BTW REALLY IS explained in detail in the readme for those who REALLY wanna know.. it doesn't hurt to download the fileset..)
PURPOSE & AIM
Super Orders is exactly what its name implies: Zen Cart's default order management on steroids.
It's more in all the areas Zen users are asking for more:
- More order control
- "Batch Form Printing" and "Batch Status Updating" including support for PDF invoices.
- "Batch Form Printing" and "Batch Status Updating" both offer expanded order search options.
- Editing of hidden "admin only" comments
- “Split Orders” allows you to split individual lines on an order. So for example:
Customer orders:
3 Super Widgets
4 Super Duper Widgets
You've only got 3 of the Super Duper Widgets in stock. With Split Orders, you can move the Super Duper Widgets to another order creating a new (child) order which is split from the parent (original)
So you will end up with 1 order (parent) with 3 Super Widgets and a child order with 4 Super Duper Widgets.
- More thorough data
- Order payment tracking -- allows shopowners to enter and track order payment details (check, money orders, etc.) Payments made via Authorize.net, Linkpoint and PayPal are entered for you automatically. Send customer payment notification/verifications
- Order refund tracking -- allows shopowners to enter and track order refund details. Send customer refund notification/verifications
- More detailed reports
- EASY integration* with Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker
- More navigation options
- More shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox
*Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker MUST be installed to use these built-in integration features
That said I STRONGLY suggest that anyone THINKING about this mod download it and READ the readme.. The readme goes into a LOT more detail about what Super Orders can do.. It should answer any questions about what this mod provides..
If you are upgrading you too should read the readme file BEFORE you upgrade.
-
Re: Super Orders v3.0 Support Thread
Change Log - v3.0
- Clean up and reorganize the readme file (again!!!)
- MANY misc bug fixes and corrections
- Overall cleanup of the files to remove deprecated and unused code
- Countries now included as search option in "Batch Form Printing" and "Batch Status Updating"
- The "Edit Status History" feature has been restored and the functionality modified. Editing of order comments is now limited to hidden "admin only" comments. Additionally in previous versions of Super Orders the "Edit Status History" feature inserted HTML and ASCII line breaks into the database, and this ugly line break code was displayed when the customer viewed their order history from "Status History & Comments". This particular problem goes back to 2006, and has now been FULLY resolved/addressed.
- Customer comments modified to incorporate the latest Zen Cart 1.3.9 functionality/format
- Packing slip images are now a simple on/off admin configurable option.
- Batch print functionality has been expanded to include PDF invoices!! All options for the PDF invoices are admin configurable
- “Split Orders” has been improved to help shopowners more easily reconcile a split order.
“ Split Orders” now creates a parent and child order. Paid split orders will display the grand total paid for both parent and child order.
For orders paid via PayPal, Authorize.net or Linkpoint, the admin payment panel will not display on the child order. - Order total and customer address edit features have been removed in their entirety. (use Edit Orders if you need order/customer address editing functionality)
- Added missing shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox.
- Restoration of missing default Zen Cart orders.php functionality. This now allows payment processor generated (PayPal, Authorize.net or Linkpoint) refunds to now be processed within Super Orders. (no longer requires the retention of the default orders.php to process PayPal, Authorize.net or Linkpoint refunds)
- AUTO PAYMENT FOR ORDERS PAID VIA PAYPAL!!!!!!! 'Nuff said...
- Improved graphics and buttons to SPRUCE UP the Super Orders UI (thought while were doing everything else, why not make it purty too! :smile:)
- If you have Edit Orders installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No code merging required.. Simply install Edit Orders and "turn on" Edit Orders in the Super Orders admin!!)
- If you have Ty Package Tracker v3.0 installed, you can enable the Ty Package Tracker fields for Super Orders (No code merging required..) Simply install Ty Package Tracker and "turn on" Super Orders from the Ty Package Tracker admin!!)
- If you have USPS Click-N-Ship installed, you can enable USPS Click-N-Ship in the Super Orders admin to enable USPS Click-N-Ship fields/buttons in Super Orders (No code merging required.. Simply install USPS Click-N-Ship and "turn on" USPS Click-N-Ship in the Super Orders admin!!)
- If you have FedEx Automated Labels installed, you can enable FedEx Automated Labels in the Super Orders admin to enable FedEx Automated Labels buttons in Super Orders (No code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
Let me stress something here so that it's CLEAR.. With regards to the mod integration options: You are NOT required to install ANY Edit Orders, Ty Package Tracker, FedEx Automated Labels or USPS Click-N Ship to use Super Orders.. You can use Super Orders even if you don’t use these other modules. That said turning on the admin flags for mods you DO NOT have installed WILL CAUSE ERRORS IN YOUR STORE!!
BUT...
If you are running any of these mods, you don't have to tear your hair out trying to get the correct Super Orders code merged into the Super Orders files to use these mods.. Install them as normal and TURN IT ON in the Super Orders admin (Ty Package Tracker will need to be turned on in the Ty Package Tracker admin)
In support of this new release there are updates to Edit Order and Ty Package Tracker that are now available in the downloads.. (See the Ty Package Tracker and Edit Orders respective support threads for details on those updates -- PLEASE do not post non Super Orders related questions here..)
Finally we are also supplying the properly merged files needed for those running FEC and COWOA. (no admin flags for these mods.. simply use the provided pre-merged files for these mods)
-
Re: Super Orders v3.0 Support Thread
Lastly I want to ask a SMALL favor.. :smile:
When posting bugs/issues about Super Orders v3.0, it's a WHOLE LOT more helpful to resolve them if you post details. Just saying "it's broken" or "doesn't work" does not provide nearly enough information to help YOU resolve YOUR issue.:smile:
Please provide as MUCH information as possible including the version of Zen Cart you are running, the version of Super Orders you are running, any other add-ons you may have also installed.. Also hosting/server information (PHP versions, mySQL versions, hosting provider etc) is helpful too.
AND if you're REALLY detail oriented, tell us the install sequence/method you used to install Super Orders.:smile:
Because folks like nohart did just this we were able to FINALLY figure out WHY direct credit card and PayPal refunds worked from the default orders.php, but NOT from super_orders.php. As a result this is FIXED in v3.0..:clap:
Anyway.. carry on.. Enjoy the new version..
-
Re: Super Orders v3.0 Support Thread
The mod works great and looks awsome great job, only issue I can see for the time being is when editing an order you see this in the shipping table for example
FedEx Ground (FedEx Home Delivery<sup><font size="1">®</font></sup> ):
I attached a screen shot for you to see I have not been looking for the code to fix but just in case thought you may want to know about it
Again overall nice work.
-
Re: Super Orders v3.0 Support Thread
Forgot to mention all other pages such as super_invoice, packing slip etc look fine
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
knuckle-101
The mod works great and looks awsome great job
Thanks!!!!
Quote:
Originally Posted by
knuckle-101
only issue I can see for the time being is when editing an order you see this in the shipping table for example
FedEx Ground (FedEx Home Delivery<sup><font size="1">®</font></sup> ):
I attached a screen shot for you to see I have not been looking for the code to fix but just in case thought you may want to know about it
Again overall nice work.
Not to be the detail police, but that's an Edit Order issue, and it should be posted in the Edit Orders support thread.. :smile:
-
Re: Super Orders v3.0 Support Thread
what version of COWOA did you put into super orders, one of the reasons i'm asking is that there is a lot of cowoa code missing from includes>classes>order.php.
is it handled differently in super orders?
Kezza
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Kezza
what version of COWOA did you put into super orders, one of the reasons i'm asking is that there is a lot of cowoa code missing from includes>classes>order.php.
is it handled differently in super orders?
Kezza
COWOA Version 2.0c
There aren't any "missing" files.. We only included Super Orders specific files with the required COWOA modifications. We did not provide merged versions for any other files core Zen Cart files that COWOA and Super Orders may have in common (including includes/classes/order.php) . You will have to use a file merging program and make those merges/changes yourself.
HTH
-
Re: Super Orders v3.0 Support Thread
that works for me, will merge the extras myself and let you know how it goes.
thanks
Kezza
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Kezza
that works for me, will merge the extras myself and let you know how it goes.
thanks
Kezza
Awesome!
-
Re: Super Orders v3.0 Support Thread
Diva et al - Many thanks for zensational work - and especially for delivering this mod before Xmas.
Missing Files - do we delete or retain the following file from previous version?
admin/includes/languages/english/super_customers.php
In the Readme > Files > Required_Core_Edits - there is no mention of what to do with the following files:
/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php
Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.
Happy Holidays
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
dw08gm
Diva et al - Many thanks for zensational work - and especially for delivering this mod before Xmas.
You're welcome..:smile: But I can't take all of the credit.. JTheed was the MAN on this release.. and tonyneimann was a real doll for sharing his PDF invoice code.. So gotta give PROPS to both of these guys too.. :clap:
Quote:
Originally Posted by
dw08gm
Missing Files - do we delete or retain the following file from previous version?
admin/includes/languages/english/super_customers.php
In the Readme > Files > Required_Core_Edits - there is no mention of what to do with the following files:
/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php
My bad for not including this in the readme..:blush:
both super_customers.php files are deprecated in v3.0
/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php
These files from the optional edits folders in the last version are no longer needed as their only purpose was to hide certain comments from customers (a rudimentary version of "admin" comments) Zen Cart 1.3.9 natively supports hidden comments, and that functionality was ported over to Super Order v3.0.
That said these are core files, you just need to backout the mods made for Super Orders and reatina any other mods you may have in these files.. If you have no other mods other than the Super Orders mods, you can SAFELY delete
- /includes/languages/english/YOUR_TEMPLATE/account_history_info.php
- /includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php
You will need to carefully remove any Super Orders changes from:
- includes/modules/pages/account_history_info/header_php.php
Quote:
Originally Posted by
dw08gm
Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.
Happy Holidays
Quote:
Originally Posted by
dw08gm
Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.
If I am remembering correctly (not in from of my home PC) This code comes from the FEC merges, you should post your query in the FEC support thread as to what it actually does..
Quote:
Originally Posted by
dw08gm
Happy Holidays
Same to you..:smile:
-
Re: Super Orders v3.0 Support Thread
I just upgraded to v 3.0 and am getting a couple of errors.
1) When I go into an order's detail I get the following at the top:
Quote:
1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '3625']
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.
2) Below the Payment Method is says...
Quote:
No Order Payment Data Available
...and there is no more information. It is completely blank. It doesn't show any order info or payment info.
Any thoughts?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
stevelucky
I just upgraded to v 3.0 and am getting a couple of errors.
1) When I go into an order's detail I get the following at the top:
Quote:
1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '3625']
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
.
Your DB is missing a required column.. Did you run the upgrade script?????
Quote:
Originally Posted by
stevelucky
2) Below the Payment Method is says...
Quote:
No Order Payment Data Available
...and
there is no more information. It is completely blank. It doesn't show any order info or payment info.
Any thoughts?
It sounds like an incomplete/incorrect install which is causing the rest of the page not to draw in the browser.. Check your install.. Make sure you did not skip any steps..
-
Re: Super Orders v3.0 Support Thread
Never mind, I figured it out (I'm an idiot and didn't install the SQL upgrade file).
But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?
Quote:
Quote:
Originally Posted by stevelucky View Post
I just upgraded to v 3.0 and am getting a couple of errors.
1) When I go into an order's detail I get the following at the top:
Quote:
1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '3625']
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
.
Your DB is missing a required column.. Did you run the upgrade script?????
Quote:
Originally Posted by stevelucky View Post
2) Below the Payment Method is says...
Quote:
No Order Payment Data Available
...and there is no more information. It is completely blank. It doesn't show any order info or payment info.
Any thoughts?
It sounds like an incomplete/incorrect install which is causing the rest of the page not to draw in the browser.. Check your install.. Make sure you did not skip any steps..
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
stevelucky
But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?
Because there is no Super Order payment record for that order..
If you are expecting that payment records will be created where none existed before that is not going to happen.. The SQL script adds the necesarry tables to store payment data, it is not going to go through all your orders and create payment records for all your PayPal and credit card paid orders..
-
Re: Super Orders v3.0 Support Thread
Would that imply that new orders going forward would have that information? I've received a couple orders in the last few minutes and they didn't have that info either.
Quote:
Quote:
Originally Posted by stevelucky View Post
But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?
Because there is no Super Order payment record for that order..
If you are expecting that payment records will be created where none existed before that is not going to happen.. The SQL script adds the necesarry tables to store payment data, it is not going to go through all your orders and create payment records for all your PayPal and credit card paid orders..
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
stevelucky
Would that imply that new orders going forward would have that information? I've received a couple orders in the last few minutes and they didn't have that info either.
If you are referring to the auto generation of Super Orders payment records, yes and no..
What was the payment method for these orders??
Only orders paid via credit card (Authorize.net & Linkpoint) and PayPal will auto generate a Super Orders payment record.. All other payment methods (as in previous versions of Super Orders) still require you to manually enter a payment record..
-
Re: Super Orders v3.0 Support Thread
I really love the new PDF packing slips. Is there a way to format them more like the standard packing slips? They look more like invoices. The packing slip shouldn't show the price. Also, it tries to fit the item and all the attributes on 1 row in a small box. If they run too long, they just run off the edge of the page.
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
stevelucky
I really love the new PDF packing slips.
They are indeed one of the coolest new features..:smile:
Quote:
Originally Posted by
stevelucky
Is there a way to format them more like the standard packing slips? They look more like invoices. The packing slip shouldn't show the price.
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.
Quote:
Originally Posted by
stevelucky
Also, it tries to fit the item and all the attributes on 1 row in a small box. If they run too long, they just run off the edge of the page.
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)
-
Re: Super Orders v3.0 Support Thread
I'll PM you with a PDF.
Quote:
Originally Posted by
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)
-
Re: Super Orders v3.0 Support Thread
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:
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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:)
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
BSHRC
How is the starbucks ice coffee treating you this holiday season? :D
Cheers! :clap:
VERY WELL thank you!!:laugh:
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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..
-
Re: Super Orders v3.0 Support Thread
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.
Quote:
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')]
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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:)
-
Re: Super Orders v3.0 Support Thread
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?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Rizla
This is going to sound stupid (oh well) since updating my enails from the store have the following heading: STORE_NAME
Dunno 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..
Quote:
Originally Posted by
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:
Quote:
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:
Quote:
Other options for the PDF packing slips are configured in the Super Orders admin. Admin > Configuration > Super Orders
-
Re: Super Orders v3.0 Support Thread
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!
-
Re: Super Orders v3.0 Support Thread
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?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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..)
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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:
Quote:
Originally Posted by
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)
-
Re: Super Orders v3.0 Support Thread
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
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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
The 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..
-
Re: Super Orders v3.0 Support Thread
Just wanted to say this is a great mod! Installs and works wonderfully!
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
dcwd
Just wanted to say this is a great mod! Installs and works wonderfully!
Awesome.. Glad you like it!!:smile:
-
Re: Super Orders v3.0 Support Thread
Never being afraid of asking obvious questions, am I correct in thinking that SO3 is based on 1.3.9 code?
Thanks.
Philip
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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....
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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
-
Re: Super Orders v3.0 Support Thread
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..
Quote:
Originally Posted by
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
-
Re: Super Orders v3.0 Support Thread
Rizla is not the only one.
I too have lost the Store_Name but have yet to discern why.
SO3 was the last mod I installed and Store_Name was definitely there beforehand as it appears in various test emails.
One thing to note is that after running the SO3 uninstall.sql for previous versions, I also had to run the uninstall.sql from SO48a due to an error message (substance since forgotten) received from SO3 install.sql.
I wonder if others have experienced problems with the uninstall.sqls.
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
dw08gm
Rizla is not the only one.
I too have lost the Store_Name but have yet to discern why.
SO3 was the last mod I installed and Store_Name was definitely there beforehand as it appears in various test emails.
One thing to note is that after running the SO3 uninstall.sql for previous versions, I also had to run the uninstall.sql from SO48a due to an error message (substance since forgotten) received from SO3 install.sql.
I wonder if others have experienced problems with the uninstall.sqls.
Not sure why you ran either of the uninstall scripts to upgrade..:unsure: Based on your post here it sounds as if you did not follow the instructions in the readme for upgrading your Super Orders install:
From the readme:
Quote:
Upgrade from Rev47 & Later Versions (up to and including v1.3.9)
- Unzip the package contents to a temp directory
- Rename all of the YOUR_ADMIN_FOLDER and YOUR_TEMPLATE folders to match the name of your admin and template folders respectively.. Let me repeat this as this is the one step in module installs that most OFTEN gets overlooked/missed
Rename all of the YOUR_ADMIN_FOLDER and YOUR_TEMPLATE folders to match the name of YOUR admin and template folders respectively - FTP the contents of [temp directory]/1_Install_Files into the ROOT of your Zen Cart installation (i.e. your "/catalog" folder). The files are already arranged following the Zen Cart folder structure.
- FTP the contents of [temp directory]/2_Required_Core_Edits into the root of your Zen Cart. installation (i.e. your "/catalog" folder). The files are already arranged following the Zen Cart folder structure.
As with ANY module, any files which override existing cart files should be merged using a tool like Winmerge or Beyond Compare before you install the module.
Because these are core files, they have been separated. If you have installed any mods which make changes to the files in this folder, you will need to use a tool like Winmerge or Beyond Compare to incorporate those changes into these files. - Run the super_orders_upgrade.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches)
IF you are upgrading from a prior version of Super Orders and you run the uninstall script to perform an UPGRADE, you will DELETE ALL of the values in the following tables:
- so_payments;
- so_payment_types;
- so_purchase_orders;
- so_refunds;
- payment_purchase_order;
- payment_check;
- payment_check_balance;
This is why we created an upgrade script so that users of prior versions of Super Orders would not lose their previous Super Orders data in the upgrade.. So I'm a little puzzled why you chose to run the two uninstall scripts instead.
(BTW upgrading in the manner in which you've done it STILL wouldn't cause the issue you are reporting as NONE of the Super Orders scripts affects the STORE_NAME configuration_key value..)
With regards to your STORE_NAME value being missing from the configuration tables, something else is going on here.. There were FOUR of us testing Super Orders prior to it's release, and NOT ONCE did we ever have this issue.. I did MANY test upgrades, test installs, and NOT ONCE did I ever wipe out my store name or any other values in the configuration table..
I cannot replicate this AT ALL..
-
Re: Super Orders v3.0 Support Thread
I want this to to be clear for others reading this thread that SOMETHING ELSE has to be going on here..
There is NOTHING in the install, uninstall, or upgrade scripts that will remove ANY values from the configuration tables other than the values which ONLY affect Super Orders.. One of those affected values IS NOT "STORE_NAME".
Script to uninstall Super Orders v3.0 - Note there is NO reference to the configuration_key STORE_NAME
Code:
-- EDIT EXISTING TABLES
ALTER TABLE `orders`
DROP date_completed,
DROP date_cancelled,
DROP balance_due;
ALTER TABLE `orders`
DROP `split_from_order`,
DROP `is_parent`;
-- DROP TABLES
DROP TABLE IF EXISTS so_payments;
DROP TABLE IF EXISTS so_payment_types;
DROP TABLE IF EXISTS so_purchase_orders;
DROP TABLE IF EXISTS so_refunds;
DROP TABLE IF EXISTS payment_purchase_order;
DROP TABLE IF EXISTS payment_check;
DROP TABLE IF EXISTS payment_check_balance;
-- Store Phone and Fax numbers
--comment out if you want to keep these values
DELETE FROM configuration WHERE configuration_key = 'STORE_FAX';
DELETE FROM configuration WHERE configuration_key = 'STORE_PHONE';
-- Purchase Order payment module configs
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID';
-- Super Orders configuration group
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Super Orders';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
Prior Version Uninstall Script - Note there is NO reference to the configuration_key STORE_NAME
Code:
-- EDIT EXISTING TABLES
ALTER TABLE orders DROP date_completed;
ALTER TABLE orders DROP date_cancelled;
ALTER TABLE orders DROP balance_due;
-- DROP TABLES
DROP TABLE IF EXISTS customers_admin_notes;
DROP TABLE IF EXISTS so_payments;
DROP TABLE IF EXISTS so_payment_types;
DROP TABLE IF EXISTS so_purchase_orders;
DROP TABLE IF EXISTS so_refunds;
DROP TABLE IF EXISTS payment_purchase_order;
DROP TABLE IF EXISTS payment_check;
DROP TABLE IF EXISTS payment_check_balance;
-- Store Phone and Fax numbers
--comment out if you want to keep these valuse
DELETE FROM configuration WHERE configuration_key = 'STORE_FAX';
DELETE FROM configuration WHERE configuration_key = 'STORE_PHONE';
-- Purchase Order payment module configs
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE';
DELETE FROM configuration WHERE configuration_key = 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID';
-- Super Orders configuration group
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Super Orders';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
Super Orders v3.0 upgrade Script - Note there is NO reference to the configuration_key STORE_NAME
Code:
-- DROP OBSOLETE TABLES --
DROP TABLE IF EXISTS customers_admin_notes;
-- --------------------------------------------------------
-- ADDITIONAL DEFAULT PAYMENT TYPES --
INSERT INTO so_payment_types VALUES (NULL, 1, 'WU', 'Western Union');
INSERT INTO so_payment_types VALUES (NULL, 1, 'REF', 'Refund');
INSERT INTO so_payment_types VALUES (NULL, 1, 'SOLO', 'Solo');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MAES', 'Maestro');
INSERT INTO so_payment_types VALUES (NULL, 1, 'JCB', 'JCB');
-- --------------------------------------------------------
-- UPDATED SPLIT ORDERS SUPPORT --
ALTER TABLE `orders`
ADD `split_from_order` INT DEFAULT '0' NOT NULL,
ADD `is_parent` TINYINT (1) DEFAULT '1' NOT NULL;
-- --------------------------------------------------------
-- UPDATE SUPER ORDERS CONFIGURATION GROUP --
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Super Orders';
INSERT INTO configuration VALUES (NULL, 'Standard Packing Slips - Show Images', 'PACKINGSLIP_IMAGES', 'Yes', 'Do you want to show product images on the packing slip??', @t4, 61, now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),");
INSERT INTO configuration VALUES (NULL, 'Batch Form Printing - Printing Menu', 'LCSD_PRINTING_MENU', '2', 'Select which printing menu to show on the Super Orders Batch Form Printing page.<br />0=Traditional Super Orders options<br />1=PDF packing slip printing options<br />2=Both menus', @t4, 65, now(), now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2''),');
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Header Logo', 'LCSD_PACKING_LOGO_LARGE', 'packingslip_HeaderLogo.png','File name of the image to show in the PDF packing slip header. Upload to admin/images folder. For best output quality, the file dimensions should be 252px X 82px.<br /><br />You should replace placeholder image with your own logo. If you do not want to use a logo, you should upload a transparent image to replace the placeholder logo. If you delete the image name in this setting you will get errors when generating PDF packing slips. Supports PNG & JPG files ONLY.',@t4, 70, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Small Logo', 'LCSD_PACKING_LOGO_SMALL', 'packingslip_SmallLogo.png', 'File name of the image to show in the upper right corner of the PDF packing slip shipping label. Upload to admin/images folder. For best output quality, the file dimensions should be 192px X 64px.<br /><br />You should replace placeholder image with your own logo. If you do not want to use a logo, you should upload a transparent image to replace the placeholder logo. If you delete the image name in this setting you will get errors when generating PDF packing slips. Supports PNG & JPG files ONLY.',@t4, 75, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Show Store Name on Packing Slip', 'LCSD_SHOW_STORE_NAME', 'True', 'Determines whether or not the store name is included in the address block on the PDF packing slip. If the store name is part of the header logo set this to false.', @t4, 80, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''),');
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Enable Shipping Label', 'LCSD_SHOW_SHIPPING_LABEL', 'False', 'Determines whether or not a pre-printed shipping label is included in a customer address block on the packing slip so you don\’t have to process a separate label report. If you are using a preprinted packing slips with a peel off label – set this to true.', @t4, 85, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''),');
-- SUPER ORDERS ADMIN FLAGS TO ADD SUPPORT FOR OTHER ADD-ONS
INSERT INTO configuration VALUES (NULL, 'Edit Orders Module Switch', 'SO_EDIT_ORDERS_SWITCH', 'False', 'If you have Edit Orders v3.0 for Zen Cart 1.3.9 module installed, set this option to TRUE to activate the Edit Orders navigation buttons to work with Super Orders.<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)<br><br>While we have not specifically tested this switch with other Edit Orders modules \(most notably the 1.5.x versions\), this switch should also work with other versions of Edit Orders as well.', @t4, 180, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
INSERT INTO configuration VALUES (NULL, 'FedEx Label Module Switch', 'SO_FEDEX_LABELS_SWITCH', 'False', 'If your have the Fedex Automated Shipping Labels module installed, set this option to TRUE to activate it to work with Super Orders<br><br><strong><font color=red>YOU MUST HAVE FEDEX AUTOMATED SHIPPING LABELS INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', @t4, 185, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
INSERT INTO configuration VALUES (NULL, 'USPS Click-N-Ship Module Switch', 'SO_USPS_CLICK_SWITCH', 'False', 'If your have the USPS Click-N-Ship module installed, set this option to TRUE to activate it to work with Super Orders<br><br><strong><font color=red>YOU MUST HAVE USPS CLICK-N-SHIP INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', @t4, 190, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
-- --------------------------------------------------------
-- UPDATE TAX EXEMPTION CONFIGURATION VALUES
SET @t4=0;
SELECT (@t4:=configuration_key) as t4
FROM configuration
WHERE configuration_key= 'FED_TAX_ID_NUMBER';
UPDATE configuration SET configuration_title = 'Tax Exemption ID Number', configuration_key = 'TAX_ID_NUMBER', configuration_value = '', configuration_description = 'If your business or organization is tax exempt, then you may have been issued a tax exmption ID number. Enter the number here and the tax columns will not appear on the invoice and the tax exemption ID number will also be displayed at the top of the invoice.'
WHERE configuration_key = @t4;
-
Re: Super Orders v3.0 Support Thread
Super Orders v3.0 install Script - Note there is NO reference to the configuration_key STORE_NAME
Code:
-- EDIT EXISTING TABLES
ALTER TABLE orders
ADD date_completed datetime default NULL,
ADD date_cancelled datetime default NULL,
ADD balance_due decimal(14,2) default NULL;
-- --------------------------------------------------------
-- SPLIT ORDERS SUPPORT
ALTER TABLE `orders`
ADD `split_from_order` INT DEFAULT '0' NOT NULL,
ADD `is_parent` TINYINT (1) DEFAULT '1' NOT NULL;
-- --------------------------------------------------------
-- SUPER ORDERS PAYMENTS SUPPORT
CREATE TABLE so_payments (
payment_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
payment_number varchar(32) NOT NULL default '',
payment_name varchar(40) NOT NULL default '',
payment_amount decimal(14,2) NOT NULL default '0.00',
payment_type varchar(20) NOT NULL default '',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
purchase_order_id int(11) NOT NULL default '0',
PRIMARY KEY (payment_id)
) TYPE=MyISAM ;
-- --------------------------------------------------------
CREATE TABLE so_purchase_orders (
purchase_order_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
po_number varchar(32) default NULL,
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (purchase_order_id)
) TYPE=MyISAM ;
-- --------------------------------------------------------
CREATE TABLE so_refunds (
refund_id int(11) NOT NULL auto_increment,
payment_id int(11) NOT NULL default '0',
orders_id int(11) NOT NULL default '0',
refund_number varchar(32) NOT NULL default '',
refund_name varchar(40) NOT NULL default '',
refund_amount decimal(14,2) NOT NULL default '0.00',
refund_type varchar(4) NOT NULL default 'REF',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
last_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (refund_id),
KEY refund_id (refund_id)
) TYPE=MyISAM ;
-- --------------------------------------------------------
CREATE TABLE so_payment_types (
payment_type_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
payment_type_code varchar(4) NOT NULL default '',
payment_type_full varchar(20) NOT NULL default '',
PRIMARY KEY (payment_type_id),
UNIQUE KEY type_code (payment_type_code),
KEY type_code_2 (payment_type_code)
) TYPE=MyISAM;
-- --------------------------------------------------------
-- CREATE DEFAULT SUPER ORDERS PAYMENT TYPES
INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');
INSERT INTO so_payment_types VALUES (NULL, 1, 'CK', 'Check');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MO', 'Money Order');
INSERT INTO so_payment_types VALUES (NULL, 1, 'WU', 'Western Union');
INSERT INTO so_payment_types VALUES (NULL, 1, 'ADJ', 'Adjustment');
INSERT INTO so_payment_types VALUES (NULL, 1, 'REF', 'Refund');
INSERT INTO so_payment_types VALUES (NULL, 1, 'CC', 'Credit Card');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MC', 'MasterCard');
INSERT INTO so_payment_types VALUES (NULL, 1, 'VISA', 'Visa');
INSERT INTO so_payment_types VALUES (NULL, 1, 'AMEX', 'American Express');
INSERT INTO so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');
INSERT INTO so_payment_types VALUES (NULL, 1, 'DINE', 'Diners Club');
INSERT INTO so_payment_types VALUES (NULL, 1, 'SOLO', 'Solo');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MAES', 'Maestro');
INSERT INTO so_payment_types VALUES (NULL, 1, 'JCB', 'JCB');
-- --------------------------------------------------------
-- ADD STORE PHONE AND FAX NUMBERS --
INSERT INTO configuration VALUES (NULL, 'Store Fax', 'STORE_FAX', '555-555-1212', 'Enter the fax number for your store.<br>You can call upon this by using the define <strong>STORE_FAX</strong>.', 1, 4, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Store Phone', 'STORE_PHONE', '555-555-1212', 'Enter the phone number for your store.<br>You can call upon this by using the define <strong>STORE_PHONE</strong>.', 1, 4, now(), now(), NULL, NULL);
-- --------------------------------------------------------
-- ADD PURCHASE ORDER PAYMENT MODULE CONFIGURATION VALUES --
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'FALSE', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ');
INSERT INTO configuration VALUES (NULL, 'Make payable to:', 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO', 'YOUR COMPANY NAME', 'Who should payments be made payable to?', 6, 2, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Sort order of display.', 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 4, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Payment Zone', 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 5, now(), now(), 'zen_get_zone_class_title', 'zen_cfg_pull_down_zone_classes(');
INSERT INTO configuration VALUES (NULL, 'Set Order Status', 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value', 6, 6, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
-- --------------------------------------------------------
-- CREATE SUPER ORDERS CONFIGURATION GROUP --
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Super Orders';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group VALUES (NULL, 'Super Orders', 'Settings for Super Order Features', '100', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Super Orders';
-- ADD VALUES TO SUPER ORDERS CONFIGURATION GROUP (Admin > Configuration > Super Orders) --
INSERT INTO configuration VALUES (NULL, 'Auto Status - Payment', 'AUTO_STATUS_PAYMENT', '2', 'Number of the order status assigned when a payment (<strong>not</strong> attached to a purchase order) is added to the payment data.', @t4, 5, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - P.O. Payment', 'AUTO_STATUS_PO_PAYMENT', '2', 'Number of the order status assigned when a payment <strong>attached to a purchase order</strong> is added to the payment data.', @t4, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - Purchase Order', 'AUTO_STATUS_PO', '2', 'Number of the status assigned to an order when a purchase order is added to the payment data.', @t4, 15, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - Refund', 'AUTO_STATUS_REFUND', '2', 'Number of the order status assigned when a refund is added to the payment data.', @t4, 20, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Payment', 'AUTO_COMMENTS_PAYMENT', 'Payment received in our office. Payment ID: %s', 'You''ll have the option of adding these pre-configured comments to an order when a payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', @t4, 25, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - P.O. Payment', 'AUTO_COMMENTS_PO_PAYMENT', 'Payment on purchase order received in our office. Payment ID: %s', 'You will have the option of adding these pre-configured comments to an order when a purchase order payment is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', @t4, 30, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Purchase Order', 'AUTO_COMMENTS_PO', 'Purchase Order #%s received in our office', 'You will have the option of adding these pre-configured comments to an order when a purchase order is entered. You can attach the payment number to the comments by typing <strong>%s</strong>.', @t4, 35, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Auto Comments - Refund', 'AUTO_COMMENTS_REFUND', 'Refund #%s has been issued from our office.', 'You will have the option of adding these pre-configured comments to an order when a refund is entered. You can attach the refund number to the comments by typing <strong>%s</strong>.', @t4, 40, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Tax Exemption ID Number', 'TAX_ID_NUMBER', '', 'If your business or organization is tax exempt, then you may have been issued a tax exmption ID number. Enter the number here and the tax columns will not appear on the invoice and the tax exemption ID number will also be displayed at the top of the invoice.', @t4, 45, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Cancelled"', 'STATUS_ORDER_CANCELLED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Cancelled!" button on super_orders.php.<p>If you do not have a "cancel" status, or do not want assign one automatically, choose <strong>default</strong> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', @t4, 50, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Completed"', 'STATUS_ORDER_COMPLETED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Completed!" button on super_orders.php.<p>If you do not have a "complete" status, or do not want assign one automatically, choose <strong>default</strong> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', @t4, 55, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Closed Status - "Reopened"', 'STATUS_ORDER_REOPEN', '0', 'Insert the order status ID # you would like to assign to an order when you undo the cancelled/completed status of an order.<p>If you do not have a "reopened" status, or do not want assign one automatically, choose <strong>default</strong> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', @t4, 60, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Standard Packing Slips - Show Images', 'PACKINGSLIP_IMAGES', 'Yes', 'Do you want to show product images on the packing slip??', @t4, 61, now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),");
INSERT INTO configuration VALUES (NULL, 'Batch Form Printing - Printing Menu', 'LCSD_PRINTING_MENU', '2', 'Select which printing menu to show on the Super Orders Batch Form Printing page.<br />0=Traditional Super Orders options<br />1=PDF packing slip printing options<br />2=Both menus', @t4, 65, now(), now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2''),');
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Header Logo', 'LCSD_PACKING_LOGO_LARGE', 'packingslip_HeaderLogo.png','File name of the image to show in the PDF packing slip header. Upload to admin/images folder. For best output quality, the file dimensions should be 252px X 82px.<br /><br />You should replace placeholder image with your own logo. If you do not want to use a logo, you should upload a transparent image to replace the placeholder logo. If you delete the image name in this setting you will get errors when generating PDF packing slips. Supports PNG & JPG files ONLY.',@t4, 70, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Small Logo', 'LCSD_PACKING_LOGO_SMALL', 'packingslip_SmallLogo.png', 'File name of the image to show in the upper right corner of the PDF packing slip shipping label. Upload to admin/images folder. For best output quality, the file dimensions should be 192px X 64px.<br /><br />You should replace placeholder image with your own logo. If you do not want to use a logo, you should upload a transparent image to replace the placeholder logo. If you delete the image name in this setting you will get errors when generating PDF packing slips. Supports PNG & JPG files ONLY.',@t4, 75, now(), now(), NULL , NULL);
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Show Store Name on Packing Slip', 'LCSD_SHOW_STORE_NAME', 'True', 'Determines whether or not the store name is included in the address block on the PDF packing slip. If the store name is part of the header logo set this to false.', @t4, 80, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''),');
INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Enable Shipping Label', 'LCSD_SHOW_SHIPPING_LABEL', 'False', 'Determines whether or not a pre-printed shipping label is included in a customer address block on the packing slip so you don\’t have to process a separate label report. If you are using a preprinted packing slips with a peel off label – set this to true.', @t4, 85, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''),');
-- SUPER ORDERS ADMIN FLAGS TO ADD SUPPORT FOR OTHER ADD-ONS
INSERT INTO configuration VALUES (NULL, 'Edit Orders Module Switch', 'SO_EDIT_ORDERS_SWITCH', 'False', 'If you have Edit Orders v3.0 for Zen Cart 1.3.9 module installed, set this option to TRUE to activate the Edit Orders navigation buttons to work with Super Orders.<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)<br><br>While we have not specifically tested this switch with other Edit Orders modules \(most notably the 1.5.x versions\), this switch should also work with other versions of Edit Orders as well.', @t4, 180, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
INSERT INTO configuration VALUES (NULL, 'FedEx Label Module Switch', 'SO_FEDEX_LABELS_SWITCH', 'False', 'If your have the Fedex Automated Shipping Labels module installed, set this option to TRUE to activate it to work with Super Orders<br><br><strong><font color=red>YOU MUST HAVE FEDEX AUTOMATED SHIPPING LABELS INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', @t4, 185, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
INSERT INTO configuration VALUES (NULL, 'USPS Click-N-Ship Module Switch', 'SO_USPS_CLICK_SWITCH', 'False', 'If your have the USPS Click-N-Ship module installed, set this option to TRUE to activate it to work with Super Orders<br><br><strong><font color=red>YOU MUST HAVE USPS CLICK-N-SHIP INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', @t4, 190, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");
-
Re: Super Orders v3.0 Support Thread
We just downloaded the contribution, but couldn't get it to work.... the file lcsd_merged_packing_slips.php doesn't have a closing tag, and if that file is in place the entire admin area doesn't work.
I tried to unzip using different tools to see if the file may have been corrupted, but no matter how I unzip the file appears to be truncated.
Any ideas?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
propel
We just downloaded the contribution, but couldn't get it to work.... the file lcsd_merged_packing_slips.php doesn't have a closing tag, and if that file is in place the entire admin area doesn't work.
I tried to unzip using different tools to see if the file may have been corrupted, but no matter how I unzip the file appears to be truncated.
Any ideas?
lcsd_merged_packing_slips.php doesn't need the closing ?> as has been posted repeatedly by the Zen Cart admins..
Chances are lcsd_merged_packing_slips.php is generating an error because there is some file it needs that was not loaded properly..
Based on what I THINK you mean by "entire admin doesn't work" I assume you mean that the admin goes blank when the lcsd_merged_packing_slips.php file is in place?? (It helps to post EXACTLY what happens so I don't have to interpret) If my assumption is correct, you need to post what the error log file that would be generated when you get the blank page says.. (log files would be located in your "cache" folder) Once we know what the error is, then I can guide you on resolving it..
-
Re: Super Orders v3.0 Support Thread
Diva
I am NOT in any way dissing your great mod, I love it.
After the DB restore I went ahead and ran the SQL and all worked this time.
The DB field that REPLACED STORE_NAME was tax excemption number.
The only place I see reference to it is here (from the SQL install)
INSERT INTO configuration VALUES (NULL, 'Tax Exemption ID Number', 'TAX_ID_NUMBER', '', 'If your business or organization is tax exempt, then you may have been issued a tax exmption ID number. Enter the number here and the tax columns will not appear on the invoice and the tax exemption ID number will also be displayed at the top of the invoice.', @t4, 45, now(), now(), NULL , NULL);
Don't know why it all went well on my 'Local' server (windows and xamp) and not on the remote (Linux)
So, SO3 now works for me on the remote and I also went ahead and installed 'Edit Orders'
I too had to uninstall both Edit Orders and SO3 (SQL) and re-install to get them working.
They do now appear to both work, ecxept the print button opens a blank page, but I can live with that.
So there is two of us that had the same problem for 'some' reason. And I know my explanation here is of little help to you as a programmer... sorry!
Rizla
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Rizla
Diva
I am NOT in any way dissing your great mod, I love it.
After the DB restore I went ahead and ran the SQL and all worked this time.
Not what I was implying at all.. Simply just wanted to make it clear that the SQL files to install, uninstall, or upgrade Super Orders cannot be the cause of what is happening in your store if they are run unedited as described in the Super Orders readme.. It's impossible to troubleshoot issues that I cannot replicate..
Quote:
Originally Posted by
Rizla
The DB field that REPLACED STORE_NAME was tax excemption number.
The only place I see reference to it is here (from the SQL install)
INSERT INTO configuration VALUES (NULL, 'Tax Exemption ID Number', 'TAX_ID_NUMBER', '', 'If your business or organization is tax exempt, then you may have been issued a tax exmption ID number. Enter the number here and the tax columns will not appear on the invoice and the tax exemption ID number will also be displayed at the top of the invoice.', @t4, 45, now(), now(), NULL , NULL);
Again, this bit of SQL would not replace the STORE_NAME in the configuration table.. Unless it was run in a way other than how the readme says to run the upgrade script.. And honestly since your post I have tried to run it in non-standard ways to try and make this happen and I cannot get the same result..
Quote:
Originally Posted by
Rizla
Don't know why it all went well on my 'Local' server (windows and xamp) and not on the remote (Linux)
So, SO3 now works for me on the remote and I also went ahead and installed 'Edit Orders'
I too had to uninstall both Edit Orders and SO3 (SQL) and re-install to get them working.
I can't say either since I cannot see your store file.. The issues you reported are not normal if Super Orders is installed following the instructions in the readme.. We stress tested to DEATH not only a fresh install but the upgrade and uninstall scripts as well..
Quote:
Originally Posted by
Rizla
They do now appear to both work, ecxept the print button opens a blank page, but I can live with that.
So there is two of us that had the same problem for 'some' reason. And I know my explanation here is of little help to you as a programmer... sorry!
Rizla
The print button opens super_data_sheet.php. If you are getting a blank page then it's likely that something is still installed wrong or this file was corrupted in your upload to your store.. The error logs in the "cache" folder will tell you exactly what error is occurring when you click the print button..
-
Re: Super Orders v3.0 Support Thread
Hi,
This is not going to be a solution! but more an addition. Another problem.
I have installed super_orders 3.0 and edit_orders 3.02 recently on a fresh insytallation of Zencart 1.3.9h. It looks likes it all works, except for the two buttons "Batch Status Update" and "Batch Form Print". When I click either one of them, the screen goes blank.
I use Windows7 64-bit, WampServer2.0 (out of the box), ZenCart 1.3.9h. I have installed the Dutch Language pack
I've gone through this thread to see if I could find a solution for this, but I don't come across this part.
Any idea where to look for clues? If more info is required, please let me know
Greetings,
Marty Jansen
-
Re: Super Orders v3.0 Support Thread
Hi,
just looked up some debug information that seems to be standard in version 1.3.9. There are errors in the cache folder. For "Batch Status Update" and "Batch Form Print" it had to do with the same error.
[30-Dec-2010 10:21:17] PHP Fatal error: Call to undefined function current_countries_array() in C:\wamp\www\shop\_admin\super_batch_forms.php on line 51
[30-Dec-2010 10:09:29] PHP Fatal error: Call to undefined function current_countries_array() in C:\wamp\www\shop\_admin\super_batch_status.php on line 51
Making line 51 a comment solves part of the problem. It will show up the page!!!! Everything seems to be working except for the dropdown list with countries, this in now empty.
Not a big problem for me, but for others this is not how it should be.
Greetings,
Marty
-
Re: Super Orders v3.0 Support Thread
The error message says that super orders is attempting to access a function it cannot locate.. This indicates to me that you missed a file in your install.. Please make sure that you check that the YOUR_ADMIN/includes/functions/extra_functions/super_orders_functions.php file is in place.. and you will need to un-comment whatever you've commented out to try and work around this error..
Quote:
Originally Posted by
jansietje
Hi,
just looked up some debug information that seems to be standard in version 1.3.9. There are errors in the cache folder. For "Batch Status Update" and "Batch Form Print" it had to do with the same error.
[30-Dec-2010 10:21:17] PHP Fatal error: Call to undefined function current_countries_array() in C:\wamp\www\shop\_admin\super_batch_forms.php on line 51
[30-Dec-2010 10:09:29] PHP Fatal error: Call to undefined function current_countries_array() in C:\wamp\www\shop\_admin\super_batch_status.php on line 51
Making line 51 a comment solves part of the problem. It will show up the page!!!! Everything seems to be working except for the dropdown list with countries, this in now empty.
Not a big problem for me, but for others this is not how it should be.
Greetings,
Marty
-
Re: Super Orders v3.0 Support Thread
Hi,
thanks for the quick response. I've checked the folders, but it is there. c:\wamp\www\shop\_admin\includes\functions\extra_functions\super_orders_function s.php. But a search in this file does not show any reference to the word countries. After inspecting the installatie folder, I noticed a difference in size. After replacing this folder everything is OK.
Thanks again for the help
Best wishes and a happy new year
-
Re: Super Orders v3.0 Support Thread
Let me make sure I am clear about how you resolved this (Might help someone else later on..) You had an older version of ths file in your store previously?? This file changed in v3.0 so if you still had a prior version of this file, that would explain the file size difference and the error..
Quote:
Originally Posted by
jansietje
Hi,
thanks for the quick response. I've checked the folders, but it is there. c:\wamp\www\shop\_admin\includes\functions\extra_functions\super_orders_function s.php. But a search in this file does not show any reference to the word countries. After inspecting the installatie folder, I noticed a difference in size. After replacing this folder everything is OK.
Thanks again for the help
Best wishes and a happy new year
-
1 Attachment(s)
Re: Super Orders v3.0 Support Thread
Hello Everyone
Congratulations and Respect to all involved with this brilliant piece of work
website info
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
HTTP Server: Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
PHP Version: 5.2.9 (Zend: 2.2.0) PHP Memory Limit: 32M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
I have used Super Orders 1.3.9.very succesfully on my live cart and am testing ver 3 with my configuration on localhost under xammp
When I try to print of a copy of the order details (see thumbnail) I get the following issue
This seems to be coming from super_data_sheet.php lines around lines 225 where TYTracker 2 is spliced in.
Question; is it intended that TY Tracker 2 should be defacto installed as well, or is there a means to switch this piece of code off or do I null this code?
Question; the radio buttons at the bottom of the order sheet are defaulted to email the customer. I personally would prefer to have them the other way round. The code in question seems to come from
/toolroom/super_orders.php
/toolroom/super_batch_status.php
If I altered the radio buttons logic on line 1273 of the former and line 302 of the latter would that do the trick?
I would be very greatful for any guidance
A healthy, happy and prosperous new year to all
Centec2b
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Centec2b
When I try to print of a copy of the order details (see thumbnail) I get the following issue
This seems to be coming from super_data_sheet.php lines around lines 225 where TYTracker 2 is spliced in.
Question; is it intended that TY Tracker 2 should be defacto installed as well, or is there a means to switch this piece of code off or do I null this code?
Good catch..:smile: This was a small oversight on our part.. Replace your super_data_sheet.php file with the one attached to this post.. See if this works for ya.. (this updated file will be included in the next update)
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Centec2b
When I try to print of a copy of the order details (see thumbnail) I get the following issue
This seems to be coming from super_data_sheet.php lines around lines 225 where TYTracker 2 is spliced in.
Question; is it intended that TY Tracker 2 should be defacto installed as well, or is there a means to switch this piece of code off or do I null this code?
Quote:
Originally Posted by
DivaVocals
Good catch..:smile: This was a small oversight on our part.. Replace your super_data_sheet.php file with the one attached to this post.. See if this works for ya.. (this updated file will be included in the next update)
NO.. As I stated in the leading post for this support thread AND in the readme, NONE of the supported mods are required to be installed to use Super Orders v3.0..
If you are not running Ty Package Tracker, USPS Click-N-Ship, FedEx Labels, or Edit Orders, you will still be able to run Super Orders v3.0. If you do use any of these mods, we simply made it easy to use them by activating the corresponding admin flag.. This was a simple oversight in one file where the required admin switch code was inadvertently left out..
Quote:
Originally Posted by
Centec2b
Question; the radio buttons at the bottom of the order sheet are defaulted to email the customer. I personally would prefer to have them the other way round. The code in question seems to come from
/toolroom/super_orders.php
/toolroom/super_batch_status.php
If I altered the radio buttons logic on line 1273 of the former and line 302 of the latter would that do the trick?
It should.. though I haven't explicitly tested this, changing the radio button that you wish to be the default to "true" should do the trick..
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
Good catch..:smile: Replace your super_data_sheet.php file with the one attached to this post.. See if this works for ya.. (this updated file will be included in the next update)
Diva - mega - works a charm - thank you :smile:
Centec2b
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by Centec2b
Question; the radio buttons at the bottom of the order sheet are defaulted to email the customer. I personally would prefer to have them the other way round. The code in question seems to come from
/toolroom/super_orders.php
/toolroom/super_batch_status.php
If I altered the radio buttons logic on line 1273 of the former and line 302 of the latter would that do the trick?
Diva Response
It should.. though I haven't explicitly tested this, changing the radio button that you wish to be the default to "true" should do the trick..
Diva I have altered the logic around super_orders.php and am testing it. I am confident the code is right.
super_batch_status.php uses the boolean test on the first part of
line 305
Code:
echo zen_draw_checkbox_field('notify', 'on', true); echo ' ' . ENTRY_NOTIFY_CUSTOMER . '<br>';
echo zen_draw_checkbox_field('notify_comments', 'on', true); echo ' ' . ENTRY_NOTIFY_COMMENTS;
ie
line 403
Code:
if ($notify == 'on') {
email_latest_status($oID);
}
Question; can I change the first checkbox on line 305 from TRUE to FALSE without changing the value? ie
Code:
echo zen_draw_checkbox_field('notify', 'on', FALSE);
Is this still within the logic expected to evaluate it on line 403?
It seems to work but I am unable to mail out on localhost so the whole action is not completed and whilst it shows an unlocked comment the green tick is not present to show the customer was emailed ok
Thank you
Centec2b
-
Re: Super Orders v3.0 Support Thread
:laugh: Oh you think I'm a REAL programmer??:laugh: Not me.. :no:
What looks logical is that changing the true to false would mean the checkbox is no longer checked by default.. (same with the radio buttons.. true = selected and false = not selected) Best way to KNOW is to simply try it (it's what I would do to test it..:smile:)
Quote:
Originally Posted by
Centec2b
Diva I have altered the logic around super_orders.php and am testing it. I am confident the code is right.
super_batch_status.php uses the boolean test on the first part of
line 305
Code:
echo zen_draw_checkbox_field('notify', 'on', true); echo ' ' . ENTRY_NOTIFY_CUSTOMER . '<br>';
echo zen_draw_checkbox_field('notify_comments', 'on', true); echo ' ' . ENTRY_NOTIFY_COMMENTS;
ie
line 403
Code:
if ($notify == 'on') {
email_latest_status($oID);
}
Question; can I change the first checkbox on line 305 from TRUE to FALSE without changing the value? ie
Code:
echo zen_draw_checkbox_field('notify', 'on', FALSE);
Is this still within the logic expected to evaluate it on line 403?
It seems to work but I am unable to mail out on localhost so the whole action is not completed and whilst it shows an unlocked comment the green tick is not present to show the customer was emailed ok
Thank you
Centec2b
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Centec2b
Diva - mega - works a charm - thank you :smile:
Centec2b
Thanks for confirming.. It was a very silly oversight..:blush:
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
:laugh: Oh you think I'm a REAL programmer??:laugh: Not me.. :no:
What looks logical is that changing the true to false would mean the checkbox is no longer checked by default.. (same with the radio buttons.. true = selected and false = not selected) Best way to KNOW is to simply try it (it's what I would do to test it..:smile:)
Diva be assured, from where I am sat, you are a real programmer....:wink:
I have implemented the changes to the buttons at the bottom of the order sheet & super batch status and everything seems to work ok - so far
/toolroom/super_orders.php
/toolroom/super_batch_status.php
so if anyone wants to change the buttons default behaviour to contact customer this may be of interest
Diva - thank you for your help - respect
Centec2b
-
Re: Super Orders v3.0 Support Thread
Well thank you, but I am more of a "figure it outter" than a programmer..:laugh:
I think your changes will work.. It's just a matter of changing what you want as the default state for the various checkboxes and radioboxes..
That said, I wanted to add this, for anyone modifying the default state of the three comments radioboxes (Email, No Email, Hide), it's NOT a good idea to set them all to false..
Unless you are VERY disciplined enough to remember to select one of the comments radioboxes, you will possibly end up with NO comment being saved at all or errors if they are all set false.. At least ONE of the radioboxes should be set to true.
Also the "Append Comments?" checkbox should always be selected or comments will not be saved to the database.
Quote:
Originally Posted by
Centec2b
Diva be assured, from where I am sat, you are a real programmer....:wink:
I have implemented the changes to the buttons at the bottom of the order sheet & super batch status and everything seems to work ok - so far
/toolroom/super_orders.php
/toolroom/super_batch_status.php
so if anyone wants to change the buttons default behaviour to contact customer this may be of interest
Diva - thank you for your help - respect
Centec2b
-
Re: Super Orders v3.0 Support Thread
Thank you for version 3.0! I was able to upgrade without any problems and love the new features. I have one very small question on the changes made to ADMIN_FOLDER/includes/modules/orders_download.php
I'm not clear on why these two changes were made:
download_reset_off is now download_reset_on
icon_green_on is now icon_yellow_on
The yellow icon indicates 'expired' on the legend for downloadable products so it seems confusing that the button next to the downloaded products is now yellow since the downloads are definitely 'active' (green on the legend).
When I press the button it resets the the number of times the file can be downloaded. I've always had odd behavior with that button in general even on the baseline zencart orders panel. It's not a feature we've needed (ie I have no expiration date for downloadable purchases thus no reason to 'reset' their downloads) so it's possible I just don't understand how it's supposed to work :)
Since I sell a lot of downloads I want to make sure I understand why I'm putting this change in so that we don't use it incorrectly or encounter unexpected behavior.
Thank you!
-
Re: Super Orders v3.0 Support Thread
Happy New Year everyone :)
Hi Diva - I LOVE this mod :clap:
I've installed it and have completed testing. I have one general question, one small issue, and one bigger issue.
Software/Server Info
- ZC 139h
- PHP 5.2.15
- Linux Server
- Super Orders 3.0
1. If I click on the customer profile icon, and then either cancel or update the profile page, it takes me back to customers.php instead of back to super orders. To get back to super orders.php, I have to click the orders button from the customers.php page.
I suspect this is what it's supposed to do, but since I didn't test that functionality prior to the s.o. install, I am unable to confirm correct functioning for myself. Can you confirm?
2. If I click on the customer name text link on super_orders.php, it takes me to mail.php to email the customer. If I click cancel, sometimes it reloads a normal looking super_orders.php page.
Other times it reloads a partially blank super_orders.php page (i.e. unpopluated with customer list - as if there are no customers). Reloading the page through the browser has no effect. If I use the menu to navigate back (customers>>super orders), the page populates normally.
On the other hand, if I go ahead and send an email, once the email is sent, it takes me back to mail.php. If I click cancel from there, it takes me back to the main admin page.
3. When I click the print button (both from s.o. admin interface and order details), the page that comes up has this error on it:
ORDER STATUS HISTORY & COMMENTS
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 zen_orders_status_history where orders_id = '1117' 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.
So I downloaded the new super data sheet file you posted earlier in this thread and uploaded it to the server.
Now when I click print, I get a blank page in a new window. This creates a debug log with this message:
[03-Jan-2011 12:13:18] PHP Fatal error: Cannot redeclare class base in public_html/My_Store/includes/classes/class.base.php on line 17
Line 17 only has this on it:
Here are lines 15-35:
PHP Code:
* @package classes
*/
class base {
/**
* method used to an attach an observer to the notifier object
*
* NB. We have to get a little sneaky here to stop session based classes adding events ad infinitum
* To do this we first concatenate the class name with the event id, as a class is only ever going to attach to an
* event id once, this provides a unigue key. To ensure there are no naming problems with the array key, we md5 the unique
* name to provide a unique hashed key.
*
* @param object Reference to the observer class
* @param array An array of eventId's to observe
*/
function attach(&$observer, $eventIDArray) {
foreach($eventIDArray as $eventID) {
$nameHash = md5(get_class($observer).$eventID);
base::setStaticObserver($nameHash, array('obs'=>&$observer, 'eventID'=>$eventID));
}
}
/**
Thoughts?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
ScriptJunkie
1. If I click on the customer profile icon, and then either cancel or update the profile page, it takes me back to customers.php instead of back to super orders. To get back to super orders.php, I have to click the orders button from the customers.php page.
This is correct bahavior.. Once you are on the customer detail edit page, you must navigate back to Super Orders using the normal menu navigation.
Quote:
Originally Posted by
ScriptJunkie
2. If I click on the customer name text link on super_orders.php, it takes me to mail.php to email the customer. If I click cancel, sometimes it reloads a normal looking super_orders.php page.
Other times it reloads a partially blank super_orders.php page (i.e. unpopluated with customer list - as if there are no customers). Reloading the page through the browser has no effect. If I use the menu to navigate back (customers>>super orders), the page populates normally.
On the other hand, if I go ahead and send an email, once the email is sent, it takes me back to mail.php. If I click cancel from there, it takes me back to the main admin page.
This is a minor buglet (thanks for providing CLEAR DETAILS :wink:..) I was working on other minor edits and bugs and will include this one..
Quote:
Originally Posted by
ScriptJunkie
3. When I click the print button (both from s.o. admin interface and order details), the page that comes up has this error on it:
ORDER STATUS HISTORY & COMMENTS
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 zen_orders_status_history where orders_id = '1117' 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.
So I downloaded the new super data sheet file you posted earlier in this thread and uploaded it to the server.
Now when I click print, I get a blank page in a new window. This creates a debug log with this message:
[03-Jan-2011 12:13:18] PHP Fatal error: Cannot redeclare class base in public_html/My_Store/includes/classes/class.base.php on line 17
Line 17 only has this on it:
Here are lines 15-35:
PHP Code:
* @package classes
*/
class base {
/**
* method used to an attach an observer to the notifier object
*
* NB. We have to get a little sneaky here to stop session based classes adding events ad infinitum
* To do this we first concatenate the class name with the event id, as a class is only ever going to attach to an
* event id once, this provides a unigue key. To ensure there are no naming problems with the array key, we md5 the unique
* name to provide a unique hashed key.
*
* @param object Reference to the observer class
* @param array An array of eventId's to observe
*/
function attach(&$observer, $eventIDArray) {
foreach($eventIDArray as $eventID) {
$nameHash = md5(get_class($observer).$eventID);
base::setStaticObserver($nameHash, array('obs'=>&$observer, 'eventID'=>$eventID));
}
}
/**
Thoughts?
Sorry girl..:laugh:
This one is not a Super Orders bug, but rather another error elsewhere in your store that the Super Orders data sheet is unfortunately burping on.. I've seen this error pop up fairly frequently.. Based on other posts on this topic, the most likely culprit is that you've got another file from another mod declaring this same class (therefore causing the error) OR you've got a duplicate/backup artifact both of which are declaring this class.. Do a search in the forum for " Cannot redeclare class base". There are a number of posts dealing with this same error, and they all seem to point to erroneous duplication of one or more files which declare this class..
-
Re: Super Orders v3.0 Support Thread
I'm gonna defer to JTheed on this one.. I don't wanna speak outta turn here.. Hopefully he'll chime in soon..:smile:
Quote:
Originally Posted by
pinkchalkstudio
Thank you for version 3.0! I was able to upgrade without any problems and love the new features. I have one very small question on the changes made to ADMIN_FOLDER/includes/modules/orders_download.php
I'm not clear on why these two changes were made:
download_reset_off is now download_reset_on
icon_green_on is now icon_yellow_on
The yellow icon indicates 'expired' on the legend for downloadable products so it seems confusing that the button next to the downloaded products is now yellow since the downloads are definitely 'active' (green on the legend).
When I press the button it resets the the number of times the file can be downloaded. I've always had odd behavior with that button in general even on the baseline zencart orders panel. It's not a feature we've needed (ie I have no expiration date for downloadable purchases thus no reason to 'reset' their downloads) so it's possible I just don't understand how it's supposed to work :)
Since I sell a lot of downloads I want to make sure I understand why I'm putting this change in so that we don't use it incorrectly or encounter unexpected behavior.
Thank you!
-
Re: Super Orders v3.0 Support Thread
Quote:
1. If I click on the customer profile icon, and then either cancel or update the profile page, it takes me back to customers.php instead of back to super orders. To get back to super orders.php, I have to click the orders button from the customers.php page.
Quote:
This is correct bahavior.. Once you are on the customer detail edit page, you must navigate back to Super Orders using the normal menu navigation.
Thanks for the confirmation!
Quote:
2. If I click on the customer name text link on super_orders.php, it takes me to mail.php to email the customer. If I click cancel, sometimes it reloads a normal looking super_orders.php page. Other times it reloads a partially blank super_orders.php page (i.e. unpopluated with customer list - as if there are no customers). Reloading the page through the browser has no effect. If I use the menu to navigate back (customers>>super orders), the page populates normally. On the other hand, if I go ahead and send an email, once the email is sent, it takes me back to mail.php. If I click cancel from there, it takes me back to the main admin page.
Quote:
This is a minor buglet (thanks for providing CLEAR DETAILS :wink2:..) I was working on other minor edits and bugs and will include this one..
Awesome, thanks!
Quote:
3. When I click the print button (both from s.o. admin interface and order details), the page that comes up has this error on it:
ORDER STATUS HISTORY & COMMENTS
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 zen_orders_status_history where orders_id = '1117' 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.
So I downloaded the new super data sheet file you posted earlier in this thread and uploaded it to the server.
Now when I click print, I get a blank page in a new window. This creates a debug log with this message:
[03-Jan-2011 12:13:18] PHP Fatal error: Cannot redeclare class base in public_html/My_Store/includes/classes/class.base.php on line 17
Quote:
Sorry girl..:laugh:
This one is not a Super Orders bug, but rather another error elsewhere in your store that the Super Orders data sheet is unfortunately burping on.. I've seen this error pop up fairly frequently.. Based on other posts on this topic, the most likely culprit is that you've got another file from another mod declaring this same class (therefore causing the error) OR you've got a duplicate/backup artifact both of which are declaring this class.. Do a search in the forum for " Cannot redeclare class base". There are a number of posts dealing with this same error, and they all seem to point to erroneous duplication of one or more files which declare this class..
Ugh...that's what I was afraid of. But thanks so much for pointing me in the right direction! I sure appreciate it :)
Off to research.... :smile:
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
ScriptJunkie
Ugh...that's what I was afraid of. But thanks so much for pointing me in the right direction! I sure appreciate it :)
Off to research.... :smile:
I know bummer huh.. But if it helps the culprit is likely whatever was installed just BEFORE or just AFTER Super Orders.. (if that helps.. :smile:)
-
Re: Super Orders v3.0 Support Thread
Hi I haven't updated my super orders mod yet but I had a quick question.
I know that it also has the tracking option. Do I have to have a tracking mod installed? I think I currently have Ty Tracker or something like that. Just wondering if Super Orders has made a smoother integration between the two or if the tracking option is just available as an upgrde with the new Super Orders....
Haha, that sounded confusing.:blink:
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
joyjoy
Hi I haven't updated my super orders mod yet but I had a quick question.
I know that it also has the tracking option. Do I have to have a tracking mod installed? I think I currently have Ty Tracker or something like that. Just wondering if Super Orders has made a smoother integration between the two or if the tracking option is just available as an upgrde with the new Super Orders....
Haha, that sounded confusing.:blink:
All of your questions are answered in the leading threads for THIS support thread (please see page 1 of this thread) and in the readme which you can get from downloading the new Super Orders..
If after reading the information provided you have additional questions or something wasn't covered in any of the support threads or documentation, let me know and I'll be happy to answer them for you..
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
I know bummer huh.. But if it helps the culprit is likely whatever was installed just BEFORE or just AFTER Super Orders.. (if that helps.. :smile:)
The only thing I installed before this mod was Edit Orders. Once Super Orders was installed, the only change I've made was to upload the new super_data_sheet.php to.....
Uh oh....I just realized there are two of these files in different locations (in /admin and again in /admin/includes/languages/english) :oops: and now I can't remember which directory I uploaded to. But I'll bet it's the wrong one - that's exactly the kind of thing that causes this kind of error according to the threads I've been reading tonight.
Let me go back and restore the originals to both locations and then I'll re-upload the new file that you posted in this thread.
For clarity, can you tell me which of those directories it should be installed in?
-
Re: Super Orders v3.0 Support Thread
Okay I read the first page...it says that Super Orders can do tracking now but it also says that it can be integrated with Ty Tracker. If Super Orders has it all I'm going to remove Ty Tracker.
Am I misunderstanding this? Thank you.
-
Re: Super Orders v3.0 Support Thread
Hi Joy,
I don't use TY Tracker but my understanding is that Super Orders integrates with TY Tracker, meaning they work together. You need to have TY Tracker installed in order to use it from inside Super Orders.
There is some awesome and extremely thorough documentation on how they work together, what order to install in, how to install based on what version of TY Tracker you're using, etc.....
All this documentation is in the Read Me file that is packaged with Super Orders.
Hope that helps :)
Quote:
Originally Posted by
joyjoy
Okay I read the first page...it says that Super Orders can do tracking now but it also says that it can be integrated with Ty Tracker. If Super Orders has it all I'm going to remove Ty Tracker.
Am I misunderstanding this? Thank you.
-
Re: Super Orders v3.0 Support Thread
Thank you for the reply. I understand this. I'm just trying to understand if Super Orders now has it's own tracking system implemented so I no longer need to have Ty Tracker installed.
-
Re: Super Orders v3.0 Support Thread
PM me before you do anything else..:wink:
Quote:
Originally Posted by
ScriptJunkie
The only thing I installed before this mod was Edit Orders. Once Super Orders was installed, the only change I've made was to upload the new super_data_sheet.php to.....
Uh oh....I just realized there are two of these files in different locations (in /admin and again in /admin/includes/languages/english) :oops: and now I can't remember which directory I uploaded to. But I'll bet it's the wrong one - that's exactly the kind of thing that causes this kind of error according to the threads I've been reading tonight.
Let me go back and restore the originals to both locations and then I'll re-upload the new file that you posted in this thread.
For clarity, can you tell me which of those directories it should be installed in?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
So on to the good stuff.. What's new, and what does Super Orders do..
Here's the answer to the most frequently asked question: "What does Super Orders do?"
(which BTW REALLY IS explained in detail in the readme for those who REALLY wanna know.. it doesn't hurt to download the fileset..)
PURPOSE & AIM
Super Orders is exactly what its name implies: Zen Cart's default order management on steroids.
It's more in all the areas Zen users are asking for more:
- More order control
- "Batch Form Printing" and "Batch Status Updating" including support for PDF invoices.
- "Batch Form Printing" and "Batch Status Updating" both offer expanded order search options.
- Editing of hidden "admin only" comments
- “Split Orders” allows you to split individual lines on an order. So for example:
Customer orders:
3 Super Widgets
4 Super Duper Widgets
You've only got 3 of the Super Duper Widgets in stock. With Split Orders, you can move the Super Duper Widgets to another order creating a new (child) order which is split from the parent (original)
So you will end up with 1 order (parent) with 3 Super Widgets and a child order with 4 Super Duper Widgets.
- More thorough data
- Order payment tracking -- allows shopowners to enter and track order payment details (check, money orders, etc.) Payments made via Authorize.net, Linkpoint and PayPal are entered for you automatically. Send customer payment notification/verifications
- Order refund tracking -- allows shopowners to enter and track order refund details. Send customer refund notification/verifications
- More detailed reports
- EASY integration* with Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker
- More navigation options
- More shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox
*Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker MUST be installed to use these built-in integration features
That said I STRONGLY suggest that anyone THINKING about this mod download it and READ the readme.. The readme goes into a LOT more detail about what Super Orders can do.. It should answer any questions about what this mod provides..
If you are upgrading you too should read the readme file BEFORE you upgrade.
Quote:
Originally Posted by
DivaVocals
Change Log - v3.0
- Clean up and reorganize the readme file (again!!!)
- MANY misc bug fixes and corrections
- Overall cleanup of the files to remove deprecated and unused code
- Countries now included as search option in "Batch Form Printing" and "Batch Status Updating"
- The "Edit Status History" feature has been restored and the functionality modified. Editing of order comments is now limited to hidden "admin only" comments. Additionally in previous versions of Super Orders the "Edit Status History" feature inserted HTML and ASCII line breaks into the database, and this ugly line break code was displayed when the customer viewed their order history from "Status History & Comments". This particular problem goes back to 2006, and has now been FULLY resolved/addressed.
- Customer comments modified to incorporate the latest Zen Cart 1.3.9 functionality/format
- Packing slip images are now a simple on/off admin configurable option.
- Batch print functionality has been expanded to include PDF invoices!! All options for the PDF invoices are admin configurable
- “Split Orders” has been improved to help shopowners more easily reconcile a split order.
“Split Orders” now creates a parent and child order. Paid split orders will display the grand total paid for both parent and child order.
For orders paid via PayPal, Authorize.net or Linkpoint, the admin payment panel will not display on the child order. - Order total and customer address edit features have been removed in their entirety. (use Edit Orders if you need order/customer address editing functionality)
- Added missing shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox.
- Restoration of missing default Zen Cart orders.php functionality. This now allows payment processor generated (PayPal, Authorize.net or Linkpoint) refunds to now be processed within Super Orders. (no longer requires the retention of the default orders.php to process PayPal, Authorize.net or Linkpoint refunds)
- AUTO PAYMENT FOR ORDERS PAID VIA PAYPAL!!!!!!! 'Nuff said...
- Improved graphics and buttons to SPRUCE UP the Super Orders UI (thought while were doing everything else, why not make it purty too! :smile:)
- If you have Edit Orders installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No code merging required.. Simply install Edit Orders and "turn on" Edit Orders in the Super Orders admin!!)
- If you have Ty Package Tracker v3.0 installed, you can enable the Ty Package Tracker fields for Super Orders (No code merging required..) Simply install Ty Package Tracker and "turn on" Super Orders from the Ty Package Tracker admin!!)
- If you have USPS Click-N-Ship installed, you can enable USPS Click-N-Ship in the Super Orders admin to enable USPS Click-N-Ship fields/buttons in Super Orders (No code merging required.. Simply install USPS Click-N-Ship and "turn on" USPS Click-N-Ship in the Super Orders admin!!)
- If you have FedEx Automated Labels installed, you can enable FedEx Automated Labels in the Super Orders admin to enable FedEx Automated Labels buttons in Super Orders (No code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
Let me stress something here so that it's CLEAR.. With regards to the mod integration options: You are NOT required to install ANY Edit Orders, Ty Package Tracker, FedEx Automated Labels or USPS Click-N Ship to use Super Orders.. You can use Super Orders even if you don’t use these other modules. That said turning on the admin flags for mods you DO NOT have installed WILL CAUSE ERRORS IN YOUR STORE!!
BUT...
If you are running any of these mods, you don't have to tear your hair out trying to get the correct Super Orders code merged into the Super Orders files to use these mods.. Install them as normal and TURN IT ON in the Super Orders admin (Ty Package Tracker will need to be turned on in the Ty Package Tracker admin)
In support of this new release there are updates to Edit Order and Ty Package Tracker that are now available in the downloads.. (See the Ty Package Tracker and Edit Orders respective support threads for details on those updates -- PLEASE do not post non Super Orders related questions here..)
Finally we are also supplying the properly merged files needed for those running FEC and COWOA. (no admin flags for these mods.. simply use the provided pre-merged files for these mods)
Quote:
Originally Posted by
ScriptJunkie
Hi Joy,
I don't use TY Tracker but my understanding is that Super Orders integrates with TY Tracker, meaning they work together. You need to have TY Tracker installed in order to use it from inside Super Orders.
There is some awesome and extremely thorough documentation on how they work together, what order to install in, how to install based on what version of TY Tracker you're using, etc.....
All this documentation is in the Read Me file that is packaged with Super Orders.
Hope that helps :)
Quote:
Originally Posted by
joyjoy
Thank you for the reply. I understand this. I'm just trying to understand if Super Orders now has it's own tracking system implemented so I no longer need to have Ty Tracker installed.
ScriptJunkie explains this perfectly..
So I've highlighted EVERYTHING I wrote in the leading posts of this thread so it's a little more obvious.. I thought it was pretty well explained here and in the readme.. If any of this is unclear, please let me know what part is not clear..
-
Re: Super Orders v3.0 Support Thread
So I owe both of you a big apology! For whatever reason, when I reviewed the changes I took "Customer Payment Tracking" as "Customer Order Tracking", I have been toggling between this mod an Ty Tracker so I just got confused.
Long story short, the answer is:
Super Orders 3.0 does NOT have a stand alone tracking system but if you use Ty Tracker, Super Orders 3.0 integrates this add on seamlessly without the need of merging files.
Got it! Thank you!:clap:
-
Re: Super Orders v3.0 Support Thread
You got it! No apologies necessary :)
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
joyjoy
So I owe both of you a big apology! For whatever reason, when I reviewed the changes I took "Customer Payment Tracking" as "Customer Order Tracking", I have been toggling between this mod an Ty Tracker so I just got confused.
Long story short, the answer is:
Super Orders 3.0 does NOT have a stand alone tracking system but if you use Ty Tracker, Super Orders 3.0 integrates this add on seamlessly without the need of merging files.
Got it! Thank you!:clap:
All of which is explained/stated on the FIRST page of this post (so that people would read it and KNOW what they were and were NOT getting from Super Orders). I also include much more detail on this same question in the readme documentation which comes with Super Orders..
I also said on page 1 of this support thread, that it does not HURT anything to download Super Orders and take some time to read through the documentation.. In fact as I also stated on page 1 of this support thread, I strongly recommend that BEFORE YOU INSTALL OR UPGRADE, you should download Super Orders and read through the readme documenatation before doing anything..
Hope you decide to upgrade.. Suggest waiting though as I will be posting an incremental update this week with some minor buglet fixes and some enhancements that were missed in the initial release..
-
Super Orders v3.0 - Minor update coming this week
Changelog: (off the top of my head as I am at work:laugh:)
- Add missing comments code from super_invoice.php and super_packingslip.php. (should better align the Super Orders versions of the invoice and packingslip.php to function more like their default cousins invoice.php and packingslip.php)
- Enable comments code on PDF packslip and included corrections to omit hidden comments and strip HTML code from the comments display. (should better align the PDF version packingslip to function more like the HTML versions)
- Correction to PDF packingslips display of product attributes (currently they are cut off or not displayed consistently/correctly)
- Correction to PDF packingslips to strip HTML code from shipping method display (it's likely that only those using the FedEx shipping mod will even notice this particular change:laugh:)
- Add Zen Cart comments style to super_batch_status.php
- Correction to fix super_data_sheet.php
- Minor updates to language files to support other changes
- Correction to e-mail link on order list so that clicking "Cancel" returns you to the order list.
I think that's it.. As I said this is off the top of my head..
-
Re: Super Orders v3.0 Support Thread
Evening Diva, All,
Has any one experienced a 1061 error in connection with this contribution?
Quote
" 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 's"
In essence the problem occurs if I try to use an apostrophe or quotation mark in the comments box EG
Quote:
"Forum Do's and Dont's"
will be rejected, but
Quote:
Forum Dos and Donts
will be accepted
There seem to be myriad occurrences of this error in the postings and many seem to indicate incompatible versions of o/s etc
I am running the most up to date version and the only change I have carried out has been the upgrade to ver3 super orders from 139. There has not been a problem using the previous setup
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2010-12-26 23:01:36] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-06-01 15:31:20] (Fresh Installation)
PHP Version 5.2.14
I can also reproduce this issue on the test system which is running under xammp
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
HTTP Server: Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
PHP Version: 5.2.9 (Zend: 2.2.0) PHP Memory Limit: 32M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Any guidance pointers thoughts gratefully recieved
A puzzled Centec2b!
-
Re: Super Orders v3.0 Support Thread
Already reported here:
http://www.zen-cart.com/forum/showth...=170525&page=3
Workaround for now is to not use quotes or single quotes in comments.. It will be included in the update I'm submitting this week..
Quote:
Originally Posted by
Centec2b
Evening Diva, All,
Has any one experienced a 1061 error in connection with this contribution?
Quote
" 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 's"
In essence the problem occurs if I try to use an apostrophe or quotation mark in the comments box EGwill be rejected, but will be accepted
There seem to be myriad occurrences of this error in the postings and many seem to indicate incompatible versions of o/s etc
I am running the most up to date version and the only change I have carried out has been the upgrade to ver3 super orders from 139. There has not been a problem using the previous setup
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2010-12-26 23:01:36] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-06-01 15:31:20] (Fresh Installation)
PHP Version 5.2.14
I can also reproduce this issue on the test system which is running under xammp
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
HTTP Server: Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
PHP Version: 5.2.9 (Zend: 2.2.0) PHP Memory Limit: 32M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Any guidance pointers thoughts gratefully recieved
A puzzled Centec2b!
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
ahhhhhh!
apologies did not see that
centec2b
-
Re: Super Orders v3.0 Support Thread
Hi Diva! I've updated my Super Orders mod and it looks great!! Thank you for all of your hard work!
I have a quick question though. Each time I login to my admin if I make an update to the payment area I'm required to login in again. What happens is this:
I'll select the payment buttom, the pop up screen will appear with the normal information. When I submit I get the login screen (on the popup) I then close the popup, refresh my admin page and I'm logged out. Once I log back in I am able to complete the payment information.
Is this normal? If not, do you know how I would fix it? Thank you!
-
Re: Super Orders v3.0 Support Thread
Not normal at all.. might be a permissions issue.. Could be a sessions issue... I would double check that all the Super Orders file permissions are correct, and re-check your sessions settings..
I'll double check on my test store, but this has never happened in testing..
Quote:
Originally Posted by
joyjoy
Hi Diva! I've updated my Super Orders mod and it looks great!! Thank you for all of your hard work!
I have a quick question though. Each time I login to my admin if I make an update to the payment area I'm required to login in again. What happens is this:
I'll select the payment buttom, the pop up screen will appear with the normal information. When I submit I get the login screen (on the popup) I then close the popup, refresh my admin page and I'm logged out. Once I log back in I am able to complete the payment information.
Is this normal? If not, do you know how I would fix it? Thank you!
-
Re: Super Orders v3.0 Support Thread
This was going on before the upgrade too. It's not a big deal but it's frustrating when I'm in a rush. I'll check the permissions, I bet that's what it is.
Thank you!
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
joyjoy
This was going on before the upgrade too. It's not a big deal but it's frustrating when I'm in a rush. I'll check the permissions, I bet that's what it is.
Thank you!
Then the issue is NOT a Super Orders issue.. Rather Super Orders is ILLUMINATING an existing issue..
Try this thread instead.. https://www.zen-cart.com/tutorials/i...hp?article=281
This might be the REAL issue you are experiencing.. If you need more assistance on it.. you know the drill.. Start a new thread..:laugh: BUT search before you do this.. I think there is a fair amount already posted on the forum on this matter..
Good luck.. Glad you like the NEW Super Orders.. You'll wanna upgrade when I submit v3.0.1 this week.. I tweaked quite a bit of stuff and fixed some buglets (see my post from yesterday) and Tony is gonna make some cool minor mods to the PDF packingslip so it will REALLY rock!!!
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Centec2b
ahhhhhh!
apologies did not see that
centec2b
No worries.. It was easy to miss this post.. :smile:
-
Re: Super Orders v3.0 Support Thread
Oh I'm not sure if I was clear on this. I was having to do this re-login thing before I upgraded to Super Orders 3.0. I don't experience this anywhere else in admin.
Do you think this is a zen cart issue then?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
joyjoy
Oh I'm not sure if I was clear on this. I was having to do this re-login thing before I upgraded to Super Orders 3.0. I don't experience this anywhere else in admin.
Do you think this is a zen cart issue then?
You were clear.. and I understood what you said.. Please see my previous responses as I did provide you some possible causes and a thread which might be the clue as to your REAL issue..
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
joyjoy
Oh I'm not sure if I was clear on this. I was having to do this re-login thing before I upgraded to Super Orders 3.0. I don't experience this anywhere else in admin.
Do you think this is a zen cart issue then?
If you are running 1.3.9h you may want to check to see if the
Debug Error Logging Utility is installed if not you can grab it here http://www.zen-cart.com/index.php?ma...roducts_id=860 this maybe a good way to start to see if any errors are popping up and give a good head start.
-
Re: Super Orders v3.0 Support Thread
Hi,
I have just installed super orders 3.0 to my zencart 1.3.9h
However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35
I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
musicfreer
Hi,
I have just installed super orders 3.0 to my zencart 1.3.9h
However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35
I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!
Try reuploading the entire directory from the 1_Install_Files folder, see if this changes anything make sure you rename the directory YOUR_ADMIN
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
knuckle-101
Try reuploading the entire directory from the 1_Install_Files folder, see if this changes anything make sure you rename the directory YOUR_ADMIN
Hi,
I have tried reuploading the whole folders again and again. And I also make sure that the admin directory has been changed.
By the way, I cannot find any folder names needed to change to my own template. Did I miss anything here?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
musicfreer
Hi,
I have just installed super orders 3.0 to my zencart 1.3.9h
However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35
I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!
On another note do you have Super Orders 2.0 installed before 3.0?
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
musicfreer
Hi,
I have tried reuploading the whole folders again and again. And I also make sure that the admin directory has been changed.
By the way, I cannot find any folder names needed to change to my own template. Did I miss anything here?
Go to your admin --> tools --> Template Select what is the name of the template you are using.
Nevertheless there is no over ride needed for the Install and Required Core Files.
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
knuckle-101
On another note do you have Super Orders 2.0 installed before 3.0?
I installed 2.0 in my old cart 1.3.8a
I am now building a new site 1.3.9h at another directory, but using the same database backup of the old website. I also believe this should be the problem, any idea how to fix it? thanks
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
knuckle-101
Go to your admin --> tools --> Template Select what is the name of the template you are using.
Nevertheless there is no over ride needed for the Install and Required Core Files.
I am using a template called cherry_zen, but the point is as you said, I cant find any overrides needed. I think the problem is on the previous installation of 2.0
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
musicfreer
I am using a template called cherry_zen, but the point is as you said, I cant find any overrides needed. I think the problem is on the previous installation of 2.0
Run this sql query file inside the Super Orders 3.0 folder uninstall_super_orders_prior_versions.sql using the admin install sql tool
admin --> tools --> Install SQL Patches use the browse and search button as it is more accurate then pasting
Once complete rerun the super_orders_install_v30.sql
-
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
knuckle-101
Run this sql query file inside the Super Orders 3.0 folder uninstall_super_orders_prior_versions.sql using the admin install sql tool
admin --> tools --> Install SQL Patches use the browse and search button as it is more accurate then pasting
Once complete rerun the super_orders_install_v30.sql
I followed your steps, when I upload that file to the hosting, admin becomes blank again, any other possible reason?