Product Attributes Advanced Customization

[TeeG]

I am working on a store for Halloween Costumes. The costume orders are supplied from a fulfillment house - they sent me their excel sheet will all the fields I need for the different tables in the store database.

 

Each costume comes in multiple sizes. Each size was originally its own entry in the database. So the costumes showed up multiple times.

 

I have created product attributes so that each costume has a drop down menu for size and now shows up only once.

 

The problem is that each size has its own SKU as defined by the fulfillment house.

 

Is there a way to set up some sort of lookup table so that when a costume is selected in a certain size, the SKU number can be captured as well? I'm not sure if just the costume model number and size is enough, or if the fulfillment house is going to require the SKU as well. I'm checking into that.

 

I have been doing well customizing the store and editing the php code so far, but I am not a programmer and any help would be appreciated.

 

Thanks in advance.

[♥geoffreywalton]

I think you will just have 1 sku held for each type of product.

 

Unless you hold a table of product sku/size/manu sku you will not be able to output the manu sku on the email you send to the manu.

 

Have you looked in the contributions? There is a stock qty/ attribute, could this be enhanced?

[TeeG]

Thanks for the response! I will try the contribution you suggested.