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

 

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:

image-1630062407842.png

Dalinantis Google Sheet nuoroda būtini nustatymai:

image-1630387373761.png

 


Revision #17
Created Wed, Aug 18, 2021 11:50 AM by Rasa
Updated Tue, Aug 31, 2021 5:23 AM by Rasa