Skip to main content

Mapping Data Between Magento2/Adobe Commerce and iPaaS.com

ing data between iPaaS and Magento

Updated over 2 weeks ago

Mapping Data Between Systems

iPaaS uses mapping collections to translate data between Magento 2/Adobe Commerce and other systems. Here are the key mappings you’ll need to set up:

Payment Methods

You’ll need to map Magento payment methods to your payment types in iPaaS. The default maps everything to CASH, which you’ll want to change.

Inventory Locations

Map your inventory locations in iPaaS to Magento 2/Adobe Commerce inventory sources. For example, if you have a Main warehouse in your system, map it to the Main source in Magento 2/Adobe Commerce.

Important: Magento requires direct 1:1 mapping between locations.

Product Categories

Set up translations to map product categories correctly. Categories can be added but not easily removed in Magento 2/Adobe Commerce.

Customer Data

This mapping contains basic mappings for customer information and addresses and handles missing company names and multiple shipping addresses.

Order Information

Order Information maps order headers, line items, payment details, and tax information as well as handling shipping and billing addresses. It provides special handling for configurable products (products with options like size/color).

Setting Up Webhooks

Webhooks tell iPaaS when something changes in Magento 2/Adobe Commerce. The integration supports these webhook types:

  • category/product/created

  • product/created

  • product/category/updated

  • product/variant/updated

  • category/product/updated

  • product/updated

  • product/inventory/created

  • product/variant/deleted

  • location/created

  • product/deleted

  • product/inventory/updated

  • product/variant/inventory/created

  • location/updated

  • product/category/created

  • product/variant/created

  • product/variant/inventory/updated

Important Things to Know

  • Category Handling: If you remove all categories from a product, you may need to manually reassign categories in Magento 2/Adobe Commerce.

  • Inventory Sources: New inventory locations must be manually assigned to your website in the Magento 2/Adobe Commerce admin.

  • Case Sensitivity: Location names are case-sensitive - “MAIN” differs from “Main”.

  • Initialization: There’s no automatic way to sync all existing data - you’ll need to set up mappings manually.

  • Throttling: The system automatically limits how many API calls are made to prevent overloading Magento 2/Adobe Commerce. For more details, see Subscription Configuration – Edit.

Common Issues and Solutions

  • Missing Categories: If categories aren’t showing up, check that your product is assigned to at least one category.

  • Inventory Problems: If inventory isn’t syncing correctly, verify your location mappings match exactly.

  • Product Not Showing: Run reindex in Magento 2/Adobe Commerce if products aren’t appearing on your site.

  • API Errors: Make sure your Access Token has full permissions.

Did this answer your question?