Sales report 2.0

[mipavluk]

Hi there!
I love this mod! but I don't know why is not working for me...

when I choose only PayPal like Payment Method, only for 1 manufacturer, I receive all payment methods report... why?

I like to know if is possible, have a report with all payment methods but with one more column that said if is: gift certificate, coupon, paypal, etc.

Another problem.... if I choose Output Format, CSV Export, my browser said: to help protect your security bla bla bla... I chose Download File, but the download never start....

I have zen cart 1.3.8 and sales report 2.2

thanks in advance!!!!

[Vladimir7]

Great mod, however I have a question that I can't figure out.
I want to create a report for products sold in a month based by attribute.
For example, a red shirt, would be seperate from a blue shirt.
So if in a month 5 shirts were bought, however 2 were red attribute, 1 blue, and 2 yellow it would show like

2 Red
1 Blue
2 Yellow

instead of just
5 shirts.

Is it possible with this mod? Or is there another mod that this is possible with?


[edit] never mind, I just noticed a couple pages back that it isn't possible.
I guess I will have to write my own reporting tool, or modify this one to do that.

[zerocrew]

I'm asking the same question....
hopefully someone can answer us.

[kuroi]

I'm asking the same question....
hopefully someone can answer us.

With over 300 posts in this forum, it would be helpful if you would be more specific about which question you believe to be unanswered.

[BlindSide]

@zerocrew & mipavluk

Guys, I'm here to help, but you have to do your own homework:

http://www.zen-cart.com/forum/showpo...&postcount=264

Search the thread next time, please?

[Vladimir7]

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product        Attribute   Amount Sold    Total
Shirt  $24
    Red  2     $16   
    Green 1   $8
Pants $60
       Black  2  $40
       Orange 1 $20 

ugg formatting screwed up... but you get the idea

[psr racing]

I'm having a small problem with version 2.2. The report is generating incorrect order totals. It is adding the product cost (ex tax) to the shipping cost (inc tax) and giving a total figure that doest match the order.
All I'm looking for with this add-on is to be able to obtain a total $ value of all orders between two dates. I need the order totals (including shipping and tax ie what the customer pays) for all orders so I have a 'total income'. Showing tax would also be a bonus but not essential as I can just divide the total by 11 (Aus GST 10%).

[BlindSide]

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product        Attribute   Amount Sold    Total
Shirt  $24
    Red  2     $16   
    Green 1   $8
Pants $60
       Black  2  $40
       Orange 1 $20 

ugg formatting screwed up... but you get the idea

Like I've said before, the first version of the Sales Report attempted this, and I took it out when I took over the project because it simply didn't work well. But I'm looking forward to seeing what solution you might come up with.

A few things you'll want to keep in mind:

• Attributes currently have no associated quantity, so you'll need to do your own counting.
• How will you handle text attributes? Remember that they are often completely different values (hence no counting).
• You'll probably want to ignore file upload and read-only attributes, but only if they do not have a currency value associated with them.

[zerocrew]

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product        Attribute   Amount Sold    Total
Shirt  $24
    Red  2     $16   
    Green 1   $8
Pants $60
       Black  2  $40
       Orange 1 $20 

ugg formatting screwed up... but you get the idea

all i have to say is if you can do this it would F!@$$# rock!
thanks for trying man.

[SkipperMcNally]

Hi there,

I haven't read through this entire thread, but I was experiencing an issue with rev 104 where, when I filtered by manufacturer, it would still show a date with orders, where that manufacturer had no orders, as having orders on the report. The product totals were zero, but the tax and discounts were still there, throwing off numbers. Additionally, I did not want to see any orders for the time period if that manufacturer had no orders.

So, I changed the query that retrieves the order numbers to consider the manufacturer filter and it appears to have resolved the issue. This is a code snippet starting at line 164:

      // build the SQL query of order numbers within the current timeframe
      $sql = "SELECT DISTINCT o.orders_id from " . TABLE_ORDERS . " o \n";
      if ($this->date_target == 'status') {
          if ($this->manufacturer) {
            $sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
            $sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
        }
        $sql .= "LEFT JOIN " . TABLE_ORDERS_STATUS_HISTORY . " osh ON o.orders_id = osh.orders_id \n";
        $sql .= "WHERE osh.date_added >= '" . date("Y-m-d H:i:s", $sd) . "' AND osh.date_added < '" . date("Y-m-d H:i:s", $ed) . "' \n";
        $sql .= "AND osh.orders_status_id = '" . $this->date_status . "' \n";
      }
      else {
          if ($this->manufacturer) {
            $sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
            $sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
        }
        $sql .= "WHERE o.date_purchased >= '" . date("Y-m-d H:i:s", $sd) . "' AND o.date_purchased < '" . date("Y-m-d H:i:s", $ed) . "' \n";
      } 

Hope this helps someone else in the same predicament. Thanks for the great report!