froogle exporter

[varnco]

Love the froogle exporter contribution, but I've found that it also exports items that are out of stock.

 

Trying to find out how to modify the code so the out of stock items don't show up in the export file.

 

I'm sure i'm not the only one that has this issue. Has anyone found a solution to it?

 

I've take a few attempts at modding the code to no avail.

 

Any help is appreciated.

[varnco]

I found an old post that explained that one had to edit the code a bit

[Guest]

Thank you for letting know you solved it but can you post the link to the article that you found.

It would help others.

 

richard ;)

[varnco]

These are the instructions I followed, however, I added what the below copy indicated, everywhere I found a similar "where" statement throughout the froogle.php file.

 

Just changing it in one location, as described below, didn't work for me.

 

Cut n pasted--------------------------------------------------------------------------------------------

Here is a fix get the Froogle upload file in EasyPopulate to only list the items that are in stock. You'll have to add this line somewhere around line 1164 in easypopulate.php.

 

CODE

 

 

AND

 

p.products_status = 1

 

 

 

 

CODE

 

 

$filelayout_sql = "SELECT

 

p.products_id as v_products_id,

 

p.products_model as v_products_model,

 

p.products_image as v_products_image,

 

p.products_price as v_products_price,

 

p.products_weight as v_products_weight,

 

p.products_date_added as v_date_avail,

 

p.products_tax_class_id as v_tax_class_id,

 

p.products_quantity as v_products_quantity,

 

p.manufacturers_id as v_manufacturers_id,

 

subc.categories_id as v_categories_id

 

FROM

 

products as p,

 

categories as subc,

 

products_to_categories as ptoc

 

WHERE

 

p.products_id = ptoc.products_id AND

 

ptoc.categories_id = subc.categories_id AND

 

p.products_status = 1

 

";

 

break;

 

 

 

}

 

$filelayout_count = count($filelayout);

 

 

 

 

Hope this helps.

------------------------------------------------------------------------------------

 

I downloaded the above instructions, so I always have them, and that way, I know what I've moded from the original files. So, I don't have a link to the actual online forum, but it was dated August 2003.

 

I hope this helps.