Export profiles

This is where you set which products and how they are exported to your sales channel.

Export Profiles List

If you click on "Export Profiles" in your menu on the left - you will see a list of all connections with your sales channels. In this section we will explain what each column means and how to use actions.

Export Profiles List

Mode

Indicates, weather the export profile is executed manually or automatically. Based on your subscription plan with us, AUTO export profiles will be executed multiple times a day.

Type

Shows the type of the export profile (usually a name of your sales channel).

Label

Name of the export profile. You can give your own export profile name and use it for your reference.

Updated At

Date and time when last time the export profile was modified. For example if you modify filters in your export profile and click "Save" -  this will be the timestamp of your action.

Completed At

Date and time when the export profile was executed and export file was generated (see Export Results tab in your export profile). In other words, date and time when Export profile status was last set to "Completed".

Status

Indicates current status of the export profile. Possible statuses are:

Actions

Creating a New Export Profile

In Wise2Sync, you can create different export profiles. This is an integration with your e-commerce store. There is a possibility to choose the export profile by selecting the template.

Go to Export Profiles → Add Profile and the pop-up appear:

create-new-export-profile.png

If you are creating a custom integration or just need a CSV file with products, most likely you would choose "XML, CSV or JSON" export template.

For other platforms, like WooCommerce, Shopify, Magento, Ebay - we have made a preset configuration which would create an Export Profile and missing attributes etc.

When in list view, you can also clone the existing export profile for your convenience. Click this icon to make a copy of Export profile:

duplicate-export-profile.png

You can have as many manual export profiles as you want. They are useful when you want to test something or just export a custom products catalog for your own use. When copying profiles, association with repricing rules is not cloned.

General Settings

Preferences

Once you open an export profile you will see the first tab "Preferences". This is where you set some preferences and set how export runs:

Export profile settings

Handling deleted products

By default Wise2Sync exports only products, that have been present in suppliers products feeds for the past hour. However, sometimes suppliers remove products from their systems. As a result those products might not be updated on your eCommerce platform. Wise2Sync tracks products history and logs date and time when certain products became missing. Use this setting to include those missing products and override the last known information from the supplier.

For example: include missing products for 3 days after they went missing and set attribute Quantity value to 0.

This feature is available for every Export profile or Integration. Open your export profile and select checkbox "Include deleted products" in "Preferences" tab:

Handlink deteled products

Customizing product Alternatives tag

When Wise2Sync finds that the same product is available with more than one supplier (based on Unique Product ID preference) it will export cheapest in stock product data and add the product alternatives into duplicates_data tag.

By default this tag will contain basic information like supplier code, product SKU, product cost price (as imported from supplier),
quantity etc.

If you wish to add more information to the alternatives, select feature "Use custom template for the Product Alternatives" and add more product attributes.

Product Alternatives template

 

Product Filter

Export profile tab "Filter" is used for configuring product rules. Here you can describe which products need to be included in the export profile.

We have written a different page section how to use rules builder.

Export Data Template

If you are exporting an XML, CSV or JSON file, this is where you would form this file and make the structure the way you want. We recommend you configure the template after you have mapped desired attributes, manufacturers categories etc.

Below we give some examples of how to configure XML template. But the same concepts and methods apply for generating JSON or CSV files.

If you navigate to Data export → Export profiles and click on the Edit icon in the corresponding row, a new page will open. Choose tab "Template" and you will see a "tree like" list of attributes:

Export Template

You can use mouse to drag and order elements, as well as moving them to groups.  Example template above will output an XML document with the structure as follows:

<item>
	<sku><![CDATA[011629]]></sku>
	<name><![CDATA[D-Link DVG-6004S Voice Gateway with 4 Port FXO]]></name>
	<ean><![CDATA[790069409981]]></ean>
	<price>191.8555</price>
	<stock>0</stock>
	<media_gallery>
		<item>
			<filename><![CDATA[wSsykjQZgZEH.jpg]]></filename>
			<added_at><![CDATA[2019-07-08 14:31:05]]></added_at>
		</item>
	</media_gallery>
	<category><![CDATA[Network components / Gateways]]></category>
	<attributes>
		<manufacturer></manufacturer>
		<part_number><![CDATA[DVG-6004S]]></part_number>
		<warranty>24</warranty>
		<weight><![CDATA[1.42 kg]]></weight>
		<supplier><![CDATA[acc]]></supplier>
	</attributes>
