I have been trying to find something out there that would let me tie more then one cost and qty for each wholesaler I have for a product. Really what I need is to not just add a new cost and qty tie to a product over what is in the product model but that I'd need to be able to overwrite the qty to have the output be the total of all the tied entries to that product. My first thought was to just make a table where it had a list of the supplier with their cost and qty that ties to a product. Not totally clear where to start on that, but then I figured someone has made this already. Anyone have an idea how to start it or a stub or module already sort of close to what I'm asking about?
2 Answers
This is similar to the multi-warehouse problem where you have different inventories in different warehouses. For your purposes, each vendor/supplier would be a "warehouse" with the total qty showing up in the product total.
There are 3-4 warehouse extensions that I think could accomplish this for you. Some will allow you to set up rules for which inventory is used when an order is placed or allow the customer to select. If these are dropship then there are extensions for that as well. (I don't work for any of these companies: ) In no particular order I have looked at InnoExts EmbeddedERP Aitoc some others not listed.
My experience is that I have been looking for a multi-warehouse solution that allow shipping from that location and I see the connection / similarity with your problem as stated.
-
yeah, they do drop ship but that is not really needed as it's not magneto as of yet that places the order, we do it by hand so having dropship extras are only pluses. Problem is those are paid(and expensive-ish) modules and I would need to hack them up so that it reads right. That is why I was looking for something in the free realm that could do it or be a stub I could edit and make things like labels and directions fit. The from scratch way I just can't seem to think of where to start. tk for the help– QuantumCommented Sep 2, 2013 at 15:46
-
ok, I think magentocommerce.com/magento-connect/dropshipper-7085.html may be close but yes I think this approach will give the best starting point.– QuantumCommented Sep 2, 2013 at 17:33
-
yes those warehouse extensions are a bit pricy but the more I look at maintaining multiple qty and cost per sku for a warehouse i pause. Are you going to run into the need to have different shipping costs depending on supplier? How many suppliers? 2 or 200? Update this question with what you find...– DanCommented Sep 2, 2013 at 22:14
-
all I need is for it to qty cost and alternate sku as far as it really goes and I have 3-5 wholesalers. so it doesn't have to be beefy. Since we do flat rate usps for most all orders it's not an issue for the shipping too. would be nice to have the extra stuff for sure.. but just to costly.– QuantumCommented Sep 3, 2013 at 2:14
-
did you have any success in looking at multi warehouse / dropshipping for a starting point?– DanCommented Sep 23, 2013 at 15:37
In this case you want to set up multiple simple products with differing qty, wholesaler/vendor and pricing/cost attributes in the backend, relating them for the frontend as a singular configurable product.
When a customer chooses a product feature that defines it to be sold from a particular vendor it will deduct the qty from that vendor alone.
answered Sep 2, 2013 at 3:25
-
the issue is there is near 50,000 products. I thought about that but it seems with the lead boots that magento tends to walk in, all the tricks to gain speed would be shoot if I had 3-4 version of a product, plus then I can't have real configurable product if those are of these sodo configurable products.. ie I'd have some monster configurable products with lets say a color variation where each one of those had 3-4 vendor variations. Or am I off? just seems like I would be making lead weights for the site doing it that way?– QuantumCommented Sep 2, 2013 at 5:36