Webshop Category Synchronization

The webshop category synchronization module allows webshop owners to import or update new webshop categories from various types of source files.

The administration screen for webshop category synchronization can be accessed via the administrative sidebar under Synchronizations Management → Synchronizations → Webshop Categories.

Webshop Category Synchronization

  1. # – the identifier of the synchronization process.
  2. Name – the name of the synchronization process.
  3. Source Type – indicates the type of synchronization source, whether the data is pulled from a source file, link, or FTP.
  4. Schedule Type – specifies when and how often the synchronization should run.
  5. Active – indicates whether the synchronization is active or not. Deactivated synchronization processes will not run, even at the scheduled time.
  6. Last Run – the exact date and time when the synchronization was last executed.
  7. Last Run Status – the status of the result of the last synchronization run.
  8. Actions:
    1. "Synchronize Now" – this button immediately triggers the synchronization, regardless of its scheduled time.
    2. "Edit" – clicking the edit button allows administrators to modify existing synchronization processes.
    3. "Delete" – if a synchronization process is no longer needed, it can be easily deleted by clicking the red "trash can" icon.
  9. Store owners can search for a specific synchronization process by typing its name in the search bar and clicking the "magnifying glass" icon.
  10. New synchronization processes can be created at any time by clicking the "Add New" button.

 

Adding and Editing Webshop Category Synchronizations


The Basic Settings, Scheduling Settings, and Source Settings were already covered in the chapter titled "General Settings for All Synchronizations" in this documentation.

Webshop Category Synchronization

Activating the Add Only toggle prevents the system from updating existing webshop categories in the system whose identifiers are present in the source file. While this toggle is active, the synchronization process will only create new webshop categories from the source file whose identifiers do not yet exist in the system.

In this chapter, we will review the remaining configuration options that are exclusively available for webshop category synchronization.

Store owners need to create a mapping between the fields where the data will be imported and the columns in the source document. This can be done by entering the column names into the column fields next to each data type.

Webshop Category Synchronization

  • Identifier - The unique identifier of the webshop category in the Sellvio system. The identifier must be specified in the source document. Rows without an identifier will fail to synchronize.
    • Existing webshop categories can be updated by providing the webshop category identifier in the source document.
    • To create a new webshop category in Sellvio during the synchronization process, the source document must include an identifier that does not yet exist in the system.
  • Parent Category Identifier - The identifier of an already existing webshop category in Sellvio. If the specified identifier does not exist in Sellvio, the synchronization of that row will fail.
  • Parent Category Name - The name of an already existing parent category in Sellvio.

Webshop Category Synchronization

  • Name - The webshop category name is read from the columns specified in the "Name" section. The name of the webshop category must be provided in the source file for every language available in the webshop. Otherwise, the row will not be imported, as webshop categories cannot be saved without a name.
  • Description - The webshop category description is read from the columns specified in the "Description" section.
    Webshop Category Synchronization
  • Active - In the "Active" section, webshop owners can specify which columns the synchronization process should use to determine whether the webshop category should be enabled for specific languages.
  • The "No" and "Yes" fields indicate which values in the source document represent "no" and "yes," respectively. The synchronization process will look for the values specified here.

Custom URL - Optionally, store owners can specify alternative custom URLs for the same webshop category. Multiple custom URLs can be provided, separated by commas, for each language supported by the webshop.

Product Image Synchronization

The product image synchronization module allows webshop owners to update the images of existing products in their webshop.

The product image synchronization administration screen is accessible via the administration sidebar under Synchronization Management → Synchronizations → Product Image.

Webshop Category Synchronization

  1. # - The identifier of the synchronization process.
  2. Name - The name of the synchronization process.
  3. Source Type - Indicates the source type for synchronization, specifying whether the data is retrieved from a source file, link, or FTP.
  4. Schedule Type - Specifies when and how frequently the synchronization should run.
  5. Active - Indicates whether the synchronization is active or not. Deactivated synchronization processes will not run, even at the scheduled time.
  6. Last Run - The exact date and time of the last synchronization run.
  7. Last Run Status - The status of the outcome of the last synchronization run.
  8. Actions:
    1. "Run Synchronization Now" - This button immediately triggers the synchronization, regardless of whether it is scheduled for another time.
    2. "Edit" - Clicking the edit button allows administrators to modify existing synchronization processes.
    3. "Delete" - If a synchronization is no longer needed, it can be deleted by clicking the red "trash bin" icon.
  9. Store owners can search for a specific synchronization process by entering its name in the search bar and clicking the "magnifying glass" icon.
  10. New synchronization processes can be created at any time by clicking the "Add New" button.

 

