I use Filemaker 11 Advanced to update the products, something I normally find much easier than the native control panel or Magnetic One.
But how can I update the stock by attributes with this program (or any other database management program, I suppose?)
Could somebody be so kind as to guide me to the exact php/sql-code that does this? Is it possible to only do this with SQL, or is the php necessary (seems like it depends on arrays)?
Would it be possible to add a database field for attributes_id in the table stock_by_attributes, or a quantity field in the products_attributes table, and thus make a more direct link?
I have given up the idea of having two options tied to one attribute anyways (I need to show exactly the attributes we have in stock, not all possible combinations), so I will just show one attribute option (being made up of both color and size where needed).
Bookmarks