Product Imports

See how products are imported into Wise2Sync.

• How do imports work?
• How do I import my products?
• Which fields do I need in my own import file?
• Which fields do I need in my own Google sheet file?

How do imports work?

Before we can export any products, we need to import them in our system. Only then product information can be used for mapping, filtering and finally be used in export.

There can be several types of imports (data sources):

• From eCommerce platform (Shopify, Magento, OpenCart etc.)
• From Products supplier (wholesaler).
• Custom products feed (XML, CSV etc.)
• Google sheet

Suppliers already have their API and products feeds ready which we are connected to. You will only need some kind of authentication from supplier (link to products feed, API key, username / password etc.) - it can be individual per supplier.

You can have multiple data sources from different types: import products from a few suppliers and also from their own eCommerce shops.

Our system syncs information from data sources multiple times a day (depends on your Plan).

Contact us by mail support@wise2sync.com to discuss possible import solutions. We are sure we can find a way how to connect your product feed with Wise2Sync.

 

How do I import my products?

There are few ways how product import can be made.

XML, CSV or JSON product feed

This method is most often used when you have custom system and want to import products into Wise2Sync.  Follow this article to see what fields are required and find some examples.

Google sheet product feed

It is possible to import products into Wise2Sync from Google sheet. You must share with us a link to this document with products info in it. Follow this article to see what fields are required and find some examples.

E-commerce platforms

Most of our built integrations (when possible) support "Product download" feature. You can ask your developers to build your products feed or use our built extensions for:

• Magento 1
• Magento 2
• OpenCart
• WooCommerce
• PrestaShop
• ...

See a full list of our integrations here.

Email us at support@wise2sync.com with the name with the platform & version and we will be happy to assist you with integrations.

Shopify

If you are using a Shopify platform for your eCommerce store, you will have to install our App "Wise2Sync Connector". App will ask for permissions to access products catalog and collections.

Which fields do I need in my own import file?

The easiest way for importing products feed data into Wise2Sync is by CSV, XML or JSON format files. Text encoding should be in UTF-8. In case you have a large amount of products (f.e. > 10 000) - consult with us first to discuss the best approach.

If you need help building the feed or After you've build your feed, 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.

Mandatory fields

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

Field	Description	Example
id	Required. Unique identification number of your product	15484
ean	Required. The barcode, ISBN, or UPC of the product.	1000005522123
product_name	Required. Name of the product.
manufacturer	Required. The manufacturer / brand of the product.	Puma
description	Required. Description of the product. Can be a plain text or in HTML format.
product_price	Required. The price of the product. Don't include any currency symbols.	9.99
quantity	Required. The number of items you have in stock of this product.	50
category	Required. Category that this product belongs to. Category should be specific as much as possible.	Accessories > Men’s Accessories > Gloves > Winter Gloves.
images	Required. URL for a product image. Product should have at least one image.	www.website.com/images/product.jpg
sku	Required. SKU (stock keeping unit) code of your product.	PUMA-AB-1548-L
product_link	Recommended. Public URL of a product	www.website.com/product-link

You can also add more attributes to the feed like: materials, warranty, delivery term etc.

Examples

XML example with no product variants:

<?xml version="1.0" encoding="UTF-8" ?>
<products>
	<product>
		<id>2579</id>
		<ean><![CDATA[356975 04/9-]]></ean>
		<name><![CDATA[Puma Winter Players Gloves]]></name>
		<description><![CDATA[PUMA Knitted Gloves are designed to work on touch screens.]]></description>
		<category_path><![CDATA[Men's Accessories > Men's Gloves]]></category_path>
		<manufacturer><![CDATA[PUMA]]></manufacturer>
		<price>15</price>
		<stock>50</stock>
		<images>
			<image>https://yourpage.com/media/Puma_Winter_Players_Gloves_1.jpg</image>
			<image>https://yourpage.com/media/Puma_Winter_Players_Gloves_2.jpg</image>
		</images>
		<sku><![CDATA[979328]]></sku>
	</product>
</products>

If your products have variants like color or size, you can also provide this information in your product feed. In this case use group_id attribute. See a JSON example:

{
 product": {
    "id": "2579",
    "ean": "2907025030709",
    "name": "Puma Winter Players Gloves",
    "description": "<p>This PUMA Knitted Gloves are designed to work on touch screens.</p>",
    "category_path": "Men's Accessories > Men's Gloves",
    "manufacturer": "PUMA",
    "price": "15",
    "stock": "50",
    "images": [
      "https://yourpage.com/media/Puma_Winter_Players_Gloves_1.jpg",
      "https://yourpage.com/media/2579/Puma_Winter_Players_Gloves_2.jpg"
     ],
    "sku": "979328",
    "part_number": "PGKG135G",
    "group_id" : "256”,
    "materials" : [
         "Acrylic 95%",
         "Elastane 5%"
    ],
    "color" : "Black"
 }
}

See our example XML file for more advanced features: xml_example.xml

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: