Jump to content



Photo
- - - - -

i need to export all product URL's to a spreadsheet.. possible?

export product urls

This topic has been archived. This means that you cannot reply to this topic.
6 replies to this topic

#1   garf90

garf90
  • Members
  • 46 posts

Posted 02 April 2012 - 19:06

We are using OSC 2.3.1 and have a client that (for amazon store purposes) needs to export ALL her product urls from her store to a spreadsheet (exel, CSV etc). We cant think of how to do this as they are dynamic so Easy Pop or SQL wont work.

Anyone got any ideas on this?

Cheers
Garf90
Garfield: WP Online Store. "The osCommerce plugin for WordPress"

#2 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,523 posts

Posted 02 April 2012 - 19:21

We are using OSC 2.3.1 and have a client that (for amazon store purposes) needs to export ALL her product urls from her store to a spreadsheet (exel, CSV etc). We cant think of how to do this as they are dynamic so Easy Pop or SQL wont work.

Anyone got any ideas on this?

You could use the googlefeeder addon. You would need to edit the feed file or change the code to only give the urls but it will work.

#3   garf90

garf90
  • Members
  • 46 posts

Posted 02 April 2012 - 19:45

Great idea Jack

Will look into that, sounds like just the job.

Cheers
Garf
Garfield: WP Online Store. "The osCommerce plugin for WordPress"

#4   garf90

garf90
  • Members
  • 46 posts

Posted 02 April 2012 - 20:57

hi Jack,

can you point me in the right direction to the plugin you're referring to?

http://addons.oscomm...ch=googlefeeder
Garfield: WP Online Store. "The osCommerce plugin for WordPress"

#5   multimixer

multimixer

    Lemons or Melons ?

  • Partner
  • 4,560 posts

Posted 03 April 2012 - 05:14

Following thought:

The products url look like this www.my_store.com/product_info.php?products_id=28

It consist of 2 parts

1) Same for all: www.my_store.com/product_info.php?products_id=
2) Variable: The products id eg 28

All product ids exist in the DB and can be exported in various ways (via phpMyAdmin as csv, using easy populate etc).

Having such a csv with the product ids, you just need to put the fixed part in front, excel has such a function I think

#6 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,523 posts

Posted 03 April 2012 - 12:41

hi Jack,

can you point me in the right direction to the plugin you're referring to?

http://addons.oscomm...ch=googlefeeder

It is this one.

#7   garf90

garf90
  • Members
  • 46 posts

Posted 03 April 2012 - 12:59

thanks multi, if the google feed option doesnt pan out I will give it a go

Chhers
garf
Garfield: WP Online Store. "The osCommerce plugin for WordPress"