I am trying to import an Excel file using CS Cart and I have multiple items but each item is the same number but they have different "color codes" attached to them.
Example:
13130HE-BN
13130JT-BN
13130WH-G
13130WH-S.

This is under the Product Code Column.

And underneath the Product name column, couple columns down to the right, are the numbers 13130.

Now my problem is, how do I merge the items with the color codes into one while creating a page on a website while creating a drop down menu for all the colors and still have pictures that correspond to each of the colors when you select them from the drop down menu
?

i assume CS cart is some specific software/framework. since i do not know anything about this thing, i recommend creating two new columns, one with just the number and one with just the letters. i assume you can do it just fine then?

tried that already

i assume you can show multiple items for a single category? Use the same idea with a many-to-one relationship. Have one table with an item code and another table with colours/pics

If that doesn't work either, i assume there's a forum for CS Cart where you can post questions. I don't know how many people here use it.

I don't think 2 different tables would work in this case and yes you can have multiple items in a single category yet you have to direct them to that category.
I think I'm going to go ask the CS Cart forums then.
Thanks for your help.