This idea is attributed to Scott Gaines.

Current functionality allows for importing the Replenishment Template header and line details, however, there is no means to create the query definition for the item number and location ID. This has been done through a lot of tedious manual input or done as a system modification. The modification takes the ITEMNUMBER | LOCATIONID which is placed in the DESCRIPTION field of the Template Line (through the use of the replenishment line template. The item number and location ID are separated by a vertical hash mark. Then we created a function that selects the ITEMNUMBER in the description field and writes it to the Item number (or product variant) in the query definition then selects the LOCATIONID to the right of the vertical hash mark and writes it to the Location ID field on the query definition. Then we created a function in the menu structure to read the values in the Replenishment Line Detail Description field and create the corresponding query definitions for each Replenishment Detail record. This same process can be used for products and product variants. There are probably other ways to address this issue, but this is what we've done repeatedly for our clients.