Installing Oberlo on your store allows you to find products that you can start selling the same day but without having to buy inventory upfront. As Oberlo is the most popular product sourcing app in the Shopify App Store – and because, you know, we are Oberlo – we’ve decided to break down the process of setting up Oberlo as well. Here’s everything on your ecommerce checklist to do next if you’re an Oberlo user:
Don’t worry about making everything perfect at the outset. As the old saying goes, done is better than perfect, and the sooner you launch your membership site, the sooner you’ll find out if it’s what your target audience wants. It’s fine to return to this step later and work on making your membership website look more professional once you've got some traction.
Google Sheets beat Microsoft to the punch and introduced a Checkbox as one of the Data Validation options. You can go to Insert > Checkbox to quickly create one, and you can customize it by going to Data > Data Validation. I've updated most of the Google Sheets versions of my checklists to use that feature. I hope Excel gets smart and introduces a similar feature some day.
^ Bergs, J; Hellings, J; Cleemput, I; Zurel, Ö; De Troyer, V; Van Hiel, M; Demeere, JL; Claeys, D; Vandijck, D (Feb 2014). "Systematic review and meta-analysis of the effect of the World Health Organization surgical safety checklist on postoperative complications". The British Journal of Surgery. 101 (3): 150–8. doi:10.1002/bjs.9381. PMID 24469615.
Shopping Cart Life Span: How soon does your shopping cart expire for anonymous users? More than a few shopping systems use Session variables for tracking cart items, and expire within hours, especially for users behind prozies that change IP addresses often, thus rendering the current Session invalid (think AOL). Several studies point to the fact that customers will wait as long as 4 days before deciding to buy, and if the item they were looking at is still in their shopping cart, you just saved them several steps and increased the possibility of conversion substantially.
Look in the general settings “redirect” area to make sure there isn’t a redirect override that you don’t want (this happens when you clone funnels or templates and you forget!).This feature is handy, but maddening if you accidentally use it! When someone clicks SUBMIT on a button, regardless of what that action is on the button, the redirect override setting makes it so they go to THAT URL. Make sure there isn’t a URL in there (unless you meant to do it)!
Special Unicode Characters in Data Validation Lists: ☐, ☑, ✓, ✔ - This may be my favorite approach. You can include special characters like this in a Data Validation drop-down list. This isn't quite as good as clicking once to fill in a checkbox, but it is great for the mobile Excel apps. The only hard part is remembering how to insert a check mark symbol in Excel. For more information, see my article Using Unicode Character Symbols in Excel.