This is what I need for my store:
We put dozens of license keys for every single product. Each time someone orders the product and order status is completed, customer will receive the license key(s) as an simple email send to the email adress he submited.
For every single product (edit/add product page) there will be a tab called "Keys", where we can manage (add, edit, remove) license keys for every product. Possibility to add by one or in bulk (every line will be a license code in textarea)
These keys will be added into DB (new tab oc_product_keys) That will consider of columns:
id(just autoincrement), product_id(connection of the key to a product), key(the single key by itself, key entered in product -> keys tab), sent (0 by default, the key wasn't sent out), customer_id (will explain later), email (explain later), price (explain later)
You'll edit the checkout :
In second step (after seeing the cart), user will enter an email adress he wants the license to be sent on.
And then he needs to confirm that email before he can come to next step (by sent link).
Once he does this, he can continue checkout.
When checkout status is "completed" so all payments been done. Your new "extension" will iterate through the product the user just ordered and for every product do this action:
Choose one row where product id = id of the product bought and sent is not 1 and key is not empty (explain later). Edit the db record:
customer_id (will become id of the customer who bought this), email (will become the email customer just entered and confirmed), price (price of the product that has been bought for, including specials etc...) sent = 1 (this indicates the key was just used)
And will send an email to the email adress filled in: that will include the a row for every product bought. (if 2 products of same product_id were bought, it counts as 2 products = 2 keys = 2 records and so on..)
Row for every single product bought will include: product name, product thumb, the key and manufacturer.
In the case user buys a product that has no keys available a record with empty key column is made (for every product in order)
And simple text apologize email is sent to the email adress given.
Once admin fills in new keys, the system will automatically check if there is no empty key record... if so, fill the newly added key in and send the same email as checkout would do (prod. name, manufacturer, key, thumb for every product...)
Doesn't matter how many products bought, only one email including all of them is sent.
Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Kind Regards,
Need more detail,can we discuss this,to know more detail,check Private Message.
We have a team of professionals,they have more than 11 year of experience,so we can manage this work and will give you quality solution