Forums / Setting Up Categories, Products, Attributes / How to print list of product id's

How to print list of product id's

Locked

Started by mcpisik on 9 Mar 2008, 10:54 PM · Views: 2,781

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
9 Mar 2008, 10:54 PM
#1
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

How to print list of product id's

Hi,
I'd like to print a list of my product id numbers, so that I can use them to input my cross sells quicker. And also for linking products to other categories i'd like to print category id's.
Any place to easily do this?
Many thanks...

10 Mar 2008, 1:13 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: How to print list of product id's

I do this via phpMyAdmin.

Just navigate to the "products" table, then export it as a csv file, (or other file type if you wish)

20 years a Zencart User

11 Mar 2008, 4:35 AM
#3
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

Re: How to print list of product id's

schoolboy:

I do this via phpMyAdmin.

Just navigate to the "products" table, then export it as a csv file, (or other file type if you wish)

Awesome! That was rather simple. I've always avoided the phpMyAdmin stuff thinking it was not my field, but it's really not that bad is it.
Appreciate your help. Hadn't even thought of looking there to do it...

11 Mar 2008, 1:11 PM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: How to print list of product id's

Tread cautiously when working in phpMyAdmin... doing simple "exports" ought not to compromise any data.

Until you are familiar with MySQL and phpMyAdmin, it's always a good idea to put your store "down for maintenance", then backup the database, and then play around in phpMyAdmin...

20 years a Zencart User

12 Mar 2008, 4:13 AM
#5
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

Re: How to print list of product id's

Ah, good point. I'll put on my sneaking shoes and tread carefully.
Thanks...

17 Mar 2008, 1:18 PM
#8
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: How to print list of product id's

johnd:

But Easy Populate doesn't have a column for the Product ID.

John

Ah, yes. That would be products_model. It would not be hard to add product_id though.