Skip to main content

Import products from a shop system

Import products from a shop system, such as WooCommerce or Shopify in Productsup.

Introduction

You can import your products directly from your shop system, such as WooCommerce or Shopify.

To find available shop systems:

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Select Shop Systems in the filters or use Search to find a desired shop by its name.

Data sources - Shop systems

Productsup supports product imports from the following shop systems:

  • BigCommerce

  • Blibli

  • Magento

  • PrestaShop

  • Salesforce

  • Shopify

  • VTEX

  • WooCommerce

Tip

Most of the shop systems connect to Productsup via REST or SOAP API connections. You can test REST API credentials in a regular Internet browser. Most API clients can perform both REST and SOAP test requests.

Here are some troubleshooting recommendations if the credentials don't work in a browser or an API client:

  • Add or remove www and similar parts of the URL

  • Add or remove a slash (/) inside or at the end of the URL

  • Try a secure protocol, HTTPS vs. HTTP

  • Set up new API credentials

  • Check the API version documentation

  • Check the shop system forums for common errors

Import products from BigCommerce

BigCommerce is the world's leading cloud-based eCommerce platform for established and rapidly growing businesses. The platform combines enterprise functionality with an open architecture and app ecosystem. It powers and boosts the performance of eCommerce websites for successful retailers worldwide.

Before importing your products from BigCommerce, you must create an account in BigCommerce. See Creating an API Account.

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for BigCommerce API Import OAuth v1 and select Add.

    BigCommerce import

  3. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  4. In Client ID, enter the client ID from the BigCommerce API account.

  5. In Access Token, add the access token from the BigCommerce API account.

  6. In Store Hash, enter a unique store hash value in the API path from the BigCommerce API account.

  7. Optionally, enter a custom name in Description (optional).

  8. Select Save.

    BigCommerce set up

Import products from Blibli.com

Blibli.com is an Indonesian online shopping mall pioneer committed to providing a convenient, safe, simple, and fun online shopping experience.

Before importing your products from Blibli, you must create an account there.

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for Blibli and select Add.

    Blibli

  3. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  4. In ZIP Password, enter the password for your Blibli zip file.

  5. Optionally, enter a custom name in Description (optional).

  6. Select Save.

    Blibli_set_up.png

Import products from Magento

Magento is a modern cloud commerce platform with an open-source ecosystem. Flexible for B2C, B2B, and hybrid solutions, Magento extends beyond the shopping cart for every shopping experience, including email, mobile, in-store, shipping, and marketplaces.

You can import your products from Magento by choosing a method appropriate to your version.

Import from Magento 1.x

Before importing your products from Magento, you must create your account in Magento. To configure Magento, see Magento Developer Documentation.

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for Magento 1.x SOAP API and select Add.

    Magento 1.x SOAP API

  3. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  4. Add the Magento SOAP URL you previously set up in your Magento account. The link format should be such as https://mymagentoshop247.com/api/soap/?wsdl.

    Note

    Perform a basic functionality test by selecting your link. It displays information about the web service.

  5. Enter your credentials in Username and Password.

  6. Define how many API calls you want the platform make simultaneously in API multiCall size.

  7. If you want to receive only a specific range of product IDs, add the first value in Start index and the last value in End index.

  8. If you manage several stores and want to download products only from a specific store, enter the store's code in Store view code.

  9. Optionally, enter a custom name in Description (optional).

  10. Select Save.

    Magento 1.x SOAP API set up

Import from Magento 2.x

