Select category to use for Google products plugin

Hi,

Sure.
You want to edit the file plugins/hikashop/google_products/google_products.php and for example, you could change the line:
$queryCategoryId = 'SELECT * FROM '.hikashop_table('product_category').' WHERE product_id IN ('.implode(',',$ids).')';
to:
$queryCategoryId = 'SELECT * FROM '.hikashop_table('product_category').' WHERE product_id IN ('.implode(',',$ids).') AND category_id NOT IN( XXX, YYY, ZZZ )';

Then, the categories XXX, YYY and ZZZ wouldn't be used in the XML feed.

That's quite complex as the system isn't supposed to handle that.
It automatically takes the prices of the user who is logged in and is generating the XML.
I would recommend to simply create a user with the user groups you want and access to the backend and then generate the XML manually with that user.

Otherwise, you would have to directly modify the function hikashop_addACLFilters in the file administrator/components/com_hikashop/helpers/helper.php which is the function used everywhere to handle user groups restrictions.
So you would need your plugin to set a global variable, for example in the $_SESSION, and then check it in that function to force the user groups check, and then unset it in the $_SESSION in the plugin before existing.

You're right, I forgot a condition.

In the code of the plugin, you can change the call to the getListingPrices function and add a fifth parameter witht he id of the user for which you want to load the prices.

Hi,

Yes ; that's what Nicolas wrote and that's what the SQL query is saying too.
" category_id NOT IN (x, y, z) " means that the category_id should not be in the list.

Regards,