Inventory Report with Attributes

[brad512]

Hello, I am trying to write a small php script to report on my inventory levels as well as prices. For the most part the PRODUCT_TABLE is just fine, but when it comes to products that may have attributes set for size and price the information is a little more difficult to glean. Could any one tell me if there is documentation available that would explain the layout and functionality of the attribute and option tables? Or perhaps there is a module available that would be able to do the job.

Thanks

Brad

[kobra]

Unfortunately, I do not believe that there is documentation for what you desire. There are 3rd party Report generation packages that might ease your quest.

Alternatively, if you can dicipher the php, you might look at how the product info page is constructed with attributes as a lead to what tables are sought.

[brad512]

Thank you for the response.

I spent the night inspecting the tables:


TABLE_PRODUCTS
TABLE_PRODUCTS_DESCRIPTION
TABLE_PRODUCTS_OPTIONS_VALUES
TABLE_PRODUCTS_ATTRIBUTES
TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK

Looks like I should be able to get what I need from there.

Brad

[kobra]

Not positive what you want to include but it appears you are looking in the correct places

[brad512]

Finished it!

now the book-keeper will be happy.

We have the stock with attributes installed so that made it interesting.

If any one would like to have it I have placed it

http://edgewatergifts.com/custom/inventory.zip

the script expects to see "abc" as a Parameter eg.

yourdomain.com/inventory.php?abc


It also expects to have a directory named feed with write permissions.

The script needs to run from the root directory.

This script will not work with out the attribute with stocks module installed. There is also minimal error checking.

Brad

[kobra]

Brad,

If you are so inclined, you might package this up with good instructions and contribute it.

There may be others that could benefit from your efforts.

[brad512]

The intention was to have a simple script that could run on it's own from a command line. I am not sure if others would find this script useful as it sits now - but perhaps components of it could be used.

I am kind of hyped with my accomplishment (small things amuse small minds!), that I have decided to write another script that looks for orphaned image files in the image directory and it's sub folders. Sort of an aid to house keeping.

Thanks for the comments

Have a happy new year

Brad