How We Repaired A WordPress Database Crash After Site Migration

HI Jim,

 

Hope your weekend is going well

 

When trying to add a new post in WordPress, the site times out.

 

I drilled down and it looks like a really quick fix – please provide a fix at your earliest convenience. (see SG support response below)

 

Hello Mitch,

 

Thank you for contacting our Help Desk center!

 

I checked your website and I noticed that upon creating a new post the page is loading with 404 page not found.

 

This is why I checked the setup of the website I noticed that there are two URLs applied for it:

(more…)

Continue Reading How We Repaired A WordPress Database Crash After Site Migration

Why Open Source Is An Experts Choice For Ecommerce Vs Hosted Platforms

If I were a cockatiel my crown would stand up straight when reading articles comparing web hosting sites like Shopify to WordPress.

cockatiel with crown up

 

There are other examples but to start because it appears that many people don’t understand the cord differences.

 

Shopify is a hosted platform.

 

You rent their servers, use their templates and are beholden to their support.

 

I think Shopify has about 600,000 stores right now.

 

WordPress is open source – it’s free, anyone can start a WordPress site although they will lead a host with the server to mount it on.

 

There are about 77,000,000 WordPress sites globally – about 1/3 of all internet sites.

 

(more…)

Continue Reading Why Open Source Is An Experts Choice For Ecommerce Vs Hosted Platforms

eCommerce Migration From Server Box To The AWS Cloud

In 2004 having taken the reins of IT duties for Windy City Parrot, I moved the website from a desktop server under Catherine’s desk to a server somewhere that I forget, but within a few months enough web hosts pissed me off until I ended up on a Wolfpaw server in Tenafly, New Jersey.

We’ve been in the cloud for 15 years.

In 2005 when our Milwaukee Street (Chicago) facility burned to the ground.

Had our website been on Catherine’s desktop server with all the local backup we would have lost the entire website and would’ve had to start from scratch.

With the site on a remote server we just needed new computers so we could talk to the Internet once again.

(more…)

Continue Reading eCommerce Migration From Server Box To The AWS Cloud

Quicker Online Store Cash Flow And A QuickBooks Accounting Hack

I thought some history of credit card processing would be a good base to build this post upon.

Going back as far as 9000 BC one could use cattle, camels and fish as currency.

You had to spend the fish fast.

Cowrie shells, gold and silver nuggets leading to Chinese deerskin notes and Native American wampum beads.

The Manhatten Wampum bead myth

“In the Dutch National Archives is the only known primary reference to the Manhattan sale: a letter written by Dutch merchant Pieter Schage on November 5, 1626, to directors of the West India Company, which was instrumental in the exploration and settlement of “New Netherland.” In the letter, he writes, “They have purchased the Island of Manhattes from the savages for the value of 60 guilders.” (There is a surviving deed for Manhattan and Long Island, but this was made well after this initial Manhattan purchase, when the Dutch had already been inhabiting the island for several decades.) 

Read more

As far back as 5000 years ago Mesopotamians used clay tablets but found them to be impractical for their wallets and purses.

Melting down tons of copper was not a much better option as you needed a horse and cart full of copper to go shopping at the renaissance mall.

In the 19th century, merchants would use “credit coins” and “charge plates” to extend credit for local farmers and ranchers, providing credit until their crops and livestock were sold.

Growing up in the 20th century long before Internet, payments were primarily made in cash or with a paper check.

In1946 guy by the name of John Biggins, a banker created the”Charge-it” card.

Purchases were forwarded to Mr. Biggins bank who reimbursed the merchant and chased the customers for payments.

This was coined the “closed loop system.”

Five years later, New York’s Franklin National Bank issued its first charge card.

Charge cards like the Diners Club card and American Express emerged but banks found a gravy train with consumer cards providing revolving credit with Bank of America leading the charge <-pun, in 1958.

Franklin’s marketing plan was to mail out thousands of cards arbitrarily to folks in California.

In 1966 MasterCard was born out of a group of banks forming the Inter-Bank card Association (ITC)

Bringing us to “now,” the buffet of payment processing choices is large enough for a kings celebration.

  • Credit Cards
  • Mobile Payments
  • Bank Transfers
  • Ewallets
  • Prepaid Cards
  • Direct Deposit
  • Cash

Cities are trying to ban cashless businesses 

Good luck with that.

What’s even more remarkable is the exponential explosion of companies and methods for processing money online.

Here are a few that I found, I’m sure there are more

