You will need to do a few steps of data entry to add groups and products under a related products cateogry. As an example, go to [url removed, login to view] and use the username and password in the attached .csv..
Click on the link on the right side called "Global Product Groupings". The first column in the .csv, "Category To Add To", will determine which of the 7 categories listed that these groupings will be added to. There are only 2 sections that we will use for this project.
Once you click on the associated Category Name, which for the first half is Dickies, you will need to add the associated Grouping Name, which is in the 2nd column of the .csv. Then you will click on the checkbox next to "Below Detail Image" in the Groupings Location column, and then copy/paste the contents of Grouping Description into the text box in that column.
Last, you will click on the Browse button next to the Product SKUs text box, do a search in the pop-up screen using the value in the last column for the field ManufID, and for the Manufacturer field, use the value in the first column of the csv (you should also click the button at the top, "Remember my last search", so that you don't have to click on the manufacturer every time you search).
Once the results are visible, make sure they are correct, and all the values have the same 3 character prefix, click select all results. This window will close, you will go back to the main page, and hit "Apply" to record the changes.
This is a test database. Once we finalize the project, we will give you a different url and password to move forward with the actual project.