Community Add-Ons

Correction de la prévisualisation
quick_updates.php
Je me suis trompé sur une des lignes
j'ai donc corrigé

Correction de la prévisualisation
quick_updates.php
l484 ajout de
$spec_price = $HTTP_POST_VARS['spec_price'];

et l493
} else $price = $products['products_price'] + $spec_price ;

problem with stylesheet.
fix line 198 to
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
uploades only admin/quick_updates.php

Uploaded the wrong quick_updates.php and install text in the previous version. Use this download instead (full package).

Bug fix in quick_updates.php that would not allow you to change the number of products to be displayed.
Bug fix in quick_updates.php that would not allow you to switch to any page other than page one.

Only quick_updates.php has been modified with code comments to fix the above.

Full Package.

Bug fix in quick_updates.php that would not allow you to change the number of products to be displayed.
Bug fix in quick_updates.php that would not allow you to switch to any page other than page one.

Only quick_updates.php has been modified with code comments to fix the above.

Full Package.

now lists all products from selected category within all subcategories (fixed previous version).

full package

now lists all products from selected category within all subcategories.

full package

Hi,
This is the full package based on "Quick Updates 2.7 Full Español"

I just translate it to Turkish and removed Espanol language file..

screenshot;
http://www.duzgun.com/quick-price-updates-full-tr-hizli-fiyat-guncelleme-t-658.html

full package....

////****TURKISH*****////
"Quick Updates 2.7 Full Español" surumu temel alinarak Turkce'ye cevrilmistir.tum fixleri yapilmis versiyonudur.
ispanyolca dil dosyas&#305; cikarilmistir.
ekran goruntuleri;
http://www.duzgun.com/quick-price-updates-full-tr-hizli-fiyat-guncelleme-t-658.html

sorulariniz icin ayni adresi kullanabilirsiniz.

All credits goes to the authors.

Esta es una Traduccion de la Instalacion, corrige el error de paginacion.

FULL PACK

BEANS

oscommerce.qadram.com

Hi all, thanks for an awesome MOD. I run this mod in a CRE Loaded cart and tried everything i could to get the last posters method to fix the manufacturer issue with pagination and could not, here is another method for those that try the last post and have no luck :) Since when selecting the manufacturer from the dropdown first you have that id in the url and all that is needed is to paste this line of code:

$manufacturer = tep_db_prepare_input($_GET['manufacturer']);

right after line 554

echo ' <a href="' . tep_href_link(FILENAME_QUICK_UPDATES,"row_by_page=$row_by_page") . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';

in the admin/quick_updates.php file. hope this helps and thanks to EVERYONE who has contributed to such an awesome add-on :)

Problem in Manufacturer dropdown box:

When you filter search by manufacturer, and you get some pages result then you try to move to the other pages, your manufacturer filter name is deleted and change to the default (all manufacturer)

To solve it find the code in line 560:

<?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page); ?>

AND CHANGE IT TO:

<?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer); ?>

now it will work fine !

no file to upload..

This is Full version tested on Oscommerce and CRE Loaded 6.2 both I fixed the SQL statement to install on CRE Loaded and quick_update.php retail price error as well.

Very Clean install.

Error de actualización rápida por fabricantes (manufacturers) reparado.

Cambio realizado:
En catalog/admin/quick_updates.php línea 526

<?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page); ?>


Reemplazar por:

<?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer); ?>

This contrib is no longer working due to an error that needs urgent attention currently rendering it useless at present.

Choosing a manufacturer to update prices with works fine, until you move to the second result page to continue updating, the chosen manufacturer is then lost.

As noted previously.

There is no download attached here, this is just a note.

FIX REQUIRED.

You may find if you have products which are not linked to a manufacturer, they will not show up in the Quick Price Updates.

This patch should fix it, & show products without manufacturers.

Based on Spaceboy's (Didier Debbaut) initial patch, found in the Quick Price Updates - Official Support thread. http://forums.oscommerce.com/index.php?showtopic=159022

Quick Price Vers. 3 -26.06.2007-

Translated into german. All needed files included.

Quick Price auf Deutsch übersetzt. Alles erforderlichen Dateien inklusive.

On your own risk... as usual :)

The corrected FULL PACKAGE... included the last fixes...

Included the spanish translation.

Regards from spain! :)

there was an error when selecting a category.
This is the correct file.

JUST this, file, replace the one from my previous upload with this one.

good code and sales.

hi there,
The last full package of this contribution (2.5b) contains a lot of thing a usual shop doesn't have.
I've eliminated all these to make this contrib working in a normal shop.
enjoy

