Sales Reports

Sales Reports

Previous Top Next

From the Administration Panel main menu, select Manage Sales. A top menu bar appears and the Customers and Messaging page opens with customers listed. From the top menu bar, select Sales Reports. Sales Reports may also be opened by clicking on the

icon next to the Sales quick stats in the administration panel index page.

Note: To quickly return to the administration panel index page, where the quick stats are shown, click on the AShop logo on the top left hand side of the pages.

The report may be selected by the following "Show" filters.

Paid - orders where payment has been recorded.

Unpaid - orders where the manual payment option was selected and the order has not been activated.

Chargbacks - orders that have been charged back (reversed).

Wholesale - This option only appears if the wholesale catalogue is activated and will show wholesale paid orders.

Select the date range of the sales report from the drop-down date boxes. If a from date is not selected, the report will show all orders from the very first order recorded.

Select the sort order for the report from the "Order by" drop-down list. Choices are by Date, Price, or Customer in Ascending or Decending order.

3a.

Click the View button to view the report in your browser.

Paid Orders, Unpaid Orders, or Chargebacks - View

3b. Click the Download button to download the report in Comma Separated Values (.csv) format for viewing in programs such as Microsoft Excel.

3c. Click the Edit button (for paid orders only) to open the chargeback view.

Paid Orders - Edit

To Chargeback an order and the corresponding affiliate commissions, click on the

icon next to each order record.

Note: If your mail server is in a different time zone and the $timezoneoffset is not set to adjust for the difference, very recent sales transactions may not be included even when the "To:" date is set for the current date. This happens when the order is stamped with a time that is ahead of your current time zone.

Recovering Incomplete Failed Orders

Preliminary Orders
Preliminary orders are created by checkout.php and are needed mainly to connect the customer with the shipping calculation when they return from the payment gateway. They are also used for tracking the IP number of the customer. The preliminary order is deleted when the customer clicks Continue Shopping or the browser Back button from the gateway. (This wasn't done from the beginning which would result in early copies of AShop Deluxe having a lot of old preliminary orders in the database.)

There are some circumstances where the preliminary order can't be deleted, such as if the customer simply closes the browser window or clicks the back button from the checkout page instead of the Continue Shopping button or if the order fails to be processed for some reason. This will inevitably cause some unnecessary preliminary orders to be left in the database over time, which is why there is a Clear button on the Sales Report page. Clicking this button will remove all preliminary orders except the last 10 (since some of them could be orders that are currently being processed).

Activating Preliminary Orders
Occassionally, payment will be completed, but the order my not be recorded in AShop. AShop relies on the payment gateway to post a payment response to complete and activate each order. If the payment gateway has trouble at the time or the post fails to reach AShop, payment may be recorded with the payment gateway and still not appear within AShop Deluxe. The Incomplete/Failed Orders report provides a way to view preliminary orders to find the one that failed, and then activate the order.

1.	From the Sales Report page, under Incomplete/Failed Orders, click Edit to show all of the preliminary orders.

Find the preliminary order and click the

icon to open the Complete Preliminary Orders menu.

Select a payment option, verify the customer's shipping address and enter information as needed, and then click Submit to activate the order. Payment is recorded in AShop for the option selected so that the order appears in sales reports for Paid orders. The receipt, order notice, and fulfilment notice are sent in the same way as when normal orders are processed. For downloadable product orders, a link and password will be included. For key code products, the key code(s) will be included in the customer's receipt.

Note: Payment is NOT submitted to the payment gateway again during this process.