ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
I have started to look at a report of OOS by Attributes. I got close to a Query that returns all Products that have Stock By Attributes that are ZERO (ie, they are out of stock). Basically, this is a query to report on all Out Of Stock Products by Attribute level.
However, I'm not able to translate the STOCK_ID or the STOCK_ATTRIBUTE Fields from table PRODUCTS_WITH_ATTRIBUTES_STOCK to their meaning full names of OPTION NAME and OPTION VALUE.
Any ideas?
****** SQL *****
Select T5.categories_name, m.manufacturers_name, T1.products_id,
T1.products_price, T2.products_name, products_with_attributes_stock.stock_attributes,
products_with_attributes_stock.quantity, products_with_attributes_stock.stock_id
From products T1
Left Join manufacturers m On T1.manufacturers_id = m.manufacturers_id
Inner Join products_description T2 On T2.products_id = T1.products_id
Inner Join products_to_categories T3 On T3.products_id = T2.products_id
Inner Join categories T4 On T3.categories_id = T4.categories_id
Inner Join categories_description T5 On T5.categories_id = T4.categories_id
Inner Join products_with_attributes_stock On T1.products_id = products_with_attributes_stock.products_id
Group By T5.categories_name, T1.products_id, T1.products_price, T2.products_name, products_with_attributes_stock.stock_attributes, products_with_attributes_stock.quantity, T2.products_id, T2.products_description, products_with_attributes_stock.products_id, products_with_attributes_stock.stock_id
Having products_with_attributes_stock.quantity = 0
Order By T5.categories_name
Last edited by gohealth; 28 Sep 2014 at 02:59 AM. Reason: Not a direct response to the questions
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Is this module the same as http://www.zen-cart.com/downloads.php?do=file&id=202
Is it possible to use this to bulk revise attributes? For example, disable some sizes of 1000 products.
Zen v1.54
SBA v1.54
Zen Magnific v1.5
DPU v3.0.2
I been attempting to debug the 'second SBA dropdown not working' on my site. Looking at the thread I can see that a couple of things have been tried i.e. validating the page to sort problems with broken tags etc - done. Incorporating an edit by mc12345678 into pad_sba_sequenced_dropdowns - done I'm using the latest from github.
I think I've now isolated the problem to a conflict with Dynamic Price Updater, if I turn it off then the SBA dropdowns work. As there are no common files between the two mods I think it might be a jscript issue. I've been looking for conflicts as much as I'm able but still no joy.
It's time to ask for help. Has anyone had this conflict between the two mods?
I have it on a test site if it helps and would rather PM you the link if you don't mind.
It now appears that it is not the conflict I described above. The two mods work together under the classic template, at least this makes it easier to debug - so still a bit of work to do.
Scrub that, the classic template reverts the attribute selection to non-dynamic dropdown hence why it worked
(not sure why I keep posting in the wrong thread)
Bookmarks