Removing unmapped products

Submitted by allanch on Mon, 2011-08-22 09:50 in Price Tapestry

Good morning David,

I hope you're well. I have a quick question that I hope you can answer. I'm thinking about removing products which haven't been mapped in a niche site. Can you advise if this is a good thing and what is the best method? I'm thinking of a mysql query that deletes all where `name` does not equal `original_name`. IS this the best way? Thanks

Hi Allan, If you're running

Submitted by support on Mon, 2011-08-22 10:28

Hi Allan,

If you're running 12/10B, this is exactly what "niche mode" will do. To enable, change line 53 of config.advanced.php as follows;

$config_nicheMode = TRUE;

Otherwise, it's very easy to set the equivalent function by making a small change to includes/admin.php. Look for the following code around line 297:

if (!$importRecord["merchant"]) return;

...and REPLACE with:

    if (!in_array($importRecord["name"],$admin_importProductMappings)) return;

    if (!$importRecord["merchant"]) return;

Cheers,
David.
--
PriceTapestry.com

Thanks for the speedy

Submitted by allanch on Mon, 2011-08-22 10:39

Thanks for the speedy response David! I have 12.10a but with the upgrads in place. I forgot about niche mode, I'll enable it and give it a shot.