The Steps to Execute Against the Specifications and Architecture to Make QR Shopping a Reality for Brothas and Sistas
In the previous article, we took a closer look at the QR code shopping videos that I put on Dream and Hustle multiple times and cats reading this blog was just ignoring or browsing through. Then the next article was creating specifications and prototyping of the concept. In this article, we create the execution order and task plan to make it happen.
First Step – Buy a Goddamn Windows Computer!
I’m tired of cats coming to me about these solutions and they either have some tablet or a Mac which are consumer electronic products for consumers. Don’t come at me talking about you want to be a tech entrepreneur and you not willing to invest in business grade tools to get the job done. You can buy a new Windows desktop computer or laptop from around $300 at places like Wal-Mart or whatever. I developed all this ish on a $339 cheap laptop. Do not email me, contact me or even bother with me if you running around with a Mac or a tablet thinking you going to hustle – nah, go visit the Apple store and hang out with the rest of those damn consumers.
Step 1: Setup Accounts
First thing to knock out is get the GoDaddy Windows Hosting Account – the $5/month version. I had cats get the Linux version not reading my articles and get the more expensive web hosting accounts with the same illogic as buying a $60,000 GMC Yukon. Get the cheapest version, you can always upgrade at a later time, homey and stop imagining ish causing you to pay more money on your startup hustle than what need to be spent.
The second thing I knocked out was get a firstname.lastname@example.org email box to associate with my PayPal account. The reason why is I’m planning to just use the standard PayPal Merchant service instead of the more premium accounts because we ain’t there yet in terms of the business. Once the business get good, then we can look at upgrading.
Paypal is going to display the email address to the customer at the checkout and payment section and you want an email address that best describe your domain and the PayPal service. In addition, the extra email box holds your money transactions which are nice to separate from the other email account.
If you have a web hosting account, you should have a whole bunch of free email mailboxes you can assign with a prefix of paypal@ for your web site domain address. This can be a secondary email box but this is the email box just to handle the payment communication.
The third thing and this is your database that will contain your data – this is where cats tend to f*ck up at and can’t get this right. Please make sure you get this ish right if you want to learn anything in programming and stepping your game up bigger and better than everybody else. In the options section, if you go to the bottom, there is a SQL Server icon, click on it to access SQL Server to setup.
In the screen above, you see that this is a SQL Server already setup in my account. There is a button called “Create Database” in the top right corner – setup your database if you haven’t done so. Since you are on a shared database, I suggest you give it a generic name that only you will recognize instead of qrshoppingdb or some crap like that to maintain privacy.
Now, once you got the database setup, click on the pencil icon in the row next to the x button and this brings up the detail. Print this page as this is the connection information you going to need to put in your code to connect to the database from the web site. This is the most important part and I hope you got this ish, real talk.
Step 2: Understand the Database Layer
Now that you setup the hustle, we already created the database structure based on our previous conversations on how to do the QR shopping. It is extremely important you understand this section to understand why I keep telling your Black ass to learn database. If you know database, then you basically got the foundation and can hustle anyway you want and out-hustle the rest of these wannabee cornballs chasing some white label hustle.
Based on my previous conversations and the video of the QR code shopping, this is the table that I design. I designed this table in SQL Express, the same free download you were told to get. Now when you see me describe each table below, you are going to see how you better learn to create a hustle like this that can scale up and down and flexible to expand and change the business model.
Shop. this table has the name of the shop that will be selling the products on the QR poster wall. Why do you think I made a shop table? The reason why is because you are flexible to do multiple shops in case you want to flip this code into a web service where you charge $200/month to different shops to advertise from your $5/month GoDaddy account. One shop can be a retail, another shop can be a bar to order drinks, another one can be a vendor table. See, I just set your Black ass up to run this kind of side hustle for the holiday season, setting up QR shopping posters for businesses and getting paid, if you want to go there.
Product. this is the product and it is information we will display on the QR code poster and on the web page as well as any receipt information. There is a shop id associated with each product for different products for different shops on different QR code shopping posters. Also notice I have what is called a MSRP (manufacture suggested retail price) and your price. Remember, you want to use this QR code shopping posters as deals and not charge someone full price. Show them that they will save money if they use your QR code shopping poster – that the leverage you need to sell them.
Inventory. this is an item level representation of every product you have in stock. I may have to add to this database later when I create the code to show when it was sold but this is to help you keep track of stock on the web site and what’s left. Now, even if you sell something like an mp3 album, e-books or a 30-minute massage or any digital good, still put a number out there on inventory like 500 so you can keep track of the sales. In addition, you see a serial number column and this is used to claim a digital good only once when sold and registered to one email address customer.
Poster. I take it you will have more than one QR code shopping poster around to promote your hustle. But if you take a close look at the table, I bet you going to laugh – yes, we are including the geolocation feature of the poster and that is done for a reason. But this is where you may realize an opportunity which is why I want you to hustle from the ground up. See, you can set up a commission/affiliate program that assign posters to cats who put them up on your behalf in cities around the world. So cats in New York, Miami, Chicago can put up the posters and they get paid a commission from orders scanned, expanding your hustle to the global level. Yeah, now your Black ass finally understand why I want you at the raw foundation database level when it comes to tech hustles.
Poster Log. the poster log will record every time you get a scan on a poster and this is used to determine in real-time if your QR code shopping poster is hot in some places and cold in other places. This help you understand where you need to focus the hustle at and if you need to print more posters in areas where you getting a lot of data.
PayPal. when a customer make a payment on PayPal, PayPal sends confirmation to an URL of your choosing with the transaction detail. I’ve seen some dumbass code out there that try to parse that data in an ASP.NET page. No, you take that entire page PayPal sends you and you dump it right into a database and you pull it out and parse later. That way, you don’t lose the data PayPal sends you and if PayPal change their code, you don’t start producing errors trying to parse in real-time.
Customer. if you are going to do mail shipping of your product (which is smart to avoid local sales tax – market outside the state only to large urban markets), Paypal sends this information to you in that IPN and this is what we are going to parse out. Keep in mind, it is important to ship FedEx or UPS and get a signature required from the customer, don’t just send ish out blindly.
Order. This is the order that was generated when the customer visited the mobile site to order the product via paypal. Notice how I have date fields to populate when the order was generated, when we confirmed the payment was made by PayPal and when we fulfilled or ship the order. Another good column for the database would be record the UPS or Fedex tracking number and update that information for the order.
PayPal Order. This is a join table that joins the paypal data with the order data to combine the two. This helps us pull the orders that have been paid for and need to be handled and shipped out.
Now with all that I written, did you see how transparent the hustle is when you put this kind of work in the database part? Do you see where I can expand the hustle, add features quickly and stuff like that? This is why I need you cats to understand the database part when it comes to these technology products.
Step Three: Create the Web Pages for Mobile
The web section is basically a couple of loose function pages that have their own purpose. Please note and this is important – two of the pages will not and I do not recommend to be loaded to your web site at any cost and that is the add shop and add product page. Do not make it easy or provide a portal for hackers to try to get into your data. Just have a web site with read-only and strict input web pages like a form with validation. Let’s go into each page.
Add Shop. This page allows you to enter the shop name, their shipping and pickup instructions and their terms and conditions on returns or whatever they may add. If it is only you doing this, then you can just add your shop but if you selling QR Code Shopping Posters and hosting the service to charge other cats, then you enter the multiple shops here. You can also enter multiple PayPal code in this section.
Add Product. This page allows you to upload the product image and add details about the product to be displayed on both the QR Code shopping poster and on the web site. You assign what store the product belongs to, the information and pricing data.
Product Info. This is the page the customer will navigate to after they scan the QR code and will contain the PayPal to purchase the item.
PayPal IPN. This is the web page, PayPal will send data to. We will restrict this page to only receive information from PayPal and also keep this page a unique name to prevent tampering with. Please note that PayPal will send emails to everybody once a transaction is made but the reason for this page is to notify retailers that an order was made and they should get it ready for customer pick-up.
PayPal Confirm. This is the page PayPal sends the customer back to if the payment was successful. We will display the next steps and how they should redeem and let them know we are sending more information to their email address.
PayPal Cancel. This is the page PayPal sends if the transaction failed or was cancelled. We will inform them the transaction was cancelled. We will give them the option of looking at the product in question once more time with a link.
Now here are some things in case you may not realize. The first thing you should know is we are able to detect the user language and be able to change the pages to be in the customer default language of their mobile phone. The second thing is we are able to detect if the user has a tablet or a mobile device and be able to adjust the page to fit their size.
Step 4: Make the Posters
This one we are looking at several options, including some we already designed for the upcoming retailing for hood-based business software the 30 Rotten Dissidents doing work on. The poster the lady has in her hand in the photo above is 24×36 that cost about $16 to produce as a sheet. Here is the thing – we have several options here.
One option is we can dynamically generate a PDF file that can arrange and format all of the product images and data and create QR codes that can be sent directly to the printer. The other option is we can use a flat-panel LCD screen to display the QR code shopping wall that is scrolling and animated. I have not decided on this yet which is why this is last.
As you see this article progress on Dream and Hustle about the QR Code shopping, you saw that we first discussed the business model by studying the videos and content from South Korea media. Then we created a prototype and specifications from that information. Now we created the technical architecture and wrote code to test functionality of the key pieces such as setting up the accounts, the database and the web site part.
This is how you make hustle happen for you and get shit done. Nothing is done overnight and it takes a methodology to turn something from an idea read on Dream and Hustle to execution and implementation. Most of the readers of Dream and Hustle were on some bullcrap and wasting precious time instead of understanding all of the hustles we were presenting, thinking we some joke like the rest of these Black tech clowns running their mouth.
As you see, Ed Dunn and the 30 Rotten Dissidents is the real thing. We make ish happen and when we do something, even if the concept is small, we take it to a level where the hustle can be expanded and taken worldwide and generate revenue channels in multiple venues. We are hoping you cats learn our biggest strategy to success and that is to focus on the raw foundation. Once you know the raw foundation, you can take yourself anywhere and everywhere and compete with the best in the world and do ish on that real level of the hustle where you got a real empire established.