Data Structure for E-Commerce Shop

Hey Guys would like to pick your brains on how you would approach the data structure of this problem i have. This would be on managing of the back end data collection from multiple online sales channels.

​

If i have a product dimension table that contains product descriptions, barcodes, configurations etc & I have multiple channels piping data as a fact table in terms of per order information, how can i have another table with product cost price that …

commerce data datascience e-commerce