Before importing your products from Magento, you must create an account in Magento. See How do I get started?

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for Magento 2.x REST API and select Add.

    Magento 2.x REST API

  3. Give your data source a custom name if desired, then select Continue.

    1. The custom name replaces the data source name on the Data Sources Overview page.

  4. Enter your credentials in Username and Password.

  5. Add the Magento REST URL you previously set up in your Magento account. The link format should be https://mymagentoshop247.com/api/soap/?wsdl.

    Note

    Perform a basic functionality test by selecting your link. It displays information about the web service.

  6. In Page size, define the number of products to extract with each API call, depending on your hosting server's capabilities.

  7. Enter a filter in Data Filter Query.

  8. In Parallel Workers, define the maximum amount of API calls to make at once to access products, stock, attributes, etc.

  9. Set Include product details to On.

  10. You may need to enter a Stock Reference Code to pull the correct stock.

    • In this case, set Include product details to Off.

  11. Select the behavior of product link information in Product links:

    1. Explode splits links into separate attributes.

    2. Discard removes the links.

    3. Bundle groups several attributes if there are too many of them.

  12. Optionally, enter a custom name in Description (optional).

  13. Select Save.

    Magento 2.x REST API set up

Tip

By default, the platform retrieves products from the following endpoints:

/products – main product catalog

/products/attributes – details of the product such as color, size, gender, etc.

/categories – the categories for the website taxonomy and specific products

If you need to fetch products from other endpoints, contact support@productsup.com.

Import products from PrestaShop

PrestaShop is an open-source eCommerce solution that powers more than 250,000 stores worldwide. It offers online shopping cart solutions with more than 300 advanced features fitting the needs of any online business.

Before importing your products from PrestaShop, you must create an access key in your PrestaShop account. See Create an access key.

Once you've created an access key, you're ready to set up the data source in the platform:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for Prestashop Import and select Add.

    PrestaShop import

  3. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  4. In API Key, enter the access key you've created in the PrestaShop account.

  5. Add your web shop's domain in Domain in the format such as https://www.yourdomain.de

  6. Optionally, in Default Language ID, define the language ID for the products you are importing. See Languages at PrestaShop website.

  7. If necessary, enter credentials in the HTTP Auth User and HTTP Auth Password fields.

  8. If you wish to import all your product variants, set Fetch Variants to On.

  9. Optionally, enter a custom name in Description (optional).

  10. Select Save.

    PrestaShop import set up

Import data from Salesforce

You can retrieve three (3) types of data from Salesforce Commerce Cloud:

  • Your catalog with all your products and their attributes.

  • Your pricing data.

  • Your inventory data containing your products' stock levels.

Import your product catalog from Salesforce

To import catalog data from Salesforce Commerce Cloud into Productsup, you need to export your Salesforce product data into an XML file and store it on an FTP server. You can use the Productsup Cartridge add-on or the out-of-the-box capabilities of Salesforce to create the XML file. To store it, you can use the Productsup FTP Server. See Create an FTP server hosted by Productsup for more information.

Note

To request Productsup Cartridge, contact your Customer Success Manager or support@productsup.com.

If you use Salesforce Commerce Cloud as a B2B organization, you should instead consider using the out-of-the-box capabilities of Salesforce to run the export.

Once the XML file is ready and available on an FTP server, the Salesforce Commerce Cloud (Catalog) data source option lets you import your products into Productsup.

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Search for Salesforce Commerce Cloud (Catalog), select Add, change the name of the data source as desired, and then select Continue.

    Add Salesforce Commerce Cloud (Catalog) data source to import product data from Salesforce

  3. In Host, enter a link to your FTP server. If you are using the Productsup FTP Server, use the link suggested in the field.

  4. In URI, specify the path to your import file on the FTP server. The path is a string of characters that uniquely identifies a location in the directory structure of your FTP server.

  5. In Filename, enter the name of your import file that corresponds to the name of your XML file on the FTP server.

  6. Provide your FTP authentication data in Username and Password.

  7. In Locale, choose which locales Productsup should import from the file. You can choose to import:

    1. Products that belong to a specific locale only. Select the needed language or market code to import products that belong to the needed locale.

    2. All products that belong to all locales in the file. Select all to import all products from all locales.

    3. The default locale of the file only. Select x-default to import products of the default locale.

  8. Edit the name of the data source in Description (optional) as needed.

  9. Select Save.

Import price and inventory data from Salesforce

There are two (2) options for importing price and inventory data from Salesforce Commerce Cloud into Productsup. Via:

  • The Feed URL data source.

  • The Productsup Platform API data source.

