Print out of product listing

[FukienMan]

Is there some way in ZC of getting a grid listing (similar to a spreadsheet) that would show all your products at a glance?

[joejoejoe]

I asked the question a while back and was told no, but there were some workarounds. The easiest one, and the one I used, was to go to Reports - Products Viewed and just copy/paste into a spreadsheet. And to make that even easier, first go to Configuration - Maximum Values - Maximum Display of Products On Reports and set that to a high number so you can get a lot on one page and don't have to copy/paste so many pages. You end up with a spreadsheet with item ID, title, and number of ties viewed (and you can just delete the column with the number viewed if you don't need it.)

There are add-ons that create price-lists, but then you've got to modify your database and to just copy/paste the items viewed report was quick and painless.

[FukienMan]

It seems like that would only show you the items that the customers viewed, not your entire database. It also does not show the model number.
My purpose in needing this is to see all the model numbers (SKU numbers) mentioned in my other post. That way I have a print out of every thing for easy access to compare item to model number. Otherwise I don't know how I am going to know which item a customer ordered without having to go into my website myself and so a search.

[FukienMan]

Is there a way of going into my SQL database on the host server and making a print out? Or is that a dumb question?

[FukienMan]

So far this suggestion is one of the best and easiest, short of adding a mod, which I do not want to do.

Click "All products" under your Zen Cart site's category list, then print using your browser's print menu.

If you have a lot of products you are going to end up with an encyclopedia worth of paper printout. But you will only have to print this one time and then manual add additional items you add in the future.

The nice thing is that at the top of the page you have the filter drop down list to filter your products to suit you before printing.

I guess until ZC does an upgrade with a simple printable list of your products from the reports in admin, this will have to do.

[joejoejoe]

If you know the code you can write a query to get the data. Just looking at the tables in SQL isn't going to show you much if you don't know how the data in the different tables is linked.

There aren't any free add-ons that will generate a report. If you want to spend the money there is a product called zencart manager. The URL is zencart dash manager dot com (I tried 3x to put the URL in here and got nothing but hashes.)



The report view I suggested does show you all products - anything not viewed shows a 0 for number of views. But no, it doesn't show the model #.

Another option would be to do a view of all products as if you were a customer. But first edit your layout settings (configuration - product listing) to hide the image, set description to 0, turn on model #, turn off everything else, and then on configuration - maximum values you set the # of products per row to a high #, to get as many on one page as you can. Then just copy/paste nto a spreadsheet. (and then set the values back to where they were so your store doesn't look funky to visitors.)

[joejoejoe]

Looks like we were typing at the same time about the same thing. You don't have to print it, just change the layout settings first so you don't have all the info you don't need, and then highlight it with your mouse and copy/paste. No physical printer needed, no trees killed.