Question: Exporting Reports in Excel

Exporting Reports in Excel

I'm getting an error of HTTPS 500 page not found whenever I try to download/export a report in excel. Would it be possible to have help in how to fix this issue? Also if it's possible to de

RK

Rachel Kong

Asked
I'm getting an error of HTTPS 500 page not found whenever I try to download/export a report in excel. Would it be possible to have help in how to fix this issue?

Also if it's possible to develop the emails to have an option for email customization and for copies of live order confirmation being sent to both the owners and the clients? Just so the owner of the store will be able to know whenever a sale is made and be able to better keep track of the order status. --- I was also wondering if this is possible to do now with the current system?

(I bought both shop API and stock manager advance with pos module)

Thanks and looking forward to your swift response!

Rachel

Thanks!
  • MS

    Mian Saleem

    Answered
    Hello,

    Please check your server error logs for 500 errors and let me know the error details so that I can suggest. You can enable app logs by changing the `log_threshold` to 1 in `app/config/config.php` Then visit the page again to reproduce the error. Lastly check the latest log file in `app/logs/` folder.

    Shop module only send emails to customer for new order and payments. All other emails options are manual.

    Thank you
  • RK

    Rachel Kong

    Answered
    Hi! thanks for the instructions. This is the log error that I got:

    <?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

    ERROR - 2020-04-17 10:25:39 --> Severity: error --> Exception: Class 'PHPExcel_Style_Border' not found /home/fromthes/public_html/app/controllers/admin/Reports.php 2293


    Also, thank you for letting me know about the emails options. Crossing my fingers that you guys would consider making this feature available in the future :)
  • MS

    Mian Saleem

    Answered
    Hello,

    I will fix this in next update. If you need it urgent, you can replace the

    ```
    PHPExcel_Style_Border::BORDER_MEDIUM
    ```

    with

    ```
    'medium'
    ```

    in `app/controllers/admin/Reports.php`

    Thank you
  • RK

    Rachel Kong

    Answered
    thanks! this helped fix the issue. I have another concern that cropped up. In the store front, there's a search bar in the header that doesn't seem to work. I can't seem to search for any product even though they're there.
  • MS

    Mian Saleem

    Answered
    Hello,

    You can try the search on demo. It should work same.

    Please let me know the site link so that I can look. You can post private reply, if you not like to share the link publicly.

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    There is no need to reply privately if there is no private data.

    May I know what's your email settings? You can check/edit the default biller and set the email address.

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    Shop will send email to user who created the order, cc to customer's email, bcc to biller's email and warehouse's email.

    You can try to edit the `order` method of `app/controllers/shop/Shop.php` (around line no 408 - 413)

    ```php
    $cc = $customer->email;
    $bcc = $biller->email;
    $warehouse = $this->site->getWarehouseByID($inv->warehouse_id);
    if ($warehouse->email) {
    $bcc .= ',' . $warehouse->email;
    }
    ```

    with
    ```php
    $cc = $customer->email;
    $bcc[] = $biller->email;
    $warehouse = $this->site->getWarehouseByID($inv->warehouse_id);
    if ($warehouse->email) {
    $bcc[] = $warehouse->email;
    }
    ```
  • RK

    Rachel Kong

    Answered
    I think this helped in a way but another issue cropped up with existing users/clients. I'm not sure how this error showed up as it only does this occasionally, but is there a way I can fix this error? I've attached a screenshot a customer sent us. Thank you! You guys have been super helpful.

    ***Edit: Also, sorry! I forgot to add, I've been getting an error when trying to log in payment through deposit/bank transfers. Even though deposited amount is exactly the same as the total bill, the error I get is that the amount should be bigger than the total. I don't know what I'm doing wrong. Thanks and looking forward to your reply!
    Attachments
  • MS

    Mian Saleem

    Answered
    Hello,

    The shop users need to confirm their email address. Once confirmed they will be active and can login. You can activate the user from the list customers page by clicking the users to view all customer user and view users model have the status column to activate/deactivate user.

    Where are you getting the error `the amount should be bigger than the total`? Can you please share screenshot?

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    Please take full screenshot :( You have already told me the error. I need to know the page.

    For the bcc, the comma separated email and the array should work. I don't know what is causing the issue in your side. You can comment the line I told you before to stop sending bcc till we figure out the cause.

    Thank you
  • Login to Reply