I have combined the Quick Price Updates v 2.3c and more_pics_6_v1.2c to be able to edit the image en 6 mopics subimages links quickly.
With this version you can now do that.
Works good if you have the same images that may appear in more than one products or want to change the images subdirectory.
It saves me a lot of time so I wanted to share this.
You can find the changes I made in catalog/admin/quick_updates.php and
catalog/admin/includes/languages/english/quick_updates.php
marked with // BOF Mopics 6 added:
it is pretty straightforward so you can easily change your files if you have other versions installed.

You need to install more_pics_6_v1.2c !

all credits to the authors.

Here is the quickupdates.php in GREEK, to put in calog/admin/includes/languages/greek/

Voila j'ai traduit la partie catalogue de quick update en français.

Ihave traduct the catalog part of quick update in french

Added the very popular Individual Shipping Prices v3.1 intergration, commented out MVS which can be restored.

in the php file there are direct link
<link rel="stylesheet" type="text/css" href="../../../../Inetpub/wwwroot/admin/includes/stylesheet.css">

replace by :
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

also change a line in the beggining to : require('includes/application_top.php');

This version has been modified to support the Multi-Vendor Shipping contribution.

***You must have Multi-Vendor Shipping installed for this version to work, otherwise you will get errors***

The configuration menu has been modified to accomodate the Vendor Name, Vendor Product Cost, and Vendor Product Number. The configuration menu has also been changed to allow the following options for each field: "Do not display or modify", "Display only", "Display and allow modifications".

Although I have this installed and running on an MS2.2 installation, since it is integrated with Multi-Vendor Shipping there may be unforeseen issues. Use at your own risk, and as always BACKUP!

Unresolved issues - Not quite sure what "Commercial Margin" is supposed to do. Seems to perform the price increase/decrease regardless of whether it is enabled or not. If someone knows what this "should" do, I will test for that functionality.

This is a full package.

EN: Quick updates are possible for:
Modell, name, status, weight, qty, images, manufacture, price, VAT

DE:Quick Updates sind möglich für:
Modell, Name, Status, Gewicht, Stück, Bilder, Hersteller, Preis, MwSt

Extension/Erweiterung
for/für Make An Offer: http://www.oscommerce.com/community/contributions,3034
for/für Product Sort: http://www.oscommerce.com/community/contributions,911
for/für Grundpreise: http://www.oscommerce.com/community/contributions,2737

EN: Additionally the following fields can be called and worked on, if available:
DE: Zusätzlich können folgende Felder aufgerufen und bearbeitet werden, wenn vorhanden:

Inhalt/Einheit: Feld products_zusatz3 in Tabelle products_description für Verpackungseinheit
EK-Preis: Feld products_price_ek in Tabelle products für Einkaufspreis.

Hi,

For those who are not using the EZ Fields Retail Price and Margin Report contributions, you're still using "p.products_retail_price" and "p.products_retail_price" in your quick_updates.php file.

This file contains what needs to be changed.

Here's the MYSQL file for the previous 2.7 addition. English only

Changes

1) Defined table headings: Cost and Retail Price (includes/languages/english/quick_updates.php

2) Added two new entries in the MY SQL English file: Display Retail Price and Display Cost.

3) Added display and write retail price and cost fields with sort orders.

I've tested everything. New mod is sweet.


Important:

You Must have EZ Fields Retail Price and Margin Report contributions.
If you don't and opt to use this script, you must turn off the display retail price and cost options in the config -> quick update menu or you will get a MySQL error.


--------------------------------------MOST IMPORTANT------------------------------------------------
PROGRAMMER'S CHALLENGE

If anyone can find a way to integrate a drop down menu to assign attributes and attribute inventory tracking (complementing the Quantity Pro module), I'll buy you lunch.

Bluestrat,

Please check the changelog for my email address.

Ful Package, changelog in 2.6

1)change ## STEP 2 (define the filename)
---------

in admin/includes/application_top.php
in the section started with :
// define the filenames used in the project
===> add the line :
define('FILENAME_QUICK_UPDATES', 'quick_updates.php');

with

## STEP 2 (define the filename)
---------

in admin/includes/filenames.php
in the section started with :
// define the filenames used in the project
===> add the line :
define('FILENAME_QUICK_UPDATES', 'quick_updates.php');


2)Added in ## STEP 3 (define in language) italian language
---------

per la lingua italian :
===> modifica admin/includes/languages/italian.php
nella sezione che inizia con :
// categories box text in includes/boxes/catalog.php
===> aggiungi la linea :
define('BOX_CATALOG_QUICK_UPDATES', 'Quick Updates');

3)Start to modify italian sql

4)fix bug of " in quickupdates.php

5)added italian translations

There is a bug, if a product have " in description or model this will be truncated :(
Another one is that this can't update multiple language description.

No file updated

Another small fix..
If there any product listed with special price the link was not pointed to its special price screen when we click on (i) button.

