Skip to Content Skip to Menu

💐 Happy Mother's Day! Great savings on Professional and Developer Memberships! Get 20% off now with code MOTHERDAY-2025!

[#3654] Substitutions in emails

  • ricco1
  • ricco1
  • OFFLINE
  • Posts: 310
  • Thanks: 8
  • Karma: -7
9 years 3 months ago - 9 years 3 months ago #276865 by ricco1
Replied by ricco1 on topic Substitutions in emails
Do you know any CBSubs compatible invoicing extension?
Last edit: 9 years 3 months ago by ricco1.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49130
  • Thanks: 8396
  • Karma: 1460
9 years 3 months ago #276870 by krileon
Replied by krileon on topic Substitutions in emails
I'm not aware of any, but there are a lot of reporting extensions that can function off database queries. in theory you could write a database query to output whatever CBSubs information you want and have said reporting extension output it into a formatted table. Custom phpmyadmin query then output the results to CSV could also work.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • ricco1
  • ricco1
  • OFFLINE
  • Posts: 310
  • Thanks: 8
  • Karma: -7
9 years 3 months ago #276874 by ricco1
Replied by ricco1 on topic Substitutions in emails
I don't know how to build queries for the tax and promotion calculation, unfortunately.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49130
  • Thanks: 8396
  • Karma: 1460
9 years 3 months ago #276876 by krileon
Replied by krileon on topic Substitutions in emails
You shouldn't have to. The calculated price is in _cbsubs_payment_baskets as mc_gross or payment_gross. Tax is also there stored in tax column.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • ricco1
  • ricco1
  • OFFLINE
  • Posts: 310
  • Thanks: 8
  • Karma: -7
9 years 3 months ago - 9 years 3 months ago #276880 by ricco1
Replied by ricco1 on topic Substitutions in emails
As far as I can see mc_gross is the full price, my payment_gross is empty, where is the discounted price?

When is the discounted price calculated? Is it as soon as the promotion is created?
Last edit: 9 years 3 months ago by ricco1.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49130
  • Thanks: 8396
  • Karma: 1460
9 years 3 months ago #276881 by krileon
Replied by krileon on topic Substitutions in emails
mc_gross is the total price they've been charged. It includes taxes and I believe also promotions. All the basket information is directly in that table.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: ricco1

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

Moderators: beatnantkrileon
Powered by Kunena Forum