MS Excel tricks can automatically generate hundreds of entries for a CSV product file upload to Shopify. Among other things, these MS Excel tricks are great for generating fields like the title, SEO description, handle and so on. Goodbye tedium! Hello SEO friendliness.
--
--
Title
A good title is comprised of different product details (its brand name, product type and so on). Here is a formula for combining its component details from other cells.
- Click on a cell within the 'Title' column
- Enter the formula as pictured immediately below. To clarify, a formula always starts with '='. Then enter the cell address of the 1st component, C3 in this case. Then enter the following to grab its content and then another '&' if another cell will follow.
=C3&""&E3
NB: If you want a space after the cell's contents leave a space between quotation marks as follows.
=C3&" "&E3
- Continue adding cells this way. When there are no further cells, do not end '&' after the last set of quotation marks.
=C3&" "&E3&" "&D3&" "
Handle
Shopify requires merchants to remove all spaces in the handle field. An automatic way of creating SEO-friendly titles and then removing the spaces with dashes '-' is as follows.
--
--
--- As shown immediately below, paste ONLY the values from the contents of the cell for the 'Title'. To get this dialog box, right click on the cell to which you will paste content and select 'Paste Special ...'.
Above we illustrated with only one line. However, you are likely to have hundreds or even thousands of lines that can be done all at once. Immediately below, I have created 2 additional lines to illustrate how this may be done for multiple 'Handle' cells at once. In fact, you may select the entire column.
- Select the entire 'Handle' column or cells whose spaces will be replaced
- Click 'Ctrl H' in Windows or 'Command H' in Apple to get the the 'Find and Replace' dialog box
- Click the 'Replace' tab
- NB create a space in the 'Find what' field by placing the cursor into that field and pressing the space bar once. Obviously, you will not see anything. However, you will know you have accomplished this task if the cursor advanced. If you do not do this, this function will not work.
- As shown immediately below, in the next field, 'Replace with', enter a dash '-'
- Click the 'Replace all' button
- If you executed the steps above, you should see a confirmation like the one pictured immediately below.
--
--
Use the Google Product Category attribute to indicate the category of your item based on the Google product taxonomy. Categorizing your product helps ensure that your ad is shown with the right search results.
- Go to 'Google Products Taxonomy' of download the MS Excel file direct from Google
- Copy your category code. In the example immediately below, the product is a rug. The code '571' is therefore highlighted.
- Paste the code into the CSV file field 'Google Shopping / Google Product Category'
SEO Description
Many people neglect this cell, allowing the body content to become the default. However, taking the time to create a formula can increase conversions. Among other things, the formula can include a product-specific value propositions and benefits like 'free shipping' and benefits'. To achieve this, I create temporary columns in my CSV file for 'value' and 'benefits'. Before uploading the file to Shopify, I copy and paste the result as values (and not formulas) and then delete the temporary columns.
In the following formula example, we combine filler words (highlighted below) with the content of cells that describe the product type and USP.
="Show off "&E3&" Get "&F3&""
If you have numerous products, some of which will not have benefits in one of the cells, it will be best to leave out filler words since the filler words will not be followed by an attribute.
=E5&""&F5&""
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.