Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Apr 2011
    Location
    Oregon
    Posts
    19
    Plugin Contributions
    0

    Default Report by Product by Attribute needed

    HI there,
    I'm sure the information is here somewhere but I've yet to figure out the right 'triggers' in search.

    My store is set up for a once-a-year event. I take orders for 3 months, then need to place orders with my vendors for the products required.

    I need the ability to view all products ordered, by product name, then by size, then color (or whichever other attributes I've attributed) and total quantity ordered by each attribute (hope I've explained that clearly). So, I need to order 15 Polo shirts, size XL, in light blue; 6 Polo shirts, size M, in White etc.

    The Sales Report doesn't do this for me. Is there an Add-On out there that will give me this specific reporting capability?

    thanks much!

    Lyn
    ps, am using 1.3.9h, Mods added are edit orders, add customer, login as customer. You can see the store at www.deerhound.org/zencart

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Report by Product by Attribute needed

    Guess I am not understanding what or how you know what and who these orders are being generated from??
    You might need to custom code based upon
    admin > reports > Products Purchased >
    To filter by date versus a total since open
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Apr 2011
    Location
    Oregon
    Posts
    19
    Plugin Contributions
    0

    Default Re: Report by Product by Attribute needed

    My customers order product. At the end of the ordering period, I want a complete list of every product permutation so I can then place an order with my suppliers. In other words, I want my customer orders translated into an ordering format that I can give to my supplier.

    I want a report that looks something like this:

    Product Size Color Qty
    Polo Shirt, Mens XL Blue 15
    Polo Shirt, Ladies L Pink 7
    Mugs - - 25
    Sweatshirts 3XL White 43

    I will know who these will be delivered to because of the customer order. Once I receive all the stock from teh supplier, I will ship to customers as normal.

    Does this exist? I'd rather not have to hand-build a spreadsheet when the information exists in Zencart.

    thanks.

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Report by Product by Attribute needed

    It does not exist by default and as I stated would have to be custom coded
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Apr 2011
    Location
    Oregon
    Posts
    19
    Plugin Contributions
    0

    Default Re: Report by Product by Attribute needed

    Wow, I find that truly interesting that no-one feels the need for such a report?

    Am I looking in the wrong place perhaps? Is this more likely to be an Inventory feature? (ie wanting to replenish from suppliers?)

    :)

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Report by Product by Attribute needed

    I find that truly interesting that no-one feels the need for such a report?
    I think you will find that most all fulfill orders as received and would not need what you are seeking
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Apr 2011
    Location
    Oregon
    Posts
    19
    Plugin Contributions
    0

    Default Re: Report by Product by Attribute needed

    I did include this in my last post and would appreciate guidance.

    "Am I looking in the wrong place perhaps? Is this more likely to be an Inventory feature? (ie wanting to replenish from suppliers when inventory runs low/runs out?)"

    I'm sure you do fulfill orders when they come in but at some point you have to replenish your inventory, hence my question.

    thanks.

  8. #8
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Report by Product by Attribute needed

    at some point you have to replenish your inventory, hence my question.
    That is a different question or a clarification of what you really wanted

    I assume that you have your stock setting set to track stock and that you are entering the true volumes of stock that you have

    admin > config > stock > Stock Re-order level > set to the level tht you want to be notified

    Then admin > reports > low stock
    Zen-Venom Get Bitten

  9. #9
    Join Date
    Apr 2011
    Location
    Oregon
    Posts
    19
    Plugin Contributions
    0

    Default Re: Report by Product by Attribute needed

    Unfortunately no I'm not tracking actual inventory (because I don't have any --- I take orders, then get the product from suppliers). I set my 'inventory' to 999 to ensure Out Of Stock is not triggered.

    So, sounds like an opportunity for someone to write another ad on!

    thanks for your help anyway.

  10. #10
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Report by Product by Attribute needed

    at some point you have to replenish your inventory, hence my question.
    And my answer stands for how this is done for the majority of users - - they track stock and need to know when to reorder

    This is not what you need - So I do not understand your comment about needing to replenish stock as this is not what you need or are doing
    sounds like an opportunity for someone to write another ad on!
    I would not hold your breath on this as I stated
    This is something that it appears you need and not something that most would need or use

    most all fulfill orders as received and would not need what you are seeking
    Last edited by kobra; 18 May 2011 at 02:38 AM.
    Zen-Venom Get Bitten

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v150 Report needed: How many of certain product ordered
    By CnTGifts in forum Managing Customers and Orders
    Replies: 1
    Last Post: 31 Jul 2012, 07:53 PM
  2. Replies: 0
    Last Post: 13 May 2009, 07:02 PM
  3. Looking for a way to report on product sales totals by attribute
    By lara-f in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 18 Dec 2008, 10:55 PM
  4. Replies: 3
    Last Post: 18 Aug 2006, 09:40 PM
  5. Product Attribute Help Needed Please
    By angelicdezigns in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 25 Jul 2006, 08:42 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