Which fields do I need in my own Google sheet file?

If you need help building Google sheet or after you've built it, send a link to support@wise2sync.com and we will verify if all is legit. Do not hesitate to contact us also if you need help with building a feed. In case you have a large amount of products (f.e. > 10 000) - consult with us first to discuss the best approach.

Mandatory fields

Below is a minimum list of product attributes that each product should have:

Field	Description	Example
unique_supplier_code	Required. Unique identification number of your product. It can be EAN, SKU, or other unique code.	15484
product_name	Required. Name of the product.
manufacturer	Required. The manufacturer / brand of the product.	Puma
price	Required. The price of the product. Don't include any currency symbols. Use dot not comma between numbers.	9.99
quantity	Required. The number of items you have in stock of this product.	50
sku	Required. SKU (stock keeping unit) code of your product.	PUMA-AB-1548-L

Recommended fields

Field	Description	Example
category	Recommended. Category that this product belongs to. Category can be specific as much as possible.	Accessories > Men’s Accessories > Gloves > Winter Gloves.
images	Recommended. URL for a product image. Product should have at least one image.	https://www.website.com/images/product.jpg
description	Recommended. Description of the product. Can be a plain text or in HTML format.
product_link	Recommended. Public URL of a product	https://www.website.com/product-link
attribute_color	Recommended. You can also add more attributes to the feed like: materials, warranty, delivery term etc. Every attribute must be in separate collumns.	Black

Examples

Google sheet example with mandatory fields. You can also add other recommended fields as mentioned above:

These settings are important for us to accsess your Google Sheet: