Community Add-Ons

file
022__MultiProductUpdate.zip

new release v1_6

features :- see for yourself

individual shipping prices per product code is fully commented out

this version will work on you store

do not set max search results in config to more that 22/23 that bug still exists and i dont know why

fully tested

one stand alone file all you need to do is link to it in you admin menu boxes left hand side.

go get it..........................

forum
http://forums.oscommerce.com/index.php?showtopic=323536

matthewjohnritchie

current fixes see forum.

this zip contains [20] and [21]

MPU --- 1_5_g - edits [15] to [19] --- mjr bluegreenenterprises

Ok - first issue mostly resolved, that was the zeroing of columns that were hidden

latest edition in product_updates[19].php, --- there is an echo statement at line 308 [[[echo $sql_do_update . '<BR>' . $query_string_parameters;]]]

that throughs up the error:

UPDATE products SET products_price = '', products_model = '', products_weight = '', products_quantity = '', products_image = '', products_status = '1', products_ship_price = '', products_last_modified = '2008-12-14 15:11:37' where products_id = '19'
action=update&ST=1&ID=7&
Warning: Cannot modify header information - headers already sent by (output started at /home/bluegree/public_html/OSC_TEST_GCO_GCODEv145a/rc1_GCOv145a/admin/product_updates[19].php:308) in /home/bluegree/public_html/OSC_TEST_GCO_GCODEv145a/rc1_GCOv145a/admin/includes/functions/general.php on line 22

but by commenting this out you can avoid this error message.

zip contains file update from [15] to [19] but only [19] is needed.

remaining problem:

on first load, and first click of update button without editing any data one product's data is errased, you can actually see this happening in the error above to 'theres something about mary'

the quizical point is that it is item id/number 19 towards the bottom of the page, hence I have no idea yet why it is being picked up and changed.

secondly - when update button is clicked, the get query string in the url has 'listing=' amended to it. I believe this is due to the sorting arrows code but still the answer is alluding me.

I am looking in to the functions tep_get_all_get_params() and tep_href_output() ??? to see if i can use these purposefully to alleviate the get array parameter problems.


so for now have a look through [19] and let me know your thoughts here:

[url="http://forums.oscommerce.com/index.php?showtopic=323536"]http://forums.oscommerce.com/index.php?showtopic=323536[/url]

Many thanks

MatthewJohnRitchie
bluegreenenterprises.com

http://forums.oscommerce.com/index.php?showtopic=323536

sorry forgot the above...

this is for my contrib below

Multi_product_update 1 5 f

Multi-Product Update v1.00

http://www.oscommerce.com/community/contributions,2415

I have put quite a bit of work into reworking this contribution and adding some new features and fixing old ones...

However, just after I uploaded it I found a serious bug!!!!!

WARNING:

when you hit 'update' submit button, field data is eatten up and lost from the database. I will work on it futher but...

WARNING

use only with a practice/development osc shop copy, one which you dont mind if data is lost! ALWAYS uesfull to have at one side...

I have 12+ ;o)

Any way, I have left all previous reworked files in the contribution zip numbered from [1] to [15]

file [15] is the latest and not quite working file so heed the WARNING above.

the other files are in various states of undress so to speak.



OH, much horrid junk has been cleared from the previous upload. BOY did it cause serious square eyes and pounding heads...

I have also heavilly commented the file and rearranged the 'HOUSE' style to make it easier to read..

many Thanks for now

Matthew John Ritchie

www.bluegreenenterprises.com --- see demo (no admin access at present otherwise you could see my secret bits) ;o) teehee.

Multi-Product_Update_1_5e by Luisete
Earlier archive uploaded by me had a wrong name, but the file inside are ok.

New features:
- Fix sorting issue (all versions?)
The sorting feature seems to fail when register_globals = Off
After lines:
$currencies = new currencies();

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
$search = (isset($HTTP_GET_VARS['search']) ? $HTTP_GET_VARS['search'] : '');

Paste:
// Fix for sorting issue with register_globals = Off
$listing = (isset($HTTP_GET_VARS['listing']) ? $HTTP_GET_VARS['listing'] : '');


- Maintain sort of products across pages (if they have been previously sorted) while we are updating them or browsing, being able to re-sort products without lose page number that we are viewing.

Backup previous version before overwrite it.

I hope it works fine.
Regards

---------------------

Multi-Product_Update_1_5e by Luisete
El anterior archivo que subí tenía mal el nombre, pero su contenido estaba bien.

Características nuevas:
- Arreglado error a la hora de ordenar los productos (¿Todas las versiones?)
El ordenamiento parece fallar cuando register_globals = Off
Después de las líneas:
$currencies = new currencies();

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
$search = (isset($HTTP_GET_VARS['search']) ? $HTTP_GET_VARS['search'] : '');

