Was the combination "product name" + "manufacturer" unique? in your tab "01"?
I have only placed the product name and Manufacturer on the 04. I am only filling in the green. But why would this cause All records to error out. I have checked for this. I am pretty sure they are unique.
You have to put it also on the 01 tab
The 04 tab references to the 01 records so if it doesn't exist in 01 tab it won't work.
I did not realize that It was required to have the Product Name and the Manufacturer on 01 form. With a rework of making the product name and manufacturer unique in itself and not including the tier1,2,3 has accomplished success. Thanks for your assistance.
It'll be the same for quite other Excel files, defining one entry in "01" tab, then copy/past+some other details in tab "02" and so on
(moving to "BMC Atrium Platform" Product Forum)
I am also getting this error.
Importing only tab 1 and and 5 (company assoc + prod cat).
Invalid Product Catalog
This data may not be found in the Product Catalog in valid state, with the correct Company/Module relationship. If loaded in an earlier step, this validation may have failed.
All companies are present in Company form.