Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

StoreFeed ver 3.3 getting SQL error.


zeeshop

Recommended Posts

I installed StoreFeed ver 3.3a for products feeds in kelkoo uk system.

 

After installation when I attampted to run file it gives me following error.

": SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'https://www.zeeshop.co.uk//product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'https://www.zeeshop.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' ORDER BY products.products_id ASC "

 

please advise me what should I fix in order to run this file succesfully to get feed for kelkoo or any other shopping search engine..

Or if there is any better contribution available for this purpose.

 

Regards

 

zee

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...