Product Status Management Green/Red/Lock

[robreil]

I am actually using CFMX but im migrating to 7.0, and im sure the data table structure is the same.

In a category in the site admin you can change the status of a product/webpage/link/category by clicking the Green/Red/Yellow Lock option. I have learned that when I create a new product or edit a product I can choose to make it active or not active and that sets the "Active" bit in the "Products" table.

However! If I go to the products table and manually move the Active bit it either sets it as locked or not locked. Not locked can be either red or green. Where would I go to choose red or green on a product?

Reason? I have a vendor that sends me monthly inventory spreadsheets and I have to manually match our inventory with his. That works fine if an available product (green) gets set to inactive or (0). But if I turn an inactive product (0) to an active product (1) I have no way to be sure that it would be a (green) or (red).

Can someone help me find out how this works and how to manage it?

Thanks.

[AbleMods]

I don't know where you're getting the red/green thing - there's nothing like that in AC7. Perhaps it's a Cold Fusion feature.

In AC7, you can set product visibility in two places. When you're browing the catalog, each product has a "Globe" icon next to it in the catalog list. Clicking this will let you rotate the product visibility between Public, Hidden or Private.

You can also set the visibility of a product on the Add/Edit Product page in the Display Options section using the Visibility dropdown choice. Each of the choices is explained in the hover text on the dropdown field.

I believe the table structures are very different from the 5.5 version to AC7, however I have never seen 5.5. Judy @ Web2Market would know.

[robreil]

Public, Hidden or Private, are the equivalent in CFMX. Green is Public, Red is Hidden, and Yellow is Private or Locked. Its the same.

The 3 settings are as ASP version settable in the catalog, and in the product/webpage/link/category details page as well. However I have only seen in those pages that you can only select the Availability as yes/no. No = Private, and Yes is Public.
But I would like to know how I can be sure that by going into the products table and set Availablity from 1-0 and from 0-1 I am toggling from Private to either of the non Private options. But I have not figured out how to manage from a DB level to be sure that a DB toggle from 0 to 1 in the Products Active field would endure that that item would be Public and not Hidden.