Forums / General Questions / Simple xls product list

Simple xls product list

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

24 Feb 2009, 9:09 PM

mickmo68

Zen Follower

Join Date:: Apr 2008
Location:: Boston
Posts:: 129
Plugin Contributions:: 0

Simple xls product list

I was wondering if anyone knew of a way to export a simple xls or similar list of all my products. Maybe just product id & product title.
Thank you

24 Feb 2009, 10:16 PM

tapper

Zen Follower

Join Date:: Nov 2007
Location:: Upstate NY
Posts:: 233
Plugin Contributions:: 0

Re: Simple xls product list

If you install easy populate there's a choice to download your products to a txt file that Excel can open. Works like a charm. You can also upload/update your products when you change prices or descriptions or whatever, and you can upload specials with expire dates and sale prices.

Easy Populate module

26 Feb 2009, 3:26 AM

gharls

New Zenner

Join Date:: Dec 2008
Posts:: 25
Plugin Contributions:: 0

Re: Simple xls product list

You could also perform a query in phpAdmin and then export the query results to a spreadsheet:

Try

SELECT
a.products_id,
a.products_model,
b.products_name
FROM products a,
products_description b
WHERE a.products_id=b.products_id