View/Print a complete Price List

[hiveuk]

Thanks - works great now - appreciate the quick response!

[malviv]

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

[Pisu]

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....

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

[malviv]

Oh yes.......

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

Mal

[psychotik_noise]

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]

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]

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.

[Pisu]

Sorry now I don't have time to work on your feature request, in fact all very nice... Does someone want to develop them???

[vm_user]

Hey Pisu, I wasn't expecting you to do any additional work! Just some advice on where to start with this 

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

Cheers.

[Pisu]

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".

[Fragrancer]

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]

Can this be modified easily to show product images?

cheers.

Rob.

[Pisu]

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).

[~ Stephan]

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]

Great!

Here is Slovenian Translation.  (Slovenian NOT Slovak!)

Siclaw

[attachment cleanup by admin]