Add a Pending Payment Box To Invoice.

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..

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.

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)

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

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