Adding and Editing Product Image Synchronizations

The Basic Settings, Schedule Settings, and Source Settings were already covered in the chapter titled General Settings for All Synchronizations in this documentation.

In this chapter, we will examine the remaining settings that are exclusively available for Product Image Synchronization.

Store owners must create a mapping between the fields into which the data will be imported and the columns in the source document. This can be achieved by entering the column names into the field next to each data type.

Webshop Category Synchronization

  • Overwriting Images - If this setting is enabled, the synchronization process will delete all product images not listed in the source file. This option is useful for completely replacing the product's images. If the option is disabled, the synchronization process will only add the images from the import file to the product while leaving the existing product images untouched.
  • SKU - The product's SKU is used to locate the corresponding product in the system. Rows without an SKU will fail to synchronize.
  • Main Image - The URL of the image to be imported as the product's main image. Only one image URL can be assigned as the main product image. Supported image formats: jpeg, jpg, and png.
  • Images - URLs of the images to be imported and added to the product. Multiple URLs can be specified in the source file, separated by commas. Supported image formats: jpeg, jpg, and png.

If the same image URL appears multiple times in the Images column, it will only be imported once.

If the same image URL is listed in both the Main Image and Images columns, the image will only be imported once. Since it is first listed in the Main Image column, it will automatically be set as the product's main image.

 

Product Synchronization

The product synchronization module allows online store owners to import new products or update existing products in the store.

The product synchronization administrative screen can be accessed from the administrative sidebar under Manage Synchronizations → Synchronizations → Product.

Webshop Category Synchronization

  1. # – the identifier of the synchronization process.
  2. Name – the name of the synchronization process.
  3. Source Type – indicates the type of synchronization source, specifying whether the data is fetched from a file, a link, or FTP.
  4. Schedule Type – indicates when and how often the synchronization should run.
  5. Active – indicates whether the synchronization process is active or not. Deactivated processes will not run, even at their scheduled time.
  6. Last Run – the exact date and time of the last synchronization run.
  7. Last Run Status – the status of the result of the last synchronization run.
  8. Actions:
    1. "Run Synchronization Now" – this button initiates the synchronization immediately, regardless of any other scheduled time.
    2. "Edit" – clicking the edit button allows administrators to modify existing synchronization processes.
    3. "Delete" – if a synchronization is no longer needed, it can be easily deleted by clicking the red "trash bin" icon.
  9. Store owners can search for a specific synchronization process by entering its name in the search field and clicking the "magnifying glass" icon.
  10. New synchronization processes can be created at any time by clicking the "Add New" button.

Adding and Editing Product Synchronizations

The Basic Settings, Schedule Settings, and Source Settings have already been covered in the "General Settings for All Synchronizations" chapter of this documentation.

In this chapter, we will review the remaining configuration options that are exclusively available for Product Synchronization.

Store owners must create a mapping between the fields where the data will be imported and the columns of the source document. This can be done by entering the column names into the respective column fields next to each data type.

Webshop Category Synchronization

  • Item Number – The item number is used to locate the existing product in the system.
    • If the item number specified in the source file is found in the system, Sellvio updates the product with the data from the source file.
    • If the item number specified in the source file is not found, Sellvio creates a new product in the system using the data provided in the source file.
  • Serial Number – The serial number to be assigned to the product.
  • EAN – The EAN number to be assigned to the product.
  • Categories – The names of the categories to which the product will be assigned, separated by commas.
  • The category names can be in any language supported by the web store, but they must already exist in the system before the product synchronization runs. If a category is not found, it will automatically be skipped.
    Webshop Category Synchronization
  • Units – In the "Units" section, store owners can specify the column from which the product unit will be read during synchronization. The system lists all available units, allowing administrators to map each unit to its equivalent in the source document. This feature is particularly essential when the source document uses different terms for specific units.
    Webshop Category Synchronization
  • Orderable – This section can be used to control the product's orderable availability directly from the source document. Administrators must define specific values in the source document corresponding to "Yes" and "No."
    Webshop Category Synchronization

