Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Export TAB/CSV for PriceComparison.com


linuxguy

Recommended Posts

Dear All...

 

Does anyone have any experience of doing a product / inventory list export

to CSV / TAB ?

 

I am trying to submit my products to PriceComparison.com they are offering free trial period during xmas 2004.

 

Pls help...

 

Here is their data feed format in PDF:

http://www.pricecomparison.com/doc/product_feed_format.pdf

 

 

Any help would be appreciated.

 

LinuxGUY

Link to comment
Share on other sites

Hi LinuxGuy,

 

There is a real easy way to do this. Install PHPMyAdmin on your web server, configure it to talk with your database meaning you must know your database servers address, user name and password.

 

Login to PHPMyAdmin and you have to option to export any table you feel like.

 

PS All your product information is stored in Products and Products_Description and if you have product attributes then in products_options_values_to_products_options.

 

Oh and the retail price shown in the products table is your default currency, so if you want them in some other currency then you will have to adjust your price accordingly.

 

Basically, its pretty easy to do if you have PHPMyAdmin and knowledge of SQL syntax.

 

The hard part is ensuring you select the correct price if you have products attributes contribution installed if you dont then its a simple two table query using products (products_id, products_retail_price) to products_description (which gives you the products description and I think name)

 

Hope that helps you out

While I'm operating on OSCommerce, I don't have to worry about silly vitals or forgetting to turn off the ane..the.. no wait I remember aes....thetic, or right I've got it Anaesthetic

Link to comment
Share on other sites

  • 2 weeks later...

Or you can just install EZPopulate and use the Export Froogle file option, and upload that. Poof, done!

 

- Brian

Simple Template System (STS)

Layout your site with 1 (or more) HTML file!

Download STS: http://www.oscommerce.com/community/contributions,1524

Support: http://www.oscommerce.com/forums/index.php?showtopic=58541

Link to comment
Share on other sites

  • 2 years later...
  • 1 month later...
  • 1 year later...

Are you in some way involved with shop mania? Is this your own site?

 

 

I have installed the recommended shop mania file, however I receive the following comment on opening the file

 

"A file permissions error has occurred. Please check the permissions on the script and the directory it is in and try again." It is in the default directory and I have not made any changes to it the security is 777. However I do have password protection on Admin for obvious reasons.

 

What am I doing wrong. I am by no means technical however have managed to created a fully up and running e-commerce website with the help of the forum. So any advice would be greatly appreciated.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...