Subscription Add on Module

[dave1!dave]

Hello -

I am looking for a subscription module that will allow me to charge users for access on a monthly basis. They will checkout using paypal the first time then we auto charge their card and continue to enable their access to our content month by month.

It could also be an annual subscription that simply expires as the end of the year.

Zen Cart 1.5.5a
Database Patch Level: 1.5.5
v1.5.5a [2016-06-26 19:08:42] (New Installation-v155a)
v1.5.5a [2016-06-26 19:08:42] (New Installation-v155a)
php 7.1.33
SEO module
1 page checkout module

[dbltoe]

You might be able to find some commercial mod that uses PayPal but watch out using Credit Cards if in the U.S. You could be violating PCI requirements.

[carlwhat]

You might be able to find some commercial mod that uses PayPal but watch out using Credit Cards if in the U.S. You could be violating PCI requirements.

this is a statement, that while not inherently false, i find completely misleading.

PCI requirements are for any entity that processes credit cards. from their site:

"The PCI DSS is the global data security standard that any business of any size must adhere to in order to accept payment cards...."

the EU has, for years, been far ahead of the US when it comes to credit card security. the idea implied in the above statement, that you could be violating PCI if in the US, but not elsewhere, is simply false...

this payment module allows for the secure storage of credit cards on the authorize.net gateway:

https://www.zen-cart.com/downloads.php?do=file&id=2272

adding a subscription element to this module, is no doubt possible, but not included in the base implementation.

best.

[dbltoe]

PCI requirements are for any entity that processes credit cards. from their site:

"The PCI DSS is the global data security standard that any business of any size must adhere to in order to accept payment cards...."

the EU has, for years, been far ahead of the US when it comes to credit card security. the idea implied in the above statement, that you could be violating PCI if in the US, but not elsewhere, is simply false...

this payment module allows for the secure storage of credit cards on the authorize.net gateway:

https://www.zen-cart.com/downloads.php?do=file&id=2272

adding a subscription element to this module, is no doubt possible, but not included in the base implementation.

best.

Actually, yours is a statement, that while not inherently false, I find completely misleading. Especially when you "put words in my mouth."

The very fact that the rest of the world may be doing a better job of PCI does not negate the fact that anyone wanting to mess with this sort of thing MUST be aware of SAD, EMV, CVV, etc; Rules 3.1-3.6 of PCI standards, and (most importantly) what is going on at their server. It is more prevalent in the US as most hosting companies don't seem to care and the merchant accounts seem to get kickbacks from the folks who offer to "fix" your problem.

The suggestion of doing a "fix it and forget it" with Zen Cart is misleading without the warning that there is still danger out there in PCI land. No matter what you do with Zen Cart (The only one I know to ever be PCI certified BTW) there still lies the problem with the server the site is sitting on or the server that is going to store the PAN and PAN-related items. There are some major hosting companies out there who do not meet PCI standards in any way whatsoever. Just go to ssllabs.com/ssltest and enter a major host. Maybe WentUncle.com They support protocols TLS 1.0 and 1.1 which were deprecated thirty months ago.

[DrByte]

the server that is going to store the PAN and PAN-related items

The OP didn't say they were planning to collect and store card numbers. In fact they specifically said they intend to use PayPal to handle it.

So, while @dbltoe is correct that collecting cards and storing them on your own server is dangerous,
so also @carlwhat is correct in pointing out that it is reasonable to trust a properly certified payment gateway that is compliant with all standards.

Both of you have taken this discussion entirely off topic.

[DrByte]

I am looking for a subscription module that will allow me to charge users for access on a monthly basis. They will checkout using paypal the first time then we auto charge their card and continue to enable their access to our content month by month.

It could also be an annual subscription that simply expires as the end of the year.

At the present time there's no official subscription plugin for Zen Cart to do automated repeated product sales. This is mostly because people then expect it to auto-generate orders AND also control all access to content automatically ... which is a tall order since it's impossible to know what sort of content you'd want it to control!

Zen Cart 1.5.5a
php 7.1.33

Friendly reminder: If such a feature does get added to Zen Cart it won't be added to old versions like v1.5.5. Best to start planning for an upgrade if you wish to be able to use plugins that get built for modern versions.

[dave1!dave]

Thank you for the detail.

[dave1!dave]

I found this plug in for subscriptions.

https://zucando.com/zen-cart-modules...s-for-zen-cart

Might be what I am looking for.

Dave

[flappingfish]

I found this plug in for subscriptions.

https://zucando.com/zen-cart-modules...s-for-zen-cart

Might be what I am looking for.

Dave

Just came across this whilst looking for something that would allow me to create a social club and unfortunately the module you linked too is no longer available, anyone happen to have the files for that module still after all these years??

my other option is to use the following ai generated "module" that to me looks like it is missing a few steps...

<?php
/**
 * Soundbyte Social Club Membership Module
 * This module integrates membership signup, management, and QR code generation into a Zen Cart store.
 */

// Ensure secure execution
define('IS_ADMIN_FLAG', true);

// Include necessary libraries
require_once(DIR_FS_CATALOG . '/vendor/phpqrcode/qrlib.php');

class MembershipModule {

