Edit Orders v4.0 Support Thread

Hi

Apologies for duplicating this, in a support thread of it's earlier version, but I still need to ask:

I am using ZC 1.5.1 and would like to install Super orders. The problem I have, is updating the invoice.php and orders.php and packingslip.php pages: because we have the Stock By Attributes plugin installed, we also need to include this in the code. However this is tricky as one of these pages has been completely re-written (I think it's the invoice page).

Please could anyone offer any advice on where I would need to add the 3 SBA blocks of code to the Super orders modified files. Please any help would be gratefully received.

Best regards

dharrison:

Hi

Apologies for duplicating this, in a support thread of it's earlier version, but I still need to ask:

I am using ZC 1.5.1 and would like to install Super orders. The problem I have, is updating the invoice.php and orders.php and packingslip.php pages: because we have the Stock By Attributes plugin installed, we also need to include this in the code. However this is tricky as one of these pages has been completely re-written (I think it's the invoice page).

Please could anyone offer any advice on where I would need to add the 3 SBA blocks of code to the Super orders modified files. Please any help would be gratefully received.

Best regards

While I don't have an answer for you nor am I sure if this area is the correct place to post this question, it is also not stated which SBA module is being attempted to merge. Hopefully though an answer will be found and the question addressed in the correct area.

Hi mc

The latest version of SBA. version 1.5.3 that runs on 1.5.1.

It's only 3 blocks of code but only being able to follow patterns and syntax, this is impossible to do where the invoice.php page has been completely re-written. Shall I include the PHP for both pages?

lhungil:

Just a reminder to turn off the Edit Orders "action debug log" for performance reasons.

This is a known bug in Edit Orders 4.1.4 when product downloads are disabled. The fix will be included in the next release of Edit Orders.

Thank you lhungil, it was indeed that bug and all is now well and fixed. Thank you for your help.

dharrison:

Hi

Apologies for duplicating this, in a support thread of it's earlier version, but I still need to ask:

I am using ZC 1.5.1 and would like to install Super orders. The problem I have, is updating the invoice.php and orders.php and packingslip.php pages: because we have the Stock By Attributes plugin installed, we also need to include this in the code. However this is tricky as one of these pages has been completely re-written (I think it's the invoice page).

Please could anyone offer any advice on where I would need to add the 3 SBA blocks of code to the Super orders modified files. Please any help would be gratefully received.

Best regards

Why is this posted in the Edit Orders support thread?????

dp-web:

Thank you lhungil, it was indeed that bug and all is now well and fixed. Thank you for your help.
You are welcome. Glad you were able to make the changes and get back to business!

DivaVocals:

Why is this posted in the Edit Orders support thread?????

I am sorry I thought I was on the correct thread. Instead of shrieking at every post I write, would you be so kind as to point me in the right direction?

dharrison:

I am sorry I thought I was on the correct thread. Instead of shrieking at every post I write, would you be so kind as to point me in the right direction?

"shrieking" eh?? Ummmm okay... For the record.. in the OTHER post you wrote on this I most certainly DID point you in the right direction as to WHERE to post.. but.. okay.. carry on..

Ok well I have found the right forum at long last. Thank you regardless :)

hello, this is kinda feature suggestion, to have the ability to add a coupon to an existing order without manually entering it

ShopVille:

hello, this is kinda feature suggestion, to have the ability to add a coupon to an existing order without manually entering it

and exactly HOW would one add a coupon to the order in an order editing module without manually entering it????

If you are going to suggest a feature.. it would help if you could explain how it should work.. IJS..:smile:

Hoping someone can help me out here. It has everything to do with this module and a little with another I am working on. Basically I am trying to generate a sales report that is accurate in it pulls the sales data from the orders_total table. Currently the sales report plug in pulls from the orders table and then recalculates the price on every order. This is causing me huge inaccuracies. So I have redone this report to pull from the table I need. It is accurate to the penny every time it is run. However, the inaccuracy comes when an order is edited. I am thinking this is because it updates the orders table and not the orders_total table. Is there an easy way to get the edit order module to update the orders_total table as well? Specifically I am looking to update the fields that appear starting with subtotal and go down to total. ie sub-total, shipping, sales tax, discounts, and total. Can anyone please help me out with this?

Thank you in advance!

DivaVocals:

and exactly HOW would one add a coupon to the order in an order editing module without manually entering it????

If you are going to suggest a feature.. it would help if you could explain how it should work.. IJS..:smile:

I am thinking they want a drop down box to select from that would be populated from the coupons table.

southshorepizza:

I am thinking they want a drop down box to select from that would be populated from the coupons table.
Perhaps but a feature suggestion with no details leaves it for the VOLUNTEER developer to figure out what the suggestion means.. this presumes he/she has free time for GUESSING what someone meant.. IJS..

I would agree! As you can see in my question I tried to be very specific in what I wanted. Hopefully someone can help me out! :)

southshorepizza:

I would agree! As you can see in my question I tried to be very specific in what I wanted. Hopefully someone can help me out! :)
You are always very specific.. lol Wish I could help with your current question.. but I'm gonna leave it to the TRUE expert!:laugh:

