Product exports
See how Wise2Sync exports products in different formats, to Marketplaces, E-commerce platforms price comparison websites.
- Downloading products and images
- Uploading exported products to FTP server
- Setting up product import to CS Cart
- Channable product export
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}
{export_profile_id}
- numeric ID number of your export profile (see first column in Data export → Export profiles to get desired profile ID.{access_token}
- access token is a set of numbers and letters which is used for identification purposes. It can be found in "Access tokens" page in your Wise2Sync account.
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.
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.
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).
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:
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:
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......
Save this link - you will need it in CS Cart administration panel.
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:
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:
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):