Where are variables stored for order guide?

[Deepak Negi]

Hi All

We come up with a requirement in which we want to get the order guide variables. For catalog item, variables are stored in "sc_item_option_mtom" table. Do any one have an idea about where order guide variables are stored.

This is what I need to do:

1. Whenever an order guide is opened we have some variables associated with it.

2. i need to create a macro, on click of which:

        a. list of all the submitted order guides will open

        b. selecting any record will populate the previous variables submitted for that particular record.

Basically I need to make a template functionality for order guides.

3. We have already created it for Catalog items now we need to configure the same for Order Guides.

All suggestions are welcome!

Thanks

Deepak

Message was edited by: deepak negi

[Brad Tilton]

I believe those variables are only used temporarily to determine which tabs get created on the next page. You may have to do something a little more manual where you do something in an onsubmit client script on the order guide that stores the values as a template somewhere.

[Uncle Rob]

Man its been a while since I've used Order Guides.   But aren't they set up to 'cascade' to the Requested Items created if those items have variables of the same name?

[Deepak Negi]

Yes

Then I have to create the same variables in all of my catalog items that are a part of the Order guide.

Also when a list of items will pop up, we do not have anything that can segregate the items created through order guide.

I suppose we need to drop this idea for now.