Page 36 of 37 FirstFirst ... 2634353637 LastLast
Results 351 to 360 of 365
  1. #351
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by jeking View Post
    I did a search but came up empty. Is there a way to report sales that includes the attribute? My client, a non-profit fog rescue, sells t-shirts and tracks inventory by size. The plugin is great for the site, but they need a report on sales to update inventory. The Sales Report plugin does not include attribute data.
    Quote Originally Posted by DivaVocals View Post
    You probably should open a new thread to get this discussion going.. SBA doesn't have any reporting mechanism..
    Would like to provide input on this "discussion" where did the thread get started?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #352
    Join Date
    Oct 2005
    Location
    Chicago, IL USA
    Posts
    1,549
    Plugin Contributions
    28

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by mc12345678 View Post
    Would like to provide input on this "discussion" where did the thread get started?
    I never actually did start a new thread.

  3. #353
    Join Date
    May 2007
    Posts
    79
    Plugin Contributions
    1

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by jeking View Post
    I never actually did start a new thread.
    I believe this is the thread for creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0 .
    It doesn't need a new thread.

  4. #354
    Join Date
    Nov 2011
    Location
    Brisbane, Australia
    Posts
    35
    Plugin Contributions
    0

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    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

  5. #355
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by cefyn View Post
    I believe this is the thread for creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0 .
    It doesn't need a new thread.
    But a discussion on a sales report DOES require a new thread.. (which is what was being referred to..)
    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.

  6. #356
    Join Date
    May 2010
    Posts
    83
    Plugin Contributions
    0

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    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.

  7. #357
    Join Date
    Oct 2005
    Location
    Chicago, IL USA
    Posts
    1,549
    Plugin Contributions
    28

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by waterbender View Post
    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.
    They are not the same. If you have a question about the 'Stock by Attributes', best to post your question in that thread. I can't say about this one, I've never used it.

  8. #358
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,221
    Plugin Contributions
    1

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    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.

  9. #359
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,221
    Plugin Contributions
    1

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    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.

  10. #360
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,221
    Plugin Contributions
    1

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    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)

 

 
Page 36 of 37 FirstFirst ... 2634353637 LastLast

Similar Threads

  1. v155 BETA feedback for Responsive-Classic in v155-beta
    By picaflor-azul in forum Addon Templates
    Replies: 51
    Last Post: 5 Mar 2016, 09:14 PM
  2. v151 Using Stock By Attributes, In Stock Value Is Sum Of Attributes' Stock
    By y0ul053 in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 29 Aug 2013, 04:23 PM
  3. Replies: 5
    Last Post: 3 Aug 2011, 08:15 AM
  4. Stock by Attributes and displaying next to attributes for Customers 1.3.8
    By tirjasdyn in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 21 May 2009, 10:31 PM
  5. Stock level indicator, for stock by attributes controller
    By vandiermen in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 13 Nov 2008, 09:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR