News:

Support the VirtueMart project and become a member

Main Menu

VirtueMart simple orders report

Started by Tzvika, April 06, 2009, 20:24:27 PM

Previous topic - Next topic

Tzvika

Hi All,

I am happy to announce new extension for VirtueMart by InteraMind - Virtuemart Simple Orders Report.

Using  Virtuemart Simple Orders Report allows you to track every item sold in your online store. It will also generates a CSV (for Excel Sheet) report of all orders in your store.

Moreover, the report is shown on the screen in a clean table, with links to each order.

Virtuemart Simple Orders Report features:

1. Simply export the data of your orders into a .CSV file.

2. Filter order by dates intervals.

3. Filter orders by Order Status.

4. Each item (product) within the order presented in a separate line (For accounting and invoicing).

Fields exported to CSV file:

    * Order Date
    * Order#
    * Name
    * Email
    * Address
    * SKU
    * Item Name
    * Currency
    * Item Price
    * Total for this order

for more details, check: http://www.interamind.com
If you are interested in VirtueMart reports, you may want to take a look on our business intelligence extension for VirtueMart - VirtueMart Analytics.

Thanks,
Tzvika

Tzvika

Hi all,

New announcement: New version of InteraMind's VirtueMart simple orders report is now available.

The main change is that the report structure is not fixed anymore, that is, you can select the fields that will be displayed and exported as a CSV file:

From "Orders" table:

* Order Date
* Order#
* Name
* Email
* Address
* Currency
* Shipping Tax
* Coupon Discount
* Coupon Code
* Discount
* Ship Method ID
* Customer Note
* Total for this order

From "Orders Items" table:

* SKU
* Item Name
* Currency
* Quantity
* Item Price
* Product Attributes

For more details, check: http://www.interamind.com

Thanks,
Tzvika

Tzvika

Hi All,

VirtueMart simple orders report v1.4.0 is now available!!!

Some of the new features:


  • New look and feel
  • Filter items by SKU
  • New report field - vendor name
  • Create orders or items report

For more details, check: http://www.interamind.com

Thanks,
Tzvika

dyung2

Hey guys,

I was wondering if anyone has customized the output for VM Simple Orders Report, such as: combining the two fields for First name and Last name; formatting phone numbers to be like: (xxx) xxx-xxx.

inbar

Hi dyung2,

I suggest you contact intermind's support and ask them for this small customization.
I used their services once and were happy with the results.
They don't charge much for customizations work.
Take care.

dyung2

Thanks inbar! I was hoping I will be able to do this on my own, but since I couldn't find much articles on this type of customization and plus I don't have any experience with php, I think I will ask intermind support.

dyung2

Hello,

I'm trying to modify some codes in the VirtueMart Simple Order Report and was wondering how will I go about changing the "Billing Phone 1" to this kind of format: (###) ###-####, so that it will be outputted into a CSV file.

dyung2

I've tried putting this code into virtuemartOrdersReport.php and it doesn't appear to be working, any reason why?

Code:
function format_phone($phone_1)
{
   $phone = preg_replace("/[^0-9]/", "", $phone_1);

   if(strlen($phone_1) == 7)
      return preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $phone_1);
   elseif(strlen($phone_1) == 10)
      return preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $phone_1);
   else
      return $phone_1;
}

aravot

Simple Order Report is a 3rd party commercial add-on please stop posting your question in various sections of this forum, contact the developer.

Topic merged
[url=http://www.virtuemart-extensions.com/]Product Comparison for VirtueMart[/url]
[url=http://www.virtuemart-extensions.com/]Pre-order[/url]
[url=http://www.virtuemart-extensions.com/]Badges[/url]
[url=http://www.virtuemart-extensions.com/]Advance Review for VirtueMart[/url]
[url=http://www.virtuemart-extensions.com/]Auto Update Price for VirtueMart[/url]
[url=http://www.virtuemart-extensions.com/]Single Page Checkout for VirtueMart[/url]
[url=http://www.virtuemart-extensions.com/]reCaptcha for VirtueMart[/url]