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
Below is a recommended list of product attributes that each product can have:
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: