How to: Use Fullfillment Integration to Update Inventory

This tutorial will show you how to use an 846 EDI file to update the inventory in web cube. To do this go to Settings > Fulfillment Integrations and click on the Add Fulfillment Integration button.

 

1. Provide a name for your integration.

Screen_Shot_2015-08-27_at_4.33.32_PM.png

2. Select the Active action to activate this integration.

Screen_Shot_2015-08-27_at_4.33.38_PM.png

3. Schedule when when to run this integration.

Screen_Shot_2015-08-27_at_4.33.40_PM.png

4. Provide the location for your 846 EDI file. In this case the EDI file will be pulled from an FTP server.

Screen_Shot_2015-08-27_at_4.33.45_PM.png

5. Select Pull Updated Inventory from the Action dropdown.

Screen_Shot_2015-08-27_at_4.33.50_PM.png

6. Since our EDI file is located on an FTP server select the FTP option from the Transport dropdown.

Screen_Shot_2015-08-27_at_4.33.55_PM.png

7. To parse the inbound data we need to specify a parser. In this case the file is an EDI file so will select the X12 EDI Parser from the dropdown.

Screen_Shot_2015-08-27_at_4.34.03_PM.png

8. In the Transport config text box we can provide optional configuration parameters related to the transport. The transaction_code EDI Transaction Code, the default code is 856. If a has_wildcard is specified, a URI can be entered with a "*", and the first pulled match will be processed (pull actions only).

 

Screen_Shot_2015-08-27_at_4.34.11_PM.png

9. Next we need to specify the parser options.

The mapping option is for the fields parsed from EDI. This includes the line header (e.g. PRF), the 1-based index if there are more than one, and the column index, e.g. PRF-1-1. The value is the key to specify for the action. For example {"PRF-1-1":"order_id","MAN-1-2":"tracking"} will result in the required [{"order_id":"123","tracking":"ABC"}] required to process ASNdefault {"PRF-1-1":"order_id","MAN-1-2":"tracking"}

use_sequence if present, allows the specification of a sequence of items to process. e.g. ["LIN","QTY"]

Screen_Shot_2015-08-27_at_4.34.18_PM.png

10. Now, let's configure the Action options.

use_upc if present, indicates that we are importing based on UPC, not SKU.

default_warehouse is the warehouse id to import the inventory in to. If not specified the default id is 1.

Screen_Shot_2015-08-27_at_4.34.31_PM.png

11. In this case the payload template is not needed.

Screen_Shot_2015-08-27_at_4.34.43_PM.png

12. Set an email address where notifications will be send.

Screen_Shot_2015-08-27_at_4.34.47_PM.png

13. Set the type of notification to be sent to the manager.

Screen_Shot_2015-08-27_at_4.34.52_PM.png

14. Save.

Screen_Shot_2015-08-27_at_4.34.58_PM.png

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk