Printable Price list :: support thread

@Paulm - my new best friend. that code works brilliantly. just needs a little bit of neet and tidy to make the print out look correct - the table headings are a little off - but i'm hoping i know enough coding to fix it....should just be a <td> somewhere i hope :smile:

thanks again buddy! now all i need to figure out is how to make it so that it is only accessible if the client is logged in....

paulm:

Of course these definitions should actually be moved to the database settings and language file.

Hey Paul - just having a little difficulty - getting the table heading to read: ID, Item Name, Price - think its because i haven't quite followed this step. Are you able to give me a bit more info...sorry - im ok, but not great at coding!

Ta,

Josh

Nevermind, i found the piece of code that was going wrong....

Line 449 of header_php.php

if (PL_SHOW_MODEL == 'true') 

needed to be changed to:

if (PL_SHOW_PRODUCTS_ID == 'true') 

Only thing is - there is no switch made for the front end to turn this on and off...might have a look at that in the future and send it to you for a future update...

Cheers!

Hi,

I've just installed this in a ZC v1.38a after following the readme instructions but the price list page displays this:

ERROR! Profile does not exist, loading default Profile instead. (3)
Gym King Printable Price List
Displaying 0 products, click on the links for detailed product information.

No products or categories match your query, please make another selection.

http://www.gymking.com.au/index.php?main_page=pricelist

In the Admin the Price-list Profile-1 page has nothing on it, i.e. I can't ADD anything? Am I meant to be able to do it all through the admin? I've checked the product pages in Admin but there is no option in there to say Add This Product to the Price List.

Not sure how this works or what may have gone wrong??

I guess something went wrong with the sql and probably an error message was returned when you tried to install it. Probably most configuration values are missing now, and that is why it does not display the products.

You can not add any products to the price list, it just shows the products you have in your shop.

This mod is exactly what I have been looking for as we get many customers asking for a catalogue - thanks a lot!!!

I have installed it and it seems to be working almost perfectly so that is fantastic. Just one question:

I have set up two profiles - one to show images/descriptions and another to show products without images. The first profile (default) shows the currency and category drop down boxes but when you select the other profile (no images or profile-2), these disappear. I really need to be able to select categories for the No-Images profile as well as for the default profile. Is there an option I should be selecting for this?

Also, something is going a bit screwy with the printing setup for the No-Images profile and I cant get it to print on A4 pages neatly like the default but I guess I'll keep playing around with it until I sort it. Would really appreciate an idea on the other question though.

url is here:
http://www.aussiesapphire.com.au/index.php?main_page=pricelist&profile=1

cheers
Leah

PaulM,

GROUP PRICING ISSUE

Love the mod - great work.

I have a number of Group Pricing groups and the mod supports this well EXCEPT it still shows the "default" price (before any group discount) on all of the lists.

Am I missing something or does it only show the one price level?

Thanks for nay advice in advance.

Max

aussiesapphire:

The first profile (default) shows the currency and category drop down boxes but when you select the other profile (no images or profile-2), these disappear.It's a setting:
Boxes
If true boxes are shown (to switch languages, currencies etc).

true
falseand it's set to false by default for profile 2

@FuzzyBunny: I don't use group pricing myself, but it appears that Zen Cart itself does not calculate and show the discount directly, only at checkout. And because the price list uses the same functions as Zen Cart, the price list won't show the discounts. And it's not a pricelist option or feature to show it either... so it won't work I am afraid.

thank you PaulM,

that fixed it. I thought it must have been something simple but between checking the settings one way or the other, reloading the page to check, I must have missed that one.

Still working on the printing problem but I think I'll work that out. Should have settings the same for both profiles but there must be something different there.

Thanks for helping on the other.
Leah

cancel the printing problem - was a "shrink to page" setting which I remember reading about on this thread. Was looking for a difference in the Printable Price List settings between profiles but it was the printer settings that had me tricked - was set on one profile but not the other which is weird but problem solved anyway.

