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

well it's amazing all the time you and others put in to help all of us out!

do you happen to know if there is a way where i don't have to go back and enter in all 700 some of the payment information?

they all say balance due $xxx even though payment has already been made through credit card or paypal through the system.

There would probably be a SQL update and I will look out for something over the next few days, best just to start using it and ignore everything below the line where payment isn't due.

Philip.

ok! i will use it as is and sit tight to see what comes up.

thanks!

You could try something like this - but backup first and verify afterwards! I recommend the backup module in the add-ons section - makes it really easy to backup - messup - restore - try again :wink:

insert into zen_so_payments(orders_id, payment_amount) 
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

carlvt88:

You could try something like this - but backup first and verify afterwards! I recommend the backup module in the add-ons section - makes it really easy to backup - messup - restore - try again :wink:

insert into zen_so_payments(orders_id, payment_amount)
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

That was a good starting point for the code but it throws a couple of errors

INSERT INTO so_payments ( orders_id, payment_amount ) select orders_id, value from orders_total zot where zot.sort_order=999

***(I STILL MULLING THIS OVER THOUGH)***

works in **Install SQL patches** because the previous code assumes that the tables are in default locations (whereas the patch program can alterthe table names to take into account different prefixes), the above code certainly populates the so_payments table but I am just trying to delve into super orders to check the exact criterea for the search that displays outstanding balances.

Philip.

philip_clarke:

That was a good starting point for the code but it throws a couple of errors

INSERT INTO so_payments ( orders_id, payment_amount ) select orders_id, value from orders_total zot where zot.sort_order=999

> 
> ***(I STILL MULLING THIS OVER THOUGH)***
> 
> works in **Install SQL patches** because the previous code assumes that the tables are in default locations (whereas the patch program can alterthe table names to take into account different prefixes), the above code certainly populates the so_payments table but I am just trying to delve into super orders to check the exact criterea for the search that displays outstanding balances.
> 
> Philip.
I think carlvt88 is certainly along the correct lines, although I am not sure why the sort order is 999, but looking through some test data it does appear correct. I'd say that as a minimum the code should be

insert into so_payments (orders_id, payment_amount)
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

Which puts a space inbetween so_payments and the first bracket but leaves zen_orders_total as the default name, because I don't think the Install SQL patches box can add the correct table prefix to the second table in a sub-select query. Oh and one would need MySQL 4+ as the database backend in case anyone has joined this conversation late.

