Author Topic: View/Print a complete Price List  (Read 290031 times)

hiveuk

  • Beginner
  • *
  • Posts: 27
Re: View/Print a complete Price List
« Reply #75 on: December 28, 2007, 10:43:13 am »
Thanks - works great now - appreciate the quick response!

malviv

  • Jr. Member
  • **
  • Posts: 81
Re: View/Print a complete Price List
« Reply #76 on: December 28, 2007, 11:08:00 am »
I hadn't even noticed that problem so thanks hiveuk, 

I have also just learnt how to turn off the manufactures column so it's been a good morning so far.

Mal
I am on Joomla 1.0.13
VirtueMart 1.0.13a

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
Re: View/Print a complete Price List
« Reply #77 on: December 28, 2007, 12:03:03 pm »
I have also just learnt how to turn off the manufactures column so it's been a good morning so far.
In the first post of thread there was the "instructions"! Didn't you see them?
http://forum.virtuemart.net/index.php?topic=33101.msg99159#msg99159

Reporting here....
Quote
Between lines 8 and 18 of file shop.pricelist.php, you can set some options:
$onlyregistered = true --> allow access only to registered customers
$displaymanuf = true --> display a column with the manufacturer name
$productlinks = true --> make the products names clickable, with links to product details page
$discountcolumn = true --> display a column with the discounted price
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net

malviv

  • Jr. Member
  • **
  • Posts: 81
Re: View/Print a complete Price List
« Reply #78 on: December 28, 2007, 12:06:31 pm »
Oh yes.......

Sometimes you can't see the wood for because of all the trees!!!!!

Mal
I am on Joomla 1.0.13
VirtueMart 1.0.13a

psychotik_noise

  • Beginner
  • *
  • Posts: 15
Re: View/Print a complete Price List
« Reply #79 on: January 07, 2008, 12:28:07 pm »
hey all !
 i want remove "product sku" but add  "Attribute List" (used for ECO DEEE) and "price quantity" in price list... some body can help me????

tank's a lot !

Pisu, please...HELLLLLPPPPPPP !!!!! :-)

Benoit Lallemand

  • Beginner
  • *
  • Posts: 9
Re: View/Print a complete Price List
« Reply #80 on: January 09, 2008, 01:38:00 am »

I have too many products, over 4000.
I have a time out for the sql query
Ideally it should be able to choose to print the list by category.

Could you adapt / modify your program ?

vm_user

  • Jr. Member
  • **
  • Posts: 156
Re: View/Print a complete Price List
« Reply #81 on: January 15, 2008, 14:45:24 pm »
Good work Pisu, we all appreciate your efforts in continuing to develop vm :-)

My client has asked for something like thi s to be available in the reports section in the back-end - is it easy to adapt this hack to do this?

Thanks.
Joomla 1.5.15, VM 1.1.4

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
Re: View/Print a complete Price List
« Reply #82 on: January 22, 2008, 12:48:29 pm »
Sorry now I don't have time to work on your feature request, in fact all very nice... Does someone want to develop them???
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net

vm_user

  • Jr. Member
  • **
  • Posts: 156
Re: View/Print a complete Price List
« Reply #83 on: January 28, 2008, 12:04:04 pm »
Hey Pisu, I wasn't expecting you to do any additional work! Just some advice on where to start with this  ;D

Can I just plug these files into the admin section of vm and access it via a new reports menu option?

Cheers.
Joomla 1.5.15, VM 1.1.4

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
Re: View/Print a complete Price List
« Reply #84 on: January 28, 2008, 13:45:48 pm »
Hey Pisu, I wasn't expecting you to do any additional work! Just some advice on where to srart with this, can I just plug these files into the admin section of vm and access it via a new reports menu option?

Cheers.
Yes, it is possible; you can change the module for this page (for example, now "shop.pricelist.php" means that the module used is "shop", you can change in "admin.pricelist.php" or other); modules are important for correctly managing permissions (shopper, storeadmin, admin..).

Then, you can add a link to this page, in the top VM panel menu; this is defined in "header.php".
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net

Fragrancer

  • Beginner
  • *
  • Posts: 6
Re: View/Print a complete Price List
« Reply #85 on: January 31, 2008, 17:10:43 pm »
Is it possible and how .... (maybe you can give me some hint), to show on product pricelist the number of products in stock ... that will be very usefull ...

rjcroasdale

  • Jr. Member
  • **
  • Posts: 81
    • Marketing Consultants
Re: View/Print a complete Price List
« Reply #86 on: January 31, 2008, 20:09:33 pm »
Can this be modified easily to show product images?

cheers.

Rob.

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
Re: View/Print a complete Price List
« Reply #87 on: February 01, 2008, 16:25:51 pm »
Is it possible and how .... (maybe you can give me some hint), to show on product pricelist the number of products in stock ... that will be very usefull ...
Hi, you can simply add a column to the pricelist table, extracting the stock variable from the database: $dbp->f("product_in_stock")

Can this be modified easily to show product images?
This is a little harder, but can be done creating IMG tags, with the correct src attribute, made in similar way as in shop.browse.php page:

Code: [Select]
314          if( $product_thumb_image ) {
 315              if( substr( $product_thumb_image, 0, 4) != "http" ) {
 316                  if(PSHOP_IMG_RESIZE_ENABLE == '1') {
 317                      $product_thumb_image = $mosConfig_live_site."/components/com_virtuemart/show_image_in_imgtag.php?filename=".urlencode($product_thumb_image)."&newxsize=".PSHOP_IMG_WIDTH."&newysize=".PSHOP_IMG_HEIGHT."&fileout=";
 318                  }
 319                  else {
 320                      if( file_exists( IMAGEPATH."product/".$product_thumb_image )) {
 321                          $product_thumb_image = IMAGEURL."product/".$product_thumb_image;
 322                      }
 323                      else {
 324                          $product_thumb_image = IMAGEURL.NO_IMAGE;
 325                      }
 326                  }
 327              }
 328          }
 329          else {
 330              $product_thumb_image = IMAGEURL.NO_IMAGE;
 331          }

The $product_thumb_image variable can be took from database: $dbp->f($product_thumb_image).
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net

~ Stephan

  • Beginner
  • *
  • Posts: 5
Re: View/Print a complete Price List
« Reply #88 on: February 03, 2008, 18:40:53 pm »
Very nice work to everyone!  Would it be possible to add a column to display the price after discount if the product is discounted?

siclaw

  • Beginner
  • *
  • Posts: 1
Re: View/Print a complete Price List
« Reply #89 on: February 03, 2008, 22:27:30 pm »
Great!

Here is Slovenian Translation.  (Slovenian NOT Slovak!)

Siclaw

[attachment cleanup by admin]