Add a Pending Payment Box To Invoice.

  • Posts: 5
  • Thank you received: 0
12 years 9 months ago #45208

Hi,

i have an unusual requirement and im not sure if Hika shop can be customized for it.

Im planning on using it as a a store solutoin. Online payment is not a requirement because we plan on selling at the store only.
I need to modify the following :


1. Some of our customers make advance payments. Is there anyway to add a column to the Invoice for Advance payment OR pending payment ?
For example : Cost of item : 300$, customer has paid 200$, so i need to have 2 rows added saying Payment Recieved 200$ and payment pending 100$ if possible.


2. Is there any way to restrict admins access to the software? (only certain secions can be accessed by restricted admins.

3. Can a record of daily/weekly/monthly sales be downloaded and kept for filing ?? (like an excel sheet format)


Any coding snippets would really help in this regard !

Thanks..

Please Log in or Create an account to join the conversation.

  • Posts: 83103
  • Thank you received: 13418
  • MODERATOR
12 years 9 months ago #45382

Hi,

1. You can add custom fields of the table "order" via the menu Display>Custom fields in the Business edition and that way you will be able to add additional data to orders.

2. Yes, in the Access level tab of the configuration in the Business edition, you can restrict the access to the different sections of HikaShop for each user group.

3. You can get an export of your orders as a CSV file via the button "export" on the orders listing. You can restrict it per periods for now but you can always delete the unnecessary rows via excel or select manually the orders to want to be exported on the orders listing.

The following user(s) said Thank You: ansaryibrahim

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
12 years 9 months ago #45488

Thank you !

so im going to have to upgrade to the Business edition then "

About Number 3 - i tried to export the CSV to excel but everything appears as one column
My header on excel is as follows :

user_id,"user_cms_id";"user_email";"user_partner_email";"user_params";"user_partner_id";"user_partner_price";"user_partner_paid";"user_created_ip";"user_unpaid_amount";"user_partner_currency_id";"user_created";"user_currency_id";"user_partner_activated";"order_id";"order_billing_address_id";"order_shipping_address_id";"order_user_id";"order_status";"order_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order


I even tried to edit the dashboard file as mentioned on another forum topic but its not working.
How do it get it to display properly in diff columns ? (i am currently working on a localhost and not a live server)

Please Log in or Create an account to join the conversation.

  • Posts: 127
  • Thank you received: 12
12 years 9 months ago #45491

Your file is semi-colon delimited.

Excel has its quirks when opening such a file depending on version. Try renaming the file as a .txt and then opening in Excel. It should start a wizard that allows you to select the delimiting character. Select semi-colon.

Or change the windows default for list separator: control panel--> region and language--> Additional Settings and again set to semi-colon.

Tony

Please Log in or Create an account to join the conversation.

  • Posts: 83103
  • Thank you received: 13418
  • MODERATOR
12 years 9 months ago #45493

Also, in the tab 'Files' of the configuration of HikaShop, you can select the separator to be used for CSV exports.

Please Log in or Create an account to join the conversation.

Time to create page: 0.050 seconds
Powered by Kunena Forum