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 a shop system, such as WooCommerce or Shopify. You can find data sources linking to shopping platforms when you add a data source and select the Shopping Platform tab.

shop_systems.png

Productsup supports product imports from the following:

  • BigCommerce

  • Blibli

  • IBM Commerce on Cloud

  • Magento 1.x

  • Magento 2.x

  • Prestashop

  • Salesforce

  • Shopify

  • Site Giant

  • VTEX

  • WooCommerce

Tip

Most of the previously-shown 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/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. Then choose Shopify Plus or Shopify (Products), etc., 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 Password fields.

    Note

    Enter your API Admin token in the Password field when using the Shopify (Products) data source. Do not use the API secret key you received from the Shopify UI.

  5. If you wish to also 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. Optionally, enter a custom name in Description (optional). This option is the same as in step 2.

  7. Select Save.

    shopify_add.png

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

You can use two methods to import your products from VTEX, such as importing publicly available product data and all product data. Both methods use VTEX REST APIs.

  1. Import publicly available product data from VTEX

    • This method lets you import all product data that is publicly available over VTEX

    • This method does not specifically import your own product data

  2. Import all product data from your VTEX catalog

    • This method lets you import all product data, including metadata, by connecting specifically to your VTEX store

Import publicly available product data from VTEX

To import all publicly available data from VTEX, perform the following:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE. Then choose VTEX - API Import without Authentication 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. See the following information to properly add your Product Endpoint URL:

    • Here is the correct format http://{{accountName}}.{{environment}}.com.br/api/catalog_system/pub/products/

    • Enter your account details in the {{accountName}} portion

    • Set {{environment}} as either vtexcommercestable or vtexcommmercebeta

  4. See the following information to properly add your Category Endpoint URL:

    • Here is the correct format http://{{accountName}}.{{environment}}.com.br/api/catalog_system/pub/category/tree/

    • Enter your account details in the {{accountName}} portion

    • Set {{environment}} as either vtexcommercestable or vtexcommmercebeta

    Tip

    Don't include the curly brackets ({}).

  5. In Whitelist Columns, enter the names of the attributes you want to import into the whitelist columns field (optional).

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

  7. Select Save.

    vtex_public.png

Import all product data from your VTEX catalog

To import all product data from your VTEX store, perform the following:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE. Then choose VTEX - API Import with Authentication 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 store account name in Account Name.

  4. In Environment, select the value vtexcommercestable or vtexcommmercebeta from the drop-down menu.

  5. Enter the authentication credentials for your VTEX shop in App Key and App Token fields. You can find them in the API request headers.

  6. In Whitelist Columns, enter the names of the attributes you want to import into the whitelist columns field (optional).

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

  8. Select Save.

    vtex_private.png

Import products and categories from IBM Commerce on Cloud

Note

To import both products and categories, you need to add the import twice. The first import is for the products, and the second is for categories.

Set your categories data source as an additional feed, see Enhance your products with additional data sources. Set the column category_GroupIdentifier as the ID column in your additional feed. Set the column ParentGroupIdentifier1 as the ID column in your main feed.

Be aware that this process may differ, depending on your IBM Commerce on Cloud setup.

To import products and categories from IBM Commerce on Cloud, perform the following:

  1. Go to Data Sources from the site's main menu and select ADD DATA SOURCE. Then choose IBM Commerce on Cloud 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 website information you received from IBM in Host and URL.

  4. Enter storeId, LogonId, and LogonPassword you received from IBM.

  5. In Action, select the appropriate action from the drop-down menu:

    • Merge - Downloads parent products and their variants, with variants inheriting attributes from the parents.

    • Product - Downloads parent products and their variants, with variants not inheriting attributes from the parents.

    • Category - Downloads all your categories on the variant level.

  6. Set the Timeout if you need a different value other than the default.

    • If you regularly experience timeout errors, you may need to increase this number.

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

  8. Select Save.

    ibm.png

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 Client 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: