Zen Cart Pros ONLY

Client wants to streamline entering and ordering of products via the Admin by some attribute mods. If what they request is not reasonable, please propose what is feasible and possible.

Please see attached example.

STOCK ZENCART ATTRIBUTE HANDLING:
Currently Zen Cart has a SKU box, but it only allows one SKU to be entered. We may have up to 5 sku for one item depending on how many different sizes where ordered. We also have a quantity box, but it doesn't break down the amount of one sku we have, it reports on the total quantity of the item (all sizes). Right now Zen Cart only knows that we have 5 black v-neck but it does not know we have 2 smalls, 1 med, and 2 larges.

REQUESTED MOD:

If we stock a shirt in 5 colors we would like be able to be able to upload all 5 colors to one Admin page, with all the skus, and quantity we have in inventory [perhaps in a table format].

Example: If we have an apparel item such as a black v-neck shirt and we have the same shirt in red. We will assign a sku for the black v-neck for each size such as 9001-S, 9002-M, 9003- L and so on... The same will happen for the red v-neck, 8001-S, 8002-M, 8003- L. (SEE ATTACHED)

We need to be able to put the quantity of black v-neck smalls, med, larges and so on with the SKU that goes along with that item by size. The red v-neck will be on the same page with the black v-neck and again we will need to have each SKU that relates to the size of the item with the number we have in inventory.