Work

Play

Live

Work

Importing Products in Multiple Languages Using WPML & WooCommerce Product CSV Import Suite

By default, the WooCommerce Product CSV Import Suite will always import your products in the default language of your eCommerce website. This can be problematic when you are working with a site that has multiple languages.

While WPML is not my language plugin of choice for WordPress, it definitely requires the least amount of work to get running with the WooCommerce ecommerce plugin. It also has several necessary functionalities that make importing products in multiple languages easier than it looks. Here’s my process in more detail.

Import Products in Default Language

A small tip, would be to have all your product images, categories, attributes and tags already uploading into WordPress. I’ve drag-and-drop uploaded over 500 images with no problem, so you shouldn’t have any problems either!

In any case, the first step is to only import the products in the default language of your theme. If you don’t do this, you’ll want to shoot yourself later on. This is relatively easy to do and if you need help working with the CSV either drop a line in the comments or read the official plugin documentation.

Export All Your Products

These easiest way to set up a unique way of detecting what products are in your default language is by exporting them before duplicating. This will allow you to create a function in Excel that can tell you if they are in the default language master sheet or not. This method of ID will only work if you are doing a bilingual site. I’m sure you can figure out a better way if you’re dealing with multiple languages. Please leave the method in the comments if you do!

Duplicate Your Products in Every Other Language

Go to the WPML Translation Dashboard in the Translation Management section. Select all your product posts and scroll down. You should see the option to duplicate the posts for your other languages. Do it as many times as needed. Be sure to have your selection only include posts that have no translation or you may be repeating the same action over and over for nothing.

Merge Proper Text for All Non-Default Languages

This is the last step on your translation journey. Export all your products and use the Excel sheet with your default language products to identity them if needed. Update the relevant information for your translations and merge. Your task is now done!

Work

Mixing Product / Informational and Marketing Content

The last talk that I will be attending at RDV_MARKETING is the one given by some lady from Twitter. I’ll probably update to her real name later but she seems really interesting and unlike the Ulule guy has good…

Work

Crowdfunding as a Native Advertising Channel

Another post about a talk at RDV_MARKETING from the guys from Alexandre Boucherot from ulule.com. Ulule is a crowdfunding platform that has been available to Canadians for about a year. Types of Crowfunding There are three types. The first…

Work

How to Be Better at Influencer Marketing

As part of the conference, Infopresse is promoting on of their paid training. This particular one focuses on Influencer Marketing. Hopefully, it’s good but it sounds like it will be just a long talk about how to get people…

Work

Tips to Better Penetrate New Markets

I’m currently attending the RDV_MARKETING where Jamie Hebert, Spotify’s Head of Marketing is talking. For those who don’t listen to music, Spotify was introduced into the Canadian market in 2014 and is a music streaming service. His talk addresses…

Live

Why I launched t.omlinson.com

I’ve finally finished the first version of t.omlinson.com. I was getting tired of the “philtomm” as a username and domain name. It violated one of the most important rules in almost all disciplines: if you’re creating something that other…

Coding

How to Customize WordPress Sidebars

If you haven’t noticed! I’ve not only migrated my domain to t.omlinson.com, but I’ve also created a child theme based off of the Redwood WordPress theme. One particular element I needed to add was different WordPress sidebars based on…

Live

Merged All My Old Web Properties

I could go on a rant about how I want to create a stronger personal brand, but that would be bullshit. While doing some spring autumn cleaning, I discovered a few funky files informing me that I’ve been hacked.…

PPC

AdWords Broken URL Checker That Won’t Timeout Ever

A common problem with broken URL checker scripts is that they tend to timeout when running on large AdWords accounts. This is because Google would rather you use their API. I’d love to start using the Google API and…