Due
Stripe
Dwolla
Apple Pay
Payoneer
2Checkout
Amazon Payments
Square
Payza
Skrill
PayPal (237 million people have active PayPal accounts)
Braintree
Venmo
Visa checkout (20 million active customer accounts worldwide)
Google wallet
Masterpass
ACH (a U.S.-specific payment method) increased by more than 1 billion in 2017 for the third year in a row)
Ali Pay (China)
WebMoney
iDeal (the Netherlands)
Giropay (Germany)
Sofort (Austria, Belgium, France, Germany, Italy, and Spain)
eNets (Singapore)
Boleto Bancaio (Brazil)
Paysafe
SEPA Direct Debit (500 million Europeans)

via GIPHY

Begin Quicker Online Store Cash Flow And A QuickBooks Accounting Hack

Every article you’ll read and all the questions you  see on LinkedIn about merchant processors sound like:

“What’s the best merchant processing rate I can find?”

“What are all those fees and will they keep me PCI DSS compliant?”

Editor’s note – We currently use PayPal exclusively online for credit card processing (and PayPal Express) which does not require PCI DSS compliance.

(more…)

Continue Reading Quicker Online Store Cash Flow And A QuickBooks Accounting Hack
Herding Cats And Chasing Social
Young stressed handsome businessman working at desk in modern office shouting at laptop screen and being angry about e-mail spam. Collage with a mountain of crumpled paper. Business, internet concept

Herding Cats And Chasing Social

Or

 

Why I see social media imploding under its own weight.

 

None of the big-brained internet CEO’s nor the billions of people who walk the planet with a not-so-smart-phone held out in front of them so they can interact with people not close have figured out what James Madison meant when he wrote the first amendment.

 

Congress shall make no law respecting an establishment of religion, or prohibiting the free exercise thereof; or abridging the freedom of speech, or of the press; or the right of the people peaceably to assemble, and to petition the Government for a redress of grievances.

 

December 5, 2018, Tumblr banned porn.

 

A couple of little hiccups as reported by the Washington post cropped up:

 

The first lesson is that it’s hard.” 

(more…)

Continue Reading Herding Cats And Chasing Social

Another Middle Finger From Zuck To The SMB’s Of The World.

I’m no stranger to social media.

You might say “I’m ancient”.

In spite of being enrolled in Medicare, I operate double-digit WordPress and Zen cart sites and have probably half a million humans(?) following me on social media in the captive bird niche.

My target audience defined broken down by buyer persona: 

Does the mirror fog when you place it under their nose? Yes.

Do they have or are they thinking of acquiring a captive bird? Yes

Great make sure we acquire their email.

(more…)

Continue Reading Another Middle Finger From Zuck To The SMB’s Of The World.

Why Paypal Working Capital Should Be An SMBs Go To Lender

Full transparency, my only relationship with PayPal is as a customer.

PayPal Working Capital was formerly Bill Me Later.

We’ve been using PayPal for 14 years and currently have three active accounts we use for selling online. 

Square is used for walk-in retail sales so we are able to separate Indiana cash and credit card sales for sales tax filing purposes.

Ironically 10% of all our online customers live in Illinois and now get a 10.25% discount from us as we are no longer collecting and paying sales tax in that state.

(more…)

Continue Reading Why Paypal Working Capital Should Be An SMBs Go To Lender

Easy Hack For Getting Your Finances Under Control $20 At A Time

I wrote the following post in 2013 but never published it.

Six years later we are under the same precept.

Recently, we took it up farther than we ever should.

We moved our home and Windy City Parrot operations from the geographical center of Chicago to Lowell, Indiana a town of about 10,000 people surrounded by corn farms.

There’s only 5 stops light from one end of the main street (which we are on) to another.

We now have one lease instead of 2 and 4 fewer utility bills while eliminating 2 buildings to maintain.

Our State Farm vehicle insurance and business insurance dropped 50%.

(more…)

Continue Reading Easy Hack For Getting Your Finances Under Control $20 At A Time

When Did Woocommerce Stop Offering Support

I am sharing this Woocommerce support thread because it is troubling.

 

Spoiler alert – I paraphrase “this as expected but there is no documentation”

 

Obviously, I question “how would one know what to expect – when there are no instructions, knowledgebase articles or documentation on the subject?

 

Woocommerce support  is so out of touch, I’m sent a WORDPRESS document and told to figure it out

 

When I click the View link on my test site, I am redirected to the Shop page on the front end of my site. (This is as expected.)

 

When I click the Edit link, I am redirected to the user’s profile in the admin area. That’s where I would change a customer’s address or any other information.

 

We do not have documentation on this. It piggy-backs on the WordPress User system. Here is more information on that:

https://codex.wordpress.org/Users_Screen

 

I’m building my first Woocommerce store possibly migrating my 17-year-old ecomm store that does mid 6-figures

(more…)

Continue Reading When Did Woocommerce Stop Offering Support