Some of you my be using CustomProperties in the bvc_Product table.
Looks like there is an issue with cloning products with CustomProperties.

I first found this in V5.4 Rev 5 and just now looked at the code in 5.6 which is the same.

\BVCommerce54\src\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb

Around line 1477 depending on version.



Problem is here the newProduct already has the full collection of CustomProperties.
So you are adding a second copy and then saving them.
What happens eventually is you will end up with huge entries in the products table.
As you clone other products from the cloned product it just gets worse.
Eventually category pages will not load or product detail pages will not load or it takes forever.
Also, whenever a bot visits the website you can be sure you'll lock things up.

So, again this only applies if you use CustomProperties and do a lot of cloning.
If another developer could verify this also it would be appreciated.

Yeah it is causing some issue on three websites I am working on.
A past developer added one custom property to the products table for a second product name.

Attached image, see the column CPropLength that shows just how bad it is :)
Jamming things up pretty good on all the websites that have been using cloning with CP

Working on a fix now to clean up the databases and adjusting the BVCore for cloning.

Matt, I do not think product type properties are an issue. CustomProperties are different and not available unless a dev adds them and those are the ones causing current problems.

Yeah it is pretty cool. Nice to use where you want to add a bit of information to the products table without adding an additional column.

Where you see "95 Gr. Pressure Formed Fusion Bullet - 20 Count Box" is a custom property name 2. Used on detail pages and for SEO.
http://www.outdooroutfitters.co...-ammunition-F243FS1.aspx

The tabbed info is product type properties and at this time I do not think there is any issue there. Just the Custom.