So to understand, you have a single source of inventory, two or more stores drawing from that inventory, each store may call the item a different name (by model?), and you want to upload the quantities of each stores inventory, but have them considered as a single item in your central supply and without either of the stores needing a modification of their model numbers or using a different field to present the model number that they call items?
If that is the case I would say that this plugin as written would not work for you; however, I'm sure it could be modified to suit your needs.
I was originally thinking that a separate field could be used to hold the base model number and that it alone could be used to perform all database functions of EP4; however, that philosophy would also result in a problem when uploading if the unique product # assigned by each store and other information that is different between the two stores is uploaded. So the next thought is, if you're store is functioning as described above, there must be either another table or another field that links the uniquely described items to you're core stock. In that regards, you would need to have a new option developed that would interface with your core stock table and (again as I have tried to restate above the conditions I am considering) update your core stock or you would need to update your core stock after uploading the individual stocks based on the stock available in each store. That last would depend on how you operate/need, and I would suggest that any code development would support both options with a user identified selection option.



Reply With Quote