For the newbie the above code adds all the payments from the table **orders_total** (default name is zen_orders_total),  to the super orders payments table **so_payments** which may on your system have zen_ stuck in front of the table name. If there are any DB_prefix errors that turn up using the above code, try adding or removing zen_ in front of the table name. if you get this error

 ERROR: Cannot execute because table zen_so_payments(orders_id, does not exist.

it's because there is not a space in between the word payments and the first bracket in carlvt88's otherwise excellent code.

Philip.

how do i add a link to the product info page?

Hi,
so Super Orders is now unsupported/a community project!

I only installed it last week and so the doubt enters as to whether this will become a blind alley, which would be a shame.

It seems a monster piece of code and I certainly am not a good enough coder (and never will have the time to be) to bring it up to the minute as it seems is necessary as a result of the latest admin patch and legacy code.

From the people who have delved into this code, and anyone else wth experience, do you think this is worth the investment in time and effort to continue using and fixing it/bringing it up to date? Is it just a matter of searching and changing certain function calls, I have no idea?

Or are there other, supported contributions that can accomplish the same funcionality and are better written/have no legacy code?
(No offence to Mr. Blindside, this module is a stunning achievement.)

There is also the rumour of some of this functionality being available in Zen Cart 2.0, although I think this IS a rumour, I dont see any evidence of this in the details released so far: http://www.zen-cart.com/forum/showthread.php?t=116018

If it IS the best tool in the box and will continue to be so with ZC 2.0 (with compatibilty changes obviously) surely there would be interest in someone competent (hello Mr. Clarke) cleaning it up on one-off now for some renumeration/contributions which I think is perfectly reasonable. I imagine there are a lot of people using it and more who would if it was fixed.

What do people think? Are lots of people interested in keeping this alive or have they moved on already?

regards
Steve

In my experience Open Source is not really a business model. My royal mail modules have had more than 10,000 downloads over the last 3 years. I have never received a donation for them.

The worldpay module has given me about £100 in the last year. I was once offered some money to modify super orders and join it with the edit orders module. The client then moved the goal posts and expected more work.

I quoted for a 3 hour job to modify some of the shipping modules, once again the client moved the goalposts and requested 3 days of work beofre releasing any funds. The only reason to develop any modules would be to become more familiar with either PHP or Zen Cart if one wanted to work as a contractor. The realiity is that the people that use zen cart do so because it's free and are on these forums to get free advice.

I donated my time back to the community when I went from being the director of a 17 person development company to being housebound because of physical disability. Recently I updated a module for a web design company who told the website owner that I was cheap. I've found wed hosting companies charging £75 to install modules that I have written as an add on for bundled hosting and that is the GPL way and the reality of the situation, it's not a complaint, there is nothing to stop a company from doing this. If a person has money to pay for hosting and shop development the they don't turn up on these forums, their designers do.

Your statement

cleaning it up on one-off now for some renumeration/contributions which I think is perfectly reasonable. I imagine there are a lot of people using it and more who would if it was fixed.

is really just a hope that someone would pay with no backing in my experience. I thnk super orders could make a good student project maybe someone would donate, but for the weeks of work required one would be working for either an alternative reason or for pennies an hour.

Philip

I am having a problem with batch print out view in admin see attachment. I am wondering how the get the layout stacked below each other in stead of across.

Thank for your help

lextechs:

I am having a problem with batch print out view in admin see attachment. I am wondering how the get the layout stacked below each other in stead of across.

Thank for your help

Sorry guys forgot to add the screen shot

Hard to tell from the thumbnail, but is the problem that some of the drop-down boxes are automatically sized to their data, and some of your fields are very large?

And to reply to Philip and Torvista, I can completely agree and appreciate Philip's experiences and views. I've also found a lot of value in SO and really like it. While I'm not a professional PHP coder, I enjoy digging in and figuring out a problem, and several times I've found answers or at least guidance on this forum. In fact, I'd say that to me, that's one of the strongest reasons to go with ZenCart is the community support found in the forum.

Maybe I wasn't paying attention, but I use SO, sales_report, and edit_orders, and haven't seen any problems since applying the patch. I'm now upgrading to 1.3.8.1 so I can't comment there.

Question: Is it necessary for one person to 'own' the addon, or can it go on as a community supported project? I try to offer assistance when I can, but I don't think I have the bandwidth or maybe even the depth of knowledge to take ownership.

Hi,
thanks for the comments Philip and carlvt88
It’s a pity no-one wants to pay for anything these days/value other peoples time.
I don’t have a problem paying for work but I have a big problem specifying what I want. I've ended up doing it all myself mainly because all the bits I wanted changing seemed so minor and the major bits I could not settle on yet.
I like to contribute when I can but I don’t have the skills to do what seems to be required to fix Super Orders and my interest is to whether it is necessary..

Calrvt88, would you mind explaining what do you use Super Orders for that Edit Orders does not do?

Thanks
Steve

In answer to recent posts, Super Orders doesn't need to be owned by any one person. However, in practise these big mods only really move forward when somebody does take responsibility for them for a period.

This is because it requires a focus and in-depth knowledge of how it all fits together, that you can't get or maintain by just dipping in and out occasionally.

Sadly, as Philip says, it's very difficult to make a living out of add-ons. The ones I release are usually spin-offs from commercial projects that I share as my way of giving back.

That was also the case for Super Orders which Bindside spun out of a requirement from a company with which he was working at the time. Had he not have invested personal time extending and bundling it, it's unlikely that we would have anything like it today. Blindside now has new business interests and the best of luck to him.

However, that does mean that until a new champion comes along, there's unlikely to be significant new development for this module.

A while back i was looking for a way to fix the OT calculations, such that the group discount is applied first, then calculate whether free shipping should be applied.

free shipping on orders over $75 (after any discounts or group discount)

I thought i had found a thread to help me fix that, and recently just noticed that free shipping is still being applied on orders the free shipping amount ($75) on orders that drop below $75 after the discount.

Could the super order module have affected it? or if anyone can point me in the right direction of how i can fix this.

Thanks!

How can the pop up windows be controlled so that they automatically adjust to open fully? Right now they open partially.

SO Super Upgrade Error 1146 payment_purchase_order doesn't exist

Was there something else in the mod to upload besides the super_upgrade and SQL?

I'm getting the following error in my website http://www.maternitystar.com.au

Fatal error: Call to undefined function zen_href_link() in /home/matern/public_html/includes/languages/english.php on line 539

What could be causing this? Thanks for any help on the matter. Please help me i am in big problem....

The function is defined in includes/functions/html_output.php. Do you know if that file is OK? Was your site working before you made a change somewhere? Do you have extra files in that directory that don't belong? Let us know how you make out...