A large audience is vital for any online store, and businesses have to increase their audience number to increase sales. Sales and audience numbers are closely related through the conversion parameter. It shows how many visitors of your store purchased something from you.
The average conversion rate in 2022 is 1.62 percent, which means that if your store has 10 000 visitors/month, you may expect 162 orders/month. If you want 1620 orders/month, you will need at least 100 000 visitors/month.
So if an online store wants to increase its sales, it has to increase its audience. Gaining audience organically is a very hard task, but there is a shortcut: use existing audiences of potential shoppers.
How can a Shopify store quickly increase its audience and, therefore, sales? It can utilize a product feed and ready available audiences of online marketplaces, like Google Shopping, Idealo, Fruugo, TikTok, PriceSpy and dozens of other.
What is a product feed
A product feed is simply a file that is used to transfer the data on products an online store sells to make a product catalog backup, to migrate from one eCommerce platform to another. But mainly, product feeds on Shopify are used to sell on price search engines, online marketplaces, price comparison engines, and so on.
You probably already know a number of such shopping engines: Google Shopping, Amazon, eBay, Kelkoo, Fruugo, Bing, and Facebook.
The product feed file can be viewed as a table that contains all the data on each product a store sells: ID, product category, title, description, URLs to product images, stock quantity, price, size, color, etc.
Here is an example of a products feed with two products:
|ID ||SKU ||Title ||Description ||Price ||Condition ||Product Page URL ||Stock availability ||Product Image URL |
|1230||TOY-1230||Toy Car||A yellow sport car||$12.99||http://example-store.myshopify.com/yellow-sport-car||http://example-store.myshopify.com/yellow-sport-car/car-image.jpg|
|1231||TOY-1231||Airplane||Remote controlled passenger airplane||$74.99||http://example-store.myshopify.com/remote-airplane||http://example-store.myshopify.com/remote-airplane/airplane-image.jpg|
What feed formats are used in eCommerce
Each shopping engine has its own standardized form of the product data feed file. The standardized feed format helps the marketplace to uniformly parse feeds from any online store.
Since product feeds in Shopify are basically a table with data on products, the data feed file is often interchangeable. Facebook Ads and Bing can use a feed created for Google Shopping, for example. At the same time, Google Shopping can use Amazon feed formats (currently in beta and for the US only).
Product feeds do not have any specific file format; they utilize common file formats used for data transfer.
Typically shopping engines use some of the following feed file formats:
- XML (Extensible Markup Language, emerged in 1996)
XML product feed example output
<title>Google Shopping den_test_store</title>
<title><![CDATA[Super Heroes Set]]></title>
<description><![CDATA[Join the superhero battle to repel the villains and save the Earth with this action-packed Super Heroes Set!]]></description>
- CSV (Comma Separated Values, emerged in 1972)
CSV product feed example output
id,item_group_id,title,brand,description,google_product_category,item_group_id,link,product_type,image_link,price,availability,gtin,mpn,sku,"additional image link",condition,gender,"age group"
41805188956358,7259352105158,"Super Heroes Set",Toys,"Join the superhero battle to repel the villains and save the Earth with this action-packed Super Heroes Set!","Home page",7259352105158,https://test-store.myshopify.com/products/super-heroes-set?variant=41805188956358&om=11467,TOYS,https://cdn.shopify.com/s/files/1/0549/3103/0214/products/a1bc38d22e49bd96073851fa589dffdb.jpg?v=1650892522,26.00,"in stock","",TOY01,TOY01,https://cdn.shopify.com/s/files/1/0549/3103/0214/products/a1bc38d22e49bd96073851fa589dffdb.jpg?v=1650892522,new,"",""
- TSV (Tab Separated Values, emerged in 2000) or TXT (Tab Delimited Text)
TSV/TXT product feed example output
id title description google product category product type link image link condition availability price sale price sale price effective date gtin brand mpn item group id gender age group color size shipping shipping weight
TV_123456 "LG 22LB4510 - 22"" LED TV - 1080p (FullHD)" "Attractively styled and boasting stunning picture quality, the LG 22LB4510 - 22"" LED TV - 1080p (FullHD) is an excellent television/monitor. The LG 22LB4510 - 22"" LED TV - 1080p (FullHD) sports a widescreen 1080p panel, perfect for watching movies in their original format, whilst also providing plenty of working space for your other applications." Electronics > Video > Televisions > Flat Panel Televisions Consumer Electronics > TVs > Flat Panel TVs http://www.example.com/electronics/tv/22LB4510.html http://images.example.com/TV_123456.png used in stock 159 USD 719192194052.00 LG 22LB4510/US US::Standard:14.95 USD 9.2 lbs
JSON product feed example output
"title": "Tears of Steel - No Ads",
"description": "This is a CGI short film with no ads.",
"categories": "action, sci-fi, demo",
"keywords": "List of keywords",
- Excel (Microsoft Excel XLS or XLSX file, emerged in 1987)
Excel product feed example output
What feed formats are used by top marketplaces
|Marketplace||Feed format||Marketplace description|
|CSV, XML, JSON||Amazon is an e-commerce platform owned and operated by Amazon. Third-party sellers sell here new or used products.|
|CSV||Germany's big price comparison engine. The platform helps online shoppers to find inexpensive offers from trustworthy shops. See how to create a feed for Billiger.|
|CSV, XML||Cdiscount is the third largest (after amazon.fr and veepee.fr) French online selling platform. It mostly focuses on electronics, household appliances and food categories.|
|CSV, XML, JSON||eBay is an online shopping service that's best known for its auctions and sales of used goods.|
|CSV||Etsy is an online marketplace that focuses on selling handmade or vintage items and craft supplies.|
|CSV, XML||Facebook is a largest social network. Merchants can advertise and sell their goods to the audiences they can form using Facebook users filtering capabilities.|
|CSV, XML, JSON||Flipkart is one of the largest online selling platforms in India. It on goods such as electronics, books, music, movies.|
|CSV/TXT, XML, JSON||Google Shopping is a service that allows consumers to search for, compare, and shop for products across different retailers who have paid to advertise their products. See how to create a feed for Google Shopping.|
|CSV||Shopee is a leading marketplace in Southeast Asia and Taiwan.|
|CSV, Excel, JSON||Walmart Inc. is an American multinational retail corporation that operates a chain of hypermarkets, discount department stores, and grocery stores from the United States.|
Some marketplaces can claim support for a feed format; however, in practice, it may be extremely hard to make a feed in that format work.
For example, Amazon and eBay state support for CSV/TXT, but in practice, feeds in this format do not work well, and it is better to use XML on these marketplaces.
Difference between feed file formats
TSV/TXT, CSV, XML, and JSON are human-readable formats, and they can be opened in any text editor. Excel XLS/SXLS format is a binary file that can be opened specifically with a spreadsheet editor Microsoft Excel, Google Sheets, LibreOffice Calc.
Why CSV and TSV/TXT feeds can be considered as one format
Often CSV and TSV/TXT are considered variations of one format of the feed file as it is basically a text file. Often TSV/TXT is called a simple CSV.
For example, a Shopify app for generating products data feed clearly distinguishes XML feed, while CSV and TSV/TXT are counted as one:
TSV uses TAB as a column delimiter; CSV uses comma or other symbols for this purpose. Both use newline to separate each product record from the previous one.
But the main difference between TSV and CSV is that the latter can fully represent common text due to the usage of escape syntax, like double quotes
Explaining the escape symbol usage in the product feed
For example, you have a talking toy that can say Hello, world!. The product feed will have a description of this toy: It can say "Hello, world!".
Typically the CSV column delimiter is comma, so without double quotes a Hello, world! phrase will be considered as two separate data columns, and that will break a feed output.
By enclosing the phrase in the escape symbol
"It can say "Hello, world!"" it will be considered a single data column.
The CSV feed will look like the following:
1234,"Talking Toy","It can say "Hello, world!""
Parsing escape symbols requires additional processing power. So TSV, which typically contains no escape symbols, is parsed faster. Faster TSV file processing makes this format better suited for the large tabular data sets.
The XML format is a format that uses tags to create a schema for data formatting. It is better suited for complex data that may have multi-level relations between its entities.
For example, a robot and a car belong to one product category toys. In XML, these two products can be assigned to a parent category. In CSV/TSV, a category should be explicitly stated for each product.
Additionally, Tags, in some cases, make the information more easily readable by human. Also, tags allow preserving specific formatting of the data.
Using tags also allows to automatically validate an XML file, making it less prone to technical errors, especially when the data contains special characters, like
Main downsides of CSV/TSV/XML feed
A product feed file in CSV/TSV/XML formats is a simple and reliable data transferring channel, free of any proprietary formats. It may be the most common way for online stores to provide information on their products to online marketplaces.
But it has some major downsides. The main downside of the CSV/XML feeds is a long update time period, which can be from a dozen minutes to several hours. For example, Idealo fetches the feed every 30 minutes, while Awin fetches every 12 hours.
The second major CSV/XML feed drawback is the lack of immediate feedback. It may take several days for the feed to be verified by the marketplace.
Product feed or API (integration, JSON feed)
Some online marketplaces offer data transferring channel via an API (it is often called "integration"). Sending product info via an API in JSON file format overcomes the drawbacks of the CSV/XML product feed.
JSON is far less verbose in comparison to XML. Data in this format is represented only as key-value pairs and arrays. This makes JSON a good solution when client-server communication is required.
Two major benefits of sending product info via an API are instant communication in real-time. Any new update in the store catalog almost immediately appears on the marketplace. And a store gets instant feedback if there is an error with data being sent.
But connecting an online store to a marketplace via an API is significantly more complex than generating and uploading a product feed file.
For example, eBay requires additional security verification via Digital Signatures is required for certain API calls. Feed integration app also should use HTTPS & TLS 1.2; calls made over HTTP will fail.
Some marketplaces, like Bol.com, state limits on the frequency of API calls. If the feed integration app exceeds these limits, the feed update may be paused for a certain time period.
How to choose what feed format to use
Online shopping engines often support products data feeds in several formats. It is up to the Shopify store owner to choose which product feed file format to use. So, when it may be preferable to use XML over CSV format, and when is a JSON a better option?
When CSV/TSV is most suitable
As the product catalog of the store is typically presented in the structured table format, then CSV can be a go-to option. It is also a good choice for stores that sell simple products. Such products do not have any configurable options.
CSV is also better suited for large data sets, as it is processed significantly faster than an XML file. The latter has tags that take lots of time to parse.
Due to a lack of tags, a CSV file can also require up to a hundred times less disk space that XML.
When XML is most suitable
The XML format is better suited for complex data that may have internal relations. For example, a shoe can be presented as a complex product: it can have color and size. Such relations are more easily presented in an XML feed.
However, sometimes an XML feed is just a verbose variant of a product feed, meaning no relations between entities. For example, a Skroutz marketplace supports only XML feed, and it uses it as a CSV. It requires each size or color of the product to be presented as a standalone product in the feed.
When JSON is used
Estimate how often it updates and how critical those updates are. For automated instant communication between your store and the marketplace, a JSON feed is the best option.
For example, an API will suit you better if prices in your store change multiple times per day. Such critical changes will be delivered to the marketplace in real-time.
If your store updates once in several days or daily, but changes are minor, for example, you edit descriptions or titles, the CSV/XML feed may be a better option for you.
How to create a product feed
Since a product datafeed is basically a table you can create it with multiple tools:
- Spreadsheet editors (Google Sheets, Microsoft Excel, LibreOffice Calc). This method is better suited for CSV, TSV/TXT feeds and shops with small product catalog that rarely updates. Microsoft Excel supports editing of XML files, but it is a complex task.
- eCommerce platform embedded tools. For example, Shopify and WooCommerce offer embedded tool for exporting product catalog in CSV format, while BigCommerce offers export to CSV and Excel. This method gives you a basic feed file that should be manually edited according to the requirements of the specific marketplace (Google Shopping, Idealo, etc.).
- Dedicated apps and plugins. Such apps automate most of the tasks on feed generation, and they can instantly provide you with multiple products data feeds configured for multiple marketplaces.
Marketplaces recommend using an automatically updated feed, which typically means that a feed should be automatically generated via a dedicated app. For example, Fruugo marketplace recommends to use an automatically updated feed to keep products and stock up to date at all times.
What data a product feed should contain
Marketplaces typically do not limit the maximal amount of information on each product. The more information seller provides on the product, the better.
However, marketplaces demand a minimally required set of data that each product in the feed should have. You need to read the feed file specification a marketplace provides for sellers.
Here is the list of typical product attributes in the feed and their status on marketplaces:
|Product attribute||Google Shopping||Idealo|
|Product identifier/GTIN (UPC, EAN, ISBN)||Required||Required||Optional|
|Product category (should be mapped to categories of the marketplace)||Optional||Required||Optional|
|Product photo URL (at least one)||Required||Optional||Required|
|Product page URL||Required||Required||Required|
|Product price. Some marketplaces, for example, Idealo requires VAT, and Shopmania requires all taxes to be included in price.||Required||Required||Required|
|Payment cost||Optional||Required||Not used|
|Delivery cost||Optional||Required||Not used|
The other attributes in the feed can be: Free Return Days, Quantity Per Order, Disposal Fee, Packaging Price, Product condition (used or new), Material of the product, Expiration date, Unit Pricing Measure (price per kg, price per liter), Loyalty Points, etc.
Steps to create a product feed
Since each marketplace has its own demands for a product feed, this article shows how to make a product feed for Shopify store in general. The Google Shopping marketplace was chosen only as an example due to it being a well-known sales channel.
To create a product feed for an online marketplace, you should do the following:
1. Create your merchant account on the marketplace
Many marketplaces provide access to feed specification and a feed example only when you have their merchant account.
To create a merchant account it is typically required to fill out the form with information on your business. The marketplace managers will analyze your info and grant you merchant access. This process can take up to several days.
To get a Google Merchant account for selling on Google Shopping you will need an ordinary Google account. Start from a Google Merchant page.
2. Find the feed specification the marketplace provides
Start making your feed by learning what feed file format (CSV/TSV/XML) is acceptable on the marketplace, what product attributes are mandatory and optional. Such information is contained in the feed specification.
Google Shopping offers feed specification on the page Product data specification in its Google Merchant Center.
List of product feed specifications
Feed specifications downloaded directly from Mulwi may not be of the latest version. Please check the marketplace for the latest version.
- Google Shopping product feed specification
- Facebook product feed specification
- Microsoft Bing Shopping feed specification
- Awin feed specification
- ShareASale CSV feed specification
- SHOPenauer XML feed specification
- Spartoo XML feed specification
- LadenZeile.de feed specification
- Ideal feed specification
- Webgains Google Shopping Feeds specification
- Kaufland.de feed specification
- Moebel.de feed specification
- KuantoKusta feed specification
- Stylight feed specification
- Kainos feed specification
- Trovaprezzi feed specification
- Stileo feed specification
- Wayfair feed specification
- Amazon XML feed specification
- Become feed specification
- Houzz feed specification
- LeGuide feed specification
- Nextag feed specification
- Rakuten feed specification
3. Download the product feed sample file the marketplace provides
A sample file greatly reduces the time required to create a feed from scratch. It also helps to avoid basic errors in feed formatting.
Get an XML feed sample for Google Shopping from a Sample Feed File page. A CSV feed example you can obtain on page Create a tab-delimited data feed. Google Shopping provides a CSV feed example inside a ZIP archive. You will need to unzip the file in order to edit it.
List of feed file examples
Feed examples downloaded directly from Mulwi may not be of the latest version. Please check the marketplace for the latest version.
- Google Shopping XML feed example, Google Shopping TXT feed example
- Skroutz feed example
- eBay feed example
- Walmart XML feed example, Walmart Excel feed
- Fundiq CSV feed example
- Wish XLSX feed example
- onBuy CSV feed example
- Price.ro CSV feed example
- Shopbot CSV feed example
- TikTok CSV feed example
- Zbozi XML feed example
- Alza.cz XML feed example
- Bricklink.com XML feed example
- Cettire CSV feed example
- Check24 CSV feed example
- Envy CSV feed example
- Italist CSV feed example
- Manor XLSX feed example
- Mantero 1902 CSV feed example
- Shopflix XML feed example
- Snoc CSV feed example
- VidadXL CSV feed example
- Wayfair XML feed example
- Become feed example
- Kelkoo feed example
- LeGuide feed example
- Rakuten feed example
4. Edit the saved example file
Use the downloaded sample file as a template and edit it as needed. The final result should contain information about all products you want to sell on the marketplace. Ensure the data is formatted accordingly to the specification.
5. Save the updated feed file on disk
When saving a feed file check the file format it is being saved to. If you edit the feed in spreadsheet editor, press File > Save as (File > Download in Google Spreadsheets) and choose CSV, TSV or TXT format accordingly to the feed specification.
For example, if you work in a Google Sheets editor, you can download a Google Shopping Tab Delimited Text (TXT) feed example directly from your Google Shopping Merchant account. The file is saved as TSV, but you will need to convert it to TXT file.
6. Login to your merchant account on the marketplace
A fully prepared feed feed file should be uploaded to your merchant account on the marketplace. Login to your account and navigate to the feed dashboard.
For Google Shopping you need to login to your Google Merchant Center account.
7. Upload the feed file you have created in your account
Marketplaces usually offer several methods to upload the feed: manual, over FTP, over HTTPS via an URL. Typically an URL over HTTPS is the easiest method. You need to simply paste the feed URL in your merchant account.
The manual feed upload method means that you select the feed file located on the hard drive of your computer. This method usually is limited by the feed file size. For example, Microsoft Shopping limits the file size to 4 MB.
The FTP method means that your feed file is available via an FTP. Submitting over HTTPS means your feed is available via an HTTPS link. The feed is fetched by the marketplace by schedule.
In both cases feed file should be accessible freely with no password protection. However, some marketplaces, like Google Shopping, support feed submitting over SFTP, which is password protected.
Google Shopping additionally provides an option to upload the feed from your Google Cloud Storage.
8. Wait while the feed will be checked for errors
Checking your feed for errors may take some time depending on the number of products in your feed.
- Correct any errors in the feed file and re-upload the file.
Some marketplaces, like Google Shopping, check the feed solely for technical errors.
Other marketplaces additionally manually check the feed for errors with content. Such content errors can be misleading or incomplete descriptions, low quality images, etc.
For example, Miinto markeplace checks the distribution of product sizes to avoid a situation when merchant does not state actual size values for products. The Fnac marketplace checks whether products attributes have predefined values.
Google Shopping provides a Troubleshoot your feed so you could more easily eliminate errors that may occur.
10. Error-free feed will be automatically launched on the marketplace
After all the problems a feed had will be resolved the products from your feed will start displaying to marketplace visitors. This process can require some time.
Verify your product listing is working by finding your goods on the marketplace.
Use an app to automate feed making
Manually editing the feed file is prone to errors as each product has dozens of attributes that should be formatted accordingly to marketplace specification. Additionally, you may need several product feeds to sell on multiple marketplaces. Lastly, the product feed has to be updated on any change in the product catalog.
Since the product feed requires constant attention and update, it may be significantly easier to use a dedicated app. Such app generates a feed file in seconds without errors. Typically all you have to do is to choose a readily available template for the marketplace and click a button to generate the feed.
What are the requirements for the product data feeds
Marketplaces demand from online stores a high-quality feed. Violation of the requirements can lead to the exclusion of the feed from the marketplace.
New feed checking is the reason why a feed you have submitted for the first time may not immediately display your products on the marketplace, and you will see a pending status in your account. For example, Google Shopping takes up to 72 hours for a feed check.
In general, a feed can have two types of problems: it can be inconsistent with the marketplace feed specification, and it can poorly present your products. In the first case, a feed will typically be rejected by the marketplace; in the second case, your feed will be published, but it can bring a lower number of sales.
Here are typical feed errors and their consequences:
|Type of feed violation||Violation consequences||Violation resolving|
|Missing required fields||Such feed will not be published on the marketplace||Edit your feed according to the feed specification|
|Incorrect price formats||Feed will not be published||Correct the feed according to the marketplace feed specification|
|Titles/Description all in capital letters||Feed will not pass the check||Make your product titles and descriptions as in normal sentence.|
|Incorrect/missing product categorization||Product feed will be rejected||Ensure the category field of your products is not blank and follows the category taxonomy of the marketplace.|
|HTML/Special characters||Feed will not be accepted||Modify your product attributes (typically Title and Description) so they contain no HTML elements and special characters.|
|Out of stock products||Feed may be rejected||Include only those products that are immediately ready to be shipped to customer.|
|Misconfigured images||Feed may be rejected||Images in the feed have to follow the marketplace feed specification. This regards the image resolution, size, format, and the overall image composition, background, etc.|
|Forbidden products||Products or the feed can be delisted||Stick to the marketplace list of allowed products in your feed. Typically, marketplaces forbid sales of alcohol, drugs, fake products, tobacco products, weapons and explosives.|
|Feed in not available/rarely updated||Marketplace will unlist the feed||Make sure the feed file is accessible by FTP/HTTPS at any time, and access requires no login credentials. If you update the feed manually typically do it once per day. Idealo, for example, requires updating the feed several times per day.|
How to optimize the feed
A feed that passes a technical check may not be a quality feed. It may require optimization in order to provide information on products in a way that will attract more customers.
Feed optimization allows your products to stand out from the competitors’ products feeds in the marketplace.
Simply put, an optimized feed should be relevant and informative. In addition to all mandatory fields, a marketplace feed specification requires to try to fill the maximal number of optional fields.
Optimize title and description
Titles and descriptions of your products should be within the limits a marketplace has. For example, Pinterest allows product titles up to 500 characters and descriptions up to 10000 characters. But it truncates titles over 128 characters and descriptions over 500 characters.
So you may want to rephrase product titles and descriptions in a way that important info was within the truncation limit and it was always visible to customers.
A truncated title or description may lose some information valuable to customers.
Optimize price format
Product prices in your feed should be formatted accordingly to the marketplace requirements.
Pinterest and Google Shopping, for example, require prices to be formatted as 1,00 USD, while Awin marketplace requires price as a number without currency symbol.
Each marketplace has its own category taxonomy. For example, Google Shopping has over 5500 categories, while Awin has only over 400 categories.
Products you place in the feed should be placed within the categories of the marketplace. This will help marketplace visitors who want to purchase an item from specific category to find your products.
Mapping category for each product in your catalog can require a lot of time. A Mulwi app offers an automated mapping based on the taxonomies of the most known marketplaces:
- Google Shopping
Simply start typing the category you want to map to, and the autocomplete will offer a list of the most appropriate variants. In such way you can save hours of time for manually browsing through the marketplace taxonomy list.
Prioritize your products
Try to create a feed with a focus on products that bring you most sales/profits. Try to skip products that may be ineffective when sold on the online marketplace.
For example, a Beslist and eMag marketplaces charge sellers for clicks on their products. On marketplaces with a pay per click model avoid placing items that have poor sales. Such products can generate a lot of clicks that cost you money without bringing actual sales.
With Mulwi Shopping Feeds app you can generate an error-free product feed in seconds. It works with a Shopify store of any size and gives you a freedom to customize the feed. Make your products more unique on Google Shopping, Idealo, Bing, Rakuten, and other online marketplaces. Help customers easier spot your products and increase sales.
A product feed is a tool you can use to quickly gain hundreds of new customers who visit popular global marketplaces such as Google Shopping, Pinterest, TikTok, and Facebook.
Knowing what the best feed format for you is and how to optimize a feed, you can flexibly combine the available data on your products to create a high-quality feed to make your products stand out from competitors.
While you can optimize your feed manually, a Mulwi Shopping Feeds app can save you lots of time and generate a high-quality feed. Make your products on online marketplaces more attractive to customers and generate more sales.