Page 58 of 360 FirstFirst ... 848565758596068108158 ... LastLast
Results 571 to 580 of 3592
  1. #571
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Quote Originally Posted by Jenniferea View Post
    I followed all the instructions, all the files seem to be in place. However when I access Admin > Product with Attributes Stock I just get the following unformatted text:

    I'm at quite a loss about what's happening. I went through and deleted all the backup files I had left on the server (ie old_orders.php) but all that did was make the spacing between the headings slightly larger.
    Sounds like you're missing the stock_attributes.css file from admin/includes
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  2. #572
    Join Date
    Dec 2006
    Posts
    32
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Hello!!

    Thank you for the fantastic add-on! I installed it on a website running on version 1.3.8a and it works perfectly!

    My question is.....is there anyway to have the products put in order by Product Model number instead of Product name?

    Thanks for any help you can give!

  3. #573
    Join Date
    Aug 2008
    Posts
    4
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    hi carilivia

    You can change the sort order by edit file
    products_with_attributes_stock.php in your admin folder

    Please make backup up of this file first before you try to change.

    First find the following code that create the sql query as below




    // Show a list of the products
    $query = 'select distinct
    attrib.products_id, description.products_name, products.products_quantity, products.products_model
    FROM
    '.TABLE_PRODUCTS_ATTRIBUTES.' attrib, '.TABLE_PRODUCTS_DESCRIPTION.' description, '.TABLE_PRODUCTS.' products
    WHERE
    attrib.products_id = description.products_id and
    attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';

    $products = $db->Execute($query);


    once found change the line

    attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';

    to

    attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_model ';

    to have it sort by product model.


    You could also pleace it with

    attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_id desc ';

    this will sort by product id in descending order so it will show newest product added first which is usually the one you want to edit.


    Hope this helps

  4. #574
    Join Date
    Dec 2006
    Posts
    32
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    This worked PERFECTLY!!!! Thanks a million Stog!
    =0)

  5. #575
    Join Date
    Oct 2008
    Posts
    55
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    I have the initial page in the admin working.

    Once I click "Define Variant" i receive this error notice:

    1146 Table 'dirtsq5_zc1.products_attributes' doesn't exist
    in:
    [SELECT pot.products_options_types_name AS name FROM products_attributes pa INNER JOIN (products_options po INNER JOIN products_options_types pot ON po.products_options_type = pot.products_options_types_id) ON pa.options_id = po.products_options_id WHERE pa.products_attributes_id = 195]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


    I don't understand what to do. Speak slowly when answering I am new with tables, db's, sql, etc.

  6. #576
    Join Date
    Oct 2008
    Posts
    2
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Hello buddies,

    Any way to have the variants sorted on the products_with_attributes_stock.php page in the same order as the attributes in the dropdown menu? For example, on the product page, the T-shirt sizes are ordered from small to x-large. There seems to be complete randomness in the display order on the PWAS page. There's the large variant listed before the small. Medium listed after the large. It looks correct in the dropdown box to the customers but what about the poor sap (me) who has to toil away, entering quantities for hundreds upon hundreds of variants? Alas, my labor is for naught, for my hard work is rife with mistakes because the variants are all unorganized. It's total and complete utter chaos. First, it's just a variant sort, then it escalates. White becomes black. Dark becomes light. What we have is everything we hold sacred in ruins at our feet. Please, help me. We must have order.

    Thanks!

    G-
    Last edited by gregoryhenry; 27 Jan 2009 at 06:53 AM.

  7. #577
    Join Date
    Jul 2007
    Posts
    124
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    I have spent much of yesterday and today trying to find the particular problem in the archived messages and can't find the exact problem addressed.
    i am using zen 1/3/7 and I've installed Stock by Attributes v.4.7. I have attributes for color for some of my products. I am testing with one product until I work this out. The product has 3 color choices, clear, pink, purple. In stock are 2 pink,2 clear and 1 purple.
    In the attributes controller, I had the flag set to "for display purposes only" as directed in the tutorial.When I select color and quantity and click "add to cart" I get this error message in a yellow box on the product page.

    Please correct the following:
    On the Option for: color You picked an Invalid Selection: Pink

    So, I want back to the attributes controller and selected NO on the flag for display only. I did the same and, on got no error on the product page, but on cart page was this message:
    Please update your order ...
    Product Name: Jelly Sandals for American Girl ... Quantity Units errors -
    You ordered a total of: 1 Units: 5

    I updated the cart, but the message remains.

    I know I must be doing some little thing wrong, but I can't figure it out and can't find it in the archives. I have searched several different ways, but I'm at a loss. I have many more shoes to list, but don't want to do it until I can set the color options.

    I hope someone can help.

    Also, one more request, please. I can't seem to find any link to start a new thread. all I can do is reply to threads already in progress and they don't always fit my situation.
    If anyone can tell me how to get the "post new thread" link, I would be so grateful. I have seen it in the past, but can't get it now.

  8. #578
    Join Date
    Dec 2008
    Location
    San Fran
    Posts
    382
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Quote Originally Posted by stog View Post
    First off I must thank for a great mod as this has been most useful for me on my own website.
    I have just finished writing stand alone add on to this mod to do bulk update of stock value and will be submitting it soon.
    When I was writing is I created a search and sort function in it.
    As I was putting more stock on recently I was having to scroll right down to bottom of screen to add more attribute when I thought I might try to add the search and sort function I had just written to file products_with_attributes_stock.php.

    I have now done this and seam to be working OK.

    My question is where best to submit it as it only a small update would it be best to as full upload or on forum section

    Regards


    Steve

    Hi Stog,

    I'm wondering if you ever got an answer to your question... a bulk update of products would be AWESOME. I'm finding it very tedious editing the quantity for a product, then reverting back to the main listing... just to do it over and over again. I lose my place every time. Where can we find this awesome addition?

    I'm also wondering if there is any way to get a listing page with all products and quantity on one single page, regardless of whether they have attributes. Right now you have to go back and forth when looking at products with and without attributes... there is no central location for updating stock... unless I am mistaken. Am I?
    Last edited by swamyg1; 19 Feb 2009 at 06:14 AM.

  9. #579
    Join Date
    Dec 2008
    Location
    San Fran
    Posts
    382
    Plugin Contributions
    0

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Quote Originally Posted by gregoryhenry View Post
    Hello buddies,

    Any way to have the variants sorted on the products_with_attributes_stock.php page in the same order as the attributes in the dropdown menu? For example, on the product page, the T-shirt sizes are ordered from small to x-large. There seems to be complete randomness in the display order on the PWAS page. There's the large variant listed before the small. Medium listed after the large. It looks correct in the dropdown box to the customers but what about the poor sap (me) who has to toil away, entering quantities for hundreds upon hundreds of variants? Alas, my labor is for naught, for my hard work is rife with mistakes because the variants are all unorganized. It's total and complete utter chaos. First, it's just a variant sort, then it escalates. White becomes black. Dark becomes light. What we have is everything we hold sacred in ruins at our feet. Please, help me. We must have order.

    Thanks!

    G-

    I'm also wondering this... ordering the attributes by stock ID would be ideal. Especially when dealing with many many products. Is anybody able to provide insight into this?

  10. #580
    Join Date
    Apr 2004
    Location
    vienna
    Posts
    198
    Plugin Contributions
    9

    Default Re: Stock by Attribute v4.0 for Zen Cart 1.3.5+

    Quote Originally Posted by swamyg1 View Post
    I'm also wondering if there is any way to get a listing page with all products and quantity on one single page, regardless of whether they have attributes. Right now you have to go back and forth when looking at products with and without attributes... there is no central location for updating stock... unless I am mistaken. Am I?
    I made a while ago an addition

    Amendments from 4.7 to 4.7ajax
    added ajax functionality

    * search filter: "%ma" filters all produchts with "ma" in products-name or in products-model; the search value will be stored in a cookie
    * a click at the "quantity in stock" value adds an input-field & you can enter the new value; the store button saves all changed values
    * added files in /ajax folder
    * changed products_with_attributes_stock.php
    * added products_with_attributes_stock_ajax.php

    you can see it in action at :: http://demo.zen-cart.at/index.php?main_page=page&id=26

    download the test version at :: http://demo.zen-cart.at/images/produ...k_4.7.ajax.zip

 

 

Similar Threads

  1. Problems with addon: Dynamic Drop Downs for Stock By Attribute
    By Dunk in forum All Other Contributions/Addons
    Replies: 56
    Last Post: 30 Apr 2014, 07:55 PM
  2. MySQL Problem with Product with Attribute Stock addon
    By rtwingfield in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 20 Sep 2011, 03:35 PM
  3. Hide Zero Quantity Attributes with attribute-stock addon
    By leevil123 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 11 Feb 2010, 05:06 PM
  4. Replies: 4
    Last Post: 22 Jan 2010, 10:43 PM
  5. Price Products in the grid by 'Stock by Attribute' addon?
    By Salixia in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 27 Oct 2009, 06:03 PM

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