Skip to main content

Import products from a shop system

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

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:

  • BigCommerce

  • Blibli

  • Magento 1.x

  • Magento 2.x

  • Prestashop

  • Salesforce

  • Shopify

  • Site Giant

  • 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 do not 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 Magento

You can import your products from Magento by choosing a method most appropriate to the version you are using.

Import from Magento 1.x

Connect to Magento 1.x via the SOAP API.

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE. Then choose Magento 1.x SOAP API and select Add.

  2. 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.

  3. Add the Magento SOAP URL you previously set up to access Magento via SOAP.

    Note

    Be certain to add a base URL and not the admin panel URL. For example, /admin at the URL end, as seen in the following example:

    magento_base_url.png

    1. To configure Magento, see Magento Developer Documentation.

    2. Your link should look similar to https://mymagentoshop247.com/api/soap/?wsdl.

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

  4. Enter your credentials in Username and Password.

  5. Define how many API calls should be made at one time in API multiCall size.

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

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

  8. Optionally, enter a custom name in Description (optional). This option is the same as in step 2.

  9. Select Save.

    magento1_x.png

Import from Magento 2.x

You can connect to Magento 2.x via the REST API.

First, you need to perform some steps directly from Magento. To begin, see How do I get started?

magento_admin.png

Once you've created a user in Magento, 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. Then choose Magento 2.x REST API and select Add.

  2. 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.

  3. Enter your credentials in Username and Password.

  4. Add the Magento REST URL to the integration you previously set up in the first stage.

    Note

    Be certain to add a base URL and not the admin panel URL, which you can as /admin at the URL end.

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

  5. Enter a filter in Data Filter Query.

  6. Set Include product details to On.

  7. In Page size, define how many products to extract with each API call, depending on your hosting server's capabilities.

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

  9. For some Magento 2.x integrations, you may need to enter a Stock Reference Code to pull the correct stock.

    • If this is the case, set Include products details to Off.

  10. You can select the behavior of product link information under Product links.

    1. Explode is the default, which splits links into separate columns

    2. Discard if you don't need the links you can get rid of them

    3. Bundle lets you group several columns if you feel there are too many

  11. Optionally, enter a custom name in Description (optional). This option is the same as in step 2.

  12. Select Save.

    magento_rest_api2_x.png

Tip

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

/products – Main product catalog

/products/attributes – Details of the product (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

To import your products from PrestaShop, you must first create an access key in the PrestaShop interface. 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. Then choose Prestashop Import and select Add.

  2. 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.

  3. Enter the API Key you created in the first stage.

  4. Add your shop's web domain in Domain.

    1. It should look similar to this: https://www.yourdomain.de

  5. In Default Language ID, define the language ID for the products you are importing (optional).

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

  7. If you wish to import all your product variants, switch Fetch Variants to On.

  8. Optionally, enter a custom name in Description (optional). This option is the same as in step 2.

  9. Select Save.

    presta_import.png

Import products from Shopify or ShopifyPlus

Note

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

To import your products from Shopify or ShopifyPlus, you must first set up an API key in the Shopify interface. See Custom apps.

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 WooCommerce

To import products from WooCommerce, you must first 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. Then choose WooCommerce and select Add.

  2. 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.

  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 API secret fields.

  5. Select a WooCommerce version in API Version.

  6. If you wish to import all your product variants, switch Import variants to On.

  7. Optionally, enter a custom name in Description (optional). This option is the same as in step 2.

  8. Select Save.

    woo_commerce.png

Import products from VTEX

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

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.

In this section: