{"els":[{"id":"loginbutton","action":"show","txt":"Login(show nickname)"},{"id":"loginbutton","action":"attr","at":"href","txt":".\/dbprocess.php?act=showlogin"},{"id":"maincontent","action":"show","txt":"<p><strong><span style=\"text-decoration: underline;\">Objective:<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Create system to import eBay and Amazon orders into database and then use the database data to ask customer to purchase from&nbsp;<a href=\"http:\/\/emmanta.com\/\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=http:\/\/EMMANTA.COM&amp;source=gmail&amp;ust=1688994944398000&amp;usg=AOvVaw3THnKiJiXTP2kGKxWfUBxx\">EMMANTA.COM<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Detail:<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export eBay and Amazon orders<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In eBay, it is relative easy<\/p>\n<p>b.&nbsp;&nbsp;&nbsp;&nbsp;In Amazon, it seems like the export doesn&rsquo;t have phone number<\/p>\n<p>c.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In ShipStation, we can export orders<\/p>\n<p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Import the csv files into our own database<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We will use the traditional relational database<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i.&nbsp;&nbsp;&nbsp;&nbsp;3 tables:<\/p>\n<p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Order detail table<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;One database record for each product within an order.<\/p>\n<p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Order table<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;One database record for each unique order<\/p>\n<p>3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Customer table<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;One database record for each unique customer<\/p>\n<p>3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Create different targeted marketing messages with coupon code and store these messages in the database<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;For example:<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i.&nbsp;&nbsp;&nbsp;&nbsp;&ldquo;Kirkland Sleep Aid&rdquo;<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ii.&nbsp;&nbsp;&nbsp;&nbsp;&ldquo;Tylenol&rdquo;<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;iii.&nbsp;&nbsp;&nbsp;&nbsp;&ldquo;Hair Growth&rdquo;<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;iv.&nbsp;&nbsp;&nbsp;&nbsp;&ldquo;Advil&rdquo;<\/p>\n<p>b.&nbsp;&nbsp;&nbsp;&nbsp;Within targeted messages, we will have variables. For example, &lt;NAME&gt; will be replaced by the actual customer name<\/p>\n<p>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We will send out the SMS messages to the targeted customers<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;For example,<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i.&nbsp;&nbsp;&nbsp;&nbsp;For all the customers who has purchased &ldquo;Kirkland Sleep Aid&rdquo; in the past, we will send them the &ldquo;Kirkland Sleep Aid&rdquo; targeted message thru SMS.<\/p>\n<p>b.&nbsp;&nbsp;&nbsp;&nbsp;Frequency<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i.&nbsp;&nbsp;&nbsp;&nbsp;Ideally, we send the first message to the customer 20 days after their most recent purchase at eBay or Amazon<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ii.&nbsp;&nbsp;&nbsp;&nbsp;Once a day, this system will automatically run a query to the database to find out eBay and Amazon customers that their most recent purchase is more than 20 days &nbsp;and we have not sent SMS to those customers.&nbsp; If something found, it will trigger an alert in the User Interface, the admin can control if we should send out the sms or not.&nbsp;<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<wbr \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;iii.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In the future phase of this system, there are some other functions that we can do:<\/p>\n<p>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We will send email also<\/p>\n<p>b.&nbsp;&nbsp;&nbsp;&nbsp;We need to measure open rate, conversion rate and other metrics for the SMS or\/and email messages that we send out.<\/p>\n<p>c.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>"},{"id":"processing","action":"hide","txt":""},{"id":"error_report","action":"show","txt":""}]}