apply a kit to multiple products

[zanzor]

I have created a kit and attached it to a product. I then used dataport to export product data. Was surprized that kit info was not displayed. I woild like to apply the same kit to all 30,000 products we sell. Is the np faster way other than one at a time on the admin section??? Thanks for any help.. tim

[zanzor]

Using version 7.0.7

[jmestep]

You would have to do the hookup one at a time or do something in the database.
Able has a page to add an existing kit component to a product, but they don't show the link in the admin. It is:
Admin/Products/Kits/AttachComponent.aspx?ProductId=4871
You would change the productid to the one you want to work on.
You can hook one up that way, then look in the database to see what got changed.
It is probably the ac_ProductKitComponent table

[zanzor]

I have added the kit to one "test" item.
I have downloaded the product data using the Dataport software, but it has not fields talking about the Productkitcomponent listed.

Is their another way to get direct access to the database?

My test site is on a dedicated Windows server...

Thanks for the help so far!!
Tim

[jmestep]

If your hoster doesn't allow you to have database access for security reasons (most don't allow it), then you would need to create a script to run thru an admin page. If you look in the Install folder for an upgrade version of the software, you can see how Able does it for an example.