If your inventory and price data don't change frequently, you can use the Feed URL data source option to import prices and stock levels as additional data sources. See Import a file from a URL and Enhance your products with additional data sources.

Note

While setting up your new additional data source with price or inventory data, set the attributes_product-id attribute in ID Column In This Feed as the Product Identifier.

In ID Column From Your Main Feed, choose the Product Identifier column from the Salesforce Commerce Cloud (Catalog) data source. Salesforce Commerce Cloud (Catalog) is your main data source.

If your price and inventory data change frequently, you can use the Productsup Platform API data source option to import this data into the platform. Selling products on multiple marketplaces and altering prices to support recurrent promotional campaigns are common causes of frequent price and inventory data updates.

The Productsup Platform API data source option requires additional configurations in Salesforce. For example, you need to set up delta jobs that look for price and inventory data changes and push those changes to the Productsup Platform API. See Import data via the Productsup Platform API for more information.

Tip

It may be the case that your price data doesn't change frequently, but your inventory data does. If so, you can use the Feed URL data source option to import the price data and the Productsup Platform API data source option to import your inventory data.

Import products from Shopify or ShopifyPlus

Shopify is a cloud-based, multi-channel commerce platform designed for small and medium-sized businesses.

Before importing your products from Shopify or ShopifyPlus, you must set up an API key in the Shopify account. See Custom apps.

Note

During imports, Productsup adds Shopify description attribute values in the body_html attribute.

Once you've created an API key, you're ready to set up the data source in the platform:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE. Search for Shopify or Shopify Plus, and select Add for a necessary import:

    Shopify Plus
    Shopify Product

  2. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  3. Add your shop's web address in Shop URL.

  4. Enter the API credentials you created in the first stage in the API Key and Password fields.

    Note

    Enter your API Admin token in the Password field when using the Shopify - Product Import data source. Don't use the API secret key you received from the Shopify UI.

    Shopify setup API credentials

  5. If you wish to import metadata, switch Include metadata to On. If your import takes a long time to complete, switch this setting to Off to speed up the process.

  6. Select desired statuses in Status to import only certain products such as Active, Archived, or Draft. This lets you exclude unnecessary products from the import. By default, the data source imports products of all statuses, but you can select a necessary combination of statuses.

    Shopify Status selection

  7. Optionally, if you only want to import products created, updated, and published after a certain date and time enter corresponding values in Created at minimum, Updated at minimum, and Published at minimum. Enter the value in the format xxD:xxH, where xx is the number of days and hours the platform should subtract from the date and time of the import. For example: 10D00H means ten (10) days and zero (0) hours before the date and time of import.

    Note

    These fields work by the AND logic. But if you want to import data either created at minimum or updated at minimum, you should set up two separate data sources: one - for Created at minimum, and the second - for the Updated at minimum.

    Shopify date selection

    Note

    We recommend using these settings if you have a large product catalog and only want to import a small amount of it to speed up the import process.

  8. Optionally, enter a custom name in Description (optional).

  9. Select Save.

Import products from VTEX

To import your products from VTEX, see Import products from VTEX.

Import products from WooCommerce

WooCommerce is an open-source eCommerce plugin for WordPress.

To import products from WooCommerce, you must set up API access in your WordPress store. See WooCommerce REST API.

Once you've created the API access, you're ready to set up the data source in the platform:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE.

  2. Search for WooCommerce Products Importer and select Add.

    WooCommerce import

  3. Give your data source a custom name if desired, then select Continue. The custom name replaces the data source name on the Data Sources Overview page.

  4. Add your web shop's address in Shop url.

  5. Enter the API credentials you've created in your WooCommerce account in the API Key and API secret fields.

  6. Select a WooCommerce version in API Version.

  7. If you wish to import all your product variants, set Import variants to On.

  8. If you want to import only specific attributes, you can type only these attributes in Import data filter. Separate them by a comma (,) without spaces such as id,name,description.

  9. To send auth secrets as string for OAuth 1.0, set OAuth 1.0 auth as string to On.

  10. Optionally, enter a custom name in Description (optional).

  11. Select Save.

    WooCommerce set up
In this section: