Product exports

See how Wise2Sync exports products in different formats, to Marketplaces, E-commerce platforms price comparison websites.

Downloading products and images

This is the most popular way of exporting products and data from Wise2Sync. You can access your export profile results after you have configured an Export profile.

Every export (no matter if it is connection with marketplace or eCommerce platform) generates an XML, CSV or smilar file. You can access this file in two ways.

Downloading export file from the App

After you login to your account, navigate to Data export → Export profiles and choose your export profile. If you click on "Export Results" tab you will see export log. You can download the most recent file or an older one.

Read this article this article to find out more.

Access products file by using file URL

As part of API support, Wise2Sync allows access of the latest export generated file by requesting it through URL.

https://app.wise2sync.com/api/exporters/{export_profile_id}/results/latest?access_token={access_token}

If you replace these variables with your values, the URL would look like this:

https://app.wise2sync.com/api/exporters/123/results/latest?access_token=ABC123...

If all is good, it will return a file which you can save and then process it. If there are errors, they will be returned with HTTP Status codes and error messages in JSON format.

Downloading images

In your export file you will see image names. To access image name you must call this URL:

https://app.wise2sync.com/api/media/{file_name}?_format=file&access_token={access_token}

Replace variables with your access token and file name. Your image URL will look something like:

https://app.wise2sync.com/api/media/filename123.jpg?_format=file&access_token=ABC123...

Make sure you use the right Access token.

Access of export files and images from URL is small part of Wise2Sync API. These methods can be used by all users. Enterprise plan users can use many more commands and benefits of API. Contact us to discuss possible solutions.

You can also easily get the product feed link by going to Export Profiles, pressing Edit export profile you need, and going to Export Results. Press the green button on the right.

image-1696593714632.png

image-1696593854712.png

Uploading exported products to FTP server

You can set Wise2Sync profile to put generated CSV, XML or JSON file to your FTP server.

See this article how to configure your export profile.

Setting up product import to CS Cart

In this article we will explain how you can use native and powerful CS Cart product import feature and import products from Wise2Sync.

CS Cart

Use following steps to setup product import from Wise2Sync App to your CS Cart store.

1. Create export profile

Login to your account at app.wise2sync.com and navigate to "Export profiles". Click "Add profile" in the top right corner and select "Basic V2 (XML, CSV or JSON)" exporter.

2. Setup general preferences

Name your export profile, select main preferences. In this example we will use output format XML (CS Cart can also accept other formats like CSV as well). You can read more about Preferences tab in this article.

Important part here is to include full image paths in the export file. Select "Use full image path" and enter one of your Access tokens (left menu Tools → API Access Tokens).

cs_cart_export_Profile_settings.png

3. Setup export Template

CS Cart has a built in field mapping feature which comes handy when mapping Wise2Sync fields to CS Cart fields. Add some elements to the template:

cs_cart_template.png

As always, you can add as many mapped attributes in the export template. CS Cart requires "vendor" field to be present in the XML file. For this you can create a dynamic attribute or just use a blank attribute like we did:

cs_cart_vendor_attribute.png

We've skipped settings in the product filter tab. As always, when testing we recommend to filter some products and do not perform test imports with full / large catalogs.

4. Create download link

After you've created your export profile and assigned some repricing rules - you need to run the export profile (if your have an "auto" type export profile - it will be executed automatically on certain time slots).

Once export profile turns back to "Completed" status, your export file is ready (to double check - open your export profile and navigate to "Export Results" tab. There you should see one or more files.

Tip: if export file size is a few kilobytes - it might be that no products were exported. Open and view the export XML file to verify this. Most likely, you will need to adjust filtering options to include more products.

Last step is to create a download link. Read this article here how to do it. It would look similar to this:

https://app.wise2sync.com/api/exporters/..../results/latest?access_token=YTc0M2E2MDAyZTg0MTQ0MTVlYWJjN2Q2M......
5. Set up product import in CS Cart

Login to your CS Cart admin panel and navigate to Administration → Import data → Products. You can find more information how to set up product import on their help page: How To: Import Products and Product Data.

Create new import and apply following settings:

cs_cart_product_import_config.png

URL: use the one you generated in Step 5.
XML Target node: "items/item"

6. Map fields in CS Cart

Fields mapping in CS Cart is standard. We used such mapping as an example:

cs_cart_field_mapping.png

Save your settings and perform a test import in CS Cart. Your new products should be imported!

Channable product export

We can offer an XML template prepared for Channable requirements. The data feed has to be available in an online location. Here you can find information on how to prepare a link to generated XML file: https://docs.Wise2Sync.com/books/product-exports/page/downloading-products-and-images

The data feed will be updated twice a day automatically on the same URL with the latest product information.

There are some limits for import files:
Each imported file may contain at most 10 Million items.
Each imported file may be no larger than 5 GB.

Here you will see Channable mandatory, optional, or recommended attributes:

Field

Example / extra information

Status

additional_image_link

Links to extra images, separated by commas

Recommended

age_group

Adult / kids

Recommended

availability

In stock / out of stock

Mandatory

brand

 

Mandatory

color

 

Recommended

condition

New / used

Recommended

description

 

Mandatory

delivery_time

2-3 days

Recommended

gender

Male / female

Recommended

google_product_category

 

Optional

gtin/ean

EAN13-code

Recommended

id

012608-BLUE-XXL (unique id preferably with color and size)

Mandatory

image_link

Main image link

Mandatory

item_group_id

012608-BLUE (variant id preferably with color)

Recommended

link

http://www.onlinestore.com/item

Mandatory

material

Material of the item, e.g. 100% cotton

Recommended

mpn

Manufacturer product number

Recommended

price

 

Mandatory

product_type

Breadcrumb of item, e.g. men/sweaters

Mandatory

sale_price

Discounted price

Mandatory

shipping_price

 

Recommended

size

 

Mandatory

stock

Amount in stock, e.g. 12

Recommended

title

 

Mandatory

percentage_variant_sizes

Percentage of available sizes per color (variant)

Recommended

percentage_product_sizes

Percentage of available sizes per article

Recommended

Make sure all mandatory attributes are mapped with the proper supplier attributes. More info about attribute mapping in Wise2Sync is provided here

All required fields above are included in XML template on Wise2Sync (check below):

image-1687951939779.png