    /**
     * Create membership as a product
     */
    public static function addMembershipProduct() {
        global $db;

        $membershipProduct = [
            'products_name' => 'Soundbyte Social Club Membership',
            'products_description' => 'Become a member of the Soundbyte Social Club and enjoy exclusive benefits, including music events and trading card tournaments!',
            'products_price' => 20.00,
            'products_tax_class_id' => 1,
            'products_status' => 1,
            'products_quantity' => 9999,
            'products_date_added' => 'NOW()',
        ];

        // Insert product into database
        zen_db_perform(TABLE_PRODUCTS, $membershipProduct);

        // Assign product to a specific category (optional)
        $productId = $db->Insert_ID();
        zen_db_perform(TABLE_PRODUCTS_TO_CATEGORIES, [
            'products_id' => $productId,
            'categories_id' => 1 // Replace with actual category ID for memberships
        ]);
    }

    /**
     * Create a new database table to store membership details
     */
    public static function createMembershipTable() {
        global $db;
        
        $sql = "CREATE TABLE IF NOT EXISTS club_members (
                    member_id INT AUTO_INCREMENT PRIMARY KEY,
                    customer_id INT NOT NULL,
                    membership_start_date DATETIME NOT NULL,
                    membership_status ENUM('Pending', 'Active', 'Expired') DEFAULT 'Pending',
                    waiting_period_end_date DATETIME NOT NULL,
                    qr_code_path VARCHAR(255),
                    FOREIGN KEY (customer_id) REFERENCES customers(customers_id)
                ) ENGINE=InnoDB;";
        $db->Execute($sql);
    }

    /**
     * Handle membership purchase
     */
    public static function handleMembershipPurchase($customerId) {
        global $db;

        $startDate = date('Y-m-d H:i:s');
        $waitingPeriodEndDate = date('Y-m-d H:i:s', strtotime('+48 hours'));

        // Generate QR Code
        $qrData = "MemberID: $customerId | StartDate: $startDate";
        $qrFileName = DIR_FS_CATALOG . "images/membership_qr_$customerId.png";
        QRcode::png($qrData, $qrFileName, QR_ECLEVEL_H, 10);

        // Insert membership details into the database
        $db->Execute("INSERT INTO club_members (customer_id, membership_start_date, membership_status, waiting_period_end_date, qr_code_path)
                      VALUES ('$customerId', '$startDate', 'Pending', '$waitingPeriodEndDate', '$qrFileName')");

        // Notify customer
        self::sendMembershipEmail($customerId, $qrFileName, $waitingPeriodEndDate);
    }

    /**
     * Send membership confirmation email
     */
    private static function sendMembershipEmail($customerId, $qrFileName, $waitingPeriodEndDate) {
        global $db;

        // Fetch customer email
        $customerQuery = $db->Execute("SELECT customers_email_address, customers_firstname FROM customers WHERE customers_id = '$customerId'");
        $email = $customerQuery->fields['customers_email_address'];
        $firstName = $customerQuery->fields['customers_firstname'];

        // Email content
        $subject = "Welcome to Soundbyte Social Club";
        $message = "Dear $firstName,\n\nThank you for joining the Soundbyte Social Club!\n\n" .
                   "Your membership is now active. Please note that alcohol privileges will be available after $waitingPeriodEndDate.\n\n" .
                   "Attached is your digital membership card with a QR code for quick verification.\n\nEnjoy exclusive events, music, and more!\n\nBest regards,\nSoundbyte Social Club";

        // Attach QR Code
        $attachment = chunk_split(base64_encode(file_get_contents($qrFileName)));
        $boundary = "==Boundary" . md5(time());

        $headers = "From: [email protected]\r\n" .
                   "MIME-Version: 1.0\r\n" .
                   "Content-Type: multipart/mixed; boundary=\"$boundary\"\r\n\r\n" .
                   "--$boundary\r\n" .
                   "Content-Type: text/plain; charset=UTF-8\r\n\r\n" .
                   "$message\r\n\r\n" .
                   "--$boundary\r\n" .
                   "Content-Type: image/png; name=\"membership_qr_$customerId.png\"\r\n" .
                   "Content-Disposition: attachment; filename=\"membership_qr_$customerId.png\"\r\n" .
                   "Content-Transfer-Encoding: base64\r\n\r\n" .
                   "$attachment\r\n--$boundary--";

        // Send email
        mail($email, $subject, '', $headers);
    }

    /**
     * Display membership QR code in customer account page
     */
    public static function displayMembershipQRCode($customerId) {
        global $db;

        $query = $db->Execute("SELECT qr_code_path FROM club_members WHERE customer_id = '$customerId'");
        if ($query->RecordCount() > 0) {
            echo '<div><h3>Your Membership QR Code</h3>';
            echo '<img src="' . DIR_WS_CATALOG . $query->fields['qr_code_path'] . '" alt="Membership QR Code">';
            echo '</div>';
        } else {
            echo '<p>No active membership found. Join the Soundbyte Social Club today!</p>';
        }
    }
}

// Initialization
MembershipModule::createMembershipTable();
MembershipModule::addMembershipProduct();

I spotted the db query looks wrong and that is probably the least of the issues, usually takes a while to edit these into something that works