[Skip to main content](#vessel-content) # Add a Pending Payment Box To Invoice. ## - **[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")** - [![ansaryibrahim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") Topic Author - [ Offline](/forum/user/6631-ansaryibrahim) Less More - Posts: 5 - Thank you received: 0 - - 14 years 7 months ago [\#45208](#45208) by [ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") *[Add a Pending Payment Box To Invoice.](/forum/4-how-to/45208-add-a-pending-payment-box-to-invoice#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..")* was created by *[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ1MjA4LWFkZC1hLXBlbmRpbmctcGF5bWVudC1ib3gtdG8taW52b2ljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 14 years 7 months ago [\#45382](#45382) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add a Pending Payment Box To Invoice.](/forum/4-how-to/45208-add-a-pending-payment-box-to-invoice#45382 "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. The following user(s) said Thank You: [ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ1MjA4LWFkZC1hLXBlbmRpbmctcGF5bWVudC1ib3gtdG8taW52b2ljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")** - [![ansaryibrahim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") Topic Author - [ Offline](/forum/user/6631-ansaryibrahim) Less More - Posts: 5 - Thank you received: 0 - - 14 years 7 months ago [\#45488](#45488) by [ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") Replied by *[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")* on topic *[Re: Add a Pending Payment Box To Invoice.](/forum/4-how-to/45208-add-a-pending-payment-box-to-invoice#45488 "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..")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ1MjA4LWFkZC1hLXBlbmRpbmctcGF5bWVudC1ib3gtdG8taW52b2ljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 7 months ago [\#45491](#45491) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: Add a Pending Payment Box To Invoice.](/forum/4-how-to/45208-add-a-pending-payment-box-to-invoice#45491 "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..")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ1MjA4LWFkZC1hLXBlbmRpbmctcGF5bWVudC1ib3gtdG8taW52b2ljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 14 years 7 months ago [\#45493](#45493) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add a Pending Payment Box To Invoice.](/forum/4-how-to/45208-add-a-pending-payment-box-to-invoice#45493 "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..")* Also, in the tab 'Files' of the configuration of HikaShop, you can select the separator to be used for CSV exports. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ1MjA4LWFkZC1hLXBlbmRpbmctcGF5bWVudC1ib3gtdG8taW52b2ljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.083 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)