Sometimes I think maybe I am too specific because I don't always get the help I need. Other times people bend over backwards to help out. The times they don't it seems I have asked for a too specific of a need.

I have figured out my question after a few hours of studying this. I was given bad information by a programer that charges. Imagine that!

southshorepizza:

... the inaccuracy comes when an order is edited. ...
Can you elaborate on what exactly is inaccurate (with Edit Orders)? Do you have any 3rd party order total modules installed? Was the order created at a time when ot_subtotal or ot_total were disabled (and then later edited)? Was the order previously edited by a version Edit Orders 4.0 (or older)?

southshorepizza:

... I am thinking this is because it updates the orders table and not the orders_total table. Is there an easy way to get the edit order module to update the orders_total table as well? ...
Edit Orders 4.1 (and newer), does update both... It actually REQUIRES the order total modules ot_subtotal and ot_total to be installed and enabled (at this time) as it utilizes the values of these two modules. Further it loads and processes any enabled order total modules against the order (when editing) to ensure they are updated (and doing the math automatically).

Edit Orders 4.0 and earlier did their own calculations (and direct mysql calls to access the tables). They did not load or utilize the order total modules (although they did write to the database table). Using these older versions may require the store owner to do their own calculations and math... And then enter the correct information in the various fields.

southshorepizza:

I am thinking they want a drop down box to select from that would be populated from the coupons table.
My best guess too...

Would the cost (money and risk) really be worth the benefit? Especially considering how easy it is to navigate coupons already using the built in Zen Cart coupon admin page?

Store owners can use "admin" --> "gift certificate / coupons" --> "coupon admin" to look through the available coupons for their store. This existing tool lets them page through coupons very quickly to find the coupon they want to apply to an order. This tool also shows all the settings on each coupon and what the coupon does when applied to an order.

If the customer did not enter the coupon (or provide the coupon information if they called in) why would a store owner erode margin further (by spending the time to see if a valid coupon exists and then applying a discount coupon to the order)? Why even bother with a coupon if this case? Just lower the cost of the products if you plan to give every customer the discount... Or use the "group discount" modules... Or shell out the $$ for some of the order total discount modules written for Zen Cart...

<rant>
A dropdown with coupons could be problematic, especially on mature stores with a large number of coupons and gift certificates / vouchers (both are stored in the same database table). Would you really want potentially hundreds of items in a dropdown?

Next I'll hear "just filter them to ones which are applicable to the order"... So now you want to add additional processing time for each and every coupon? Not to mention issuing a considerable number of SQL queries? All needing to be performed EACH AND EVERY time the order is loaded (or edited) in Edit Orders?

Okay, and now that we have filtered the coupons... How do you know which coupon does what? Sure you have the coupon name in the dropdown, but it is only a name (and is not required to be unique). Coupons in Zen Cart can be applied in many different ways and contain many different settings...

So even with this "dropdown", in order to know what a coupon does (without applying it to the entire order and starting over back at the first paragraph), a store owner would need to go to the Zen Cart coupon admin page to see what the coupon does. So in this case, no time has been saved (quite the opposite actually)...

Add on top of this all the coding required to support such functionality (everything above, AJAX code for selection, PHP handlers for fallback when JavaScript fails or is disabled, etc). And now what happens if ot_coupon is changed in a future version (in order to filter the coupons we needed to directly use a method from this order total module)?

Who is going to PAY for the cost required to implement and maintain a coupon dropdown? Especially given the limited
</rant>

The only application I could envision something like this occurring is if say a discount is offered on a specific day for example, and the system went down for a period of time, but orders were still being manually processed to be updated later. Regardless, would think that such a coupon could be incorporated into a sale type situation instead or some other method, and that the quantity of such orders hopefully would be limited to a small number. And in that case would agree that the cost would seem high in comparison to the manual entries needed to catch up. (I use the term manual loosely though as there could be ways to populate en mass.)