The Prices section lists all pricing structures used in the web store. All products in Sellvio must have prices in each pricing structure. Any row in the source document where the product prices are not properly specified will be skipped.

  • Net Price – The product's net price in a specific pricing structure (mandatory).
  • VAT – The value-added tax (VAT) applicable to the product price (mandatory).
  • Gross Price – The product's gross price in a specific pricing structure (mandatory).
  • Old Price – The previous net price of the product in a specific pricing structure.

    Webshop Category Synchronization

This section is used to map the product name, description, and short text fields to the corresponding columns in the source file for each language.

The product name must be provided in the source file for each language. Otherwise, the row will not be processed during synchronization.

  • Name – The product name in all supported languages of the web store (mandatory).
  • Lead Text – The product's lead text (short description) in all supported languages of the web store.
  • Description – The product description text in all supported languages of the web store.

Webshop Category Synchronization

  • Visible – This section controls the visibility of the product for each supported language in the web store, directly from the source document. Administrators must define specific values in the source document corresponding to "Yes" and "No."
    Webshop Category Synchronization
  • Custom URL – Optionally, store owners can specify alternative custom URL addresses for the same product category. Multiple custom URLs can be defined for each supported language in the web store, separated by commas.

 

Adding and Editing User Synchronizations

The Basic Settings, Schedule Settings, and Source Settings have already been covered in the section titled "General Settings for All Synchronizations" in this documentation.

In this chapter, we will explore the remaining settings that are exclusively available for User Synchronizations.

Webshop Category Synchronization

  1. # – The identifier of the synchronization process.
  2. Name – The name of the synchronization process.
  3. Source Type – Indicates the source type of the synchronization, specifying whether the data is pulled from a source file, link, or FTP.
  4. Schedule Type – Specifies when and how often the synchronization should run.
  5. Active – Indicates whether the synchronization process is active or not. Deactivated synchronization processes will not run, even at the scheduled time.
  6. Last Run – The exact date and time when the synchronization was last executed.
  7. Last Run Status – The result status of the last synchronization execution.
  8. Actions:
    1. "Run Now" – This button immediately starts the synchronization process, regardless of its scheduled time.
    2. "Edit" – Clicking the edit button allows administrators to modify existing synchronization processes.
    3. "Delete" – If a synchronization is no longer needed, it can be deleted by clicking the red "trash" icon
  9. Store owners can search for a specific synchronization process by entering its name in the search bar and clicking the "magnifying glass" icon.
  10. New synchronization processes can be created at any time by clicking the "Add New" button.

 

Adding and Editing User Synchronizations

The General Settings, Schedule Settings, and Source Settings have already been covered in the "General Settings for All Synchronizations" section of this documentation.

In this section, we will examine the remaining configuration options exclusively available for User Synchronization.

Store owners need to map fields between the data being imported and the corresponding columns in the source document. This mapping can be performed by entering the column names into the designated field next to each data type.

By correctly setting up the mapping, data will seamlessly transfer into the correct user fields during synchronization.

Webshop Category Synchronization

  • Name - The name of the user to be imported or updated. Users cannot be saved without a name. The user's name must be provided in the source file; otherwise, the synchronization process will skip the row.
  • First Name - The first name of the user to be imported or updated.
  • Email - The email address of the user to be imported or updated. Users in Sellvio are tracked based on their email address, and no data can be saved without one.
    • If the email address already exists in the database, the synchronization process updates the user's information with the data provided in the source document.
    • If the email address does not exist in the database, the synchronization process creates a new user with the email address and the data provided in the source document.
  • Phone - The phone number of the user to be imported or updated.
  • Status - Sellvio users can have one of three statuses: Inactive, Active, or Blocked.
  • In this section, administrators can specify which column in the source file contains the user status. Administrators can also define how different statuses are labeled in the source document.

The information listed above constitutes the minimum requirements for importing or updating users through the synchronization process.

However, Sellvio also enables store owners to specify a billing address and a shipping address for users to be imported or updated during the synchronization process.

Enabling the Shipping Address option reveals the Shipping Address fields, allowing administrators to map the Sellvio fields to the appropriate fields available in the source document.

If administrators decide to include address imports, they should be aware that nearly every field related to addresses must have a mapping and corresponding data provided to ensure successful processing.

Webshop Category Synchronization

Country - The Country section allows administrators to specify which column in the source document represents the country, how the countries are identified in the source document, and how they correspond to countries in Sellvio (e.g., the country "Hungary" might be labeled as "HUN" in the source document).

Postal Code - The postal code for the address type being imported.

City - The city of the address type being imported.

