X-Cart forums

[SamsonWebDesign]

I have just installed On Sale for a client and it's a great mod.
There is one small problem with the module that hopefully someone can help with which is to do with the Froogle or Google Base export function.

Now the prices are all discounted by On Sale when the customers does their export for Froogle it shows the full retail price instead of the discounted price.

Does anyone know how to get the Froogle export to use the On Sale discounted price?

[mmcelroy]

I tried looking through the code to see if there was a relatively easy way to implement this, but it looks much more difficult and involved than I anticipated.

My original plan was to hopefully modify the SQL query in modules/froogle/froogle.php to simply pull a discounted product price from onsale's SQL tables. This does not work, however, because it looks like the product discounts are calculated in real time with a call to modules/on_sale/onsale_product_functions.php.

What further complicates things is the way the discounts are stored in the onsale database tables. If you look in the xcart_onsale table in the xcart database, you'll see a field named "criteria" which holds almost ALL the info for the sale. Why all this info is jumbled together into one field is beyond me; I would think it should make more sense to make a separate field for each one of these values. If that were the case, it would be much easier to just pull the discount out of the table, calculate the sale price, and stick it in the froogle.php SQL query.

What also doesn't make sense is the representation of the begin/end date/time in the xcart_onsale table. So even if you figure out how to get a correct price into the froogle.php SQL query, you still have to figure out how to make sense of the start and end date/time so you aren't advertising prices for expired sales.

So maybe someone with more experience than I could figure this out for us, because this functionality would be quite useful (would save me time having to enter discounted prices manually into my google base import). Maybe Bill will see this thread and offer an easy solution - that would be nice too!