[Skip to main content](#vessel-content)

#  Profile for posurreal

##

[![posurreal's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35847-posurreal "View posurreal's Profile")

**[ Offline](/forum/user/35847-posurreal)**

- **User Type:** User

- **Register Date:** 22 Jan 2015
- **Last login:** 4 months 1 week ago
- **Time Zone:**  UTC -5:00
- **Local Time:** 22:53

- **Posts:** 20
- **Profile views:** 91
- **Thank you received:** 4

- **Gender:** Unknown
- **Birthdate:** Unknown
- **Medals:**  Hikashop Business

- Posts

#  posurreal's recent posts  (20 messages )

All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year     All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368) | [Remove Pricing on User's Email Template](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368 "-- url of the page with the problem -- :   wmrhill.com/glass-containers  -- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Firefox and Chrome -- Error-message(debug-mod must be tuned on) -- : N/A  Hi there,  I used AI to assist with the email template changes and we've made great progress! However, I can't seem to remove the $0.00 on the email template for the user who filled out the request.  My client is in a panic, thinking the user will assume the product is free. I've commented out references to pricing directly in the admin area and I manually uploaded order&#95;notification.preload.modified.php through the file manager. See attached, changed php to txt for security purposes.  In configuration, Display Price is set to No. Perhaps that doesn't apply to the email template?  Thanks for your time, Mary")         Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368 "Eureka! This is fabulous information!  1) I'll definitely use the administrator area to customize those accordingly.  2) I was editing order&#95;notification.preload.modified.php and similar files VS order&#95;creation&#95;notification.preload.modified.php. Yes, I will focus on the HTML version  3) Thanks for the tags to look for related to pricing since I'm using it as a quoting system.  Thanks Nicolas!") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:252 | [Last Post](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368 "Eureka! This is fabulous information!  1) I'll definitely use the administrator area to customize those accordingly.  2) I was editing order&#95;notification.preload.modified.php and similar files VS order&#95;creation&#95;notification.preload.modified.php. Yes, I will focus on the HTML version  3) Thanks for the tags to look for related to pricing since I'm using it as a quoting system.  Thanks Nicolas!") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372359) | [Remove Pricing on User's Email Template](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372359 "-- url of the page with the problem -- :   wmrhill.com/glass-containers  -- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Firefox and Chrome -- Error-message(debug-mod must be tuned on) -- : N/A  Hi there,  I used AI to assist with the email template changes and we've made great progress! However, I can't seem to remove the $0.00 on the email template for the user who filled out the request.  My client is in a panic, thinking the user will assume the product is free. I've commented out references to pricing directly in the admin area and I manually uploaded order&#95;notification.preload.modified.php through the file manager. See attached, changed php to txt for security purposes.  In configuration, Display Price is set to No. Perhaps that doesn't apply to the email template?  Thanks for your time, Mary")         Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368 "Eureka! This is fabulous information!  1) I'll definitely use the administrator area to customize those accordingly.  2) I was editing order&#95;notification.preload.modified.php and similar files VS order&#95;creation&#95;notification.preload.modified.php. Yes, I will focus on the HTML version  3) Thanks for the tags to look for related to pricing since I'm using it as a quoting system.  Thanks Nicolas!") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:252 | [Last Post](/forum/25-install-update/910624-remove-pricing-on-users-email-template#372368 "Eureka! This is fabulous information!  1) I'll definitely use the administrator area to customize those accordingly.  2) I was editing order&#95;notification.preload.modified.php and similar files VS order&#95;creation&#95;notification.preload.modified.php. Yes, I will focus on the HTML version  3) Thanks for the tags to look for related to pricing since I'm using it as a quoting system.  Thanks Nicolas!") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331) | [Drag and Drop Feature for Email Templates](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331 "-- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : N/A  Hi there! I have several custom fields such as style, capacity, finish, mold number, and those specific to the category such as finish cork crowns TE. There are 22 total custom fields.  I attempted to use the drag and drop area of the default email template. I moved all product info into 1 column. But, after I save, it reverts to the row and is cut off in the template.  Here are the two templates I worked with using the drag and drop.  ----- ID #2 Quote request notification Admin Receives Email subject line that starts with ... &quot;Success! Quote Request No. %s is now %s at %s&quot;  ----- ID #5 Quote request notification User Receives Email subject line that starts with ... &quot;Well done! Quote Request No. %s is now %s at %s&quot;  I customized the HTML in the previous Hikashop version, but it makes sense to get this working and avoid another round of edits in the next upgrade.  Any ideas?")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331 "Thank you. Sounds like I will customize it, now that's it's upgraded. Then, I'll do it again for future updates.") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:288 | [Last Post](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331 "Thank you. Sounds like I will customize it, now that's it's upgraded. Then, I'll do it again for future updates.") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372326) | [Drag and Drop Feature for Email Templates](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372326 "-- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : N/A  Hi there! I have several custom fields such as style, capacity, finish, mold number, and those specific to the category such as finish cork crowns TE. There are 22 total custom fields.  I attempted to use the drag and drop area of the default email template. I moved all product info into 1 column. But, after I save, it reverts to the row and is cut off in the template.  Here are the two templates I worked with using the drag and drop.  ----- ID #2 Quote request notification Admin Receives Email subject line that starts with ... &quot;Success! Quote Request No. %s is now %s at %s&quot;  ----- ID #5 Quote request notification User Receives Email subject line that starts with ... &quot;Well done! Quote Request No. %s is now %s at %s&quot;  I customized the HTML in the previous Hikashop version, but it makes sense to get this working and avoid another round of edits in the next upgrade.  Any ideas?")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331 "Thank you. Sounds like I will customize it, now that's it's upgraded. Then, I'll do it again for future updates.") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:288 | [Last Post](/forum/25-install-update/910617-drag-and-drop-feature-for-email-templates#372331 "Thank you. Sounds like I will customize it, now that's it's upgraded. Then, I'll do it again for future updates.") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324) | [Admin Notification: Include email address of user](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324 "-- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : N/A  I am pleased to announce that I have upgraded Joomla and Hikashop! I also created overrides in the Language file for English.  My next step is to figure out how I can include the user's email address in the admin notification email.This means they can see the quote request but do not have a way to reply to the user. I had this issue in the previous version and can't find a solution for the upgraded version.  I used the https://URL/upgrade as a staging area. Nicholas still has super admin access, but I'm happy to send it again.  Best Regards, Mary")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324 "Thank you Nicolas,  Fortunately, I started with a clean slate (no customizations) after updating, but that's the next task on my list.  Again, I appreciate you! Mary") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:241 | [Last Post](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324 "Thank you Nicolas,  Fortunately, I started with a clean slate (no customizations) after updating, but that's the next task on my list.  Again, I appreciate you! Mary") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372298) | [Admin Notification: Include email address of user](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372298 "-- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.1 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : N/A  I am pleased to announce that I have upgraded Joomla and Hikashop! I also created overrides in the Language file for English.  My next step is to figure out how I can include the user's email address in the admin notification email.This means they can see the quote request but do not have a way to reply to the user. I had this issue in the previous version and can't find a solution for the upgraded version.  I used the https://URL/upgrade as a staging area. Nicholas still has super admin access, but I'm happy to send it again.  Best Regards, Mary")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 4 months 1 week ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324 "Thank you Nicolas,  Fortunately, I started with a clean slate (no customizations) after updating, but that's the next task on my list.  Again, I appreciate you! Mary") 4 months 1 week ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:2  Views:241 | [Last Post](/forum/25-install-update/910609-admin-notification-include-email-address-of-user#372324 "Thank you Nicolas,  Fortunately, I started with a clean slate (no customizations) after updating, but that's the next task on my list.  Again, I appreciate you! Mary") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 1 week ago |
| [](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372259) | [Admin Notification: Include email address of user](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372259 "-- url of the page with the problem -- :   wmrhill.com/quote-request-shopping-cart/checkout  -- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : No error.  Hi there! Thank you for your time. My client receives the admin notification and I get cc'ed on the order notification.  Right now, there is no email address showing up inside the body of the admin notification, so there is no way to respond to the user who sent the quote request.  --- 2QUESTIONS --- 1) Which {tag} do I use to populate it 2) Do I populate it in all 3 PHP files?  --- WHAT I ATTEMPTED --- I downloaded: order&#95;admin&#95;notification.html.modified.php order&#95;admin&#95;notification.preload.modified.php order&#95;admin&#95;notification.text.modified.php  I placed the email address in this area of the code:   {TXT:BILLING&#95;ADDRESS} {VAR:BILLING&#95;ADDRESS} {billing&#95;address.address&#95;email}   Before that, I tried using USER&#95;EMAIL.  I feel like I'm super close to solving it, but can't seem to get there. - Mary")        Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 4 months 2 weeks ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372260 "Hi,  You do not need to download the latest version or pull any files for this. The tag is not tied to a recent version (it has been available for years), and the data it shows is already present on your site. It is missing from your template simply because that email layout was customized at some point and the line that printed it was removed.  The simplest fix is to add one tag where you want the address to appear :  This reads the customer's account email directly. It works the same way in the order creation email and in the admin notification, so it is the safest tag to use in a customized template.") 4 months 2 weeks ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:348 | [Last Post](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372260 "Hi,  You do not need to download the latest version or pull any files for this. The tag is not tied to a recent version (it has been available for years), and the data it shows is already present on your site. It is missing from your template simply because that email layout was customized at some point and the line that printed it was removed.  The simplest fix is to add one tag where you want the address to appear :  This reads the customer's account email directly. It works the same way in the order creation email and in the admin notification, so it is the safest tag to use in a customized template.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 months 2 weeks ago |
| [](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372254) | [Admin Notification: Include email address of user](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372254 "-- url of the page with the problem -- :   wmrhill.com/quote-request-shopping-cart/checkout  -- HikaShop version -- : 6.5.0 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : No error.  Hi there! Thank you for your time. My client receives the admin notification and I get cc'ed on the order notification.  Right now, there is no email address showing up inside the body of the admin notification, so there is no way to respond to the user who sent the quote request.  --- 2QUESTIONS --- 1) Which {tag} do I use to populate it 2) Do I populate it in all 3 PHP files?  --- WHAT I ATTEMPTED --- I downloaded: order&#95;admin&#95;notification.html.modified.php order&#95;admin&#95;notification.preload.modified.php order&#95;admin&#95;notification.text.modified.php  I placed the email address in this area of the code:   {TXT:BILLING&#95;ADDRESS} {VAR:BILLING&#95;ADDRESS} {billing&#95;address.address&#95;email}   Before that, I tried using USER&#95;EMAIL.  I feel like I'm super close to solving it, but can't seem to get there. - Mary")        Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 4 months 2 weeks ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372260 "Hi,  You do not need to download the latest version or pull any files for this. The tag is not tied to a recent version (it has been available for years), and the data it shows is already present on your site. It is missing from your template simply because that email layout was customized at some point and the line that printed it was removed.  The simplest fix is to add one tag where you want the address to appear :  This reads the customer's account email directly. It works the same way in the order creation email and in the admin notification, so it is the safest tag to use in a customized template.") 4 months 2 weeks ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:348 | [Last Post](/forum/35-orders-management/910596-admin-notification-include-email-address-of-user#372260 "Hi,  You do not need to download the latest version or pull any files for this. The tag is not tied to a recent version (it has been available for years), and the data it shows is already present on your site. It is missing from your template simply because that email layout was customized at some point and the line that printed it was removed.  The simplest fix is to add one tag where you want the address to appear :  This reads the customer's account email directly. It works the same way in the order creation email and in the admin notification, so it is the safest tag to use in a customized template.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 months 2 weeks ago |
| [](/forum/27-checkout/910584-change-country-default#372201) | [Change Country Default](/forum/27-checkout/910584-change-country-default#372201 "-- HikaShop version -- : 6.4.1 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : Country issue, no specific error  UPDATE- SOLVED: Found in Zones.  HI there, Thank you for your time. In the checkout process, the default country is United States Minor Outlying Islands which then shows Baker Island. Potential customers don't know to look to the bottom to change the country, then scroll up to the State.  Where is the setting to change it to United States of America?")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 4 months 3 weeks ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/27-checkout/910584-change-country-default#372201 "-- HikaShop version -- : 6.4.1 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : Country issue, no specific error  UPDATE- SOLVED: Found in Zones.  HI there, Thank you for your time. In the checkout process, the default country is United States Minor Outlying Islands which then shows Baker Island. Potential customers don't know to look to the bottom to change the country, then scroll up to the State.  Where is the setting to change it to United States of America?") 4 months 3 weeks ago     by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile") | Replies:0  Views:307 | [Last Post](/forum/27-checkout/910584-change-country-default#372201 "-- HikaShop version -- : 6.4.1 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Browser(s) name and version -- : Chrome Version 149.0.7827.54 and Firefox Version 149.0.7827.54 -- Error-message(debug-mod must be tuned on) -- : Country issue, no specific error  UPDATE- SOLVED: Found in Zones.  HI there, Thank you for your time. In the checkout process, the default country is United States Minor Outlying Islands which then shows Baker Island. Potential customers don't know to look to the bottom to change the country, then scroll up to the State.  Where is the setting to change it to United States of America?") by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")      4 months 3 weeks ago |
| [](/forum/35-orders-management/910583-routing-quote-request-to-google-sheet#372200) | [Routing Quote Request to Google Sheet](/forum/35-orders-management/910583-routing-quote-request-to-google-sheet#372200 "-- HikaShop version -- : 6.4.1 -- Joomla version -- : 6.1.0 -- PHP version -- : 8.3 -- Error-message(debug-mod must be tuned on) -- : No error message, but Email issue.  Thank you for your time!  My client is having trouble receiving email notices when someone requests a quote. Since I have no control over that, I'd like to route quote requests to a Google Sheet. Please see details below.  Customers add products to the &quot;Quote Cart&quot; and submit a quote request, which creates an order in the HikaShop backend. There is no pricing, tax, shipping, or payment involved on the customer-facing side.  Our goal is to automatically log each new quote request (order) to a Google Sheet, similar to how the RSForms Google Sheets plugin works for contact form submissions. We already have a Google Cloud project with the Sheets API enabled and OAuth 2.0 credentials in place.  Questions:  Does HikaShop Business offer a native plugin or integration for logging orders/quote requests to Google Sheets?  If not, is there an officially recommended third-party plugin or approach you support?  Are there any HikaShop events (such as onAfterOrderCreate) that a custom Joomla plugin could reliably hook into for this purpose on Joomla 6?")        Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 4 months 3 weeks ago, by [posurreal](/forum/user/35847-posurreal "View posurreal's Profile")       [Last Post](/forum/35-orders-management/910583-routing-quote-request-to-google-sheet#372203 "Hi,  Thanks for the detailed write-up.  1) No, HikaShop has no native Google Sheets connector, and we don't bundle or officially resell a third-party one for it.  2) You don't actually need a third-party plugin. HikaShop Business already has what you need in the Mass actions feature (System &gt; Mass actions). Create a mass action with:  - Trigger: &quot;After an order is created&quot; (or &quot;After an order is confirmed&quot; if you only want submitted quotes). - Action: &quot;Send HTTP request&quot;, which lets you POST the order data to any URL, with your own headers and a body where you can inject fields with placeholders like {order&#95;id}, {order&#95;number}, etc.  The simplest sink for the Sheet is a Google Apps Script Web App: deploy a small script with a doPost(e) that calls sheet.appendRow(...), and point the mass action's HTTP request at its /exec URL. That avoids juggling OAuth tokens on the Joomla side, since the script writes to the Sheet under its own account.  If you prefer to hit the Sheets API directly (spreadsheets.values.append), the &quot;Send HTTP request&quot; action also has a built-in OAuth2 mode (token URL, token request body, token extraction) so it can fetch a bearer token before the call. The Apps Script route is just less work in practice.  There is also a &quot;Run PHP code&quot; action in the same mass action if you want to call the Sheets API straight from PHP using the credentials you already set up.  3) Yes. The reliable hook is onAfterOrderCreate, in a plugin of the &quot;hikashop&quot; group:  public function onAfterOrderCreate(&amp;$order, &amp;$send&#95;email) { ... }  It fires for every new order, including quote requests, since those go through the same order-save path. onAfterOrderUpdate(&amp;$order, &amp;$send&#95;email) is the matching hook for later status changes. This is exactly the event the Mass actions order plugin uses internally, so whichever route you pick (no-code mass action or your own plugin), you are hooking the same point.") 4 months 3 weeks ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:269 | [Last Post](/forum/35-orders-management/910583-routing-quote-request-to-google-sheet#372203 "Hi,  Thanks for the detailed write-up.  1) No, HikaShop has no native Google Sheets connector, and we don't bundle or officially resell a third-party one for it.  2) You don't actually need a third-party plugin. HikaShop Business already has what you need in the Mass actions feature (System &gt; Mass actions). Create a mass action with:  - Trigger: &quot;After an order is created&quot; (or &quot;After an order is confirmed&quot; if you only want submitted quotes). - Action: &quot;Send HTTP request&quot;, which lets you POST the order data to any URL, with your own headers and a body where you can inject fields with placeholders like {order&#95;id}, {order&#95;number}, etc.  The simplest sink for the Sheet is a Google Apps Script Web App: deploy a small script with a doPost(e) that calls sheet.appendRow(...), and point the mass action's HTTP request at its /exec URL. That avoids juggling OAuth tokens on the Joomla side, since the script writes to the Sheet under its own account.  If you prefer to hit the Sheets API directly (spreadsheets.values.append), the &quot;Send HTTP request&quot; action also has a built-in OAuth2 mode (token URL, token request body, token extraction) so it can fetch a bearer token before the call. The Apps Script route is just less work in practice.  There is also a &quot;Run PHP code&quot; action in the same mass action if you want to call the Sheets API straight from PHP using the credentials you already set up.  3) Yes. The reliable hook is onAfterOrderCreate, in a plugin of the &quot;hikashop&quot; group:  public function onAfterOrderCreate(&amp;$order, &amp;$send&#95;email) { ... }  It fires for every new order, including quote requests, since those go through the same order-save path. onAfterOrderUpdate(&amp;$order, &amp;$send&#95;email) is the matching hook for later status changes. This is exactly the event the Mass actions order plugin uses internally, so whichever route you pick (no-code mass action or your own plugin), you are hooking the same point.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      4 months 3 weeks ago |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.074 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
