Contents x
    Product Import via Excel
    • 13 Apr 2022
    • 8 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Product Import via Excel

    • Updated on 13 Apr 2022
    • 8 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Required permissions

    In order to view content or perform actions referred to in this article, you need to have the appropriate permissions enabled. An employee must be assigned to the shop with a Shop Owner Admin role.

    ShopCtrl Product Import tool allows to:

    • Import Product details per Shop group, such as SKU/Code, name, description, EAN, product brand and groups, metadata, product dimensions, properties values.
    • Import product prices and regulate product availability per shop.
    • Import product stock levels per warehouse and location.

    How to import products details

    You can import product details per shop group and translation. Update existing products and create new products based on your Excel file. The number of fields to update is customizable, and you can create any number of import profiles specific to your needs.

    Create import profile for product details

    Before you start

    Properties and Property sets should be pre-created in ShopCtrl, to update the properties correctly.
    Please check Product Properties for more information.
    Product brands and Product groups should be pre-created in ShopCtrl as well.

    product-import-product-create-profile

    To create an import profile that will update product details per shop group and translation:

    1. Go to Product Management > Product export/import profiles.
    2. Click Add.
    3. Select Profile type: Product.
    4. Enter the Profile Name.
    5. Choose a number of Header Rows that will be skipped during import.
    6. Select Culture of the file being imported.
    7. Select Translation to be updated. By default, Global is pre-selected.
    8. Choose the Encoding of the file to import.
    9. Select the Excel file Field separator.
    10. Choose Shop Group to which the products belong.
    11. Max Groups - total number of product groups that could be linked to a product.
    12. Max related products - total number of relations that a product could have to a different products.
      Supported relation types: Cross Sell, Upsell, Contains Product.
    13. (Optional) Max multiselect options - defines a maximum number of options that could be selected for the multi-select type properties.
    14. Mark the Can create new product checkbox if you would like to create new products if no matching product code was found during product import.
    15. Turn on the Can update existing products setting to update existing products matched by product code.
    16. From the dropdown list select Property Set that is used for products. Once selected, the properties from the set will be added to the included properties list.
    17. Edit the list of Included properties. By default, the list includes all possible properties:
      1. Exclude unnecessary fields using the ◀ button.
      2. Use arrows ⬆⬇ to change the order of included properties to repeat the order of the columns in your Excel document.
      3. Include fields back in the list with the ▶ button.
    Please note

    Product Code will be used to map the products to existing product codes in ShopCtrl. This field is required. Other properties are optional. If products already exist in ShopCtrl, you can additionally use ShopCtrl ID for product mapping.
    Column order in the file is important. The document should start with the first Included property and continue with subsequent properties. Column names are ignored during import.

    1. Click Download Sample to download a sample Excel file generated based on the included properties list. The Lookup tab stores the values that already exist in ShopCtrl and should be specified exactly as in the system. To guarantee that values will be matched during import.
      product-import-sample-file
    2. Save or Save and Close profile.
    Tip

    You can create an import profile for one Translation and use it later on different translations. Just choose a different translation while importing a file.

    Import product details per shop group

    To update product details per shop group and translation:

    1. Go to Product Management > Product import.
    2. Select a Product type import profile.
    3. (Optional) The Translation displayed is the one preselected from the import profile. You can change the translation to a different one.
    4. Click Browse and choose a file to import.
    General file requirements

    Supporting file formats: .xlsx and .csv

    1. If you are uploading a short list of products, you can use an interactive way:
      1. Click Preview to upload the file and anylize it for any possible errors.
        import-product-details
      2. (Optional) Correct the errors and upload the file again.
      3. Click Save to process the file and create/update products.
    2. If the file processed contains a significant amount of data, the preview interactive mode might take a significant amount of time to load. Use the Sync Request option to run the import in the background:
      1. Select Sync Request.
      2. Click Import to start the process in the background.
      3. Process result will be opened on a new tab. Click Refresh to check the process status.
        product-import-product-price-result-page
      4. Once the process is finished, the message field will display the status of the import. If any errors occurred during import, click Download Report to view the detailed import result in the Excel file.

    How to import product price and change product availability per shop

    The import of product prices in ShopCtrl is performed per shop, as well as change of the product publication status and VAT tariff.
    To import product prices, you will first need to create a shop-specific profile.

    You can update product Price including VAT, excluding VAT, or both. The corresponding shop Foreign Price Inc or Ex prices will be updated. The global price excluding VAT won't be affected. Auto calculation of prices based on global price excluding VAT will be turned off for the product in this shop.

    VAT tariff should be configured to be used on a shop you are updating. Otherwise, the import won't proceed. Please check the configured VAT tariffs on Shop details page > Financial > VAT.

    Create import profile for product price, VAT and publication status

    product-import-product-price-create-profile-all

    To create an import profile that will update product price excluding VAT and availability per shop:

    1. Go to Product Management > Product export/import profiles.
    2. Click Add.
    3. Select Profile type: Product price.
    4. Enter the Profile Name.
    5. Choose a number of Header Rows that will be excluded during import.
    6. Select Culture of the file being imported.
    7. Choose the Encoding of the file to import.
    8. Select the Excel file Field separator.
    9. From the dropdown list select Shop for which profile will be used.
    10. Edit the list of Included properties. By default, the list includes all possible properties:
      1. Exclude unnecessary fields using the ◀ button.
      2. Use arrows ⬆⬇ to change the order of included properties to repeat the order of the columns in your Excel document.
      3. Include fields back with the ▶ button.
    Please note

    Product SKU will be used to map the products to existing product codes in ShopCtrl. This field is required. Other properties are optional.
    Column order in the file is important. The document should start with the first included property and continue with subsequent properties. Column names are ignored during import.

    1. Save or Save and Close profile.
    Tip

    You can create an import profile for one shop and use it later for different shops. Just choose a different shop while importing the file.

    Import product price, VAT, and availability status

    product-import-product-price

    To update product prices, VAT tariffs, and publication status per shop:

    1. Go to Product Management > Product import.
    2. Select a Product price type import profile.
    3. (Optional) The Shop displayed is the one preselected from the import profile. You can change the shop to a different one.
    4. Click Browse and choose a file to import.
    General file requirements

    Supporting file formats: .xlsx and .csv

    1. Click Start to begin importing process.
    2. Process result will be opened on a new tab. The import process will be performed in the background. Click Refresh to check the process status.
      product-import-product-price-result-page
    3. Once the process is finished, the message field will display the status of the import. If any errors occurred during import, click Download Report to view the detailed import result in the Excel file.

    To change the publication status of a product, you need to set value to true or false in the Excel file for the Active column.

    As a result of the import the specific Shop Product Price Excluding VAT, Foreign Price Excluding VAT, Foreign Price Including VAT, Product VAT tariff are updated. The publication status on a certain shop is changed accordingly.

    product-foreign-price-update

    How to import product stock

    You can import products stock levels via an Excel file per warehouse and location. It is also possible to set up a scheduled import via FTP or HTTP protocol using the same import profile.

    Create import profile for product stock update

    product-import-product-stock-create-profile

    To create an import profile that will update product stock per warehouse location:

    1. Go to Product Management > Product export/import profiles.
    2. Click Add.
    3. Select Profile type: Product stock.
    4. Enter the Profile Name.
    5. Choose a number of Header Rows that will be excluded during import.
    6. Select Culture of the file being imported.
    7. Choose the Encoding of the file to import.
    8. Select the Excel file Field separator.
    9. From the dropdown list select Warehouse for which profile will be used.
    10. (Optional) Check Auto-create location to create a location if no matching location is found.
    11. Edit the list of Included properties. By default, the list includes all possible properties:
      1. Exclude unnecessary fields using the ◀ button.
      2. Use arrows ⬆⬇ to change the order of included properties to repeat the order of the columns in your Excel document.
      3. Include fields back with the ▶ button.
    Please note

    Product SKU will be used to map the products to existing product codes in ShopCtrl. SKU and QtyOnHand (Quantity on hand) are required fields. Other fields are optional.
    Column order in the file is important. The document should start with the first included property and continue with subsequent properties. Column names are ignored during import.

    1. Save or Save and Close profile.

    Import product stock to the warehouse

    product-import-product-stock

    To update product stock per warehouse location:

    1. Go to Product Management > Product import.
    2. Select a Product stock type import profile.
    3. (Optional) The Warehouse displayed is the one preselected from the import profile. You can change the warehouse to a different one.
    4. Click Browse and choose a file to import.
    General file requirements

    Supporting file formats: .xlsx and .csv

    1. Click Start to begin importing process.
    2. Process result will be opened on a new tab. The import process will be performed in the background. Click Refresh to check the process status.
      product-stock-import-result
    3. Once the process is finished, the message field will display the status of the import. If any errors occurred during import, click Download Report to view the detailed import result in the Excel file.
    What's Next