User Manual

Integration between MRPeasy and Magento

Magento is a powerful e-commerce platform. Magento and MRPeasy can work seamlessly together so that sales and shipments are done in Magento and products are made and booked, materials are handled, production is planned, and purchasing managed in MRPeasy.

Magento 1 and 2 are supported.

Jump to:

  1. How to integrate MRPeasy and Magento? Installation of the Magento MRPeasy extension.
  2. How does the MRPeasy and Magento integration work?
  3. How to post sales order from Magento to MRPeasy?
  4. How to subtract shipped items from the stock in MRPeasy when items are shipped in Magento?
  5. How to synchronize inventory levels between Magento and MRPeasy?

1. Disclaimer

Installation of Magento extension is a serious process that contains some risks to the e-shop. It must be fulfilled by a person with IT knowledge, and experience with Magento. This person must:

  1. know how to install Magento extensions,
  2. make full backup of the website, and be able to restore it, if needed,
  3. have full access to the server (FTP or SSH and MySQL).

As a negative consequence of the installation, the website can become unavailable to visitors. In this case this person must be able to rollback all changes and turn the maintenance mode OFF.

MRPeasy does not provide this service.

It is strongly advised that installation would be performed by the company or person, who has installed the Magento website initially.

Please evaluate MRPeasy to check whether it suits your manufacturing process. If you decide to implement MRPeasy in your company, and become a paying customer, we will send you the Magento extension.
Due to technical reasons, the Magento extension is not publiclly available. We send it manually  to permanent (paying) customers only.

Since the result of integration depends on the specialist who configures it, we have the right to turn it off at any time.

2. Installation

Create a backup of the website before installing the extension. Also, make sure that you have full access to the server (FTP or SSH and MySQL).

In Magento 1, go to Magento -> System -> Magento Connect -> Magento Connect Manager and upload the extension file.

In Magento 2:

  1. Upload the extension file to Magento [root_folder]/app/code. If this folder does not exists, create it.
  2. Open server terminal (console).
  3. Extract the file:
    tar -xzf MRPeasy-Integration-2.0.0.tgz
  4. Change the access permissions of files and folders:
    find MRPeasy -type d -exec chmod 755 {} \;
    find MRPeasy -type f -exec chmod 644 {} \;
  5. Go to Magento root folder.
  6. Run the following commands:
    ./bin/magento module:enable MRPeasy_Integration
    ./bin/magento setup:upgrade

During the installation, the following changes are made:

  1. The extension is placed into
    • Magento 1 [root_folder]/app/code/community/MRPeasy;
    • Magento 2 [root_folder]/app/code/MRPeasy;
  2. In Magento 1, a configuration file [root_folder]/app/etc/modules/MRPeasy_Integration.xml is created;
  3. Order statuses ‘In manufacturing’ (mrpeasy_posted) and ‘Ready for shipment’ (mrpeasy_ready) are created and assigned to state ‘processing’;
  4. Columns ‘mrpeasy_cust_ord_code’ and ‘mrpeasy_cust_ord_id’ are added to the table ‘sales_flat_order’ (Magento 1) or ‘sales_order’ (Magento 2);
  5. columns ‘mrpeasy_cust_ord_id’, ‘mrpeasy_cust_line_id’ and ‘mrpeasy_shipment_id’ are added to the table ‘sales_flat_order_item’ (Magento 1) or ‘sales_order_item’ (Magento 2).

After the extension is installed, it must be configured in Magento 1 -> System -> Configuration -> Services -> MRPeasy Integration or Magento 2 -> Stores -> Configuration -> Services -> MRPeasy Integration.

The following settings must be set:

  • MRPeasy API key – API key from MRPeasy -> Settings -> System settings -> Integration -> API access.
  • MRPeasy Access key – Access key from MRPeasy -> Settings -> System settings -> Integration -> API access.
  • Send sales orders – how to send sales orders from Magento to MRPeasy:
    • Separately – each sales order from Magento becomes a separate customer order in MRPeasy;
    • Group orders – all sales orders from Magento are posted to MRPeasy as one customer order, each line from sales orders is a separate line in the customer order;
    • Group products – all sales orders from Magento are posted to MRPeasy as one customer order, each product is a separate line in the customer order and quantity is a total amount of that product, sold in all sales orders.
  • Update inventory levels in e-shop – if ‘Yes’, then Magento imports inventory levels of products from MRPeasy.

Integration between MRPeasy and Magento runs in the background once per hour. The extension requires the Magento cron job to be configured.

3. How the integration between Magento and MRPeasy works

The integration between MRPeasy and Magento works as follows:

  1. A sales order from Magento is posted to MRPeasy.
  2. Once items become available, the sales order in Magento is updated to status Ready for shipment
  3. Items are shipped in Magento, and inventory is subtracted from MRPeasy.
  4. Plus, it's possible to synchronize inventory levels between MRPeasy and Magento.

Jump to: 

  1. Posting sales order from Magento to MRPeasy.
  2. Updating of statuses of sales orders in Magento.
  3. Subtracting shipped items from the stock in MRPeasy
  4. Updating inventory in Magento

Step 1. Posting sales orders from Magento to MRPeasy

The posting of sales order from Magento to MRPeasy works as follows:

  • Sales orders in status Processing are posted from Magento to MRPeasy.
  • The SKU in Magento must match Part Number in MRPeasy.
  • Order’s status in Magento is changed to In manufacturing.
  • A customer order in status Confirmed is created in MRPeasy -> CRM -> Customer orders. This order must be processed as usually: items must be booked.
  • If the items are available in stock, these will be automatically booked for the order.

Warnings:

  1. If sales order in Magento contains an item with SKU that does not match any part number in MRPeasy, then this item is ignored.
  2. It is advised to check Magento list of orders. If there are sales orders in status Processing, that have been received before the last synchronization, then it means that they could not be posted to MRPeasy, and they must be handled manually.

Step 2. Automatic updating of the statuses of sales orders in Magento

When all items of a sales order are ready to be shipped:

  • the status of the sales order in Magento is changed to Ready for shipment,
  • the status of the Customer Order in MRPeasy is changed to Ready for shipment.

Step 3. Subtracting shipped items from the stock in MRPeasy

Items must be shipped in Magento.

When sales orders that were posted to MRPeasy are shipped in Magento, then items are subtracted from the stock in MRPeasy as follows:

  1. a Shipment for the customer order in MRPeasy is created;
  2. all items are picked.

If some shipment in MRPeasy is in status Ready for shipment and wasn't automatically shipped, then this means one of the following:

  1. The items cannot be picked automatically because serial numbers must be specified. Please pick items manually by
    1. opening the Customer order at CRM -> Customer Orders,
    2. opening the shipment in the Shipment section,
    3. clicking on the Pick or Pick all items button,
    4. selecting the serial numbers and Saving.
  2. Item’s quantity in the shipment in MRPeasy does not match the quantity in Magento. In this case please turn to MRPeasy support.

Updating inventory in Magento

The integration extension can update inventory levels in Magento by fetching stock item quantities from MRPeasy.

  • If the setting Update inventory levels in e-shop in Magento -> System (Stores) -> Configuration -> Services -> MRPeasy Integration is turned ON, then quantities of products are updated in Magento.
  • Products are matched using SKU field in Magento and Part Number field in MRPeasy.
  • The Available quantity from MRPeasy is set as a quantity in Magento.