Hi

We've purchased and setup a BV 5 store on new hosting we want to import all of our data from our old site which is having different database structure. And we have identified that when we are adding product and options for product from admin section it is inserting records in multiplication of options. Example as following
Actual details we have

Product - Size - Color
======================
Product1 - 4, 5,6 - Red, Black, Blue
Product2 - 4,5 - Red, Black

In BvSoft Cart it inserts record like following

ProductName
================
Product1 4 Red
Product1 4 Black
Product1 4 Blue
Product1 5 Red
Product1 5 Black
Product1 5 Blue
Product1 6 Red
Product1 6 Black
Product1 6 Blue
Product2 4 Red
Product2 4 Black
Product2 5 Red
Product2 5 Black


There are some restriction for adding more product options and values so we edited some code in ProductChoices.aspx page so we can add all the values.

For testing we added 1 products with all the options and option values then it has added 350 rows in bvc_Product table; creating all the combination for the product.
It is taking long time to insert and update product details.

We have 2000 products and each product have 10 options like size, colors, fabric type, etc and options also have many values then you can imagine how many records will be get inserted into database.

Has anyone else encountered this issue? Can anyone point me in the right direction? Any assistance would a great help.