Full package ....

When we change any product option, it wasn't updating product update time/day (products_last_modified). It remains unchanged.

Now with this fix it also updates Last Modified date information in database.

Just replace /catalog/admin/quick_updates.php file provided in attached ZIP file

Only a new upload becuase the last one dose not work (error 404 if dowload startet)

Just a cleaner Look :-)

only little bugfix and german .sql file<br>

fixed forgotten "php" statement to "<?php" on line 414 in catalog/admin/quickupdates.php<br>
caused trouble because some webserver need it <br><br>

added changes.sql - sql-file for german database-entries<br>
working also with webmin-mysql-interface (the original commands didnt work)<br><br>

(based on v.2.4 from Eylert Mathieu)

You can now :
- Just display the tax or the manufacturer.
- Activate or desactivate the commercial margin.

Fix a bug.

This is the full package.

Thanks to Fernando Maluenda for spanish translation!!!

Spanish translation of Quick Price Updates

Correction of English translation.

Thanks to Azer.

- German translation added
- "Print" button added
- Tested with OSC2.2 MS2 CVS from 30.05.2003

Now the two Images will be extracted to the correct directory.

You can now configure this module through the admin.

for any french to english translation that seems incomplete or incorrect, please contact me.

- You can now disable the fact that you can see the price with all inclusive of tax when you are typing the price or when the mouse is over a product, read the file install.txt.

- Nearly in the version 2.3 you will be able to configure this module in the admin.
Be patient!

- Fix some bugs.
- Add the possibility to print the page.
- Upgrade ergonomics.
- Optimization of the code.

Fix a javascript bug when there isn't tax for a product.

- Fix some bugs.
- Select by manufacturer.
- Added possibility to change image, manufacturer, name and model.
- You can configure what you want to change and display. (read the file install.txt).
- You can see the price with all inclusive of tax when you are typing the price or when the mouse is over a product.
- You can add a commercial margin to all the products that you receive from your supplier.

Correction of english translation,
somes details added
- html correction,
- round prices to 2 decimales (ie 1.614 = 1.61 and 1.616 = 1.62)
- comments in the code for futur updates

Fix minor bug on back from preview

add -
- select by category (thanks Xaglo!)
- select number of rox viewed
- update all prices by group with amont more or less or rate
- specials products prices locked
- count number of items updated for control (and number of total modifications)

New version with split page, and others stuffs.

includes English and french version

Working on 2.2 MS1
not tried on others but seems to be working.

If you have previous version installed, just unzip and replace files else follow the install.txt file.

fix a bug due to the presence of character badly coded (not necessary on all plateform)

ADDED V1.4b
------------------------------------------------------------
fix a bug for products without tax

add 'order by' with choosing option

ADDED V1.4

------------------------------------------------------------
changed ID information for model information and order by model

added possibility to change Taxe and Status

added french version

fix a warning bug

some small modifications

08/01/2002 - quick product update.zip (2.2-CVS) Author: Alparsalan
change sql and add turkish language

07/31/2002 - quick product update.zip (2.2-CVS) Author: blue dog
Working off Quick Price Updates V1.2, I have now enabled it so that you can update not just prices from a single page, but product weight and quantity too.

I'm still figuring out the split page thingy for all you peeps with a large product list - perhaps 30 per page in alphabetical order. My thanks to Richard Fielder for the sort order mod.

(Based on the original script contributed by Burt and updated by Henri
Bredehoeft)

Working off Quick Price Updates V1.2, I have now enabled it so that you can update not just prices from a single page, but product weight and quantity too.

I'm still figuring out the split page thingy for all you peeps with a large product list - perhaps 30 per page in alphabetical order. My thanks to Richard Fielder for the sort order mod.

(Based on the original script contributed by Burt and updated by Henri
Bredehoeft)

Based on the original script contributed by Burt and updated by Henri Bredehoeft, this has now been tweaked to integrate completely with the admin section - doesn't look like a "bolt on". I have also added a cancel and back button. Next phase is to bring in product weight etc. and span the results over multiple pages for those with a large product list.

Enjoy.

Blue Dog

Taking the origianl idea by BURT, I have hacked it so that it is now integrated into the admin reports section. I have also rewritten parts of it to pull relevent info from the stylesheet.

All done on 12th July snapshot.

Thanks to Burt for the original idea.

BD

This is an update of the original version by Burt (burt@xwww.co.uk). This version uses some of the already build in osCommerce functions to connect to the database. Please see the readme.txt for additional information.

A fairly simple script which presents all of your products and prices into a "form" which is then updatable all in one go.

Tested 360 products and it dealt with those changes in under 2 seconds.

Its version 1, so might be a bit buggy, but it works perfect on my servers.

*** make sure to back up your database before using this script - just in case ***