Convertproducts.asp

After you import products, the convertproducts.asp script reads through the products table and synchronizes the links between categories and products in the prodcategories table.

To overcome time limitations on very large databases, you can specify ranges of product catalogids, and convert chunks of the database at a time.

The normal VPCART product record only holds a categoryid and possibly a subcategory id. If you have products in multiple subcategories, you can create a list of these in the level3 field – for example 5,6,99,5.

Convertproducts.asp will then use this to update the prodcategories table and link that product to the categories listed in the level3 field.

Note: If youare using the level3 field for something else, you can change the field being used by editing convertproducts.asp and changing the following line to have a different field name.

const subcatfield="level3"