[SOLVED] "Artnum" column logic in database

1 month 2 weeks ago - 1 month 2 weeks ago #316651 by agaudin

I have two questions about the "artnum" column in "cbsubs_payment_items" table :
- what is th logic and code used in thoses numbers : I got only half of it ( ???-USER_ID-PLAN-ID)
- is it possible to change this process ? I tried to find where to set more readable records

Thanx by advance. Regards,

1 month 2 weeks ago #316654 by krileon
Artnum can not be changed. It's specific to a few details about what is being purchased. Specifically the following


For a merchandise plan you may have something like the below.


The above describes merchandise plan 1 being purchased for user 42 for plan 1. For a subscription this is a bit different since instead of the 3rd set being plan id it's typically subscription id. Example as follows.


The above is subscription plan 1 for user 42 with subscription 3. If it's an upgrade subscription it can also have -UPGD on the end.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
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 EST to 4:00 PM EST. 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: agaudin
1 month 2 weeks ago #316675 by agaudin
Thanks a lot for your answer !
Moderators: beatnantkrileon
Time to create page: 0.418 seconds

Facebook Twitter LinkedIn