29736 comments found.
Mate, why does the Merchant → Quick Management (Last 5 Orders) section show that?
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.is_commission_applied' in 'SELECT'. The SQL statement executed was: SELECT a.order_id, a.order_uuid, a.client_id, a.status, a.order_uuid , a.payment_code, a.service_code,a.total, a.delivery_date, a.delivery_time, a.date_created, a.payment_code, a.total, a.payment_status, a.is_view, a.is_critical, a.whento_deliver, a.use_currency_code,a.base_currency_code,a.exchange_rate, a.is_commission_applied, a.merchant_total, b.meta_value as customer_name, IF(a.whento_deliver='now', TIMESTAMPDIFF(MINUTE, a.date_created, NOW()) , TIMESTAMPDIFF(MINUTE, concat(a.delivery_date,' ',a.delivery_time), NOW()) ) as min_diff , ( select sum(qty) from st_ordernew_item where order_id = a.order_id ) as total_items FROM `st_ordernew` `a` LEFT JOIN st_ordernew_meta b on a.order_id=b.order_id WHERE ((a.merchant_id=:merchant_id AND meta_name=:meta_name ) AND (status NOT IN (:ycp0, :ycp1))) AND
hmmm this is a new field that i added but i did not include this in the update yet
can you
Please email me all your access details, including:
Site link
Admin login
FTP accessAlso, provide a screenshot of the error and include a detailed description of the issue in the email.
You can reach support here: https://codecanyon.net/user/bastikikangCheers
Ok mate mail sent
sent
Hello Basti,
I tried to upload to hosting server and extract the latest web version 2.0.6 in accordance with your instruction. But every time I upload and extract and then go back to backoffice admin panel > utilities> fixed database I get only version 2.0.4. Why am I not able to install and extract the latest version 2.0.6? What am I doing wrong?
Thank you,
(Version: 2.0.6 – Last update: September 4, 2025 – requirements PHP 8.2 – Update notes: update process has been change since version 1.0.7, step 1 extract the update.zip as before step 2 no need to run the backoffice/update anymore just go to admin panel -> ulitities -> fixed database, this will create all new tables and menu)
Did you change the backoffice folder to a different name? If yes, then after extracting the update.zip file, the folder names will not match. To fix this, you need to rename the backoffice folder inside update.zip so it matches your current folder name before extracting.
Another common issue: Some hosting providers (like Hostinger) don’t replace files when extracting a zip. Instead, they create a new folder. To fix this, add a dot (.) when extracting the zip file so it extracts into the current directory instead of creating a new folder.
Thank you Basti for your prompt response. I have discussed the issue with the hosting support team too.
May be now I need more details from you on this issue like: What exactly is the backoffice folder in reference to the update and where exactly is the folder located within the admin panel what is it called? Do I have to rename the backoffice folder inside update.zip using file manager hosting or using admin panel facility? Please give me step by step instructions for implementing the update correctly.
Thank you again,
hi mate
the update is easy you just need to overwrite your files
1. i think the best way is to extract the file in your pc and upload the files using filezilla
you will find the same files in your server in the update.zip you just need to over write your server files with the updated files
2. second options is to upload the update.zip in your main root folder and extract this basically just over write your server files
Thanks a lot Basti for your prompt support. You are right I found the same file in my server update.zip and did overwrite server files with the update files but did not help. I will try the other options you have proposed.
ok mate let me know how it goes
Email sent about payment module
sent
what frameworks used on this website?
am not sure you still keep asking this question anyways is yii
Hi Basti, this is my developer sent you this comment via my account and will contact you from now on
ok mate noted
HI Basti Not Sure but was there or is there a option on Admin Panel to ads funds to wallet for customer first order i think i saw it but now i cant seem to find it?
in admin panel -> buyers -> edit and under wallet tab you can adjust the customer wallet
Ok I See you can manually add, for next update option to put money in customer wallet for sign up and first order like points options, what you think thanks for the good work..
am sorry what do you mean?
you can adjust it and the description you can write it
Hi Basti, i have the same settings in firebase chat when creating the database chat just like your video and when i go to chats and select a restaurant i get this error:
FirebaseError: [code=permission-denied]: Missing or insufficient permissions.
please verify chat in website don’t have issue like this
check the config in admin panel -> 3rd party -> firebase
I have everything just like you did on the video heres a screenshot
https://i.imgur.com/caEMUef.pngI have this in rules
rules_version = ‘2’;
service cloud.firestore { match /databases/{database}/documents { match /{document=**} { allow read, write: if false; } } }
Could this be firestore issue?
My mistake I had : if false, not like in your video sorry. thanks for your help
no worries mate
glad you figure it out
How does admin commission per delivery work? Is it that admin can get a commission from the delivery fee that the customer pays?
it depends in your settings
by default delivery fee goes to driver
only admin earn commission per order
There is a setting for Admin commission per delivery. I was expecting that admin could make a commission per delivery fee.
hi mate
yes sorry if forgot i check once order is delivered by rider yes that commission will have affect in the delivery fee
How does that work when the order is COD?
upon checking my code if order is cod
all the amount will be deducted from driver wallet instead of credit
unfortunately it does not deduct the delivery fee. It actually logs delivery fee as 0
try to update to latest version
I have updated to 2.0.6 and still 2 issues:
1. Packaging fee is NOT accounted for and it’s not logged anywhere, not on merchant and not on admin but the customer is charged.
2. Delivery fee for Driver wallet is still 0 and it’s not collected from customer.
Everything else looks fine.
1. will check on my end the packaging fee should go always to merchant
2. for this which one completed the order? merchant or driver?
need to be the driver who delivered the order
1. Yes but the packaging fee is NOT assigned to anyone at all. Driver only gets credited the raw cost of the item and then debited the commission.
2. Driver delivered the order as Independent Contractor. Driver wallet shows the order is listed but deliver fee paid to driver is listed as 0.
1. like i mention will have to check first on my end
2. what i can see here is maybe the delivery fee is below 1 ?
2. Delivery fee is actually set at 500/km for 5km = 2,500 in the local currency.
better Hi,
Please email me all your access details, including:
Site link
Admin login
FTP accessAlso, provide a screenshot of the error and include a detailed description of the issue in the email.
You can reach support here: https://codecanyon.net/user/bastikikangCheers
I sent 2 emails: - One from the support link with the details you asked for and - One direct email with screenshots describing the problem.
Thank you.
Still waiting
wait for my email
btw did you fixed the ftp ?
Yes I did
sent
Thank you. Unfortunately “Packaging” fee is still not being assigned to the merchant.
ok mate will check that you might be right cause i did not release the update for this one yet
will send you the file with the fixed
Hi mate Last Orders Quick management of the last 5 orders not showing up in merchant dashboard
i don’t have changes in this part
please use the update and run fixed database
Yes mate I’m using the last update that’s why after update not showing that’s which file or path for that in the files to check
did you run fixed database? usually it should not have issue cause i never updated this part
Mate I think you uploaded files from your side that’s damaged all my website 
what do you mean?
Few issues:
1. Delivery fee: During order creation, all fee are displayed. After selecting Payment as COD or wallet, Order details still displays all line items very well. However, after validating order, NO DELIVERY FEE line… Customer is not charged delivery fee at all. Customer is only made to pay the other fees but NOT delivery fee. On payment receipt, only Item cost line and service fee are displayed and charged.
2. Commission System does not calculate order commission from vendor, it shows commission as 0 after order is complete.
3. What’s the cost to get flutterwave Payment setup?
hi mate
1. please update to latest version this was a bug in last version 2.0.4 update i update the tax calculation in which i already keep providing the fixed for this since that version
2. check if you run the cron jobs properly specially the cron processjobs
3. contact me via email https://codecanyon.net/user/bastikikang
1. I have the latest version already and same issue.
2. All crons are properly set. However, my server only lets me go as often as 5 minutes. So all 1 and 2 minutes crons are set to 5 minutes.
I now see commission transactions only on POS orders. Mobile and web orders don’t display commissions.
mate please verify
it should work in online orders cause i have same code with commission
every time you change the order status it will trigger this jobs only it will earn commission for admin and merchant once order is delivered or completed depends in your settings
Habría posibilidad de poner todo el sistema en español ? O como puedo hacer?
yes you can change this to any language
watch this video
https://www.youtube.com/watch?v=RfgBHGNsJC0&t=84sHi Basti How can i fix the following issue Please new customer cant place order due to error message saying you have another order inprogress and there are no orders under customers name. how to fix please… https://prnt.sc/tm6ox79YkAUM
this is in your settings you not allowing the customer to order if previous order is still processing
go to admin panel -> site config -> ordering & food -> Cannot do order again if previous order status is
remove all the status here to allow customer to continue order without checking the last order
hi basti looks like that message appears if customer didnt select a payment option shouldn’t it say “please select payment option ??” is there a option to fix this in admin
mate am the author of this code
so i know that error message
read my answer carefully above
HI Basti Sorry man im getting same issue from Multiple customers that just now registered never orderd but getting same issue when i log in with there credentials on my phone its not showing that error https://prnt.sc/Ookhsq3UHCTt , https://prnt.sc/TK7X-WzUDKWB
mate please check the settings
go to admin panel -> site config -> ordering & food -> Cannot do order again if previous order status is
remove all the status here and try again you see you can purchase
Hi friend Basti, I don’t know if I’m crazy or if I’m missing some configuration, when adding a delivery address it seems that the latitude and longitude were added automatically before the last update, I’m doing some tests here and I saw that the fields are not filling in automatically, neither on the web nor in the PWA, did you change something? Or did I forget some configuration? I reinstalled the system on another server now and came across this!
i don’t have changes in the address as you can see the log file changes
when you add address it will use the coordinates of the address now if you change the map pin or adjust the pin
when saving that would be the coordinates
Sorry Basti, I’m using location search and I forgot to enable it (Enabled get coordinates from maps) now it works fine on the web, but in the pwa the map is not loading I get the error: this page did not load the map correctly, in principle my apis are working on the normal web, did I forget some configuration?
in latest version of kmrs i added new api keys only for all apps
you need to set this in admin panel -> site config -> map api keys -> Google Maps JavaScript API Key (Mobile App)
hey basti, sent you email about spend-based free item
sent
No worries
sorry ?
congrats for the update. cheers!
Thank you mate !
Hi mate, is there any updates about multi-branch feature?
am carefully doing this cause its affect the main core of kmrs yes its on development
Okay mate. Thank you.
cheers
email sent
sent
Hi mate, after updating to the latest version, the Merchant → Dashboard shows Total Sales = $0.00. Before the update it displayed the correct total.
no changes in this part kindly update the files and run fixed database
sent
?
Mail basti
sent
sen
sent
mail sent
sent
sent
sent
sent
sent
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
