Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 14, 20178 yr Trying to do a simple inventory management system by pulling my products out of Nexus into Excel via ODBC and joining them with a spreadsheet that has my physical inventory locations. (Nexus has no way of adding a inventory location to a product record.) What I want is product title, description, qty, price and a unique ID (index) The problem is with V4 the table structure is more complex and I can't find some needed fields. A product title is stored in core_sys_lang_words table, and all commerce titles have a "nexus_package_" prefix and the descriptions have a "_desc" suffix. (This are values in the column, not the column name.) The also have a index column called word_id with a value like "15451". What I can't find is the inventory quantity and price and how they get joined back to the core_sys_lang_words table. I'm assuming their is an intermediate table but haven't had any luck identifying. Can anyone help?
Archived
This topic is now archived and is closed to further replies.