Having a high-quality data feed is essential.
Here are some tips to double-check your feed:
-
After optimizing the product feed, you need to download the output in .CSV file.
-
Import the .CSV file in Google sheets (www.sheets.new)
-
Once the product data is loaded in Google sheets, select all the data then go to Data Menu then select Create a filter.
-
After creating a filter, go to Insert Menu then select Pivot table.
-
Go to the Pivot table editor on the side menu, set the Values to [id] and Summarize by COUNTA
-
In the Pivot table editor select the field you want to view by utilizing the Rows option, selecting the field you want to add. You’ll need to add one field on the Rows one at a time to check the data.
-
If you added the [id] & [title] make sure the value of [COUNTA of id] column is equal to one. Else you don’t want to have a duplicate [id] or [title] on your feed. If there are any duplicate [id] you’ll need to check it on the backend of the website to fix any duplicate ids from your store. As for the title, make sure that the variant attributes like size, color, gender were appended so that it will not make a duplicate title on your feed.
-
When you check the link or image_link on the pivot table make sure that the links are working properly by clicking on the url. Else, you’ll need to ask for the web developer’s assistance if there are any broken links on the product feed.
Note: This method using the Pivot Table to check the quality of your feed is very important to ensure the accuracy of your data that will be uploading to the sales channel.
