Magento stores old sales quotes dating back to the first day you launched your site. Sooner than you know it, you can be up to a couple million quotes that have never been processed but which can take up significant space, and slow your database.
This SQL query will clean out quotes (and their related content in other tables) that are older than 60 days.
DELETE FROM quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY)
Make sure to get this task setup on a cron job so that you don’t have to think about it again and your Magento store can keep running fast!
Frustrated by the ridiculous database log management (or the lack thereof) in Magento 2? Us too. We keep hoping that with each iteration, 2.1, 2.2, 2.3 they would finally consider that actions that took place four years ago don’t need to be cluttering our databases. I digress. If you’re looking for a quick sql solution to clean up millions of database rows in your Magento installation, look no further:
SET foreign_key_checks = 0; TRUNCATE customer_log; TRUNCATE customer_visitor; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE report_viewed_product_aggregated_daily; TRUNCATE report_viewed_product_aggregated_monthly; TRUNCATE report_viewed_product_aggregated_yearly; TRUNCATE report_viewed_product_index; TRUNCATE product_alert_stock; TRUNCATE search_query; TRUNCATE catalogsearch_fulltext_scope1; TRUNCATE sales_bestsellers_aggregated_yearly; TRUNCATE sales_bestsellers_aggregated_monthly; TRUNCATE sales_bestsellers_aggregated_daily; SET foreign_key_checks = 1;
This week, Magento, the e-commerce content management system used by top development teams around the world, announced the public release of Magento 2.0, ushering in a new era of online sales. Saderra is pleased to announce we are among the first web development agencies to take advantage of the new platform. Magento 2.0 offers enhanced performance and scalability, new features to boost conversion rates, and business agility and productivity improvements.
Magento has long been the leader in B2C and B2B e-commerce platforms and Saderra’s values align with the open source mentality of the brand. We are excited to bring many of Magento 2.0’s new features to our clients, including increased customization, modern theming, and automated testing. Magent0 2.0 also allows for increased scalability and decreased product set up, meaning your site will be up and running faster than ever.
For those unfamiliar with what Magento offers, Magento 2.0 is the best way to connect you with your customers and offers integration with secure and trusted payment partners, including PayPal, Braintree, and Authorize.net. Additionally, the integrated support we offer with Stripe allows for your store to now accept Apple Pay and Google Pay. This ability to allow customer to make purchases with a simple scan of their fingerprint has been proven to increase sales.
I remember the 90’s. I was a wizard using Dreamweaver, and I was one of the best Cold Fusion developers in the world. I could table up a website in my sleep. I could output an Access database with my eyes closed. I rocked tags most people web developers today have never even heard of.
Then came div tags. Div tags were great back in the day. It allowed your website content to reformat based upon the size of the browser. We had almost four different screen sizes back then, so that was pretty important. Admittedly, most of the browsers didn’t support div tags the same way, so presentation was severely hampered. Ultimately, tables won out in the front-end coding world.
If you wanted a content management system, you needed to custom build it. Tools like Joomla, WordPress, or even Movable Type were years away, so any sort of coding required custom development. This is one of the primary reasons I was so focused on Cold Fusion. To tell you the truth, I still like Cold Fusion, but that’s neither here nor there. One of the interesting, niche tricks I had up my sleeve was my mastery of Server Side Includes. This technology was ridiculously fast, and provided the ability of parting out straight HTML. (more…)
Even though you’ll see it everywhere (even here!), there is much more to SEO than “writing great content.” While this is a fantastic start, it is only a start. There are many “behind the scenes” actions that people can take to help make content more visible and increase search engine rankings. Many of these improvements are not-visible to website visitors (unless they take the time to look at your site’s code), but don’t worry, it doesn’t take advance coding or web development knowledge to make these simple changes.
I have personally been in the marketing and advertising industry since 1997; long enough to know the difference between marketing and advertising. There exists a panoply of buzzwords and descriptors of what it is we supposedly do. Web marketing, online marketing, interactive, user experience, digital… To tell you the truth, I don’t care about these labels.
Those who have been in this field as long as I don’t care either. Here’s what we care about; sharing a story or product in a way that compels the right people to listen or buy. At the end of the day we want our respective businesses to be profitable so that we can properly provide for our families. Those who have been around long enough, know that work is merely a method of generating personal security. Sure it can be fun, or even uplifting at times, but it will never match the kind of joy that is felt around loved ones.
I can always tell a marketing novice by the words they use in meetings. They throw around whatever today’s buzzwords are; banal jargon typically generated by some blog post rehashing the same self-serving recognition that most of today’s tech bloggers thrive on. Indeed, I have never met a group so desperate for the praise or recognition of their peers.
These novices have not yet learned that working 100 hours a week is actually less effective than working 40 hours a week. They remain glued to their phones and tablets, even when spending time with their friends and family. At some point, these people will hit a wall, and when they do, they will come to understand a simple principle: They have wasted their prime years in the foolish pursuit of praise.
This is one of the first things we tell people that come to work at Saderra. Indeed, we do higher junior team members on occasion and they all need to hear this message. Sometimes evens senior member need to be taught this lesson.
I understand that this approach may not make us “super-cool” or the guys everyone wants to hang out with at SXSW. But honestly? Who really cares? Not the kind of people I want to associate with, that much I’m sure of. I’d rather have my kids think I’m awesome because I go to all of their games. I’d rather my team spend time with friends and family than some conference or event. When you learn what really matters in life, you work hard to ensure you can be apart of a great company, that values the same things you do.
I suppose sharing one of our most important and distinguishing factors could be considered foolish. I am so tired of other companies not doing the same, I feel perhaps those who know this secret may be keeping it too close to the chest. (more…)
The Importance of Using Social Media
Social Media has been on the rise the last several years and now many businesses are finding that it’s important to implement. As reported by Hubspot in 2014, 92% of marketers from surveys highlighted the importance of social media marketing for their business.
The Key Performance Indicators (KPI) you track for social media are typically shares, likes, engagement, favorites, Analytics traffic, mentions, etc. Using this data consistently will help make positive changes for your business.
Content marketing was touted as the most commercially important digital marketing trend for 2015 according to the recent digital marketing trends polls from Smart Insight. Social media engagement tells people that the brand is active and legitimate, and consumers are most likely to do business with brands that are alive.
The Synergy of PR and SEO
Saderra has just introduced a PR Division, so now is the perfect time to delve into the synergy between PR and SEO. The future of SEO is not in the technology, but the ability to tell stories that readers will find interesting.
Public relations enhances SEO by focusing on what’s newsworthy, crafting a great story, finding editorial opportunities, getting coverage and building relationships with media. PR helps SEO directly by increasing branded traffic. PR professionals are skilled storytellers and content generators and should be integrated with SEO for the most successful results.
1. Create targeted press releases by constructing them carefully and distributing them to the right people. The releases need to have a strong news angle and should include relevant quotes from your company.