Zen Follower
- Join Date:
- Aug 2007
- Location:
- Eugene, OR
- Posts:
- 166
- Plugin Contributions:
- 0
OLD Super Orders 2.0 (See v3.0 thread instead)
Never mind! I just tested that method and it does not work. I am stumped on this one. Sorry!
Views: 456,069
Zen Follower
Never mind! I just tested that method and it does not work. I am stumped on this one. Sorry!
New Zenner
Hi, maybe you guys think this is a very stupid question, but I don't really know how Purchase Order works. I've installed Super Order2 mod and notice that Purchase Order needs also to be activated to get it works. Can someone give me a lightly guide about how Purchase Order works? My first thought was P.O. is like an invoice mod, but I can't make it right.
My apology if this question has been asked before, or not belongs to this thread, but i can't find any answer anywhere.. I've spent many hours to read through this (not finished yet, it is so long:blush:) and others thread without any luck.
Plz help me:cry: I do really want to use Super Order2.
New Zenner
I have a question about the flow of order processing & if what I want is possible.
Is this possible? I was thinking I could use the purchase order module as a way to modify the shipping information & notify the customer, but how can I modify the order to invoice them to pay with paypal?
Thanks so much for your help with this.
Totally Zenned
i just updated from an earlier version of zencart and also updated from superorders 1.3 to 2.0
looks like the edit order functionality disappeared
does anyone know if anyone is working on that functionality?
Zen Follower
sgflowers:
i just updated from an earlier version of zencart and also updated from superorders 1.3 to 2.0
looks like the edit order functionality disappeared
does anyone know if anyone is working on that functionality?
I installed superorders 2.0 fresh, and it does have the edit order functionality. So it sounds like you may have missed something in the upgrade process.
Specifically, which function are you missing?
Totally Zenned
thomasw98:
I installed superorders 2.0 fresh, and it does have the edit order functionality. So it sounds like you may have missed something in the upgrade process.
Specifically, which function are you missing?
when i click on edit products in the order details - it doesn't give me the capability to edit any of the products in the order - ie prices, product , quantities etc
Zen Follower
sgflowers:
when i click on edit products in the order details - it doesn't give me the capability to edit any of the products in the order - ie prices, product , quantities etc
On mine, I can "edit contact data", "edit products", and "edit order totals". Order totals and contact data work great, BUT the "edit products" link only brings up a popup screen which does not seem to do anything. So I guess that is what you are saying.
Now that I think about it, I remember the creator of this mod said something about this recently in this thread. Maybe you can look back a few pages and find his comment. I believe he said that allowing editing of product details is very complex, so he does not have this functionality in place now, etc. etc. I forget the rest, but you can probably find it.
New Zenner
Edit Products only allows you to split some products to another order. i.e. break the order into multiple orders if say something is not available and you want to bill & ship the available products only.
Totally Zenned
Hi,
I installed Super Order module recently. When I ran the SQL file, I received the following error.
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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.
I did what was suggested in this thread by checking duplicate lines in phpmyadmin. I then ran the lines that don't exist yet in the database. Everything seems to be in the database now except the following one.
-- Super Orders configuration group
INSERT INTO configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);
When I ran this line, I received the following error. I checked the database but this line does not exist. Any suggestion? Thanks in advance.
1062 Duplicate entry '28' for key 1
in:
[INSERT INTO zen_configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Totally Zenned
For your information, I just found out that I could not find Admin > Configuration > Super Orders in my admin. What did I do wrong?
Totally Zenned
Okay, I found out the reason why I am getting the 1062 duplicate entry '28' for key 1 is because the following SQL line
-- Super Orders configuration group
INSERT INTO configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);
has been inserted into the previously taken id field 28, namely the SEO URL. Should I remove these? Should I change the id field for Super Orders to something new instead of 28?
Any suggestion will be greatly appreciated. Thanks a lot.
New Zenner
Just change the number 28 in the sql line to the next available number in the configuration group
Totally Zenned
Hi,
Thanks for your response. Do I change the id for Super Order or SEO URL? Would this cause any damage? What about those Super Order stuff that has been inserted into the SEO URL configuration group? How do I remove them?
New Zenner
If your happy with messing about with your database I would change the id for SEO as this is normally put in the next available slot but with Super orders it is 28 and any changes to Super Orders will be made with this number (otherwise just change the number 28 in the sql for Super Orders from -- Super Orders configuration group onwards (13 lines)
you would have to have a look in configuration (16 entries) and configuration group (1 entry) to change the SEO configuration_group_id
Totally Zenned
Hi,
Thanks for your help.
If worse come to worst, I am thinking to restore my database. Do you know how exactly I can do it? I am concerned that something bad might happen. Please advise. Thanks again.
Totally Zenned
change the number 28 in the sql for Super Orders from -- Super Orders configuration group onwards (13 lines)
If I change the Super Order id to something else, would those Super Order configuration previously inserted into the the SEO URL configuration be automatically removed? Thanks.
Totally Zenned
YAY! I solved the problem. Thanks to topcat24. Based on his suggestion, I first re-ran the following sql line after changing the configuration group id '28' to something else, for example '50'.
INSERT INTO configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);
Then I changed the Super Order configuration id in the configuration table of the database (all 12 entries) to '50' using phpmyadmin.
I hope this is helpful for those who are struggling with the same problem. Good luck everyone. Thanks again.
New Zenner
swan:
I have an interesting problem I hope you all can help with. I'm totally sold on Super Orders. However, I'm using both the USPS and UPS shipping modules. When people select overnight shipping, for example, super orders just says "UPS" in the order. If I switch over to the standard order system, the full line "UPS: overnight" (or whatever they selected) is there. So, the information is being captured by the system, but SO is not showing it. So, we have to log into the regular ordering system to see what shipping method they chose.
Anyone have any ideas?
Had the same problem. This worked for me.
For Print Data Sheet (admin/super_data_sheet.php) around line 183:
<?php // Short shipping display // Formats shipping entry to remove the TEXT_WAY define for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { // if ($order->totals[$i]['class'] == 'ot_shipping') { // $format_shipping = explode(" (", $order->totals[$i]['title'], 2); // $clean_shipping = rtrim($format_shipping[0], ":"); // $display_title = $clean_shipping . ':'; // } // else { // $display_title = $order->totals[$i]['title']; // } $display_title = $order->totals[$i]['title']; For Invoice (admin/super_invoice.php) around line 262: <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { // if ($order->totals[$i]['class'] == 'ot_shipping') { // $format_shipping = explode(" (", $order->totals[$i]['title'], 2); // $clean_shipping = rtrim($format_shipping[0], ":"); // $display_title = $clean_shipping . ':'; // } // else { // $display_title = $order->totals[$i]['title']; // } $display_title = $order->totals[$i]['title']; For Packing Slip (admin/super_packingslip.php) around line 145: <?php // Trim shipping details for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { if ($order->totals[$i]['class'] == 'ot_shipping') { // $format_shipping = explode(" (", $order->totals[$i]['title'], 2); // $shipping_method = rtrim($format_shipping[0], ":"); $shipping_method = $order->totals[$i]['title']; break; } } ?>Hope this helps.
Totally Zenned
Hi,
I found out that when customers choose to pay by credit card, their order seems to be marked as paid automatically because the balance due in Customers > Super Orders is displayed as zero and the amount applied is the same as the total. This isn't good because not all credit card transactions go through successfully. What should I do to fix this? Please advise. Thank you.
Totally Zenned
Also, I found out that if customers choose to pay using PayPal, the balance due is not zero. Because PayPal payment goes through instantly, it will be great if we can display it as zero with amount applied same as the total. Please advise. Thank you.
Tell staff why this post should be reviewed.