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

[BlindSide]

I posted a while back with the new features I've got in the pot right now. Here's the feature list I provided in that post:

• More bug fixes, based largely on your feedback (thanks!)
• New installer for all users, new or returning. Will handle all DB changes automatically.
• Some fancy-shmancy AJAX effects, particularly in the new features below
• New order search interface for order listings, similar to the one on the batch pages.
• New product edit module. Edit product quantity and any associated attribute values (mimics attribute display on storefront, only fills in existing values).
• New product return/exchange module. Return a product and exchange for one or more new products. Also processes refunds on tax and shipping, and adds new fees for tax, shipping. Includes option for exchange service charge.

[BlindSide]

I should also note that the biggest hang-up to release will be updating the installer. The package has simply gotten too complicated for a simple SQL file and some readme steps (as many of the posts here can attest), so I'm gonna have to do something more along the lines of the Zen Cart installer.

[kelvyn]

I posted a while back with the new features I've got in the pot right now. Here's the feature list I provided in that post:

• More bug fixes, based largely on your feedback (thanks!)
• New installer for all users, new or returning. Will handle all DB changes automatically.
• Some fancy-shmancy AJAX effects, particularly in the new features below
• New order search interface for order listings, similar to the one on the batch pages.
• New product edit module. Edit product quantity and any associated attribute values (mimics attribute display on storefront, only fills in existing values).
• New product return/exchange module. Return a product and exchange for one or more new products. Also processes refunds on tax and shipping, and adds new fees for tax, shipping. Includes option for exchange service charge.

Sounds great - can't wait! (In fact, I AM waiting before I upgrade to 1.3.7 and catch up with my signature!)

[spectreman]

I tried your changes....but i'm getting error messages, and batch update won't open. i had to revert to the orig super_batch_status.php. is it working for you?

[audradh]

I am working with a fresh install of 1.3.7, loaded by my host with some of the key Zen community contributions.

I am having a problem that I believe is related to SO based upon this thread by WickedKlown:

http://www.zen-cart.com/forum/showth...ht=balance_due

I installed Paypal Express. I'm not clear as to whether it is incompatible w/ SO or whether there is just some lost functionality, but that is not really relevant here.

I received the exact error that WickedKlown describes in the above thread. I could see the order in admin, but if I tried to open the order or click on customers->super orders:

1054 Unknown column 'balance_due' in 'field list'
in:
[update orders set balance_due = '0.08' where orders_id = 289]
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 removed Paypal Express and installed Paypal IPN. I created another order through the catalog end. This time, from the customer perspective, everything seemed perfect.

In the admin, the new order never appeared, but clicking on customers->super orders now functions correctly. Clicking on that first (Paypal Express) order now opens the order but with the error

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = 289 AND parent_txn_id = '' ]
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.

Based upon WickedKlown's thread I'm guessing that it is something not quite current with the SO install. Given that I didn't do the install I'm not real sure where to start. It looks like the defines and file edits are in place.

If I try to re-run the sql I receive an error because it is trying to add a field that already exists. I'm not clear from the errors what tables the noted fields should be in, so that I can at least look at those tables in phpMyAdmin.

Finally, I'm guessing that this is a simple upgrade fix, if I only knew what it was, lol. I have yet to try a cc order, so I am off to do that now.

Any ideas appreciated
Are you out there Wicked?

Thx!
Audra

[Merlinpa1969]

Audra when you brought your old database parts you brought the orders table with correct?

Ok you need to run this in your sql updater in ZC admin

ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;

when you added the old tables and ran the upgrade script did you add the zen_ prefix?

If so then you will need to download the SO module and run the sql file in the zc admin sql updater, this will then add the prefix to the mix

[grimbergen]

Hello,
I'm trying to install super orders for the first time and in the SQL Patch update I get this error:

**********************************
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 'True', 'False'), ')' at line 1
in:
[INSERT INTO zcart_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'), ');]
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 went back to the admin to try out Customers-> Super Orders but I get:

**********************************
Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.
**********************************

I'm assuming it didn't install properly due to the SQL error. Can you provide some advice on how to proceed?

I have zen cart Zen Cart 1.3.6, PHP Version 4.4.4, MySQL 4.1.21.

Thanks!
Arthur

[Ryk]

I'm no expert on this stuff, but removing the comma after ('True', 'False') in

'zen_cfg_select_option(array('True', 'False'), ');]

so that it reads

'zen_cfg_select_option(array('True', 'False') ');]

did the trick for me.

[Merlinpa1969]

If you are running super orders and admin levels you will need to assign the super orders to the admin levels

[audradh]

Audra when you brought your old database parts you brought the orders table with correct?

Ok you need to run this in your sql updater in ZC admin

ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;

when you added the old tables and ran the upgrade script did you add the zen_ prefix?

If so then you will need to download the SO module and run the sql file in the zc admin sql updater, this will then add the prefix to the mix

Yes, I did bring in the orders table.
I ran the suggested sql. I think maybe that portion was done when I tried to run the SO sql last night because I am getting already exists errors. That would explain the errors that went away.

What I am left with is an error only when opening a Paypal order.
An example:

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = '283' order by paypal_ipn_id DESC LIMIT 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.

I see that it is looking for zen_order_id in the paypal table. My paypal table has just order_id. So, I see the problem, but don't know how to fix it. I'm off to peruse the SO mod, and see if I can't figure it out where it asks for zen_order_id.

(In answer to your question Merlin, no I did not add the zen prefix back into my database.)

Thanks!
Audra