cheers
Leah

Thanks PaulM,
I'll have to keep doing the adjustment in Excel and send out manually for now, I'll see if I can work out how we may be able to use the "online group pricing" mod (which we also use) to reflect the Group values in the list somehow - must be a way - hopefully I can find out and post it here!!!

Additoinally, is there a way to NOT LIST ITEMS WITH STOCK BALANCE ZERO.

This is because we sell flowers - some flowers are only available seasonally, so we have the sotck balance at zero, but leave the item active so that people know that wedo stock that item when it IS in season (eg. peony rose only availabel for two months, but we want everyone to know we have it when it is available, so a wedding person for example can plan to have them at that time). Perhaps this is possible with the "available" date setting in the products?

Any guidance greatly appreciated.

products_date_available and products_quantity are both stored in the products table, so it would be a relatively easy modification to add a "WHERE products_quantity > 0" or a similar products_date_available condition to the price list module query.

I'll see if I can work out how we may be able to use the "online group pricing" mod (which we also use) to reflect the Group values in the list somehow - must be a way - hopefully I can find out and post it here!!!I am sure a lot of users would be interested :smile: (and if that mod shows the discount prices directly it's probably easier to implement than then the zen group prices)

Just one more little question and I hope it hasnt been asked before. I vaguely remember something similar but just trawled through the whole thread and couldnt find it. Apologies if has been answered before.

I would like to exchange where the model number displays for the Product ID# allocated by Zencart. I am using the Printable Price List as the basis for our catalogue and rather than re-do a whole new numbering system, thought it would be simpler just to use the category and product numbers used by the zencart database but these need to be displayed for customers to refer to them. Product ID is the main one needed and it can be just a straight swap for the Model Number.

All else is exactly as I need.

cheers
Leah

Hi Leah,

I posted a message about the products id display here:
http://www.zen-cart.com/forum/showthread.php?p=550813&highlight=products_id#post550813

A modified header_php.php file (which is needed to display the products_id) is available a couple of posts below that message.

good luck

Thanks Paul - I thought I remembered seeing it but couldnt find it anywhere. Thanks for pointing me in the right direction. I think I can work it out from those pointers (I hope?? - pretty sure I can do it).

Realy appreciate your work on this - easy to install, does exactly what it says without complication and is making my work a great deal easier.

cheers
Leah

HELP !!! Broke my price list - cant fix it. Was trying to do the modification to get products_id to show instead of model number. Downloaded the new header_php file and uploaded it to my site. Backed up the old header_php file (just renamed it so I could revert back to it if necessary). Couldnt get the new one to work so while checking it out, renamed the old one back to header_php.php. One renaming back to the old version worked but the second time I went back to it, the whole thing went blank on me.

Now all I get is a blank page. Cant work out what to do. Have tried uninstalling and reinstalling but still cant get past the blank page.

My price list is here:
http://www.aussiesapphire.com.au/index.php?main_page=pricelist

In the reinstall, lost my settings but made a record of all of them so no problems there. Just need a pointer on how to get the pricelist displaying again.

Probably something totally basic and obvious but can anyone help me out here. Sorry to be a nuisance - thought I was pretty safe when I had the old file ready to put back but obviously it is not quite as simple as that.

cheers
Leah

Cancel the main panic - I've got it displaying again by changing the name of my renamed "new" version of the header_php file. It seems to have been getting confused as to whether to use the old or new file.

Got an error message on one of the profiles but I'll work on that next. Sorry for the false alarm.

Leah

Hi,
I would like to know if I want to add custom links below the logo which file should edit?

I am using pricelist on 1.38 no header and footer just logo enabled in my pricelist.

Thanks

Hi,

Can we convert the printable price list to PDF format?

The price list does not support PDF output. But, if it's for your own usage, you can use a print to PDF tool to create a PDF file from the price list. I think a FF addon exists that can do that for you, and there a several other (free) solutions available.