Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy populate, specials and froogle?


cgchris99

Recommended Posts

  • 5 months later...

I am using Easy Populate 2.72 for MS2.

 

When I upload to froogle, the specials aren't sent. It just shows regular price. Anybody having the same problem? Any suggestions?

 

Thanks

James

Link to comment
Share on other sites

  • 5 months later...

There is an error in EasyPopulate. It might be fixed in the latest versions, but it's in my copy.

 

In the file easypopulate.php, around line 500, you will find:

 

  if ($dltype == 'froogle'){
	 // For froogle, we check the specials prices for any applicable specials, and use that price
	 // by grabbing the specials id descending, we always get the most recently added special price
	 // I'm checking status because I think you can turn off specials
	 $sql2 = "SELECT
  	 specials_new_products_price
   FROM
  	 ".TABLE_SPECIALS."
   WHERE
   products_id = " . $row['v_products_id'] . " and
   status = 1 and
   expires_date < CURRENT_TIMESTAMP
   ORDER BY
  	 specials_id DESC"
	 ;

 

The problem is expires_date < CURRENT_TIMESTAMP, it should be expires_date > CURRENT_TIMESTAMP.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...