Pegar:
// Fix for sorting issue with register_globals = Off
$listing = (isset($HTTP_GET_VARS['listing']) ? $HTTP_GET_VARS['listing'] : '');


- Se mantiene el orden de los productos (si los hubiéramos ordenado previamente) mientras los vamos actualizando o navegando por ellos, siendo capaces de reordenar los productos manteniendo sin perder la página que estemos viendo.

Haz copia de seguridad de la versión anterior antes de sobreescribirla.

Espero que todo funcione bien.
Saludos
Luisete

www.flashpc.es

Warning: this version skips Ballies's changes. If you want them, you must download his archive.

New in this version:
Redirection codes rewrited to maintain last page viewed (also after a product was modified or (de)activated).
Search feature changed to show only requested products searching by product name, model or manufacturer (thanks Andrew for the suggestion).
Minor cosmetic changes.

Not full package, only product_updates.php.
Backup your previous version of this file before overwrite it.

I hope that works flawless ;)
---------------------

Atención: esta versión no contiene los cambios aplicados por Ballie. Si los quieres, tendrás que descargar su archivo.

Nuevo en esta versión:
Códigos de redirección reescritos para mantener la página visualizada (incluso después de que un producto se haya modificado o (des)activado).
Cambio en la búsqueda para que muestre sólo los productos buscados, ya sea por nombre de producto, modelo o fabricante (gracias Andrew por la sugerencia).
Cambios menores.

Paquete incompleto, sólo archivo product_updates.php
Haz copia de seguridad de la versión anterior de este fichero antes de sobreescribirlo.
Espero que todo funcione bien ;)

www.flashpc.es

My first Contribution

Small update to product_updates.php

* Product links to Preview Page so Inactive items can be previewed too.
* Added rollover effect

Not full package
Only: product_updates.php &
(alternative easy 1 copy & paste text install)

Adapted by Ballies

Update and fix to previous versions.

* Reviewed sql queris to shows all products even if they don't have a manufaturer.
* Link to open products admin editor.

By Chaveiro

added ability to show product status and activate or deactivate them from list.
Not full package.

http://www.carballino.eu/

Removed support for UPS XML dimensions and ready to ship, maintaining feature "update only products that were changed" (little bit changed; earlier version does not work for me).
Reformatted number_format to english notation, without comma for thousands and dot for decimals. Added a search box to find products in admin faster from product_updates page.
Added feature to generate different products_last_modified values in database (thanks OSdave for your help), with sorting, useful for show date ordered listings (an rss channel for products, for example).
Add javascript to replacing commas to periods and alert the admin if a value entered is not correct. Arrow icons moved (and unified in only one location) to images folder of admin.
Added spanish language.
Added a box in left column of admin.
Used in http://www.carballino.eu/shop/

Same version as before plus update now works only for products that were actually changed (either weight, length, width, height, price or quantity) This will really speed up updates for shops with large number of items in stock. I do not care about sorting by category, so will leave it as little exercise for somebody else.

Minor fixes and inconveniences:
- tep_num_rows() does not make separate select() just ot count rows :)
- initial sort order is by product quantity. At the end you update stock because it's low or new, so it does make sense to show low stock products first
- Field for model is readonly now and size of model fields is larger than dimension/weight/price/quantity fields
- Fixed minor glitches in the code

Same as below but added dimension support for UPS XML to be able to quickly edit dimensions of products and ready ship.

"Dutch language not updated"

Install UPS XML 1.23 w/ dimension support and then this, should work flawlessly!

Fixed bug where multiple lines werre shown per product on multi-language shops (1 line per language per product). Since we're only updating the products table this is not necessary. Also added Dutch language,

Personal note: I love this contrib, it's exactly what I was looking for :-)

Have included 2 small gif images, ic_up and ic_down that this contribution calls for and are not in any of the other files.
Without these the updates page was about 4 screens wide.
No changes have been made to the actual script

added GPL.

No other changes from 1.1.

Full Package.

If your not using manufacteres you would get 0 in result. I have added at new product_updates file. Which remove query on manufatures.

Did not have the time to change the query.

Just overwrite old product_updates.php in catalog/admin/

Changelog:
1.1 - Feb 12, 2005 - Jared Call - added ability to sort by all fields (modified code from Order Sort Admin - http://www.oscommerce.com/community/contributions,1374 .

Good contribution, works smooth
Thanks to Acheron

Added weight update

This mod will allow you to update price and stock for multiple products at once. It also features a 'Save to CSV' feature just for the heck of it. It requires 3 tiny additions to your files and includes 2 new files. A screenshot is included.