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 Generate credentials from the Shopify admin.

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.

  5. If you wish to also import metadata, switch Include metadata to On.

  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