Address - The street address and house number of the address type being imported.

Contact Name - The name of the contact person associated with the address (particularly important for shipping addresses).

Contact Phone - The phone number of the contact person associated with the address (especially important for shipping addresses).
 

Company-Related Information

NON-LEGAL ENTITY - If no associations are provided for the company data, the imported address will be stored as a private address.

LEGAL ENTITY - When importing an address for a legal entity, associations must also be provided for the company-related fields.

  • Company Name: The name of the company, essentially the name of the legal entity. This is a mandatory field; if the Company Name is missing from the source document, synchronization for the corresponding row will fail.
  • Tax Number: The tax identification number of the legal entity; if the tax number is missing from the source document, synchronization for the corresponding row will fail.
  • Registration Number: The registration number of the legal entity.
  • Bank Account: The bank account number of the legal entity (this supplementary information is useful when generating invoices).

Synchronization Log

While the synchronization list provides brief feedback on the results of each synchronization, Sellvio includes a dedicated administration page where administrators can thoroughly review the outcomes of each completed process.

The Synchronization Log administration screen can be accessed from the administration sidebar under Manage Synchronizations → Synchronization Log.

Webshop Category Synchronization

  1. ID - The identifier number assigned to the synchronization process run.
  2. Name - The name of the synchronization process.
  3. Status - The state of the synchronization process. Each process can have one of the following statuses:
    1. Queued - The synchronization is queued.
    2. Running - The synchronization is currently running. In this case, a progress bar appears in the synchronization row, indicating the number of rows processed out of the total.
    3. Failed - The synchronization was unsuccessful.
    4. Completed with warnings - The synchronization has completed, but the process encountered issues with some rows in the source document.
    5. Successfully completed - The synchronization has finished without encountering any issues with any rows in the source document.
  4. Total rows - The number of rows identified in the source document by the synchronization process.
  5. Processed rows - The number of rows handled by the synchronization process.
  6. Created - The number of new entries created by the synchronization process based on the source document.
  7. Updated - The number of existing entries in the system updated by the synchronization process based on the source document.
  8. Failed rows - The number of rows that failed due to missing required data or configuration errors between the synchronization and the source document.
  9. Start time - The exact date and time when the synchronization process began processing the source document.
  10. End time - The exact date and time when the synchronization process finished processing the source document.
  11. Details - The "Details" column icons serve three purposes:
    1. Color - Based on the color, administrators can immediately determine whether the synchronization process was successful. Green icons indicate success. Red icons signify failure. Orange icons indicate the process completed but encountered issues.
    2. Number - The number in the icon indicates the count of problematic rows encountered during the synchronization process. A zero always indicates success, meaning the synchronization process either found no rows in the source document or processed all rows successfully.
    3. Clickable - Each icon is clickable. Clicking on the icon opens the Synchronization Details modal, which provides detailed information about the results of the synchronization process.
  12. During the import of data from source documents, log entries can quickly accumulate on the Synchronization Log page. The search bar allows users to search the synchronization log by entering the synchronization name and clicking the magnifying glass icon next to the search bar.

    IMPORTANT: The Synchronization Log table can be sorted by ID, status, start time, and end time. The sorting functionality remains available even after performing a log search by name.
     

Synchronization Details Modal

As mentioned earlier, clicking on the indicator at the end of a synchronization log entry opens the Synchronization Details Modal. Let’s take a closer look at its contents in two scenarios: when every row in a synchronization is processed successfully and when some rows fail to process due to errors.

Webshop Category Synchronization

Synchronization Details Modal - Successful Synchronization

Webshop Category Synchronization

Synchronization Details Modal - Completed with Warnings

 

  1. Row - Refers to the row number in the source document where the synchronization failed due to certain issues.
  2. Column - Refers to the specific column in the source document where the problem was identified.
  3. Attribute - Refers to the field that the import process attempted to populate from the corresponding column in the source document when the issue occurred.
  4. Message - A brief explanation of why the row failed to synchronize. (In the example above, the "G" column in the source document was empty in the third row, where the synchronization expected a country name, as defined in the USER-IMPORT-5 synchronization settings.)
  5. Value - The value found in the "G" column of the third row in the source document during the synchronization process.


IMPORTANT: After reviewing the list of problematic rows in the Synchronization Details Modal, business owners must correct the source document, update the synchronization with the new source file, and either reschedule the synchronization or manually rerun it.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.
We use cookies to personalise content and ads.