Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Is it possible to get a Datafeed from sql?


cdamianou

Recommended Posts

Hi

 

Thanks for your reply, however i am pretty confused as to what you mean by Attach to the database using access, link the tables, and then run a query on it.

 

Do you mean Microsoft access?

 

How do i link the tables and run a query?

 

Thanks for your help

Link to comment
Share on other sites

Hi

...

Do you mean Microsoft access?

 

How do i link the tables and run a query?

 

Thanks for your help

There are several contributions for adding products from excel (for example).

 

Look for "Easy Populate" in the contribution area.

 

/Fred

Link to comment
Share on other sites

I think the questions here is about supplying a datafeed to kelkoo or other comparison shopping site.

Easy Populate could be used, but you'd have to manually do this as far as I know.

I believe some scripts have been posted in the past (check for "froogle").

 

As for using Access, you can often not connect with ODBC based tool to a live (unix) webshop, however, on local machine this is definitely a very handy way to look at your data.

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Hi i would like to get a datafeed of the following:

Product Name

Product ID

Product Description

Site Category

Price

Product Image URL

 

Is this possible, and how to i go about doing it?

 

Thanks

Yes, it can be done. I am working the one for Froogle as we speak. Froogle Data Feeder

Most likely your question has been answered, please do a search first.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...