Possible to run a report on 'quantity'?

[Guest]

Is it possible to run a report somehow or bring up on screen the quantity of all products in a category?

 

I need to do an inventory and cross check it to be sure everything is accurate, but I don't want to have to individually open each product and check what is there

[Rumble]

Theres probably a contribution but a way to do it is browse the table in phpmyadmin, or whatever database editor you use!?

[Guest]

Oy vey.

 

"Browse the table in phpmyadmin" -- in English, how do I do that? :)

 

I can get into phpmyadmin to do a db dump but haven't done anything else ....

[guntersammet]

Try to run one of the 2 following queries in phpMyAdmin:

 

 

#This one displays all products (including the inactive:

SELECT DISTINCT cd.categories_name, count(*) AS summary FROM products p, products_to_categories ptc, categories_description cd WHERE p.products_id = ptc.products_id AND ptc.categories_id = cd.categories_id AND cd.language_id = 1 GROUP BY ptc.categories_id ORDER BY cd.categories_name

 

#This one displays only the active products

SELECT DISTINCT cd.categories_name, count(*) AS summary FROM products p, products_to_categories ptc, categories_description cd WHERE p.products_id = ptc.products_id AND ptc.categories_id = cd.categories_id AND cd.language_id = 1 AND p.products_status = 1 GROUP BY ptc.categories_id ORDER BY cd.categories_name

 

 

 

If you don't know how to execute a SQL statement in phpMyAdmin, please reply and I'll try to give you a step by step instruction.

 

One thing isn't in consideration with these 2 statements. If you have a product linked to more than one category, it will show as a count in each category.

 

HTH

 

Gunter

[Guest]

Somehow I think you misunderstood me -- I said ENGLISH, not more TECHNO GEEK language

 

:)

 

When I said 'run a report' I meant can't I click something from within the admin panel and have it show a column with product, quantity, etc, so I can look at the screen, compare it to my hand-written list, and make notes on what to fix?

 

This myphpmyadmin thingie scares me

[Rumble]

Lol cheeky bird,

 

Plain answer no! Look in the contributions there might be something there.

 

:P

[guntersammet]

Sorry if this is too techie for you. You mentioned that you can do a DB dump in phpMyAdmin, so I figured you should be able to execute this query as well. This gives you a nice listing of all the categories (including names) and the product count. It's pretty easy to do and I don't consider that very techie.

I checked the reports contribution (http://www.oscommerce.com/community/contributions/category,12) and I didn't see anything there and I don't feel like writing one at the moment. Maybe there are some other takers. The SQL statement I wrote is already about 50% of the work :-).

 

In case you want to try the phpMyAdmin version with one of the 2 statements, follow these simple instructions:

 

-open phpMyAdmin

-Select you DB

-Find out where you can execute a SQL query. Depending on your version it's a text area field (Run SQL query/queries on database shop) on the first page after the listing of all the tables. In other versions there is a tab on the top which says SQL.

-Copy one of the 2 sql queries and paste it in the text area.

-Press the execute button.

 

HTH

 

Gunter

[mugitty]

Pam;

 

You might want to take a look at the "Quick Update" contribution:

http://www.oscommerce.com/community/contributions,122

 

• Choose between 10 -> 100 items per page

Selectable by category

Shows Model, Name, Status, Weight, Quantity, Price, Tax Status

Can be sorted by any of the above, ascending or descending

[Guest]

I will try this later. I only learned how to do a db dump 2 days ago, so I'm not quite at expert level yet

 

:)

 

Coming here is like stumbling into another country and not knowing the language and praying you can find a translator

 

Cheeky, indeed :)