We have an existing ecommerce store that was custom built which we are porting over to MarketPress. Our products have three variations license, image type and language. The license determines the price. We have 43 different licenses, 3 image types and 2 languages (with more languages being added as well). You can see an example of our existing page here: http://www.politicalcartoons.com/cartoon/6749a0e5-3e89-4169-9b22-a6e10e18d4fa.html
With over 138,000 products and the above variations gives us over 35 million product records using MarketPress; as it's my understanding that each combination of variations creates an individual product post record. I believe this makes using MarketPress extremely risky for us as that is an extremely large dataset to work with and raises a lot of performance concerns.
So here are my two big questions:
1) Is there a way to dynamically pass a price to the product without having it as a variation?
2) What is the table structure used for the records (documentation)? Our existing data is in SQL 2000 and we can create a DTS job to create the records needed for MarketPress but we need a table structure to create a data map for output. As I understand it, there is no native way to import these records in this kind of volume.