Quick Updates plugin [support]

[harry2cool]

Thanks for the help paul,

I did overwrite and had no problem,

the only problem I am facing as of now is this message "Illegal Access" if I try to upload the quick_copy.php in the functions/extra_functions folder.


Why is this and what do I do, I use the older version of Zencart, 1.27 is this causing any problem ??

[paulm]

The only reason I can think of is that it's related to permission settings on your server for that folder (or the file if it already contains a file with that name).

[harry2cool]

I dont think this is the reason, but if somebody can intrepet the below , I think we can come to know the reason for this erro,



if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}



the above is from quick_copy.php

[paulm]

Aha, now I understand. You're using an older version of Zen Cart. I suggest to add the define (to the top of admin/application_top.php ).

Like this:

define('IS_ADMIN_FLAG', 'true');

Newer Zen Cart version have this line, it's for improved security.

(you could also delete the lines from quick copy, but I think it's better to be safe than sorry.... especially with quick updates ;-) )

[harry2cool]

yes it works,
thanks a ton paulm

[paulm]

I am glad it did the trick, and thanks for letting me and other users know it did :-)


I am still working on a new 3.x version, but I need some beta testers.

Download: http://www.beterelektro.nl/zen-cart/...=quick_updates (stable versions, if available, will of course be uploaded to the Zen Cart downloads section)

Basic tests have been done on a 1.3.6 and a 1.3.7 shop, but it's not really recommended for live shop usage yet.

Most changes are not visible for the user (code). Currently it does not include an sql file and there are no db admin settings (so files need to be editted to change the default configuration).

Some new features are:

-a lot more product data updateable/viewable now (columns of the products table)

-basic search function

-add specials, edit special prices and status (not start and end date). Needs GV check to be added!

-quickly switch on/off columns for view/edit

-dramaticly less update queries needed per update (depending on what's updated)

-highlight of "0 fields" (using CSS of course), for example highlights 0 weight and "no manufacturer" and "0.00" price, etc

-highlight of last editted products

-switch between horizontal (=normal) and vertical tabbing

-added "bottom header" (no need to scroll to the top of the page to check what you're viewing/editting)


But remember: it's beta, so be very carefull and backup your database before each usage! (if you decide to use it on a live shop anyway).

Todo: a lot! (maybe later)

[paulm]

Forgot to mention:

feature:

-now it's possible to change the sort order of the quick updates columns

known issues:

- price markups may act a bit weird excluding tax (currently configured for nice inc. tax prices only)

- trying to update columns like products margin or purchase price will result in SQL error messages, if you don't have these columns. (so you need add these to your database, or disable them for quick updates)

[WmKenny]

[FONT=Arial]Quick updates is very powerful and flexible, very nice job.[/FONT]
[FONT=Arial]I'm considering using quick updates in a different manner and need your advice. [/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]What would need to be done in order to have quick updates display/edit the line items from an order? This would give the customer the ability to make corrections to their order. I'm thinking QU could fire up from the order confirmation email which will pass the order number. Quick updates would retrieve the products_id and products_quantity from order_products and pull the remaining data from the products table, display/edit those items and then update order_products and most importantly update the products table with the changes from that order. Updating the order_total is preferred but not a requirement (at this time). [/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]So a quick recap is - QU fires up via url with order number parameter, display/edit order line items, update products and order_products, recalc order totals (preferred not required).
Do you think QU would be a good tool for this type of use? If not, please inform me and you can stop reading. [/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]If you think QU is a good candidate then...[/FONT]
[FONT=Arial]How about adding additional items to the order, selected from the products table?[/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]That’s it for now. I know this is an odd request and modifying a completed order is a no no. But this will close the loop for my system, allowing the customer to correct discrepancies in their order. I can live (for now) with the detail not equaling the totals, as long as the products table is updated.[/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]When you get a chance please let me know your thoughts, or if you have any questions please do not hesitate. Sorry for replying to your update notice but I could not find where to start a new thread.[/FONT]
[FONT=Arial]
Thanks,[/FONT]
[FONT=Arial] [/FONT]
[FONT=Arial]Bill Kenny[/FONT]

[paulm]

Hi Bill Kenny,

currently I am rewriting quick updates, and hopefully it will be possible to view/edit more db tables some day using quick updates. But I think editting orders is something different and quick updates won't help much for that.

You could take a look at the Order Editor contribution (which is included in Super Orders). It's not written to allow customers to edit their own orders, but at least it's made to edit orders.

[WmKenny]

Greetings Paulm,

Thank you for your reply and directing me towards super orders. Good luck on your upgrade of quick updates.

Bill