Copying the Entire Variables Section

[Pratik Fullont1]

I want to copy the entire Variables Section from the Parent RITM to the Child RITM. Can anyone please tell me how to do it?

[Mark Roethof · Accepted solution]

Hi there,

There's no out-of-the-box function for that. What you could do, is create new M2M records to those variables to your other RITM, that way you don't need to also duplicate the variable records.

[Pratik Fullont1]

In which table to create the M2M records? Can you please showcase me the steps? Thanks!

[Mark Roethof]

When a RITM is created, the submitted Variables are stored in several tables. Amongst them, sc_item_option. That table though, has NO direct reference to the RITM! That goes through table sc_item_option_mtom, a many to many table.

So you could use that many to many table to your benefit. Just creating new many to many records to the existing sc_item_option records and with your new RITM.