Report & Export Wizard

$395.00
In stock
SKU
dump

Create ad hoc reports on any AbleCommerce data table. You can view the report, and export the data to Excel.

Create, save and run reports using any combination of tables in AbleCommerce. Using SQL queries, you can retrieve almost any data in the database (encrypted data like password cannot be retrieved). A relatively easy way to create almost any kind of report you'll need. If you're not familiar with the SQL language, we'll be glad to create the queries for you. Most queries can be created in fifteen minutes or less.

Click on the More Detail link above to see the 36 included reports.

Note that in order to ensure you receive the latest code for your AbleCommerce version, we check compatibility for each order and this can take up to 3 business days.

Licensing: One license per store. Details here.

Estimated install time:1-2 hours.

Documentation Provided:Yes. ","Report 1

  • 'All Product Basic Info',
  • 'Get the Name, SKU, Base Price, Image URL, and Page URL of each product',

Report 2

  • 'Products with Pricing Rules Report',
  • 'Displays SKU, Name, Price, SalePrice, Start and End Date for products containing pricing rules. Sorted by Sku.',

Report 3

  • 'Volume Discount',
  • 'Reports all Volume Discounts for all products, ordered by Sku, Discount, Group, and Minimum Value',

Report 4

  • 'Volume Discount for Sku',
  • 'Reports all Volume Discounts for a specific Sku, ordered by Sku, Discount, Group, and Minimum Value',

Report 5

  • 'Dollars per Coupon',
  • 'Retrieve the amount of $ per coupon. In the Sku box enter the Coupon Code.',

Report 6

  • 'Dollars per Coupon for Date Range',
  • 'Retrieve the amount of $ per coupon filtered by date. Select a start and end date and in the Sku box enter the Coupon Code.',

Report 7

  • 'Total Coupons',
  • 'Retrieve the amount of $ saved with coupons.',

Report 8

  • 'Total Coupons for Date Range',
  • 'Retrieve the amount of $ saved with coupons filtered by date. Select a start and end date.',

Report 9

  • 'Dollars per Sku',
  • 'Retrieve the amount of $ per coupon. In the Sku box enter the product Sku.',

Report 10

  • 'Dollars per Sku for Date Range',
  • 'Retrieve the amount of $ per coupon filtered by date. Select a date and in the Sku box enter the product Sku.',

Report 11

  • 'Order Totals by Sku',
  • 'Returns the Order Number and Total Charges for any order containing the Sku you have entered.',

Report 12

  • 'Order Totals by Sku for Date Range',
  • 'Returns the Order Number and Total Charges for any order containing the Sku you have entered for a specified date range.',

Report 13

  • 'Quantity and $ sold per Sku',
  • 'Returns the quantity and total $ sold for each Sku.',

Report 14

  • 'Quantity and $ sold per Sku for Date Range',
  • 'Returns the quantity and total $ sold for each Sku in a given date range.',

Report 15

  • 'Order Info by Date',
  • 'Get Order#, Product Subtotal, Fees Total, Total Charges, Total Payments, Balance Due, and Order Weight for a date range.',

Report 16

  • 'Order Item Export including messages',
  • 'Export all Order Items, including Order Details, Shipment Details, Order Item Input Field, Line Message, Gift Message, and Shipping Message. Note: If you have multiple input fields line items may be duplicated.',

Report 17

  • 'Order Item Export including messages for Date Range',
  • 'Export all Order Items, including Order Details, Shipment Details, Order Item Input Field, Line Message, Gift Message, and Shipping Message for a date range. Note: If you have multiple input fields line items may be duplicated.',

Report 18

  • 'Refunds Report',
  • 'Get all refunds. Sorted by Order Number.',

Report 19

  • 'Refunds Report for Date Range',
  • 'Get all refunds filtered by activity date. Sorted by Order Number.',

Report 20

  • 'Items in open orders where quantity on hand is'Returns items that have been sold and are on open orders but are listed as out of stock.',

Report 21

  • 'Sales by Category',
  • 'Returns total sales for all products in specified Category (including sub-categories). Enter the Category ID in the Sku box.',

Report 22

  • 'Sales by Category for Date Range',
  • 'Returns total sales for all products in specified Category (including sub-categories) for Date Range. Enter the Category ID in the Sku box.',

Report 23

  • 'Featured Products Sold',
  • 'Report on Featured Products sold. Note: Only shows products currently marked as Featured.',

Report 24

  • 'Featured Products Sold by Date',
  • 'Report on Featured Products sold by Date Range. Note: Only shows products currently marked as Featured.',

Report 25

  • 'Items Never Sold',
  • 'List of Items never Sold',

Report 26

  • 'Order Items by Bill To State',
  • 'Returns all Order Items by Bill To State. Enter the Bill To State abbreviation to filter in the Sku box, e.g. CA for California.',

Report 27

  • 'Order Items by Bill To State for Date Range',
  • 'Returns all Order Items by Bill To State for a date range. Enter the Bill To State abbreviation to filter in the Sku box, e.g. CA for California.',

Report 28

  • 'Order Totals by Bill To State'
More Information
User Guide
Write Your Own Review
You're reviewing:Report & Export Wizard

HELP DETERMINE WHICH PLATFORM IS BEST FOR YOU. ARE YOU READY TO WORK WITH US?LET'S GET STARTED