I just got done designing the database schema for the Buy Low Sell High Brain idea I mentioned in my previous post.
This is a data dump of the general ideas that this program would implement. However, I took this a little further than my original intentions and implemented wholesale supplier and market place analysis capabilities into the design. This way, the brain can not only utilize wholesale supplier pricing but also scan marketplace sources for products by UPC and/or title and do a comparison as well as historic survey of the product niche space across multiple sales channels.
Furthermore, this schema contains inventory tracking for on hand items as well as wholesale supplier inventory as well as mapping of inventory source feeds to the appropriate sales channel data feeds.
In the end this schema would allow for the brain to programmatically manage wholesale account buying, sales channel order fulfillment, and marketplace analysis and price adjustments all by itself.
To be continued…