Community Add-Ons

the footer.php was being nested in the table and didn't stretch to it's full size

how to fix: in pricelist.php go to the 12th line from the bottom and replace this:

</table>

with this:

</table></table>

note: attached file is empty

Have edited price_list.php to have decent sorting order...

Full package included with revision made only to price_list.php

See it in action here: http://rkscomputersolutions.com/onlineshop

Full credit to the original authors

includes minor modifications to options of:
-show Product Models
-show Product Quantity
-show Out Of Stock Products
-printable view

New options of defining:
-text for no price or zero price
-width of the pricelist
-identation for subcategories

Package includes a complete single file
Or, a full version for language support

Full credit to the original authors

Full credit to the original authors

includes small modifications to options of:
-show Product Models
-show Product Quantity
-show Out Of Stock Products
-printable view

New are the options of defining:
-text for no price or zero price
-width of the pricelist
-identation for subcategories

Package includes a version complete in 1 file or a full version for language support

This is a small modification of pricelist.

It show the product model before the product ID.

Developed by Germán S. Arduino (gsa@arsol.net).

Date: October 2006.

Trouble:
---
The superfluous symbol "a" to the reference of products is added

Please change this:
---
function get_products($id_group){
global $currencies;
$products_price_query = tep_db_query("select products_description.products_name, products.products_price, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);
$x=0;
while ($products_price = tep_db_fetch_array($products_price_query)){
$cell = tep_get_products_special_price($products_price['products_id']);
if($cell == 0)
$cell = $products_price['products_price'];
if($x==1) {
$col = "#F8F8F9";
$x = 0;
}else{
$col = "#FFFFFF";
$x++;
}
print "<tr bgcolor="".$col.""><td class="productListing-data"> <a href=" . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "a>".$products_price['products_name']."</td><td align="right" class="productListing-data">".$currencies->display_price($cell,TAX_INCREASE)."</td></tr>";
}
}
---

TO:

---

$products_price_query = tep_db_query("select products_description.products_name, products.products_price, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);
$x=0;
while ($products_price = tep_db_fetch_array($products_price_query)){
$cell = tep_get_products_special_price($products_price['products_id']);
if($cell == 0)
$cell = $products_price['products_price'];
if($x==1) {
$col = "#F8F8F9";
$x = 0;
}else{
$col = "#FFFFFF";
$x++;
}
print "<tr bgcolor="".$col.""><td class="productListing-data"> <a href=" . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . ">".$products_price['products_name']."</td><td align="right" class="productListing-data">".$currencies->display_price($cell,TAX_INCREASE)."</td></tr>";
}
}

---
See work - Real shop:

http://www.notebook-sales.ru/pricelist.php
--
Sergei Podolich

Smal bug fix for mozilla firefox. The link dosn't work, the work only in IE. Now is fixed.

you can see this on my test page

http://partners.simtron.si/cenik.php

The closing tag on the center tag was omitted. It may not be crucial but it may cause some browsers to not center it.

As below, just 2 things changed.

1) Fix for looking in the root directory after clicking "Printable Version"
2) Centred the table for the printalble version.

Here is my version. It doesn't have images for stock levels, nor does it have '[edit]' features... Plus the edit feature shows the world where your admin is.

I did add a print feature that just hides the left and right columns. I left the footer, but you can modify the code to hide that too. I wasn't up to adding a language file, but it is easy. It is just the same as any other one and w/out it means a few less queries, right?

I changed the name of the file to 'price_list.php'. Change it back if you want, but this is a bit more descriptive.



Cheers,

willross
reply@qwest.net

Ïî óìîë÷àíèþ âûâîäèò äàæå òå êàòåãîðèè ñî ñïèñêîì òîâàðîâ, ó êîòîðûõ categories_status=0 (ò.å. íå àêòèâíàÿ êàòåãîðèÿ), ïðè ýòîì òåðÿåòñÿ ñìûñë íå àêòèâíûõ êàòåãîðèé.

Ðåøåíèå.

 ôàéëå price.php â ôóíêöèè get_group() íàõîäèì ïðèñâîåíèå çíà÷åíèÿ ïåðåìåííîé $groups_price_query:

$groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." order by categories.sort_order");

è çàìåíÿåì íà:

$groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." and categories_status=1 order by categories.sort_order");

This mod of the contribution let the admin click to modify an item directly from the html price list

Sorry, just a pair of slashes :((
fixed zip

Price with "LED" quantity and "call" icons, so you shouldn't show the real amount of goods in the stock [Russian "CALL" icons]

Moooie File maar niet handig als je met meedere talen werkt.
artikelen worden geplaatst naar aantal talen die je heb geinstalleerd. hierdoor duurd het opvragen van de file (page) erg lang

er scheelde vanalles met de vorige versies maar deze zijn nu opgelost hiermee...

Gewoon de price.php in je 'shop'folder uploaden. Veel plezier ermee!

Bezoek http://www.compumaster.be/shop/price.php voor een voorbeeld.

v1.2
Sorting of groups (the Order of sorting as it is specified in admin/catalog) is corrected.
The opportunity show of model is added. (a line 9)
Opportunity of summation with the tax rate. (a line 8)

v1.2
Èñïðàâëåíà ñîðòèðîâêà ãðóïï (Ïîðÿäîê ñîðòèðîâêè, êàê óêàçàí â admin/catalog)
Äîáàâëåíà âîçìîæíîñòü âûâîäà ìîäåëè. (ñòðîêà 9)
Âîçìîæíîñòü ñóììèðîâàíèÿ ñ íàëîãîâîé ñòàâêîé. (ñòðîêà 8)

Correct:
Removed product listings for products that are out of stock.
Added select listing for show or hide quantity products.
Èñïðàâëåíî:
Óáðàí âûâîä òîâàðîâ, êîòîðûõ íåò â íàëè÷èè.
Äîáàâëåí âûáîð âûâîäà êîëè÷åñòâà òîâàðîâ.

Deduces the list of products on groups with the prices. (HTML price)
Âûâîäèò ñïèñîê òîâàðîâ ïî ãðóïïàì ñ öåíàìè (HTML ïðàéñ)