Printable Price list :: support thread

I have installed v1.3.7 on Zen Cart v1.3.7.

I think it could be the prefix ..... what do I need to do to change this?

Thanks

trevor4370:

I have installed v1.3.7 on Zen Cart v1.3.7.?
I think it could be the prefix ..... what do I need to do to change this?The sql tool does not always work, but if after copy and paste into the sql tool textarea you get the succes message (Like: "Success 117 statements processed."), and no errors, I am quite sure the sql has been entered succesfully to the database (including the table prefix) of the shop you're logged in to. But the error you get indeed indicates the sql has not been added succesfully to your shops database, so if you want to try it using phpMyAdmin anyway: if your table prefix is "zen_" for example you should add "zen_" to all table names like "configuration" and "configuration_group" (so they become "zen_configuration" and "zen_configuration_group").

Hi
I've got the pricelist working on 1.3.7

except the first 5/6 pages print okay - then it seems to lose the page break and not keep to the A4 size. It sems to print half a table on one sheet and then start a new catagory halfway down a page. The footer would also print over previous table

I have the profiles set to start new table and new page.

Same thing happens in landscape.

Any ideas how to restore the page layout/margins/page break?
John

I guess no one has an idea why this is happening :unsure:

It looks that the description field has a preset number of lines, so if the products have different description length that means that the whole pricelist will print incorectly. That is my guess.

Well I had pricelist working until I tried installing the admin tool for access rights. That didn't go well so removed admin tool.

Now I just found out my Pricelist tool doesn't work.

Problem:

I see the price list and the profiles in the admin -> config
But when I go to the link

index.php?main_page=pricelist

It just re-displays the whole admin's panel.

I removed the whole pricelist and reinstall it twice.
Still same thing.

Please advise!

Thanks

wdrx02:

when I go to the link

[SIZE=2]index.php?main_page=pricelist

It just re-displays the whole admin's panel:blink: :shocking:
Really weird. I guess some files or modifications of the "admin tool for access rights" (which i don't know anything about) have ended up in your catalog while they should probably be applied to your admin files. I really don't believe that there is way that the pricelist can show anything of the admin, it does not modify any files and it's totally unrelated to the admin (exept that the pricelist settings are controlled by the admin of course).

I would undo the other mod asap, or go back to your latest working backup....

paulm:

:blink: :shocking:
Really weird. I guess some files or modifications of the "admin tool for access rights" (which i don't know anything about) have ended up in your catalog while they should probably be applied to your admin files. I really don't believe that there is way that the pricelist can show anything of the admin, it does not modify any files and it's totally unrelated to the admin (exept that the pricelist settings are controlled by the admin of course).

I would undo the other mod asap, or go back to your latest working backup....

I tried copying some original files from a new full download of Zencart, same thing. I uninstalled, reinstalled pricelist mod and I rechecked that no "admin tool profile" was there.

Same.... I do have a backup but I already done a lot of changes within the past 1-2 days and haven't got a chance to backup! doh! any other ideas? Help!

I got 78 statements of the following:

ERROR: Cannot insert configuration_key "" because it already exists

Did I miss something?

nvm... trying something else..

Tried renaming the configuration and configuration_group to reflect my prefix name and for some reason I get this:

 #1146 - Table 'belladon_cart.configuration_group' doesn't exist

belladon_cart is my database name... I'm not understanding what the problem is.. :(

OK, I fixed the one problem but I still have the 78 statements of:

ERROR: Cannot insert configuration_key "" because it already exists

When going the URL of http://www.belladonnascauldron.com/index.php?main_page=pricelist, I recieve the error of:

"ERROR! Profile does not exist, loading default Profile instead. (PL_DEFAULT_PROFILE)"

Anyone? Any idea?

paulm:

Don't forget to add your zen db prefix then! (if any)

By default the default profile is 1 and it (PL_DEFAULT_PROFILE) should be defined by this setting in the admin (admin: configuration: pricelist settings):

Which pricelist version is it that you installed? On which Zen Cart version?

edit:
That reminds me! :-)

what do I replace with my database name?

AvieLF:

what do I replace with my database name?You don't replace anything with your database name. If you want to enter the sql using phpMyAdmin you need to add the prefix to the table names (this is the same prefix you may have entered during the Zen Cart installation). So "configuration" becomes "zen_configuration" for example (if "zen_" is the prefix you're using), and "configuration_group" becomes "zen_configuration" then.

has this been updated to accomodate 8.5 x 11 yet?

I really need some help here. First of all I must say thanks. It is great module.

I just don't know what I have done wrong!!

I have the profile 1 enabled and nothing else and I am just using this to print myself to pdf for sending to particular clients via email.

Anyway I am having a problem with the incl tax coloumn. It is not showing the amount with the tax it just shows the same as the ex tax. I am in California and I have the state sales tax of 8.25%. I would like to have the correct amount with the incl tax coloumn showing, so what do I need to do??

I have a strange request from I fellow I am working with on his site. He wants the pricelist, minus the prices. Any easy way to hide the pricing. He wants to use more as a catalog of product images, descriptiions & size. Thanks!

Can this printable price list be open within the site instead of opening a new page??

has this been updated to accomodate 8.5 x 11 yet?There are rumours (and it's very likely) that some people have done this, but as far as I know it's not publicly available. The mod does not include a stylesheet for 8.5" x 11"

@supersnow: the pricelist only show inc. tax prices if the prices are shown inc tax in your shop. So I assume your shop is not setup to show inc tax prices.

@loosecannon: actually I think an option to disable the prices should be added and you request is not strange :-) Because early version were made to replace an existing static pricelist making the prices display optional didn't cross my mind at the time. If I find the time to upgrade I will probably add this option (but don't hol your breath ;-) )

@sal4888: the pricelist is not desigend to open within the site. Some parts would need to be recoded for that (it uses it's own main layout so the site layout won't interfere when printing it).