Quote Originally Posted by chadderuski View Post
Hi,

I have not used the stock by attribute mod. If this mod uses custom tables to track stock, then I don't think EP4 (or any EP version) will help.

Perhaps another zenner has an answer or can suggest another mod.

EP4 uses the products_model as it's main key to link the various databases. If you don't use products_model numbers, then EP4 won't work for you...

-chadd
So Propster, as written, no it will not import to Stock by attributes.

It would require a little more work. The Stock By Attributes table does (the version I'm using) include a reference back to the product id, which is also in the products table. Couple that information with the products_model info and you have references to the data that you need in the stock by attributes table. Thing is that table works a lot like (well basically is) the attributes table does, in that there are multiple entries tied to a single object. One of the differences/difficulties is that the data stored for a single stocked item (all the associated attributes) is not the same for all versions of Stock By Atttributes if I am correct. So any "manual" or instructions related to that portion may not be consistent across all versions. Being possible, I would say yes. Quick and easy, I would say relatively no.

But a start would be to look through some of the other import/export functions that work similarily and identify what information is needed to work both directions (import/export). And then carry on. It does seem that the code is robust with the various types of export reports, so this would just be one more report type.

Oh yes, the total # of items would be affected by EP 4 or others, but stock by attributes has it's own quantities and depending again on the installed version, the total may get reset or other things may change depending on how the SBA works, but this mod does not currently interface with the SBA table.