You are here:  » Only storing mapped products in db

Only storing mapped products in db

Submitted by PS on Thu, 2018-11-01 11:02 in

Hi David,

Is it possible to only store mapped products in the database?

I've just checked and we have around 500,000 products in the database, but probably show around 100 max on the frontend.

Maybe there are no performance issues with lots of rows, but I'd be happier with something more streamlined. Sometimes it's difficult to remove some categories from merchant feeds, for fear of not including a relevant product.

Thanks for any advice.


Submitted by support on Thu, 2018-11-01 11:10

Hi Tim,

That's all built-in (since 12/10A), called "Niche Mode", which only imports products configured in Product Mapping. To enable, edit config.advanced.php and change line 53 as follows;

  $config_nicheMode = TRUE;

(will be applied at next full import)

I know you've been running the script for several years now so if not supported in your installation let me know, it's straight forward to apply...


Submitted by PS on Sat, 2018-11-03 16:10

Ah brilliant, thanks so much, David! Worked great.