OLD Super Orders 2.0 (See v3.0 thread instead)

[PeterBKK]

I have the same issue and posted it yesterday.
Haven't got an answer back yet. wonder if something is missing from the newest upload?

I ran the SQL file from the zen tools browsing to the file I unziped if it matters.

Check if you have the "Store Fax" and "Store Phone" already at line 3 and 4 in admin/configuration/my store. As i already had that (from SO1,3) the sql stopped to execute the comands after that of some unknown reason.

if yes, just paste every comand one by one from:

INSERT INTO zen_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ');

It helped me...
Peterbkk

[inksale]

Yes it has fax and phone.
As soon as my eyes open and coffee is in my cup Ill give your directions a shot. I will report back.

Thanks for translating your post into language I understand :)

[PeterBKK]

Does anyone know how to see the order weight?? I can't see it anyware.

Also, is there a way to print packaging list with pictures?

Peter

[PeterBKK]

Yes it has fax and phone.
As soon as my eyes open and coffee is in my cup Ill give your directions a shot. I will report back.

Thanks for translating your post into language I understand :)

hehe, It takes a dummy to explane for another dummy

Past and RUN every comand one by one. Be sure that every comand ends with a ;

PeterBKK

[inksale]

Everything seems to be there and working.
AFTER I BACKED UP!
I tried to run the entire SQL (from ZenCart Tools) from a brand new download this morning and it did not fix it.

I cut and past the following info directly from the same document into the Zen SQL Tool and it did the trick.
There must be something in the code preventing it from doing its thing.

Thank you !!!!!

INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', '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', 'Destination ImagiNation, Inc.', '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(');

-- Super Orders configuration group
INSERT INTO configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);

-- Super Orders configs (Admin > Configuration > Super Orders)
-- Automatic Status Updating
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.', 28, 11, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO configuration VALUES (NULL, 'Auto Status - Payment', 'AUTO_STATUS_PAYMENT', '2', 'Number of the order status assigned when a payment (<B>not</B> attached to a purchase order) is added to the payment data.', 28, 10, 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 <B>attached to a purchase order</B> is added to the payment data.', 28, 10, 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.', 28, 13, 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>.', 28, 14, 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>.', 28, 14, 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>.', 28, 15, 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>.', 28, 17, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '00-000000', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.', 28, 50, 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 <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, 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 <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, 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 <B>default</B> and this option will be ignored.<p><strong>You cannot attach comments or notify the customer using this option.</strong>', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');

[BlindSide]

If folks can wait, I'll take this on and supply BS with the fixed code so he can roll it in. I'm going to be in the exact same situation as you, as I use many currencies, and I'm also able to find, fix, and test the code. But patience is needed because I haven't gotten that far and I'm not going to change the order or my development at this stage. I'm doing my site from scratch in V1.3 and I'm still only working on the visual templates. Otherwise, if BS or someone else wants to do it - I'm fairly certain on what I said above.

Steve, I would love it if you could help me with the currency logic. Like I said, I only use USD, so testing well for others can be tough (I'm building for a US company, so I can't spend their time on much non-related stuff). Let me know what you need (if anything), and what needs to be corrected. Though it took some wringing, thanks for bringing this one to light, Peter.

[BlindSide]

DrByte has sent me the specifics on what caused your issue, InkSale. I will be applying the fixes and issuing a new release. Not sure how I'm going to ahndle the configuration_group_id yet. I may change it and build a new upgrade script for all users regardless of version.

I also pinpointed some more of your frustration, Peter, that I can alleviate with a few changes. If it's working, go with it, but I'll try to save others similar confusion.

[inksale]

Thank you Sir!
I do appreciate all the time you have put into this project and all the time you spend supporting it. It has great functionality and has been well thought out.

[tajul_ashyqin]

Steve, I would love it if you could help me with the currency logic. Like I said, I only use USD, so testing well for others can be tough (I'm building for a US company, so I can't spend their time on much non-related stuff). Let me know what you need (if anything), and what needs to be corrected. Though it took some wringing, thanks for bringing this one to light, Peter.

Welcome back Blindside... for the currency issue, i think i managed to fix this but to the old mod, not these SO v2.0! can you point me which section effect this so that i can check back my files and post it to these forum...

[kelvyn]

Does anyone know if this plays nicely with the 1.3.5d release announced this morning ?