How can I import products from Magento?

Catalog Machine can quickly import or update products from your Magento store. After import you can add additional custom fields and images to products  for use in catalogs. 

To import products from Magento follow the steps below.

A. Configure Magento Store for enabling Catalog Machine access

Set up a Web Services user and role for Catalog Machine from the System | Web Services menu:

magento-system-menu

  1. Create a new role
  2. Assign required permissions for the new role (more details below)
  3. Create a new user: provide User Name and API key that you will use for connection from Catalog Machine.
  4. Assign this new user to the new role

Magento-users-roles

Permissions required for the new Catalog Machine role:

  • Catalog | Product | Retrieve products data
  • Catalog | Product | Product Attributes | Attribute Sets | List
  • Catalog | Product | Product Attributes | Attribute Sets | Retrieve attribute data
  • Catalog | Product | Product Images
  • Catalog | Category | Retrieve category data
  • Catalog | Category | Retrieve categories tree
  • Catalog | Category | Assigned products (uncheck Remove, Update, Assign)

role-permissions

Required Magento Role permissions 

5. Check if Services (System | Configuration) > Magento Core API > WS-I Compliance is set to No in the system configuration menu.

magento-system-ws-i

6. Catalog Machine needs PHP SOAP extension (“soap.so”) in order to communicate with your Magento store through the API. You can check if your Magento application has a full SOAP support by browsing to the page:

  • [YOUR_MAGENTO_SHOP_URL]/api/v2_soap.

It should give you an XML-document explaining more about the usage of SOAP. If you see the message “0 Unable to load Soap extension on the server” or “0 SOAP extension is not loaded”, SOAP support is missing from the Webserver.

Normally this is something that your web hosting provider would have to install, so we recommend contacting them and asking them to install it. For RPM-based Linux distributions this is installed with the command “yum install php-soap”. Also, note that the PHP SOAP extension is not the same thing as the PEAR SOAP extension.

 B. Connect Catalog Machine to Magento

Go to Magento account page

Enter your Magento store web address, User Name and API key that you created on the previous step.

magento-setup

C. Create a Product Category for Magento products

Create a new product category based on existing Magento attribute set. First free image fields will be used for loading images for the product based on Magento image sort order.

magento-product-category

D. Import and update products from Magento store

Select and sync Magento products to create or update them in Catalog Machine product database. The product attributes will be matched to the field name of the Catalog Machine product category.

magento-sync

  1. Get products from Magento store. You can optionally filter them by category of product type.
  2. Select products for import.
    • If the product already imported, make sure you have selected the same category for import.
  3. Select import category and click Import products.
    • You can optionally override prices of configurable product from the first associated simple product.

You products with images and other fields are now imported and you can use them to make catalogs.

 

Leave a Reply

Your email address will not be published. Required fields are marked *