</item>

 

Adding elements

You can add more elements in the template by clicking red "Add Element". A pop-up will open:

Adding elements in export profile #1

Use search function to find desired attribute:

If you choose to add a system attribute (f.e. category, manufacturer), there will be a new field "Mapper Value".

Adding elements in export profile #2

Mapper value has two options:

See category product data mapping section how data mapping works and how to set different attribute codes and labels.

Uploading products to FTP

Use this option if you want to export products data and upload it to your FTP account.

Open your export profile, click on a tab "Upload to FTP". There are few simple parameters:

Upload files to FTP

If all is OK, Wise2Sync will upload your products file to your server every time the profile is executed.

Troubleshooting

Test your logins first. You can use our built-in "Test FTP connection" feature to do this. Our system will try to login to the server and create a small file. It will also delete this file. If we had problems doing these actions - it will show an error. If success message is shown - upload to FTP is working.

Make sure your FTP user has write permissions

Our system will not be able to upload files if the specified user does not have permission to write files.

Make sure you have enough space on the server

Wise2Sync will not be able to upload export files to FTP server if there is not enough space. Your hosting provider or server administrator can look it up for you. Missing enough space can lead to only partially uploaded file (for example only 5Mb of 10Mb will be uploaded).

Make sure you do not have IP access limitations

Sometimes FTP server can be configured to allow connections from only fixed IP addresses. If you need IP address of Wise2Sync app - contact our support and we will provide you with the needed information.

Testing logins and permissions manually

You can always connect to your FTP account and check whether you can upload a file yourself manually (use FileZilla or any other preferred FTP client). If you can upload a file and delete it - your logins are OK.

 

Export results - product log files

When editing an export profile you will see a tab "Export results". No matter if you are using a simple XML export or connection with any marketplace - every time Wise2Sync runs the export profile it generates some kind of file.

You can download and read this file for your own use or for debugging purposes.

Export results log

Read this article how to download these files with Access token and URL.

Export result files are accessible only for certain amount of time (usually few weeks back).

XSD Schema validation for XML type export profiles

XML validation against XSD schema is useful when you want to make sure the generated XML file is in the right format.

XSD schema validating only with XML and XMLv2 output formats.

Creating a new export profile, select XML, or XMLv2 output format, and mark the checkbox for XSD validation.

validate-XSD.png

Add new schemas by pressing "Upload SXD Schema". You can add as many files as you need.

XSD-schemas.png

All added schemas will be visible across all export profiles. You do not have to upload the same XSD file multiple times.

Setup an export profile and generate it. Validation results will be available in Reports tab.

reports-tab.png

Left column is a report of errors after validation. Right column - the validated XML file.

How Automated & Manual Exports Work

The daily export means our system collects data from the suppliers, applies all required transformation, and prepares products' catalog in the chosen format to be imported into your e-shop. You can read more about the export profiles here:  Export Profile.

Automated Export

This is done automatically multiple times a day depending on your chosen plan (see our available pricing plans). It is also run on fixed hours daily and you are not required to do anything. The green badge "Auto" in profiles list indicates that this export profile is executed automatically.

autogeras.png

Manual Export

On-demand export is when the client manually initiates the product export process. Our app will not download product information from suppliers. It will regenerate the product feed with your changes (f.e. new filter, export template, modified pricing rules etc.).

This option is used mainly at the beginning of the e-shop life cycle to import products for testing purposes. It is also handy to use when you want to push an updated product pricing, data mapping, or any changes that you made in your products' catalog.

To generate the manual export file click on the first blue button "Queue" the status will change to "In progress". It takes a few minutes to generate the export file. Once the file is prepared it will change back to the green color "Completed".

sitas-geras.png

You can also see what type of export profile you have in Wise2Sync. In the third column, it indicates whether it is the default one (XML, CSV or JSON) or any other that you may have for example Woocommerce, Shopify and etc.

MB4type-n.png