Community Add-Ons
Quickly Update Product Stock
for osCommerce Online Merchant v2.2
This stand-alone tool will allow you to update the stock on an entire category at once (on a per product basis). An optional checkbox will set the products status based on the amount of stock for that product. Categories browsing is done through dropdown boxes.
Quick Product update - V3.8.1
ChangeLog:
v3.8.1 05/06/09 Version by: Azrin Aris
Summary :
1. Add "Title" tag to Category/Manufacture selector to show its category/manufacture id - requested by Jim Hande ;)
BugFix:
1. MySQL not updating if manufactures_id is not set when MySQL is configures as 'STRICT' - Fixed by Steve (Jimbob_pooley)
Quick Product update - V3.8
ChangeLog:
v3.8 05/5/09 Version by: Azrin Aris
Summary :
1. Minor Redesign on UI:
+ added Top/Bottom Action Bar
2. Added Update/Copy/Move/Delete Function
3. Added Numeric Input filtering
4. Added quick_stockupdate.css file for easier table customization
5. BugFix:
- if a value is more than a thousand, using autoupdate will make the price to 1.00 - Fixed
These instructions adds the option to update the item's cost, and are based on QuickStockupdate 3.5
I assume you already installed http://addons.oscommerce.com/info/3161 "Stocktaking Cost" - If you did not, then this is not for you.
Full package
Version française de la contrib avec la dernière mise à jour qui a été posté le 24 janvier 2009 par azrin_aris .
l'installation est en anglais mais c'est une contrib vraiment très facile à installer vous avez juste à traduire sur google.
Je trouve cette contrib vraiment intéressante elle permet beaucoup de changement rapide pas seulement le stock mais aussi le prix, le poids et le modèles !!
v3.7 01/25/09 Version by: Azrin Aris
Summary :
1. Add Language Filter
Support Forum :
http://forums.oscommerce.com/index.php?showtopic=142177
Status : Beta
Package : Update
Installation :
Please replace the quick_stockupdate.php in /catalog/admin/
v3.6 01/23/09 Version by: Azrin Aris
Summary :
1. Remove the need to use /tmp directory
2. Add Search by Category or By Manufacture
Support Forum :
http://forums.oscommerce.com/index.php?showtopic=142177
Status : Beta
Package : Update
Installation :
Please replace the quick_stockupdate.php in /catalog/admin
RECENT UPDATE:
v3.5 12/16/08 Version by: Azrin Aris
Summary :
1. Add Quick Stock Updater Configuration page (Configuration->Quick Stock Updater)
- Enable/Disable Add to stock option (value entered in 'New Stock' will be added to existing stock - Default = Enable)
- Enable/Disable Update Process time (Default = Enable)
- Set Max input character for 'Model' field (Default = 8)
- Set Max input character for 'Weight' field (Default = 4)
- Set Max input character for 'New Stock' field (Default = 4)
- Set Max input character for 'Price' field (Default = 6)
- Set decimal point for 'Price' field (Default = 2)
2. SQL installation script for configuration page QuickStock_sql_install.sql is included
3. SQL uninstallation script for configuration page QuickStock_sql_uninstall.sql is included
Full Package
VERY-VERY MUCH Faster the the previous version - new update method
RECENT UPDATE:
v3.2 12/12/08 Version by: Azrin Aris
Summary :
1. Remove Server loading checking
2. Remove Row-By-Row SQL Update method
3. Change update method to SQL import method
4. Add update time display
Use at your own risk :)
This is a Full Package
RECENT UPDATE:
v3.1 12/1/08
Summary :
1. Added serverload checking to avoid server bogging if items are too many
2. Added Data changed event to update only changed record(s) to minimize server load
3. Added Message notification
4. Added Screen shot ;)
5. Added mosoft's German Translation - but additional variables still need translation
version 3.0 lists all products in all languages.
the mod lists only german product_descriptions, search quick_stockupdate.php for language_id '43' and change to your prefered language.
german translation included.
this is just a mod
A complete rewrite (95%) of the module:
Now works with more tha 40 items (tested on my 300+ items store).
New Features:
- Active/Inactive is selectable
- Manufacture is changeable
Language Supported:
English
Further work needed:
- Get Currency symbol from DB
- Move/Copy multiple items
- Show/hide item thumbnail
THIS IS FULL VERSION
Took the file from shaggy2dope added the lines to solve the line 90 problem (the solution was in the forum http://forums.oscommerce.com/index.php?showtopic=142177) deleted some links. hope it works
changed things around a little. it now displays the current stock level and then allows you to go and add to it. so instead of having to go and count the number of that item you have each time you get a "truck" all you need to do is input that you got 3 of that item in today. so if you had 5 and got three, you'll end up having to only input 3 instead of 8 like it was on the old system. screen shot is included.
Tradução p/ Português
Correção de Bug
http://www.disy.com.br/
Translation of this contribution to spanish. and add the spanish language
Only add a instrutions in PDF format
and
***if you have the number of Order :0 in your default Language then no show the drop-down of categories to modified****
This version included V 2.5 Update and "Corrected small error"
Incluye nuevo: intrucciones en español en formato PDF con images de cada paso a seguir y descripcion detallada.
Esta version incluye de la version ingles hasta la V 2.5 Update y la "Corrected small error".
AVISO:
***Si en el idioma que tienes por defecto lo tienes con numero de Orden:0 entonces no te funcionara correctamente esta contribucion, lo deberas cambiar a 1 o a otro numero, si no te afecta a otra funcion que le hayas dado a tu web.
Descripcion:
Con esta contribuccion puedes actualizar con mayor rapidez tu catalogo de producto realizandolo por categorias en vez de por productos sueltos, puedes actualizar precios, modelo, peso, cantidad que tienes en stock y si el producto esta activo o no activo.
Se ha hecho una pequeña correccion, elimanadas dos carpetas que se pusieron por error y ampliado las instrucciones mas detalladas ademas de un screenshots de como es el resultado en el menu de seleccion en administracion.
Traduccion al español de esta contribuccion.
Translation of this contribution to spanish.
Con esta contribuccion puedes actualizar con mayor rapidez tu catalogo de producto realizandolo por categorias en vez de por productos sueltos, puedes actualizar precios, modelo, peso, cantidad que tienes en stock y si el producto esta activo o no activo.
solo se ha traducido las instrucciones y un archivo que se ha añadido para poner en la carpeta de idioma español
Incluye el V 2.5 Update
Traduccion al español de esta contribuccion
Con esta contribuccion puedes actualizar con mayor rapidez tu catalogo de producto realizandolo por categorias en vez de por productos sueltos, puedes actualizar precios, modelo, peso, cantidad que tienes en stock y si el producto esta activo o no activo.
solo se ha traducido las instrucciones y un archivo que se ha añadido para poner en la carpeta de idioma español
Incluye el V 2.5 Update
Man kann jetzt auch Lager, Staffelpreise, VK-Preis und EK-Preise. In diesem Contribut eingeben und man hat auch die Möglichkeit VK-Preise und EK-Preise, im bereich Admin - Katalog eingeben. Die EK-Preise werden auch nicht im Katalog auf der Indexseite anzeigt.
Bild und Text
Lager
Staffelpreise
Verkaufspreis VK
3 x Lieferantenpreis EK
Corrected small error in english language file - this is the full package
little bugfix in quick_stockupdate.php (language)
modified input folders
modified install-instructions in readme.txt
have fun,
:-)
some bugfix in language_id (read readme.txt)
changes for multilanguage use (german, english)
Have fun ;-)
All credit to PopTheTop: Fixed categories menu, slightly different formating, left aligned. Removed some more old code.
Took out some old left over code mentioned in the line previous.
Please do not post comments on the contribution pages. Instead use the forum. I created a new topic for anyone that has trouble with this simple contribution.
http://forums.oscommerce.com/index.php?showtopic=142177
Screenshot included.
Waht is the line below? Is it a file that was supposed to be included???
<SCRIPT LANGUAGE="JavaScript1.2" SRC="jsgraph/graph.js"></SCRIPT>
Updated the look to make it much easier to read took off the images it took to long, added more fields: model, weight, price, stock are all editable.
You can now easily add more fields if you need to.
I needed this so the pages wouldn't take long to load. Maybe someone else might find this useful... Just upload the file to admin directory.
v2.2 thowden 10/2004 Added edit function for the image file for each item.
I did not have the time to figure out the image processing in the main products page and having used quick_stock_update v2.1 it seemed a logical extension to allow for the editing of the image file.
I am normally adding lots of products before I order them, and when they arrive I then take the picture and need to add both the stock qty and the image details. Seems to work ok. Mods were to the stock_update values to create a multi-dim array and then to the update process to read the array and process both the qty and image fields at the same time.
I just corrected the incorrect path for the product image that was in v2.
Also did some cosmetic changes: formatted all the text. I didn't like the text being your browser default font & size.
Added one line of code to display the products' ID and name underneath the picture.
Added one line of code to display the products' ID and name underneath the picture.
Fixed the bug that wont show the image during item listing.
Just overwrite the quick_stockupdate.php file in the /admin/ dir with the one included.
Warren Ashcroft
Add: snapshot.jpg
and Update file.
Edit interface in AdminTheme
and addition new install manual
Stylesheet adapted from Mattice<http://www.matthijs.org>
Quick Stock Update v1.0
Quick Stock Update v1.0
This stand-alone tool will allow you to update the stock on an entire category at once
(on a per product basis). An optional checkbox will set the products status based on
the amount of stock for that product. Categories browsing is done through dropdown boxes.
Just one file to upload, no changes needed to osCommerce files.
screenshot:
http://www.xs4all.nl/~mattice/qsu_screenshot.jpg
