Pulling inventory from database

[beyre]

A client needs to submit information to a potential buyer and we need JUST the following data:

Product # (model number, however you want to label that as)
Product Name/Title
Price

When I'm in the database via MyPHPAdmin, and click on "Products" - I got the Product # and Price ... but no Product Name/Title.

And none of the subsequent "product_" choices have that information.

So, how do I do this? Will I have to go to the store and copy/paste in the product name/title into the spreadsheet by hand?

Just to clarify, I do NOT need the "product id", the one generated by Zencart when you add the product. I need the product # WE assign (model number, again, whatever you want to call it).

[fe1lho]

You have the products_model, products_price and products_description

Does it help ?
Pascal

[beyre]

Problem is the product_model and product_price are under "products" and product_name is under "product_description". That's 2 separate exports. I am including product_id in both because I going to try and combine the two using that one common factor that is in both sets of data.

When I do the product_name is under "product_description", and try to open the downloaded notepad file into Open Office spreadsheet, it doesn't give me the screen to do tab delimited so the contents show up in neat columns. I am able to do that in other file.
So, since I can't easily read this 2nd file, I can't combine the two.

Again, the clarify, the ONLY data I need is:
product_name
product_model
product_price

No product description, no product ID (zencart generated number).

Now, databases/MySQL/MyPHPAdmin and I are not friends. If there is an easy way to do this, please give me step by step. I can do an easy export, but combining data from several sub-sections of a database is beyond me ... hence why I'm trying to combine two sub-sections of data.

[beyre]

Ok, I got the 3 pieces of data, plus product_id (for reference) into one spreadsheet by exporting "products" and "product_description".

But OMG! There is no way to combine them. Some of the product_id numbers have been combined with other data.

Some I have been able to put where they belong, but others are so cut up and mingled among another product_id's info that I don't know which is which.

And there are even some product_ids without any other information!

And, until I can get all the product_ids sorted, I can't do a sort by product_id so that I end up with both sets of data together:

(1 product_model product_price
(1 product_name
(2 product_model product_price
(2 product_name
(3 product_model product_price
(3 product_name

With all the clean up I need to do, it would be just easier to do this manually.

Is there anyway to just literally export: product_model, product_name, and product_price only (and they match up correctly) ??????

[apsona]

You can do this quite easily with Apsona ShopAdmin. Just create a product report, add the three fields you want, run it, and export the results.

Hope this helps.

Apsona
http://apsona.com